Phlippine Gov't Contribution Tables: January 2020

USE [test]
GO
/****** Object: Table [dbo].[PhilHealth] Script Date: 1/30/2020 7:27:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PhilHealth](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TableId] [nvarchar](255) NULL,
[RangeStart] [float] NULL,
[RangeEnd] [float] NULL,
[PreimiumRate] [float] NULL,
[MonthlyPremium] [float] NULL,
[DateAdded] [datetime] NULL,
[DateUpdated] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SSS] Script Date: 1/30/2020 7:27:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSS](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TableId] [nvarchar](255) NULL,
[RangeStart] [float] NULL,
[RangeEnd] [float] NULL,
[MSC] [float] NULL,
[ER] [float] NULL,
[EE] [float] NULL,
[EC] [float] NULL,
[DateAdded] [datetime] NULL,
[DateUpdated] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[TaxTable] Script Date: 1/30/2020 7:27:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TableId] [nvarchar](255) NULL,
[BracketNumber] [int] NULL,
[RangeStart] [float] NULL,
[RangeEnd] [float] NULL,
[Tax] [float] NULL,
[AdditionalTax] [float] NULL,
[Type] [nvarchar](255) NULL,
CONSTRAINT [PK__TaxTable__3214EC075006DFF2] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[PhilHealth] ON

INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (1, N'012020', 0, 10000, 0.3, 300, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (2, N'012020', 10000.01, 59999.99, 0.3, 0, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (3, N'012020', 60000, 0, 0.3, 1800, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (4, N'012021', 0, 10000, 0.35, 350, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (5, N'012021', 10000.01, 69999.99, 0.35, 0, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (6, N'012021', 70000, 0, 0.35, 2450, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (7, N'012022', 0, 10000, 0.4, 400, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (8, N'012022', 10000.01, 79999.99, 0.4, 0, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (9, N'012022', 80000, 0, 0.4, 3200, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (10, N'012023', 0, 10000, 0.45, 450, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (11, N'012023', 10000.01, 89999.99, 0.45, 0, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (12, N'012023', 90000, 0, 0.45, 4050, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (13, N'012024', 0, 10000, 0.5, 500, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (14, N'012024', 10000.01, 99999.99, 0.5, 0, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (15, N'012024', 100000, 0, 0.5, 5000, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (16, N'012025', 0, 10000, 0.5, 500, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (17, N'012025', 10000.01, 99999.99, 0.5, 0, NULL, NULL)
INSERT [dbo].[PhilHealth] ([Id], [TableId], [RangeStart], [RangeEnd], [PreimiumRate], [MonthlyPremium], [DateAdded], [DateUpdated]) VALUES (18, N'012025', 100000, 0, 0.5, 5000, NULL, NULL)
SET IDENTITY_INSERT [dbo].[PhilHealth] OFF
SET IDENTITY_INSERT [dbo].[SSS] ON

INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (1, N'42019', 0, 2249.99, 2000, 160, 80, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (2, N'42019', 2250, 2749.99, 2500, 200, 100, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (3, N'42019', 2750, 3249.99, 3000, 240, 120, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (4, N'42019', 3250, 3749.99, 3500, 280, 140, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (5, N'42019', 3750, 4249.99, 4000, 320, 160, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (6, N'42019', 4250, 4749.99, 4500, 360, 180, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (7, N'42019', 4750, 5249.99, 5000, 400, 200, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (8, N'42019', 5250, 5749.99, 5500, 440, 220, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (9, N'42019', 5750, 6249.99, 6000, 480, 240, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (10, N'42019', 6250, 6749.99, 6500, 520, 260, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (11, N'42019', 6750, 7249.99, 7000, 560, 280, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (12, N'42019', 7250, 7749.99, 7500, 600, 300, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (13, N'42019', 7750, 8249.99, 8000, 640, 320, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (14, N'42019', 8250, 8749.99, 8500, 680, 340, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (15, N'42019', 8750, 9249.99, 9000, 720, 360, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (16, N'42019', 9250, 9749.99, 9500, 760, 380, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (17, N'42019', 9750, 10249.99, 10000, 800, 400, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (18, N'42019', 10250, 10749.99, 10500, 840, 420, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (19, N'42019', 10750, 11249.99, 11000, 880, 440, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (20, N'42019', 11250, 11749.99, 11500, 920, 460, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (21, N'42019', 11750, 12249.99, 12000, 960, 480, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (22, N'42019', 12250, 12749.99, 12500, 1000, 500, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (23, N'42019', 12750, 13249.99, 13000, 1040, 520, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (24, N'42019', 13250, 13749.99, 13500, 1080, 540, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (25, N'42019', 13750, 14249.99, 14000, 1120, 560, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (26, N'42019', 14250, 14749.99, 14500, 1160, 580, 10, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (27, N'42019', 14750, 15249.99, 15000, 1200, 600, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (28, N'42019', 15250, 15749.99, 15500, 1240, 620, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (29, N'42019', 15750, 16249.99, 16000, 1280, 640, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (30, N'42019', 16250, 16749.99, 16500, 1320, 660, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (31, N'42019', 16750, 17249.99, 17000, 1360, 680, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (32, N'42019', 17250, 17749.99, 17500, 1400, 700, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (33, N'42019', 17750, 18249.99, 18000, 1440, 720, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (34, N'42019', 18250, 18749.99, 18500, 1480, 740, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (35, N'42019', 18750, 19249.99, 19000, 1520, 760, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (36, N'42019', 19250, 19749.99, 19500, 1560, 780, 30, NULL, NULL)
INSERT [dbo].[SSS] ([Id], [TableId], [RangeStart], [RangeEnd], [MSC], [ER], [EE], [EC], [DateAdded], [DateUpdated]) VALUES (37, N'42019', 19750, 20249.99, 20000, 1600, 800, 30, NULL, NULL)
SET IDENTITY_INSERT [dbo].[SSS] OFF
SET IDENTITY_INSERT [dbo].[TaxTable] ON

INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (1, N'012018122022', 1, 0, 684.99, 0, 0, N'Daily')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (2, N'012018122022', 2, 685, 1095.99, 0.2, 0, N'Daily')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (3, N'012018122022', 3, 1096, 2191.99, 0.25, 82.19, N'Daily')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (4, N'012018122022', 4, 2192, 5478.99, 0.3, 356.16, N'Daily')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (5, N'012018122022', 5, 5479, 21917.99, 0.32, 1342.47, N'Daily')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (6, N'012018122022', 6, 21918, 0, 0.35, 6602.74, N'Daily')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (7, N'012018122022', 1, 0, 4807.99, 0, 0, N'Weekly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (8, N'012018122022', 2, 4808, 7691.99, 0.2, 0, N'Weekly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (9, N'012018122022', 3, 7692, 15384.99, 0.25, 576.92, N'Weekly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (10, N'012018122022', 4, 15385, 38461.99, 0.3, 2500, N'Weekly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (11, N'012018122022', 5, 38462, 153845.99, 0.32, 9423.08, N'Weekly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (12, N'012018122022', 6, 153846, 0, 0.35, 46346.15, N'Weekly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (13, N'012018122022', 1, 0, 10416.99, 0, 0, N'Semi-Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (14, N'012018122022', 2, 10417, NULL, 0.2, 0, N'Semi-Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (15, N'012018122022', 3, 16667, NULL, 0.25, 1250, N'Semi-Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (16, N'012018122022', 4, 33333, NULL, 0.3, 5416.67, N'Semi-Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (17, N'012018122022', 5, 83333, NULL, 0.32, 20416.67, N'Semi-Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (18, N'012018122022', 6, 333333, NULL, 0.35, 100416.67, N'Semi-Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (19, N'012018122022', 1, 0, 20832.99, 0, 0, N'Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (20, N'012018122022', 2, 20833, 33332.99, 0.2, 0, N'Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (21, N'012018122022', 3, 33333, 66666.99, 0.25, 2500, N'Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (22, N'012018122022', 4, 66667, 166666.99, 0.3, 10833.33, N'Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (23, N'012018122022', 5, 166667, 666666.99, 0.32, 40833.33, N'Monthly')
INSERT [dbo].[TaxTable] ([Id], [TableId], [BracketNumber], [RangeStart], [RangeEnd], [Tax], [AdditionalTax], [Type]) VALUES (24, N'012018122022', 6, 666667, 0, 0.35, 200833.33, N'Monthly')
SET IDENTITY_INSERT [dbo].[TaxTable] OFF

Monthly Basic Salary
Start	End	Premium Rate	Monthly Premium
10000	0	3%	300.00
10000.01	59999.99	3%	300.00 to 1800.00
60000	0	3%	1800.00

Range of Compensation	Monthly Salary Credit	SS Contribution			EC Contribution
		ER	EE	Total	ER
BELOW – 2,250	2,000	160.00	80.00	240.00	10
2,250 – 2,749.99	2,500	200.00	100.00	300.00	10
2,750 – 3,249.99	3,000	240.00	120.00	360.00	10
3,250 – 3,749.99	3,500	280.00	140.00	420.00	10
3,750 – 4,249.99	4,000	320.00	160.00	480.00	10
4250 – 4,749.99	4,500	360.0	180.00	540.00	10
4,750 – 5249.99	5,000	400.00	200.00	600.00	10
5,250 – 5,749.99	5,500	440.00	220.00	660.00	10
5,750 – 6,249.99	6,000	480.00	240.00	20.00	10
6,250 – 6,749.99	6,500	520.00	260.00	780.00	10
6,750 – 7,249.99	7,000	560.00	280.00	840.00	10
7,250 – 7,749.99	7,500	600.00	300.00	900.00	10
7,750 – 8,249.99	8,000	640.00	320.00	960.00	10
8,250 – 8,749.99	8,500	680.00	340.00	1,020.00	10
8.750 – 9,249.99	9,000	720.00	360.00	1,080.00	10
9,250 – 9,749.99	9,500	760.00	380.00	1,140.00	10
9,750 – 10,249.99	10,000	800.00	400.00	1,200.00	10
10,250 – 10,749.99	10,500	840.00	420.00	1,260.00	10
10,760 – 11,249.99	11,000	880.00	440.00	1,320.00	10
11,250 – 11,749.99	11,500	920.00	460.00	1,380.00	10
11,750 – 12,249.99	12,000	960.00	480.00	1,440.00	10
12,250 – 12,749.99	12,500	1,000.00	500.00	1,500.00	10
12,760 – 13,249.99	13,000	1,040.00	520.00	1,560.00	10
13,250 – 13,749.99	13,500	1,080.00	540.00	1,620.00	10
13,750 – 14,249.99	14,000	1,120.00	560.00	1,680.00	10
14,250 – 14,749.99	14,500	1,160.00	580.00	1,740.00	10
14,750 – 15,249.99	15,000	1,200.00	600.00	1,800.00	30
15,250 – 15,749.99	15,500	1,240.00	620.00	1,860.00	30
15,750 – 16,249.99	16,000	1,280.00	640.00	1,920.00	30
16,250 – 16,749.99	16,500	1,320.00	660.00	1,980.00	30
16,750 – 17,249.99	17,000	1,360.00	680.00	2,040.00	30
17,250 – 17,749.99	17,500	1,400.00	700.00	2,100.00	30
17,750 – 18,249.99	18,000	1,440.00	720.00	2,160.00	30
18,250 – 18,749.99	18,500	1,480.00	740.00	2,220.00	30
18,750 – 19,249.99	19,000	1,520.00	760.00	2,280.00	30
19,250 – 19,749.99	19,500	1,560.00	780.00	2,340.00	30
19,750 and above	20,000	1,600.00	800.00	2,400.00	30

Phlippine Gov't Contribution Tables

Thursday, January 30, 2020

Updated Ph Goverment Deductions - January 2020

Wednesday, January 29, 2020

2020|PhilHealth Contributions for the Year 2020

04/2019|SSS Contributions Table for Employed SSS Members - Effective April 2019

Blog Archive