GPSG_IR8S_A_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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.
4	GPSG_CPY_TAX_REF	Character(11)	VARCHAR2(11) NOT NULL	Singapore Company Tax Reference Number
5	GPSG_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year for Singapore IRAS Reporting
6	GPSG_IRAS_STG_FLG	Character(1)	VARCHAR2(1) NOT NULL	STAGING FLAG
7	GPSG_MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month code, 01 thru 12, plus 99 for totals. 01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December 99=Total
8	GPSG_A_ORD_WAGES	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Ordinary Wages
9	GPSG_A_EE_ORD_CPF	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	MTD employee ordinary CPF for the CPF reporting.
10	GPSG_A_ER_ORD_CPF	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employer contribution to CPF for Ordinary Wages
11	GPSG_A_APP_FND_ORD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employer ordinary contributions to an approved fund other than CPF.
12	GPSG_ADD_WAGES	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	MTD additional wages for the CPF reporting.
13	GPSG_A_EE_ADD_CPF	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	MTD employee additional CPF for the CPF reporting.
14	GPSG_A_ER_ADD_CPF	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employer Additional CPF Contributions
15	GPSG_A_APP_FND_ADD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employer additional contributions to an approved fund other than CPF.