EP_ITEM_CMT_VW(SQL View) |
Index Back |
|---|
| SELECT A.EP_APPRAISAL_ID , A.EP_ROLE , A.EP_REVIEWER_ID , A.EP_SECTION_TYPE , A.EP_ITEM_ID , A.EP_ITEM_SEQ , B.EP_REVIEW_STATUS , C.EP_TRK_ANM_EE_SW , C.EP_TRK_ANM_MGR_SW , 'C' , A.EP_RESULTS FROM PS_EP_APPR_ITEM A , PS_EP_APPR_ROLE B , PS_EP_APPR_PARTIC C WHERE A.EP_APPRAISAL_ID = C.EP_APPRAISAL_ID AND A.EP_ROLE = C.EP_ROLE AND A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND A.EP_ROLE = B.EP_ROLE AND A.EP_REVIEWER_ID = B.EP_REVIEWER_ID AND A.EP_RESULTS IS NOT NULL |
| # | 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 |
| 6 | EP_ITEM_SEQ |
Number(2,0) | SMALLINT NOT NULL | Item sequence number |
| 7 | EP_REVIEW_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged AR=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held |
| 8 | EP_TRK_ANM_EE_SW | Character(1) | VARCHAR2(1) NOT NULL | Switch that determines if anonymity is maintained during the track participant feedback process for the employee. |
| 9 | EP_TRK_ANM_MGR_SW | Character(1) | VARCHAR2(1) NOT NULL | Switch that determines if anonymity is maintained during the track participant feedback process for the manager. |
| 10 | EP_WRT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Tip Source
C=Other Evaluators' Comments D=Development Tips P=Performance Notes S=Suggested Results W=Results Writer |
| 11 | EP_SUGGEST_RESULT | Long Character | CLOB | Suggested Results Test |