GPSG_CPF_RPTG(SQL Table) |
Index Back |
|---|---|
CPF ReportingThis table is used for producing the CPF reports and CPF Line files. It is polulated by the monthly CPF Data Creation Process. |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | GPSG_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 4 | MONTHCD |
Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | 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. |
| 7 | GPSG_EE_CPF_ACCT | Character(9) | VARCHAR2(9) NOT NULL | Employee CPF Account No. |
| 8 | GPSG_NEW_EMPLOYEE | Character(1) | VARCHAR2(1) NOT NULL | New employee flag |
| 9 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 10 | GPSG_ER_ORD_CPF | Number(16,2) | DECIMAL(15,2) NOT NULL | Employer contribution to CPF for Ordinary Wages |
| 11 | GPSG_EE_ORD_CPF | Number(16,2) | DECIMAL(15,2) NOT NULL | MTD employee ordinary CPF for the CPF reporting. |
| 12 | GPSG_ER_ADD_CPF | Number(16,2) | DECIMAL(15,2) NOT NULL | Employer Additional CPF Contributions |
| 13 | GPSG_EE_ADD_CPF | Number(16,2) | DECIMAL(15,2) NOT NULL | MTD employee additional CPF for the CPF reporting. |
| 14 | GPSG_ER_VOL_CPF | Number(16,2) | DECIMAL(15,2) NOT NULL | Employer Voluntary CPF Contributions |
| 15 | GPSG_EE_VOL_CPF | Number(16,2) | DECIMAL(15,2) NOT NULL | Employee Voluntary CPF Contribution |
| 16 | GPSG_MBMF | Number(8,2) | DECIMAL(7,2) NOT NULL | Mosque Building & Mendaki Fund |
| 17 | GPSG_MBF | Number(8,2) | DECIMAL(7,2) NOT NULL | Mosque building fund |
| 18 | GPSG_YMF | Number(8,2) | DECIMAL(7,2) NOT NULL | Yayasan Mendaki Fund |
| 19 | GPSG_SINDA | Number(8,2) | DECIMAL(7,2) NOT NULL | Singpore Indian Development Association |
| 20 | GPSG_CDAC | Number(8,2) | DECIMAL(7,2) NOT NULL | GPSG. Chinese Dev Assistance Council |
| 21 | GPSG_ECF | Number(8,2) | DECIMAL(7,2) NOT NULL | GPSG. Eurasian Community Fund |
| 22 | GPSG_SHARE | Number(8,2) | DECIMAL(7,2) NOT NULL | SHARE |
| 23 | GPSG_FWL | Number(8,2) | DECIMAL(7,2) NOT NULL | Foreign Worker Levy |
| 24 | GPSG_SDL | Number(8,2) | DECIMAL(7,2) NOT NULL | Skill Development Levy |
| 25 | GPSG_ORD_WAGES | Number(16,2) | DECIMAL(15,2) NOT NULL | Ordinary Wages |
| 26 | GPSG_ADD_WAGES | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | MTD additional wages for the CPF reporting. |
| 27 | GPSG_CPF_REFUND | Character(1) | VARCHAR2(1) NOT NULL | This fields is a flag to indicate if there is CPF refund. |
| 28 | GPSG_OLD_CPF_LIMIT | Number(16,2) | DECIMAL(15,2) NOT NULL | Old CPF limit for the CPF reporting. |
| 29 | GPSG_NEW_CPF_LIMIT | Number(16,2) | DECIMAL(15,2) NOT NULL | New CPF limit for the CPF reporting. |
| 30 | GPSG_CPF_UNIT_NO | Character(3) | VARCHAR2(3) NOT NULL | CPF Unit No. for MOF/MID. |
| 31 | GPSG_CPF_ER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
CPF employer type for MOF/MID for the CPF reporting.
A=Bonus Payment C=Contract Servicemen N=Non-pensionable P=Pensionable S=Saver's Plan |