EPO_PLN_POSN_LV

(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) , BL.LANGUAGE_CD , BL.DESCR FROM PS_EPO_PLAN_PAGES A , PS_POSITION_DATA B , PS_EPO_OBJ_PLAN C , PS_POSN_DATA_LANG BL 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.POSITION_NBR = BL.POSITION_NBR AND B.EFFDT = BL.EFFDT 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 for EPO_PLN_POSN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description