EMPLIDREVIEW_DTEVALUATION_IDCM_EVAL_CUR_VW(SQL View) |
Index Back |
|---|---|
Current Comp. Evaluation ViewThis view shows the current (most recent review_dt) competency evaluation. |
| SELECT A.EMPLID , A.REVIEW_DT , MAX(A.EVALUATION_ID) FROM PS_CM_EVALUATIONS A WHERE (A.EVALUATION_TYPE = 'S' OR (A.EVALUATION_TYPE = 'R' AND A.EP_APPRAISAL_ID > 0)) AND A.REVIEW_DT = ( SELECT MAX(B.REVIEW_DT) FROM PS_CM_EVALUATIONS B WHERE B.EMPLID = A.EMPLID AND (B.EVALUATION_TYPE = 'S' OR (B.EVALUATION_TYPE = 'R' AND B.EP_APPRAISAL_ID > 0))) GROUP BY A.EMPLID, A.REVIEW_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | REVIEW_DT |
Date(10) | DATE | Review Date |
| 3 | EVALUATION_ID |
Character(2) | VARCHAR2(2) NOT NULL | Evaluation ID |