OPRIDRUN_CNTL_IDEP_APPRAISAL_IDEP_ROLEEP_REVIEWER_IDEPO_OBJ_ITEM_IDEPO_CASC_REP(SQL Table) |
Index Back |
|---|---|
Cascade Items Report TableTemporary table used for reporting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 4 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL | Role unique identifier |
| 5 | EP_REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 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_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description field used in ePerformance. |
| 8 | EPO_CASC_REASON | Character(40) | VARCHAR2(40) NOT NULL | Cascade Item Reason |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | EP_ITEM_ID | Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
| 12 | EPO_CASC_ITEM | Character(1) | VARCHAR2(1) NOT NULL | Cascade Item to Doc |