POSN_BDGT_L_VW

(SQL View)
 Index Back

Position budget view (LNG)

Position budget view (Language)

SELECT DISTINCT B.SETID ,B.BUDGET_DEPTID ,A.POSITION_NBR ,C.LANGUAGE_CD ,C.DESCR FROM PS_POSITION_DATA A , PS_DEPT_TBL B , PS_POSN_DATA_LANG C WHERE B.SETID=( SELECT Z.SETID FROM PS_SET_CNTRL_REC Z WHERE Z.SETCNTRLVALUE=A.BUSINESS_UNIT AND Z.RECNAME='DEPT_TBL') AND B.DEPTID=A.DEPTID AND ((A.EFFDT > B.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_POSITION_DATA A1 WHERE A1.POSITION_NBR = A.POSITION_NBR AND A1.DEPTID = A.DEPTID AND A1.EFFDT < A.EFFDT AND A1.EFFDT > B.EFFDT) AND NOT EXISTS ( SELECT 'X' FROM PS_DEPT_TBL B1 WHERE B1.SETID = B.SETID AND B1.DEPTID = B.DEPTID AND B1.EFFDT < A.EFFDT AND B1.EFFDT > B.EFFDT)) OR A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_POSITION_DATA A2 WHERE A2.POSITION_NBR = A.POSITION_NBR AND A2.DEPTID = A.DEPTID AND A2.EFFDT <= B.EFFDT)) AND A.POSITION_NBR = C.POSITION_NBR AND A.EFFDT = C.EFFDT

  • Related Language Record for POSN_BDGT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description