GPSG_IR8S_RF_VW

(SQL View)
 Index Back

Sgp IR8S data

Data extracted for Singapore IR8S reporting

SELECT A.EMPLID , A.BALANCE_GRP_NUM , A.GPSG_CPY_TAX_REF , A.GPSG_TAX_YEAR , A.SEQNBR , A.SEQ_NO , A.GPSG_ADD_WAGES , A.GPSG_ADD_FROM_DT , A.GPSG_ADD_TO_DT , A.GPSG_ADD_PAID_DT , A.GPSG_REF_A_AMT_ER , A.GPSG_REF_A_INT_ER , A.GPSG_REF_DT_ER , A.GPSG_REF_A_AMT_EE , A.GPSG_REF_A_INT_EE , A.GPSG_REF_DT_EE FROM PS_GPSG_IR8S_A_RFD A WHERE A.SEQNBR = ( SELECT MAX(A_S.SEQNBR) FROM PS_GPSG_IR8S_A_RFD A_S WHERE A_S.GPSG_CPY_TAX_REF = A.GPSG_CPY_TAX_REF AND A_S.GPSG_TAX_YEAR = A.GPSG_TAX_YEAR AND A_S.EMPLID = A.EMPLID AND A_S.BALANCE_GRP_NUM = A.BALANCE_GRP_NUM AND A_S.SEQ_NO = A.SEQ_NO AND A_S.SEQNBR < ( SELECT MAX(B_S.SEQNBR) FROM PS_GPSG_IR8S_A_RFD B_S WHERE B_S.GPSG_CPY_TAX_REF = A.GPSG_CPY_TAX_REF AND B_S.GPSG_TAX_YEAR = A.GPSG_TAX_YEAR AND B_S.EMPLID = A.EMPLID AND B_S.BALANCE_GRP_NUM = A.BALANCE_GRP_NUM AND B_S.SEQ_NO = A.SEQ_NO )) AND EXISTS( SELECT C.EMPLID FROM PS_GPSG_IR8A_A_TBL C WHERE C.GPSG_CPY_TAX_REF = A.GPSG_CPY_TAX_REF AND C.GPSG_TAX_YEAR = A.GPSG_TAX_YEAR AND C.EMPLID = A.EMPLID AND C.BALANCE_GRP_NUM = A.BALANCE_GRP_NUM AND C.GPSG_8A_STATUS = 'W')

# 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