EP_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 |