GPDE_SI_LCOF_VW

(SQL View)
 Index Back

SI Prov Local Offices

SI Prov Local Offices

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

  • Related Language Record: GPDE_SI_LCO_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 Effective Date

    Default Value: %date

    3 GPDE_SI_LCL_OFC Character(8) VARCHAR2(8) NOT NULL Social Insurance Provider
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description