GPSG_CPF_RATES(SQL Table) |
Index Back |
|---|---|
CPF Rates TableThis table contains the CPF rates details. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPSG_SECTOR |
Character(1) | VARCHAR2(1) NOT NULL |
The sector used to determine the CPF rate for public or private sectors.
1=Statutory Body (Pensionable) 2=Statutory Body(NonPensionable) 3=Private Sector |
| 2 | GPSG_GRADUAL_IND |
Character(1) | VARCHAR2(1) NOT NULL |
The indicator used to determine the CPF rates for PR 1st year, PR 2nd year or full rates applicable.
1=PR Grad Emplr & Ee - 1st Yr 2=PR Grad Emplr & Ee - 2nd Yr 3=PR Full Emplr, Grad Ee-1st Yr 4=PR Full Emplr, Grad Ee-2nd Yr F=Full CPF |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | GPSG_AGE |
Number(10,6) | DECIMAL(9,6) NOT NULL | The age limit used to determine the CPF rates. |
| 5 | GPSG_WAGES |
Number(17,6) | DECIMAL(16,6) NOT NULL | The wage level used to determine the CPF rates. |
| 6 | GPSG_TOT_PCT_ORD | Number(8,4) | DECIMAL(7,4) NOT NULL | Total Percentage of ordinary wages |
| 7 | GPSG_TOT_PCT_NP | Number(8,4) | DECIMAL(7,4) NOT NULL | Total percentage of NPVP/NPC wages. |
| 8 | GPSG_TOT_LIMIT | Number(12,2) | DECIMAL(11,2) NOT NULL | Total limit on ordinary CPF |
| 9 | GPSG_TOT_WAGE_BASE | Number(9,4) | DECIMAL(8,4) NOT NULL | The wages base is used in obtaining the difference with total wages or ordinary wages for the calculation of CPF. |
| 10 | GPSG_TOT_FLAT_AMT | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Used to store the value of flat amount |
| 11 | GPSG_TOT_NUMERATOR | Number(4,0) | SMALLINT NOT NULL | Numerator for the calculation of CPF. |
| 12 | GPSG_TOT_DENOM | Number(5,0) | INTEGER NOT NULL | Denominator used for the calculation of CPF. |
| 13 | GPSG_WAGES_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Wages Type used for the calculation of CPF. It is Ordinary Wages for civil service and Total Wages for private sector.
1=Ordinary Wages 2=Total Wages |
| 14 | GPSG_TOT_PCT_ADDNL | Number(8,4) | DECIMAL(7,4) NOT NULL | Total percentage of additional wages. |
| 15 | GPSG_RCV_PCT_ORD | Number(8,4) | DECIMAL(7,4) NOT NULL | Recoverable percentage of ordinary wages |
| 16 | GPSG_RCV_PCT_NP | Number(8,4) | DECIMAL(7,4) NOT NULL | Recoverable percentage of NPVP/NPC wages. |
| 17 | GPSG_RCV_LIMIT | Number(12,2) | DECIMAL(11,2) NOT NULL | Recoverable limit on ordinary CPF |
| 18 | GPSG_RCV_WAGE_BASE | Number(9,4) | DECIMAL(8,4) NOT NULL | The wages base is used in obtaining the difference with total wages or ordinary wages for the calculation of CPF recoverable. |
| 19 | GPSG_RCV_FLAT_AMT | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Used to store the employee flat amount |
| 20 | GPSG_RCV_NUMERATOR | Number(4,0) | SMALLINT NOT NULL | Numerator used for the calculation of CPF recoverable. |
| 21 | GPSG_RCV_DENOM | Number(5,0) | INTEGER NOT NULL | Denominator used for the calculation of CPF recoverable. |
| 22 | GPSG_RCV_PCT_ADDNL | Number(8,4) | DECIMAL(7,4) NOT NULL | Recoverable percentage of additional wages. |