GPDE_SI_RFD_WRK(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 | GPDE_SI_PCT | Number(10,3) | DECIMAL(9,3) NOT NULL | Percent |
7 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |
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 |