TRN_BU_EMPL_VWL

(SQL View)
 Index Back

Rel Lang for TRN_BU_EMPL_VW

Related language reocrd for TRN_BU_EMPL_VW.

SELECT E.OPRID , C.BUDGET_PERIOD , B.BUSINESS_UNIT , A.EMPLID , A.LANGUAGE_CD , A.NAME_DISPLAY FROM PSOPRDEFN E , PS_NAMES_LNG A , PS_JOB B , PS_BUDGET_PERIOD C , PS_BUDGET_BUS_UNIT D WHERE A.EMPLID = B.EMPLID AND A.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES_LNG, A, %CurrentDateIn) AND D.BUSINESS_UNIT=B.BUSINESS_UNIT AND D.BUDGET_PERIOD=C.BUDGET_PERIOD AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_JOB D WHERE D.EMPLID = B.EMPLID AND D.EMPL_RCD = B.EMPL_RCD AND D.EFFDT <= C.THRU_DATE) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT) AND B.JOB_INDICATOR = 'P'

  • Related Language Record for TRN_BU_EMPL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name