GPSG_CPF_RSLTS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	PERIOD_END_DATE	Date(10)	DATE	Period End Date
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	GPSG_CPF_EMPLR_REF	Character(15)	VARCHAR2(15) NOT NULL	CPF Employer Reference no.
11	GPSG_ER_ORD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer contribution to CPF for Ordinary Wages
12	GPSG_EE_ORD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	MTD employee ordinary CPF for the CPF reporting.
13	GPSG_ER_ADD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer Additional CPF Contributions
14	GPSG_EE_ADD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	MTD employee additional CPF for the CPF reporting.
15	GPSG_ER_CPF_ADJ	Number(16,2)	DECIMAL(15,2) NOT NULL	CPF Adjustment
16	GPSG_EE_CPF_ADJ	Number(16,2)	DECIMAL(15,2) NOT NULL	GPSG. Employee CPF Adjustment
17	GPSG_ER_VOL_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer Voluntary CPF Contributions
18	GPSG_EE_VOL_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employee Voluntary CPF Contribution
19	GPSG_MBMF	Number(8,2)	DECIMAL(7,2) NOT NULL	Mosque Building & Mendaki Fund
20	GPSG_MBF	Number(8,2)	DECIMAL(7,2) NOT NULL	Mosque building fund
21	GPSG_YMF	Number(8,2)	DECIMAL(7,2) NOT NULL	Yayasan Mendaki Fund
22	GPSG_SINDA	Number(8,2)	DECIMAL(7,2) NOT NULL	Singpore Indian Development Association
23	GPSG_CDAC	Number(8,2)	DECIMAL(7,2) NOT NULL	GPSG. Chinese Dev Assistance Council
24	GPSG_ECF	Number(8,2)	DECIMAL(7,2) NOT NULL	GPSG. Eurasian Community Fund
25	GPSG_SHARE	Number(8,2)	DECIMAL(7,2) NOT NULL	SHARE
26	GPSG_FWL	Number(8,2)	DECIMAL(7,2) NOT NULL	Foreign Worker Levy
27	GPSG_SDL	Number(8,2)	DECIMAL(7,2) NOT NULL	Skill Development Levy
28	GPSG_ORD_WAGES	Number(16,2)	DECIMAL(15,2) NOT NULL	Ordinary Wages
29	GPSG_ADD_WAGES	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	MTD additional wages for the CPF reporting.
30	GPSG_NP_WAGES	Number(16,2)	DECIMAL(15,2) NOT NULL	Non-Pensionable Wages
31	GPSG_CPF_REFUND	Character(1)	VARCHAR2(1) NOT NULL	This fields is a flag to indicate if there is CPF refund.
32	GPSG_NEW_CPF_LIMIT	Number(16,2)	DECIMAL(15,2) NOT NULL	New CPF limit for the CPF reporting.
33	GPSG_OLD_CPF_LIMIT	Number(16,2)	DECIMAL(15,2) NOT NULL	Old CPF limit for the CPF reporting.
34	GPSG_CPF_UNIT_NO	Character(3)	VARCHAR2(3) NOT NULL	CPF Unit No. for MOF/MID.
35	GPSG_CPF_ER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	CPF employer type for MOF/MID for the CPF reporting. A=Bonus Payment C=Contract Servicemen N=Non-pensionable P=Pensionable S=Saver's Plan
36	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.
37	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status