GPSG_CPF_RT_AGE (SQL Table)	Index Back
CPF Rate with age This table contains the age for the different CPF rates.

GPSG_CPF_RT_AGE

(SQL Table)

CPF Rate with age

This table contains the age for the different CPF rates.

# 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

4 GPSG_AGE Number(3,0) SMALLINT NOT NULL The age limit used to determine the CPF rates.

#	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
4	GPSG_AGE	Number(3,0)	SMALLINT NOT NULL	The age limit used to determine the CPF rates.