EPO_PLN_POSN_VW

(SQL View)
 Index Back

Objective Plan - Position Data

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

SELECT A.EPO_OBJ_PLAN , %Substring(A.EPO_NODE_ID, 1, 8) , B.DESCR ,B.BUSINESS_UNIT ,B.DEPTID ,B.REPORTS_TO FROM PS_EPO_PLAN_PAGES A , PS_POSITION_DATA B , PS_EPO_OBJ_PLAN C WHERE A.EPO_OBJ_PLAN = C.EPO_OBJ_PLAN AND C.EPO_HIERARCHY_MTHD = 'P' AND %Substring(A.EPO_NODE_ID, 1, 8) = B.POSITION_NBR AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_POSITION_DATA B2 WHERE B2.POSITION_NBR = B.POSITION_NBR 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.EPO_NODE_ID = A.EPO_NODE_ID)

  • Related Language Record: EPO_PLN_POSN_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 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    6 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA