GPSG_CPF_RT_HDR (SQL Table)	Index Back
CPF Rates Header This table consists of a list of sectors and the CPF gradual types.

GPSG_CPF_RT_HDR

(SQL Table)

CPF Rates Header

This table consists of a list of sectors and the CPF gradual types.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPSG_SECTOR Character(1) VARCHAR2(1) NOT NULL The sector used to determine the CPF rate for public or private sectors.
1=Statutory Body (Pensionable)
2=Statutory Body(NonPensionable)
3=Private Sector

2 GPSG_GRADUAL_IND Character(1) VARCHAR2(1) NOT NULL The indicator used to determine the CPF rates for PR 1st year, PR 2nd year or full rates applicable.
1=PR Grad Emplr & Ee - 1st Yr
2=PR Grad Emplr & Ee - 2nd Yr
3=PR Full Emplr, Grad Ee-1st Yr
4=PR Full Emplr, Grad Ee-2nd Yr
F=Full CPF

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPSG_SECTOR	Character(1)	VARCHAR2(1) NOT NULL	The sector used to determine the CPF rate for public or private sectors. 1=Statutory Body (Pensionable) 2=Statutory Body(NonPensionable) 3=Private Sector
2	GPSG_GRADUAL_IND	Character(1)	VARCHAR2(1) NOT NULL	The indicator used to determine the CPF rates for PR 1st year, PR 2nd year or full rates applicable. 1=PR Grad Emplr & Ee - 1st Yr 2=PR Grad Emplr & Ee - 2nd Yr 3=PR Full Emplr, Grad Ee-1st Yr 4=PR Full Emplr, Grad Ee-2nd Yr F=Full CPF
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date