ESTAB_HQ_VW

(SQL View)
Index Back

SELECT A.ESTABID , A.EFFDT , A.EFF_STATUS , A.COMPANY , A.DESCR FROM PS_ESTAB_TBL A WHERE A.HQUNIT = 'Y' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ESTAB_TBL A_ED WHERE A.ESTABID = A_ED.ESTABID AND A_ED.EFFDT <= %CurrentDateIn )

  • Related Language Record: ESTAB_HQ_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description