EPO_NOD_POS_VW (SQL View)	Index Back
Obj Mgmt - Posn with pages Used as a prompt table for valid Positions on the Common Objective Page Selection page. Uses the Position security view.

EPO_NOD_POS_VW

(SQL View)

Obj Mgmt - Posn with pages

Used as a prompt table for valid Positions on the Common Objective Page Selection page. Uses the Position security view.

SELECT DISTINCT HDR.EPO_OBJ_PLAN , HDR.EPO_NODE_ID , S.OPRID , S.DESCR FROM PS_EPO_PLAN_PAGES PG , PS_EPO_PG_HDR HDR , PS_POSITION_SRCH S WHERE PG.EPO_OBJ_PLAN = HDR.EPO_OBJ_PLAN AND PG.EPO_NODE_ID = HDR.EPO_NODE_ID AND PG.EPO_NODE_ID = S.POSITION_NBR 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.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 EPO_NODE_ID Character(10) VARCHAR2(10) NOT NULL Objectives Management. Used to store the Node ID associated with the Objective Plan

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 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	EPO_NODE_ID	Character(10)	VARCHAR2(10) NOT NULL	Objectives Management. Used to store the Node ID associated with the Objective Plan
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description