EPO_NO_ITEM_VW(SQL View) |
Index Back |
---|---|
Objectives Page ItemHolds the Item information for the Objectives Pages |
SELECT EPO_PAGE_ID , EFFDT , EPO_SECTION_TYPE , EPO_OBJ_ITEM_ID FROM PS_EPO_PG_ITEM WHERE 1 = 2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(8,0) | INTEGER NOT NULL |
Objectives Management: Objective Page ID
Prompt Table: EPO_PG_HDR |
|
2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
3 | Character(8) | VARCHAR2(8) NOT NULL |
Objectives Section type
Prompt Table: EPO_SECTN_DEFN |
|
4 | Number(8,0) | INTEGER NOT NULL | Objectives Management: Objective Item ID. Used as a key to hold unique values as Item ID is not a key in Objective Management. It will uniquely define an item on ePerformance document when cascaded or copied over. |