EMPLIDEMPL_RCDLANGUAGE_CDEP_RATCURML_LVW(SQL View) |
Index Back |
|---|---|
Current Employee Rating for MLThis 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 the Manager Landing Page. |
| SELECT A.EMPLID , A.EMPL_RCD , C.LANGUAGE_CD , C.DESCR FROM PS_EP_APPR A , PS_REVW_RATING_LNG C WHERE 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' ) 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) 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 = 'M') |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |