GPMX_ESTAB_VW

(SQL View)
 Index Back

Establishment not RPU

Establishmentes that are not defined as RPU

SELECT A.ESTABID , A.DESCR FROM PS_ESTAB_TBL A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ESTAB_TBL A_ED WHERE A.ESTABID = A_ED.ESTABID ) AND NOT EXISTS ( SELECT 'X' FROM PS_ESTAB_TBL B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_ESTAB_TBL B_ED WHERE B.ESTABID = B_ED.ESTABID) AND B.COMPANY = A.COMPANY AND B.RPU_ESTABID_MEX = 'Y')

  • Related Language Record: GPMX_ESTAB_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description