EPO_PLN_DEPT_VW

(SQL View)
 Index Back

Objective Plan - Dept View

This is a view of plan pages record and the department table. This is used in the objective page creation process.

SELECT A.EPO_OBJ_PLAN , A.SETID , A.EPO_NODE_ID , B.DESCR , B.MANAGER_ID , B.MANAGER_POSN FROM PS_EPO_PLAN_PAGES A , PS_DEPT_TBL B , PS_EPO_OBJ_PLAN C WHERE A.EPO_OBJ_PLAN = C.EPO_OBJ_PLAN AND C.EPO_HIERARCHY_MTHD = 'D' AND A.SETID = B.SETID AND A.EPO_NODE_ID = B.DEPTID AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_DEPT_TBL B2 WHERE B2.SETID = B.SETID AND B2.DEPTID = B.DEPTID AND B2.EFFDT <=%CurrentDateIn) AND NOT EXISTS ( SELECT EPO_NODE_ID FROM PS_EPO_PG_HDR HDR WHERE HDR.EPO_OBJ_PLAN = A.EPO_OBJ_PLAN AND HDR.SETID = A.SETID AND HDR.EPO_NODE_ID = A.EPO_NODE_ID)

  • Related Language Record: EPO_PLN_DEPT_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EPO_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

    Prompt Table: HCR_SUP_ID_DVW

    6 MANAGER_POSN Character(8) VARCHAR2(8) NOT NULL Manager Position

    Prompt Table: POSN_DATA_VW