EP_APPRAISAL_IDEMPLIDEMPL_RCDPERIOD_END_DTEP_PG_RATING_VW(SQL View) |
Index Back |
|---|---|
Employee Performance RatingThis view returns rating for the latest completed document which is used by the Scatter Plot base view. |
| 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 , PS_EP_DEFAULT EPDFLT WHERE A.EP_REVIEW_STATUS = 'CO' AND A.EP_REVIEW_TYPE=EPDFLT.EP_REVIEW_TYPE AND EPDFLT.EP_TRANSACTION_NM = 'M' AND A.PERIOD_END_DT =( SELECT MAX(A1.PERIOD_END_DT) FROM PS_EP_APPR A1 WHERE A.EMPLID =A1.EMPLID AND A.EMPL_RCD=A1.EMPL_RCD AND A.EP_REVIEW_STATUS=A1.EP_REVIEW_STATUS AND A.EP_REVIEW_TYPE=A1.EP_REVIEW_TYPE ) |
| # | 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 |