WPL_EST_VW_BRA

(SQL View)
 Index Back

Worplace Establishment Tbl BRA

Workplace establishments setup table BRA.

SELECT A.COMPANY ,A.WPLACE_LOC_BRA ,A.WPLACE_CODE_BRA ,A.EFFDT ,A.ESTABID ,B.DESCR FROM PS_WPL_ESTAB_BRA A , PS_ESTAB_TBL B WHERE A.ESTABID = B.ESTABID AND A.COMPANY = B.COMPANY AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_ESTAB_TBL B2 WHERE B2.ESTABID = B.ESTABID AND B2.EFFDT <= A.EFFDT)

  • Related Language Record: WPL_EST_LNG_BRA

  • Parent record: WPLACE_TBL_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 WPLACE_LOC_BRA Character(1) VARCHAR2(1) NOT NULL Worplace location.
    1=Employer Establishment
    2=Service Taker Establishment
    3=Third Party Establishment
    3 WPLACE_CODE_BRA Character(10) VARCHAR2(10) NOT NULL Workplace code.
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_COMP_VW

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