GPSG_MOM_DATA

(SQL Table)
Index Back

Sgp Payroll MoM File Data

Singapore Payroll MoM File Data. It stores the MoM file data and generated comparison data.

# 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