EP_APPRAISAL_IDEP_ROLEEP_REVIEWER_IDEP_SECTION_TYPEEP_ITEM_IDEP_OC_ITEM_VW(SQL View) |
Index Back |
|---|
| SELECT EP_APPRAISAL_ID , EP_ROLE , EP_REVIEWER_ID , EP_SECTION_TYPE , EP_ITEM_ID FROM PS_EP_APPR_ITEM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL | Role unique identifier |
| 3 | EP_REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 4 | EP_SECTION_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Section type |
| 5 | EP_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |