GPJP_TAX_ESTABEFFDTDefault Value: %date
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Y/N Table Edit
Default Value: N
GPJP_SC_EST_DTA(SQL Table) |
Index Back |
|---|---|
SI Establishment Rates detailThis table is used to store Social Insurance Premium rates by Social Insurance Establishment. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPJP_TAX_ESTAB |
Character(15) | VARCHAR2(15) NOT NULL | Salary Payer Reference Number |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPJP_SAL_HLTH_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Salary Health Rate
Default Value: 0 |
| 4 | GPJP_SAL_NURS_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Salary Nursing Care Rate.
Default Value: 0 |
| 5 | GPJP_SAL_PENS_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Employee's Pension.
Default Value: 0 |
| 6 | GPJP_SAL_EPFUND_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Employee's Pension Fund.
Default Value: 0 |
| 7 | GPJP_BNS_HLTH_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Payee's Health Insurance Rate for Bonus
Default Value: 0 |
| 8 | GPJP_BNS_NURS_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Bonus Nursing Care Rate.
Default Value: 0 |
| 9 | GPJP_BNS_PENS_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Employee's Pension.
Default Value: 0 |
| 10 | GPJP_BNS_EPFUND_RT | Number(8,5) | DECIMAL(7,5) NOT NULL |
Employee's Pension Fund.
Default Value: 0 |
| 11 | GPJP_SAL_HLTH_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Health Insurance Rate for Salary |
| 12 | GPJP_SAL_NURS_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Nursing Care Rate for Salary |
| 13 | GPJP_SAL_PENS_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Pension Insurance Rate for Salary |
| 14 | GPJP_SAL_PF_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Pension Fund Rate for Salary |
| 15 | GPJP_BNS_HLTH_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Health Insurance Rate for Bonus |
| 16 | GPJP_BNS_NURS_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Nursing Care Rate for Bonus |
| 17 | GPJP_BNS_PENS_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Pension Insurance Rate for Bonus |
| 18 | GPJP_BNS_PF_RT_C | Number(8,5) | DECIMAL(7,5) NOT NULL | Payer's Pension Fund Rate for Bonus |
| 19 | GPJP_SC_ROUND | Character(1) | VARCHAR2(1) NOT NULL |
Round Up if >= 0.501
Y/N Table Edit Default Value: N |