EPO_PAGE_IDEPO_OBJ_PLANEPO_SECTION_TYPEEPO_OBJ_ITEM_IDUX_OBJ_SUM_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 ,COUNT(DISTINCT EMPLID) , ' ' , ' ' FROM PS_EPO_OBJ_EXTRACT GROUP BY EPO_PAGE_ID ,EPO_OBJ_PLAN ,EPO_SECTION_TYPE ,EPO_OBJ_ITEM_ID |
| # | 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 | EPO_EMPLID_CNT | Number(6,0) | INTEGER NOT NULL | Number of Employees |
| 6 | DESCR200 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |