EP_APPRAISAL_IDEMPLIDEMPL_RCDPERIOD_END_DTEP_RATING_VW(SQL View) |
Index Back |
|---|---|
Employee Performance RatingThis view takes data from EP_APPR for closed performance reviews and sets up a key structure where the emplid, empl_rcd and period_end_dt are keys. This allows the view to be used in pages where it is necessary to retrieve data by emplid. This view is also used as a base view for EP_RATINGCUR_VW which retrieves the last completed review rating where the last review is defined by the latest period end date. |
| SELECT A.EP_APPRAISAL_ID , A.EMPLID , A.EMPL_RCD , A.PERIOD_END_DT , A.EP_REVIEW_TYPE , A.PERIOD_BEGIN_DT , A.CREATION_DT , A.EP_RATING , A.RATING_MODEL , A.REVIEW_RATING FROM PS_EP_APPR A WHERE A.EP_REVIEW_STATUS = 'CO' AND A.EP_REVIEW_TYPE = ( SELECT B.EP_REVIEW_TYPE FROM PS_UX_DIR_PLT_CFG B) |
| # | 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 |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | PERIOD_END_DT |
Date(10) | DATE | Period End Date |
| 5 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 6 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 7 | CREATION_DT | Date(10) | DATE | Creation Date |
| 8 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 9 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 10 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |