DEPT_POSITIONS

(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 ,A.DEPTID ,A.POSITION_NBR ,A.EFFDT ,A.DESCR FROM PS_POSITION_DATA A , PS_DEPT_TBL B 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 A.EFFDT=( SELECT MAX(E.EFFDT) FROM PS_POSITION_DATA E WHERE E.DEPTID=B.DEPTID AND E.EFFDT<=%CurrentDateIn)

  • Related Language Record: DEPT_POSNS_LANG

    • # 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 EFFDT Date(10) DATE Effective Date
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description