GPDE_SI_PROV_IDEFFDTDefault Value: %date
GPDE_SI_REGION0=General
1=East
2=West
GPDE_SI_RFND_TYP1=Blue Collar Worker
2=Maternity
GPDE_SI_RFND_GRPPrompt Table: GPDE_SI_RFND_GR
GPDE_SI_RFND_RT(SQL Table) |
Index Back |
|---|---|
Refund Insurance RatesRefund Insurance Contribution Rates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_SI_PROV_ID |
Character(8) | VARCHAR2(8) NOT NULL | Provider ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPDE_SI_REGION |
Character(1) | VARCHAR2(1) NOT NULL |
Region
0=General 1=East 2=West |
| 4 | GPDE_SI_RFND_TYP |
Character(1) | VARCHAR2(1) NOT NULL |
Refund Insurance Type
1=Blue Collar Worker 2=Maternity |
| 5 | GPDE_SI_RFND_GRP |
Character(2) | VARCHAR2(2) NOT NULL |
Refund Insurance Contribution Group
Prompt Table: GPDE_SI_RFND_GR |
| 6 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |
| 7 | GPDE_SI_PCT | Number(10,3) | DECIMAL(9,3) NOT NULL | Percent |
| 8 | GPDE_REF_PCT | Number(9,2) | DECIMAL(8,2) NOT NULL | Refund Percent |
| 9 | GPDE_LIM_U1_U2_MAT | Number(1,0) | SMALLINT NOT NULL | Limit U1/U2 Maternity |
| 10 | GPDE_LIM_U2_EMP_BN | Number(1,0) | SMALLINT NOT NULL | GPDE_LIM_U2_EMP_BN |
| 11 | GPDE_REF_CONTR_A_L | Number(1,0) | SMALLINT NOT NULL | Refund Contribution Actual or Lump sum |
| 12 | GPDE_REF_ACT_LP | Number(11,3) | DECIMAL(10,3) NOT NULL | Percent Refund Actual /Lump sum |