GPDE_SI_HRT_WRK

(SQL Table)
Index Back

Health Prov Contrib Rates

Contribution rates for health care providers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPDE_SI_PROV_ID Character(8) VARCHAR2(8) NOT NULL Provider ID

Prompt Table: GPDE_SI_HDOF_VW

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_RATE_CD Character(3) VARCHAR2(3) NOT NULL Calculation Rate

Prompt Table: %EDITTABLE

5 GPDE_SI_PCT Number(10,3) DECIMAL(9,3) NOT NULL Percent
6 GPDE_SI_PCT_EE Number(8,4) DECIMAL(7,4) NOT NULL Percent Employee
7 GPDE_SI_PCT_ER Number(8,4) DECIMAL(7,4) NOT NULL Percent Employer
8 GPDE_SI_TOTAL_COST Number(19,3) DECIMAL(18,3) NOT NULL Total Computed Cost
9 GPDE_SI_EE_COST Number(7,2) DECIMAL(6,2) NOT NULL Employee Contribution
10 GPDE_SI_ER_COST Number(7,2) DECIMAL(6,2) NOT NULL Employer Contribution
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

12 LAST_UPDATE_DATE Date(10) DATE Date of last update