|
SELECT A.EMPLID , %TrimSubstr(D.COMPETENCY,1,8) %Concat 'x' %Concat %NumToChar(S.YEARS_OF_EXP) AS YRS 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 , %Table(RS_YRS_EXP_VW) S 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 C.YEARS_OF_EXP >= S.YEARS_OF_EXP
|
EMPLID