TRN_ESBU_LNG_VW

(SQL View)
 Index Back

Estab-Business Rel Lang View

Establishment Related Language View

SELECT DISTINCT C.BUDGET_PERIOD ,A.BUSINESS_UNIT ,E.ESTABID ,E.LANGUAGE_CD ,E.DESCR FROM PS_JOB A , PS_BUDGET_PERIOD C , PS_BUDGET_BUS_UNIT D ,PS_ESTAB_TBL_LANG E WHERE D.BUDGET_PERIOD=C.BUDGET_PERIOD AND D.BUSINESS_UNIT=A.BUSINESS_UNIT AND E.ESTABID=A.ESTABID AND A.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOB A1 WHERE A.EMPLID=A1.EMPLID AND A.EMPL_RCD=A1.EMPL_RCD) AND A.EFFDT <=C.THRU_DATE AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A.EMPLID = A2.EMPLID AND A.EMPL_RCD = A2.EMPL_RCD AND A.EFFDT = A2.EFFDT) AND E.EFFDT=( SELECT MAX(E1.EFFDT) FROM PS_ESTAB_TBL_LANG E1 WHERE E1.ESTABID=E.ESTABID AND E1.EFFDT<=C.THRU_DATE AND E1.LANGUAGE_CD=E.LANGUAGE_CD)

  • Related Language Record for TRN_ESTB_BUS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description