GPDE_SI_HRT2_VW

(SQL View)
 Index Back

Health Prov Contrib Rates

Contribution rates for health care providers, keyed by GPDE_SI_PROV. This is the search key of the SI Providers component. The view is used for referencing the health rates in this component.

SELECT B.GPDE_SI_PROV , A.GPDE_SI_PROV_ID , A.EFFDT , A.GPDE_SI_REGION , A.GPDE_SI_RATE_CD , A.GPDE_SI_PCT , A.GPDE_SI_PCT_EE , A.GPDE_SI_PCT_ER , A.GPDE_SI_TOTAL_COST , A.GPDE_SI_EE_COST , A.GPDE_SI_ER_COST , A.CURRENCY_CD FROM PS_GPDE_SI_HLTH_RT A , PS_GPDE_SI_HRT_VW B WHERE A.GPDE_SI_PROV_ID = B.GPDE_SI_PROV_ID AND A.GPDE_SI_REGION = B.GPDE_SI_REGION AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPDE_SI_PROV Character(8) VARCHAR2(8) NOT NULL Social Insurance Provider
2 GPDE_SI_PROV_ID Character(8) VARCHAR2(8) NOT NULL Provider ID
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GPDE_SI_REGION Character(1) VARCHAR2(1) NOT NULL Region
0=General
1=East
2=West
5 GPDE_SI_RATE_CD Character(3) VARCHAR2(3) NOT NULL Calculation Rate

Prompt Table: GPDE_SI_RATE_CD

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

Prompt Table: CURRENCY_CD_TBL