GPSG_CPF_R_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	PERIOD_END_DATE	Date(10)	DATE	Period End Date
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	GPSG_CPF_EMPLR_REF	Character(15)	VARCHAR2(15) NOT NULL	CPF Employer Reference no.
13	GPSG_ER_ORD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer contribution to CPF for Ordinary Wages
14	GPSG_EE_ORD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	MTD employee ordinary CPF for the CPF reporting.
15	GPSG_ER_ADD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer Additional CPF Contributions
16	GPSG_EE_ADD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	MTD employee additional CPF for the CPF reporting.
17	GPSG_ER_CPF_ADJ	Number(16,2)	DECIMAL(15,2) NOT NULL	CPF Adjustment
18	GPSG_EE_CPF_ADJ	Number(16,2)	DECIMAL(15,2) NOT NULL	GPSG. Employee CPF Adjustment
19	GPSG_ER_VOL_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer Voluntary CPF Contributions
20	GPSG_EE_VOL_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employee Voluntary CPF Contribution
21	GPSG_MBMF	Number(8,2)	DECIMAL(7,2) NOT NULL	Mosque Building & Mendaki Fund
22	GPSG_MBF	Number(8,2)	DECIMAL(7,2) NOT NULL	Mosque building fund
23	GPSG_YMF	Number(8,2)	DECIMAL(7,2) NOT NULL	Yayasan Mendaki Fund
24	GPSG_SINDA	Number(8,2)	DECIMAL(7,2) NOT NULL	Singpore Indian Development Association
25	GPSG_CDAC	Number(8,2)	DECIMAL(7,2) NOT NULL	GPSG. Chinese Dev Assistance Council
26	GPSG_ECF	Number(8,2)	DECIMAL(7,2) NOT NULL	GPSG. Eurasian Community Fund
27	GPSG_SHARE	Number(8,2)	DECIMAL(7,2) NOT NULL	SHARE
28	GPSG_FWL	Number(8,2)	DECIMAL(7,2) NOT NULL	Foreign Worker Levy
29	GPSG_SDL	Number(8,2)	DECIMAL(7,2) NOT NULL	Skill Development Levy
30	GPSG_ORD_WAGES	Number(16,2)	DECIMAL(15,2) NOT NULL	Ordinary Wages
31	GPSG_ADD_WAGES	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	MTD additional wages for the CPF reporting.
32	GPSG_NP_WAGES	Number(16,2)	DECIMAL(15,2) NOT NULL	Non-Pensionable Wages
33	GPSG_CPF_REFUND	Character(1)	VARCHAR2(1) NOT NULL	This fields is a flag to indicate if there is CPF refund.
34	GPSG_NEW_CPF_LIMIT	Number(16,2)	DECIMAL(15,2) NOT NULL	New CPF limit for the CPF reporting.
35	GPSG_OLD_CPF_LIMIT	Number(16,2)	DECIMAL(15,2) NOT NULL	Old CPF limit for the CPF reporting.
36	GPSG_CPF_UNIT_NO	Character(3)	VARCHAR2(3) NOT NULL	CPF Unit No. for MOF/MID.
37	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
38	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.
39	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status