WP_EST_BRA_VW

(SQL View)
 Index Back

Workplace by Establishment

Workplace by Establishment

SELECT A.ESTABID , A.WPLACE_CODE_BRA , B.DESCR100 FROM PS_WPL_ESTAB_BRA A , PS_WPLACE_TBL_BRA B WHERE A.WPLACE_LOC_BRA = B.WPLACE_LOC_BRA AND A.WPLACE_CODE_BRA = B.WPLACE_CODE_BRA AND A.EFFDT = B.EFFDT AND %EffdtCheck(WPLACE_TBL_BRA B1, B, %CurrentDateIn)

  • Related Language Record: WP_E_BRA_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    2 WPLACE_CODE_BRA Character(10) VARCHAR2(10) NOT NULL Workplace code.
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description