EMPLIDEMPL_RCDEP_RATINGCUR_VW(SQL View) |
Index Back |
|---|---|
Current Employee RatingThis view takes data from EP_RATING_VW which is based on EP_APPR. It retrieves data for the last completed review rating where the last review is defined by the latest period end date. EP_RATING_VW 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. EP_RATINGCUR_VW follows this same key structure and is used on the direct line reports pagelet to retrieve the latest completed employee performance rating. |
| SELECT 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 , C.DESCR FROM PS_EP_RATING_VW A , PS_REVW_RATING_TBL C WHERE A.PERIOD_END_DT = ( SELECT MAX(B.PERIOD_END_DT) FROM PS_EP_RATING_VW B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD) AND C.RATING_MODEL = A.RATING_MODEL AND C.REVIEW_RATING = A.REVIEW_RATING AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_REVW_RATING_TBL D WHERE D.RATING_MODEL = C.RATING_MODEL AND D.REVIEW_RATING = C.REVIEW_RATING AND D.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 4 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 5 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 6 | CREATION_DT | Date(10) | DATE | Creation Date |
| 7 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 8 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 9 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |