EPO_CASCITEM_VW(SQL View) |
Index Back |
|---|---|
Objectives Items of a NodeDisplays the items of a section of a given Node |
| SELECT B.EPO_OBJ_PLAN , A.EPO_PAGE_ID , B.EPO_NODE_ID , B.SETID , A.EPO_SECTION_TYPE , A.EPO_OBJ_ITEM_ID , A.EP_ITEM_ID , A.EP_TITLE FROM PS_EPO_PG_ITEM A , PS_EPO_PG_HDR B WHERE A.EPO_PAGE_ID = B.EPO_PAGE_ID AND A.EFFDT = B.EFFDT AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EPO_PG_HDR B1 WHERE B1.EPO_PAGE_ID = B.EPO_PAGE_ID AND B1.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_PAGE_ID | Number(8,0) | INTEGER NOT NULL | Objectives Management: Objective Page ID |
| 3 | EPO_NODE_ID | Character(10) | VARCHAR2(10) NOT NULL | Objectives Management. Used to store the Node ID associated with the Objective Plan |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | EPO_SECTION_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Objectives Section type |
| 6 | EPO_OBJ_ITEM_ID | 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. |
| 7 | EP_ITEM_ID | Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
| 8 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |