EPO_CASCDEPT_VW (SQL View)	Index Back
Departments with Obj Pages Objective Pages created for Departments

EPO_CASCDEPT_VW

(SQL View)

Departments with Obj Pages

Objective Pages created for Departments

SELECT A.EPO_NODE_ID FROM PS_EPO_PLAN_PAGES A , PS_EPO_PLAN_DEPT B WHERE A.EPO_OBJ_PLAN = B.EPO_OBJ_PLAN AND A.SETID = B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EPO_NODE_ID Character(10) VARCHAR2(10) NOT NULL Objectives Management. Used to store the Node ID associated with the Objective Plan