GPSG_CPF_AWH_VW

(SQL View)
 Index Back

CPF Add wages results View

This table is created through global payroll process for Singapore extension. It stores the Additional wages and CPF rates results.

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , PERIOD_END_DATE , GPSG_PAY_YEAR , GPSG_PAY_MTH , GPSG_ADD_WAGES , GPSG_ADD_WAGES_SEG , GPSG_ADD_WAGES_YTD , GPSG_AW_CPF_MTD ,GPSG_ADD_WAGES - GPSG_AW_CPF_MTD , GPSG_CPF_TOT_LIMIT , GPSG_CPF_ORD_LIMIT , GPSG_CPF_ADD_LIMIT , GPSG_TOT_PCT_ADDNL , GPSG_EE_PCT_ADDNL , GPSG_EE_ADD_CPF , GPSG_ER_ADD_CPF FROM PS_GPSG_CPF_AW_HIS WHERE CAL_RUN_ID = ORIG_CAL_RUN_ID AND (GPSG_ADD_WAGES - GPSG_AW_CPF_MTD) > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 PERIOD_END_DATE Date(10) DATE Period End Date
9 GPSG_PAY_YEAR Number(4,0) SMALLINT NOT NULL Number field to represent a year
10 GPSG_PAY_MTH Number(2,0) SMALLINT NOT NULL Month code, 01 thru 12
11 GPSG_ADD_WAGES Signed Number(17,2) DECIMAL(15,2) NOT NULL MTD additional wages for the CPF reporting.
12 GPSG_ADD_WAGES_SEG Signed Number(17,2) DECIMAL(15,2) NOT NULL Additional wages in segment for the CPF reporting.
13 GPSG_ADD_WAGES_YTD Signed Number(17,2) DECIMAL(15,2) NOT NULL YTD additional wages for the CPF reporting.
14 GPSG_AW_CPF_MTD Signed Number(17,2) DECIMAL(15,2) NOT NULL MTD additional wages for the CPF contribution.
15 GPSG_AW_CPF_NC Signed Number(17,2) DECIMAL(15,2) NOT NULL MTD additional wages not contributed to CPF
16 GPSG_CPF_TOT_LIMIT Number(16,2) DECIMAL(15,2) NOT NULL Total wages CPF limit for the CPF reporting.
17 GPSG_CPF_ORD_LIMIT Number(16,2) DECIMAL(15,2) NOT NULL Ordinary wages CPF limit for the CPF reporting.
18 GPSG_CPF_ADD_LIMIT Number(16,2) DECIMAL(15,2) NOT NULL Additional wages CPF limit for the CPF reporting.
19 GPSG_TOT_PCT_ADDNL Number(8,4) DECIMAL(7,4) NOT NULL Total percentage of additional wages.
20 GPSG_EE_PCT_ADDNL Number(8,4) DECIMAL(7,4) NOT NULL Employee percentage of additional wages.
21 GPSG_EE_ADD_CPF Number(16,2) DECIMAL(15,2) NOT NULL MTD employee additional CPF for the CPF reporting.
22 GPSG_ER_ADD_CPF Number(16,2) DECIMAL(15,2) NOT NULL Employer Additional CPF Contributions