|
SELECT A.EMPLID , %TrimSubstr(D.COMPETENCY,1,8) %Concat 'x' %Concat %TrimSubstr(E.REVIEW_RATING,1,1) AS PRO FROM %Table(RS_EVALUATIONS) A , %Table(INSTALLATION_RS) B , %Table(COMPETENCIES) C , %Table(COMPETENCY_TBL) D , %Table(REVW_RATING_TBL) E , %Table(RS_WRKR_ELGBL) F WHERE A.EVALUATION_TYPE = B.EVALUATION_TYPE AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMPETENCIES Z WHERE Z.EMPLID = C.EMPLID AND Z.EVALUATION_ID = C.EVALUATION_ID AND Z.EVALUATION_ID = A.EVALUATION_ID AND Z.COMPETENCY = C.COMPETENCY AND Z.EFFDT <= %CurrentDateIn) AND A.EMPLID = C.EMPLID AND A.EMPLID = F.EMPLID AND A.EVALUATION_ID = C.EVALUATION_ID AND C.COMPETENCY = D.COMPETENCY AND D.RATING_MODEL = E.RATING_MODEL AND C.PROFICIENCY >= E.REVIEW_RATING AND F.SYSTEM_SOURCE='WM'
|
EMPLID