EPO_PGSEL_DT_VW

(SQL View)
 Index Back

Objectives Date Range

Used to determine the plan begin and end dates in the Objectives Page.

SELECT HDR.EPO_PAGE_OWNER_ID , HDR.EPO_PAGE_STATUS ,CASE WHEN HDR.EPO_PAGE_STATUS='U' THEN '0' WHEN HDR.EPO_PAGE_STATUS='A' THEN '1' WHEN HDR.EPO_PAGE_STATUS='R' THEN '2' WHEN HDR.EPO_PAGE_STATUS='P' THEN '3' END , PLN.EPO_PLAN_BEGIN_DT , PLN.EPO_PLAN_END_DT FROM PS_EPO_OBJ_PLAN PLN , PS_EPO_PG_HDR HDR WHERE HDR.EPO_OBJ_PLAN = PLN.EPO_OBJ_PLAN AND PLN.EFF_STATUS = 'A' AND HDR.EFFDT = ( SELECT MAX ( HDR2.EFFDT ) FROM PS_EPO_PG_HDR HDR2 WHERE HDR2.EPO_NODE_ID = HDR.EPO_NODE_ID AND HDR2.EPO_OBJ_PLAN = HDR.EPO_OBJ_PLAN AND HDR2.SETID = HDR.SETID ) UNION SELECT HDR.EPO_PG_UPD_ALT_ID , HDR.EPO_PAGE_STATUS ,CASE WHEN HDR.EPO_PAGE_STATUS='U' THEN '0' WHEN HDR.EPO_PAGE_STATUS='A' THEN '1' WHEN HDR.EPO_PAGE_STATUS='R' THEN '2' WHEN HDR.EPO_PAGE_STATUS='P' THEN '3' END , PLN.EPO_PLAN_BEGIN_DT , PLN.EPO_PLAN_END_DT FROM PS_EPO_OBJ_PLAN PLN , PS_EPO_PG_HDR HDR WHERE HDR.EPO_OBJ_PLAN = PLN.EPO_OBJ_PLAN AND PLN.EFF_STATUS = 'A' AND HDR.EFFDT = ( SELECT MAX ( HDR2.EFFDT ) FROM PS_EPO_PG_HDR HDR2 WHERE HDR2.EPO_NODE_ID = HDR.EPO_NODE_ID AND HDR2.EPO_OBJ_PLAN = HDR.EPO_OBJ_PLAN AND HDR2.SETID = HDR.SETID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EPO_PAGE_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who owns the Objective Page
2 EPO_PAGE_STATUS Character(1) VARCHAR2(1) NOT NULL Objectives Management: Status of the Objective Page
A=In Progress - Assigned
I=Inactive
P=Published
R=Ready to Publish
U=In Progress - Unassigned
3 EP_SORT Character(1) VARCHAR2(1) NOT NULL field used to sort current documents grid in NUI MSS
4 EPO_PLAN_BEGIN_DT Date(10) DATE the Date the Objective Plan begins
5 EPO_PLAN_END_DT Date(10) DATE The date the Objective Plan ends