EP_APPRAISAL_IDAK=Acknowledged
AR=Available for Review
CA=Cancelled
CO=Completed
IP=In Progress
NS=Not Started
RH=Review Held
EP_PE_ALERT_VW(SQL View) |
Index Back |
|---|---|
Employee Review Alerts View |
| SELECT A.EP_APPRAISAL_ID , A.EP_MANAGER_ID , A.EMPLID , A.PERIOD_END_DT , A.EP_REVIEW_TYPE , A.EP_REVIEW_STATUS , B.EP_DUE_DT FROM PS_EP_APPR A , PS_EP_APPR_PARTIC B WHERE A.EP_APPRAISAL_ID=B.EP_APPRAISAL_ID AND B.EP_ROLE='M' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | EP_REVIEWER_ID | Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 5 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 6 | 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 |
| 7 | EP_DUE_DT | Date(10) | DATE | Date a review is due |