GPSG_IR8S_MONTH(SQL Table) |
Index Back |
---|---|
Sgp IR8S dataData 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. |