GPDE_AL_PERF_VW

(SQL View)
 Index Back

Flattened Refund Data for PE

Flattened Refund Insurance Data for Pay Entity. The contribution groups for the two refund types are selected into the fields GPDE_SI_CMPINS_1/2.

SELECT RF.PAY_ENTITY , RF.EFFDT , RF.GPDE_SI_RFND_YN , RP1.GPDE_SI_RFND_PRV , SI.GPDE_SI_REGION , RG1.GPDE_SI_RFND_GRP , '21' , RP1.GPDE_SI_DEF_PRV_YN FROM PS_GPDE_AL_PE_RFND RF , PS_GPDE_AL_PE_SDTA SI , PS_GPDE_AL_PE_RFPR RP1 , PS_GPDE_AL_PE_RFGR RG1 WHERE SI.PAY_ENTITY = RF.PAY_ENTITY AND SI.EFFDT = ( SELECT MAX(SI2.EFFDT) FROM PS_GPDE_AL_PE_SDTA SI2 WHERE SI2.PAY_ENTITY = SI.PAY_ENTITY AND SI2.EFFDT <= RF.EFFDT ) AND RF.PAY_ENTITY = RG1.PAY_ENTITY AND RF.EFFDT = RG1.EFFDT AND RF.GPDE_SI_RFND_YN = 'Y' AND RG1.GPDE_SI_RFND_TYP = '1' AND RP1.PAY_ENTITY=RF.PAY_ENTITY AND RP1.EFFDT=RF.EFFDT AND RP1.GPDE_SI_RFND_PRV=RG1.GPDE_SI_RFND_PRV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 GPDE_SI_RFND_YN Character(1) VARCHAR2(1) NOT NULL Refund Insurance Flag

Y/N Table Edit

4 GPDE_SI_RFND_PRV Character(8) VARCHAR2(8) NOT NULL Social Insurance Provider

Prompt Table: GPDE_SI_RFPR_VW

5 GPDE_SI_REGION Character(1) VARCHAR2(1) NOT NULL Region
0=General
1=East
2=West
6 GPDE_SI_CMPINS_1 Character(3) VARCHAR2(3) NOT NULL U1 for Sickness
00=None
10=Regular
11=Increased
12=Reduced
7 GPDE_SI_CMPINS_2 Character(3) VARCHAR2(3) NOT NULL U2 for Maternity
00=None
20=Regular
21=Increased
22=Reduced
8 GPDE_SI_DEF_PRV_YN Character(1) VARCHAR2(1) NOT NULL Default Provider Flag