EMPLIDEMPL_RCDJPM_CSC_EPRF_VW(SQL View) |
Index Back |
|---|---|
JPM Compare - ePerf RatingsThis 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 where the document type is the same as is set up as the default for Profile Compare. |
| 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_APPR A , PS_REVW_RATING_TBL C WHERE 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) AND A.EP_REVIEW_STATUS = 'CO' AND A.EP_REVIEW_TYPE = ( SELECT B.EP_REVIEW_TYPE FROM PS_EP_DEFAULT B WHERE EP_TRANSACTION_NM = 'J') AND A.PERIOD_END_DT = ( SELECT MAX(B.PERIOD_END_DT) FROM PS_EP_APPR B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EP_REVIEW_TYPE = A.EP_REVIEW_TYPE AND B.EP_REVIEW_STATUS = 'CO' ) |
| # | 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 |