GPDE_SI_RFD_WRK

(SQL Table)
Index Back

Refund Insurance Rates

Refund 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