EPO_GBLKEY_SRCH(SQL View) |
Index Back |
---|---|
Objective Page Search ViewThis 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 |