GPSG_IR8S_MONTH

(SQL Table)
Index Back

Sgp IR8S data

Data extracted for Singapore IR8S reporting

# 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.