GPSG_IR8S_MONTH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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.
3	GPSG_CPY_TAX_REF	Character(11)	VARCHAR2(11) NOT NULL	Singapore Company Tax Reference Number
4	GPSG_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year for Singapore IRAS Reporting
5	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
6	GPSG_ORD_WAGES	Number(16,2)	DECIMAL(15,2) NOT NULL	Ordinary Wages
7	GPSG_EE_ORD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	MTD employee ordinary CPF for the CPF reporting.
8	GPSG_ER_ORD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer contribution to CPF for Ordinary Wages
9	GPSG_APP_FUND_ORD	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer ordinary contributions to an approved fund other than CPF.
10	GPSG_ADD_WAGES	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	MTD additional wages for the CPF reporting.
11	GPSG_EE_ADD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	MTD employee additional CPF for the CPF reporting.
12	GPSG_ER_ADD_CPF	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer Additional CPF Contributions
13	GPSG_APP_FUND_ADD	Number(16,2)	DECIMAL(15,2) NOT NULL	Employer additional contributions to an approved fund other than CPF.