EPO_OWN_DEPT_VW

(SQL View)
 Index Back

Obj Mgmt - Dept with pages

View of active departments that have pages created. This view uses the Dept Security view.

SELECT DISTINCT HDR.EPO_OBJ_PLAN , HDR.SETID , HDR.EPO_NODE_ID , HDR.EPO_PAGE_OWNER_ID , HDR.EPO_PAGE_OWNER_RCD , S.DESCR FROM PS_EPO_PLAN_PAGES PG , PS_EPO_PG_HDR HDR , PS_DEPARTMENT_SRCH S WHERE PG.EPO_OBJ_PLAN = HDR.EPO_OBJ_PLAN AND PG.SETID = HDR.SETID AND PG.EPO_NODE_ID = HDR.EPO_NODE_ID AND PG.EPO_NODE_ID = S.DEPTID AND PG.SETID = S.SETID AND HDR.EPO_PAGE_STATUS <> 'I' AND HDR.EFFDT = ( SELECT MAX ( HDR2.EFFDT ) FROM PS_EPO_PG_HDR HDR2 WHERE HDR2.EPO_NODE_ID = HDR.EPO_NODE_ID AND HDR2.SETID = HDR.SETID AND HDR2.EPO_OBJ_PLAN = HDR.EPO_OBJ_PLAN AND HDR2.EFFDT <= %CurrentDateIn )

# 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 EPO_NODE_ID Character(10) VARCHAR2(10) NOT NULL Objectives Management. Used to store the Node ID associated with the Objective Plan
4 EPO_PAGE_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who owns the Objective Page
5 EPO_PAGE_OWNER_RCD Number(3,0) SMALLINT NOT NULL Page Owner Record Number
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description