EMPLIDEP_APPRAISAL_IDEP_ROLEEP_REVIEWER_IDEP_SECTION_TYPEEP_ITEM_IDEP_ITEM_SEQEPO_PAGE_IDEPO_OBJ_PLANEPO_SECTION_TYPEEPO_OBJ_ITEM_IDEP_ITEM_STATUSA=Not Applicable
C=Complete
I=In Progress
EPO_OBJ_DET2_VW(SQL View) |
Index Back |
|---|---|
View Summary Data by ItemView used to sum data by Item from EPO_OBJ_EXTRACT |
| SELECT EMPLID ,EP_APPRAISAL_ID ,EP_ROLE ,EP_REVIEWER_ID ,EP_SECTION_TYPE ,EP_ITEM_ID ,EP_ITEM_SEQ ,EPO_PAGE_ID ,EPO_OBJ_PLAN ,EPO_SECTION_TYPE ,EPO_OBJ_ITEM_ID ,EP_ITEM_STATUS ,EP_ITEM_PCT ,EP_ITEM_DUE_DT FROM PS_EPO_OBJ_EXTRACT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 3 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL | Role unique identifier |
| 4 | EP_REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 5 | EP_SECTION_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Section type |
| 6 | EP_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
| 7 | EP_ITEM_SEQ |
Number(2,0) | SMALLINT NOT NULL | Item sequence number |
| 8 | EPO_PAGE_ID |
Number(8,0) | INTEGER NOT NULL | Objectives Management: Objective Page ID |
| 9 | EPO_OBJ_PLAN |
Character(8) | VARCHAR2(8) NOT NULL | Objectives Management: Objective Plan ID field |
| 10 | EPO_SECTION_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Objectives Section type |
| 11 | 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. |
| 12 | EP_ITEM_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Status of an Item.
A=Not Applicable C=Complete I=In Progress |
| 13 | EP_ITEM_PCT | Number(3,0) | SMALLINT NOT NULL | Percentage complete an item is. |
| 14 | EP_ITEM_DUE_DT | Date(10) | DATE | Date that an item is due. |