DEPT_POSNS_LANG

(SQL View)
 Index Back

Positions within Department

The list of all positions in a given Department. This view is used for F4 prompt support in Position Budgeting.

SELECT B.SETID ,B.DEPTID ,C.POSITION_NBR ,C.LANGUAGE_CD ,C.EFFDT ,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 B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_DEPT_TBL D WHERE D.DEPTID = B.DEPTID AND D.SETID=B.SETID AND D.EFFDT<=%CurrentDateIn) AND C.POSITION_NBR=A.POSITION_NBR AND C.EFFDT=A.EFFDT

  • Related Language Record for DEPT_POSITIONS

    • # 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

    Prompt Table: DEPT_TBL

    3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE Effective Date
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description