EPO_NOD_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.

EPO_NOD_DEPT_VW

(SQL View)

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 , S.OPRID , 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description