EPO_GBLKEY_SRCH

(SQL View)
Index Back

Objective Page Search View

This search view is used by components that display an Objective Page. The view contains SearchInit PeopleCode that pre-loads the keys (Objective Plan & Page) with the corresponding values from the Objectives global record, so that the search dialog can be bypassed.

SELECT A.EPO_PAGE_ID , B.EPO_OBJ_PLAN , A.EFFDT FROM PS_EPO_PG_HDR A ,PS_EPO_OBJ_PLAN B WHERE A.EPO_OBJ_PLAN = B.EPO_OBJ_PLAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID
2 EPO_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field
3 EFFDT Date(10) DATE Effective Date

Default Value: %date