# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
GPSG_CPF_EMPLR_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
CPF Employer Reference no.
|
2 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
3 |
GPSG_UPLOAD_DT |
Date(10) |
DATE |
GPSG_UPLOAD_DT
|
4 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
5 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
6 |
GPSG_MOM_LEVY_DT |
Date(10) |
DATE |
Singapore Payroll MoM Levy Date
|
7 |
GPSG_MOM_LV_EDT |
Date(10) |
DATE |
Global Payroll Singapore MoM Levy End Date
|
8 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
10 |
EMPLNAME |
Character(50) |
VARCHAR2(50) NOT NULL |
EmplName
|
11 |
GPSG_MOM_AMOUNT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Singapore Payroll MoM Amount
|
12 |
GPSG_MOM_LEVY_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Singapore Payroll MoM Levy Rate
|
13 |
WORKER_TYPE_SGP |
Character(2) |
VARCHAR2(2) NOT NULL |
Worker's Type - Singapore
|