ESTAB_SRCH_VW

(SQL View)
 Index Back

Establishment Search Record

Establishment Search Record.

SELECT A.ESTABID ,A.DESCR FROM PS_ESTAB_TBL A WHERE A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_ESTAB_TBL A1 WHERE A.ESTABID = A1.ESTABID) AND A.EFF_STATUS = 'A'

  • Related Language Record: ESTAB_SRCH_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