delete from CPF_RATE
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,0,1,1,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,16,2,1,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,500,0,0,48,16,3,1,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,120,750,0,0,24,16,4,1,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,120,750,0,0,24,16,5,1,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,20,16,6,1,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,0,1,2,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,50,0,10.63,2,2,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,500,0,50,48,10.63,3,2,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,120,750,74.475,750,24,21.71,4,2,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,120,750,172.20,1200,24,22.60,5,2,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,20,16,6,2,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,0,1,3,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,50,0,7.97,2,3,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,500,0,50,43.2,7.97,3,3,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,108,750,55.80,750,21.6,15.04,4,3,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,108,750,123.48,1200,21.60,18.84,5,3,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,18,12,6,3,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,0,1,4,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,50,0,5.97,2,4,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,500,0,50,30,5.97,3,4,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,75,750,41.85,750,15,9.9,4,4,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,75,750,86.40,1200,15,16.2,5,4,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,12.5,9,6,4,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,0,1,5,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,50,0,4.31,2,5,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,500,0,50,18,4.31,3,5,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,45,750,30.225,750,9,5.41,4,5,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,45,750,54.6,1200,9,14.3,5,5,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,7.5,6.5,6,5,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,0,0,1,6,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,50,0,4.31,2,6,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,500,0,50,12,4.31,3,6,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,30,750,30.225,750,6,5.41,4,6,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,30,750,54.6,1200,6,14.3,5,6,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go
insert into CPF_RATE (RATE_TYPE_ID,RATE_EMP_FIX,RATE_EMP_OFFSET,RATE_COY_FIX,RATE_COY_OFFSET,RATE_EMP_CPF,RATE_COY_CPF,RATE_WAGE_ID,RATE_AGE_ID,RATE_END_DATE,RATE_START_DATE,ORG_ID)
values (1,0,0,0,0,5,6.5,6,6,'2999-12-31 23:59:59','2000-01-01 00:00:00',0)
go