EP_SS_DTL_VW(SQL View) |
Index Back |
|---|---|
Review Selection ViewThis view is used to display Review sub-documents available for selection from the generic "Review Selection Page". |
| SELECT A.EP_APPRAISAL_ID , A.EMPLID , A.EMPL_RCD , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , A.EP_REVIEW_TYPE , A.EP_REVIEW_ID , B.EP_REVIEWER_ID , C.NAME , B.EP_DUE_DT , A.EP_REVIEW_STATUS , B.EP_REVIEW_STATUS , A.EP_RATING , A.REVIEW_RATING , A.RATING_MODEL , A.EP_EE_REVIEW_FLG FROM PS_EP_APPR A , PS_EP_APPR_ROLE B , PS_PERSON_NAME C WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND B.EP_ROLE = 'M' AND C.EMPLID = A.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | PERIOD_BEGIN_DT | Date(10) | DATE NOT NULL | Period Begin Date |
| 5 | PERIOD_END_DT | Date(10) | DATE NOT NULL | Period End Date |
| 6 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: EP_REVW_TYP_TBL |
| 7 | EP_REVIEW_ID | Character(8) | VARCHAR2(8) NOT NULL | Review ID |
| 8 | EP_REVIEWER_ID | Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 9 | EP_REVIEWER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Author |
| 10 | EP_DUE_DT | Date(10) | DATE | Date a review is due |
| 11 | 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 |
| 12 | EP_ROLE_STATUS | Character(4) | VARCHAR2(4) NOT NULL | This field is used in views and derived records to store the status of a Review sub-document, which may be different from the overall status of the Review. |
| 13 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 14 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 15 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 16 | EP_EE_REVIEW_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Field used to determine the process flow for a performance review.
01=Approval Before EE Review Held 02=Approval After EE Review Held 03=No Approval, EE Review Held 04=No Approval, No EE Review Held 05=Approval, No EE Review Held |