WPL_ES2_LNG_BRA

(SQL View)
 Index Back

Worplace Establishment Tbl BRA

Workplace establishments setup table BRA.

SELECT DISTINCT A.COMPANY ,A.WPLACE_LOC_BRA ,A.WPLACE_CODE_BRA ,A.EFFDT ,A.ESTABID ,C.LANGUAGE_CD ,C.DESCR FROM PS_WPL_SRV_TKR_BRA A , PS_ESTAB_TBL B , PS_ESTAB_TBL_LANG C WHERE A.ESTABID = B.ESTABID AND A.COMPANY = B.COMPANY AND B.ESTABID = C.ESTABID AND B.EFFDT = C.EFFDT 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 for WPL_EST2_VW_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description