EPO_PAGE_IDEPO_OBJ_PLANEPO_SECTION_TYPEEPO_OBJ_ITEM_IDEP_ITEM_STATUSA=Not Applicable
C=Complete
I=In Progress
UX_OBJ_DET_VW(SQL View) |
Index Back |
|---|---|
View Summary Data by ItemView used to sum data by Item from EPO_OBJ_EXTRACT |
| SELECT EPO_PAGE_ID ,EPO_OBJ_PLAN ,EPO_SECTION_TYPE ,EPO_OBJ_ITEM_ID ,EP_ITEM_STATUS , COUNT(DISTINCT EMPLID) , ' ' FROM PS_EPO_OBJ_EXTRACT GROUP BY EPO_PAGE_ID ,EPO_OBJ_PLAN ,EPO_SECTION_TYPE ,EPO_OBJ_ITEM_ID ,EP_ITEM_STATUS |
| # | 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 | EPO_SECTION_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Objectives Section type |
| 4 | 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. |
| 5 | EP_ITEM_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Status of an Item.
A=Not Applicable C=Complete I=In Progress |
| 6 | EPO_EMPLID_CNT | Number(6,0) | INTEGER NOT NULL | Number of Employees |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |