|
SELECT A.EMPLID , %TrimSubstr(C.COMPETENCY,1,8) %Concat 'x' %Concat %TrimSubstr(E.REVIEW_RATING,1,1) AS INTEREST 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_V) 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 E.RATING_MODEL ='INT' AND C.INTEREST_LEVEL >= E.REVIEW_RATING AND E.REVIEW_RATING > '0'
|
EMPLID