GPDE_SI_RFPR_VW

(SQL View)
 Index Back

Refund Insurance Providers

Refund Insurance Providers

SELECT DISTINCT A.GPDE_SI_PROV , A.EFFDT , A.DESCR FROM PS_GPDE_SI_PROV A , PS_GPDE_SI_RFND_RT B WHERE B.GPDE_SI_PROV_ID = A.GPDE_SI_PROV_ID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GPDE_SI_PROV C WHERE C.GPDE_SI_PROV = A.GPDE_SI_PROV AND C.EFFDT <= B.EFFDT ) AND A.EFF_STATUS <> 'I'

  • Related Language Record: GPDE_SI_RFP_LNG

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

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description