| # |
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 |
SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 6 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
GPSG_ADD_WAGES |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
MTD additional wages for the CPF reporting.
|
| 8 |
GPSG_ADD_FROM_DT |
Date(10) |
DATE |
Additional Wages period from date
|
| 9 |
GPSG_ADD_TO_DT |
Date(10) |
DATE |
Additional Wages period to date
|
| 10 |
GPSG_ADD_PAID_DT |
Date(10) |
DATE |
Additional Wages date paid
|
| 11 |
GPSG_REF_A_AMT_ER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Employer CPF refund amount
|
| 12 |
GPSG_REF_A_INT_ER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Employer CPF interest amount refunded
|
| 13 |
GPSG_REF_DT_ER |
Date(10) |
DATE |
Refund date of employer CPF contributions
|
| 14 |
GPSG_REF_A_AMT_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Employee CPF refund amount
|
| 15 |
GPSG_REF_A_INT_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Employee CPF interest amount refunded
|
| 16 |
GPSG_REF_DT_EE |
Date(10) |
DATE |
Refund date of employee CPF contributions
|