ESTAB_BRA_VW

(SQL View)
 Index Back

Establishment Brazil - View

Establishment Brazil

SELECT A.ESTABID , A.EFFDT , A.DESCR FROM PS_ESTAB_TBL A , PS_ESTAB_TBL_BRA B WHERE B.ESTABID = A.ESTABID AND B.EFFDT = A.EFFDT AND %EffdtCheck(ESTAB_TBL A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: ESTB_BRA_VW_LNG

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

    Prompt Table: ESTAB_TBL

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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