GPDE_SI_PROVEFFDTDefault 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_RFR2_VW(SQL View) |
Index Back |
|---|---|
Refund Insurance RatesRefund Insurance Rates keyed by GPDE_SI_PROV. |
| SELECT DISTINCT B.GPDE_SI_PROV , B.GPDE_SI_PROV_ID , A.EFFDT , A.GPDE_SI_REGION , A.GPDE_SI_RFND_TYP , A.GPDE_SI_RFND_GRP , A.GPDE_SI_PCT , A.GPDE_REF_PCT FROM PS_GPDE_SI_RFND_RT A , PS_GPDE_SI_RFRT_VW B WHERE A.GPDE_SI_PROV_ID <> ' ' AND B.GPDE_SI_PROV_ID = A.GPDE_SI_PROV_ID AND B.EFFDT = A.EFFDT AND B.GPDE_SI_REGION = A.GPDE_SI_REGION |
| # | 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_RFND_TYP |
Character(1) | VARCHAR2(1) NOT NULL |
Refund Insurance Type
1=Blue Collar Worker 2=Maternity |
| 6 | GPDE_SI_RFND_GRP |
Character(2) | VARCHAR2(2) NOT NULL |
Refund Insurance Contribution Group
Prompt Table: GPDE_SI_RFND_GR |
| 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 |