RS_XS_CNCOMPPRO

(SQL View)
 Index Back

SELECT A.SETID , A.CONTACT_ID , %TrimSubstr(A.SETID,1,5) %Concat '' %Concat %TrimSubstr(A.CONTACT_ID,1,15) AS SOID , %TrimSubstr(A.COMPETENCY,1,8) %Concat 'x' %Concat %TrimSubstr(C.REVIEW_RATING,1,1) AS PRO , CASE WHEN (A.WEIGHT_POINTS = 0 AND A.PROFICIENCY = C.REVIEW_RATING) THEN 'Y' ELSE 'N' END AS REQ , CASE WHEN (A.WEIGHT_POINTS = 0 AND A.PROFICIENCY = C.REVIEW_RATING) THEN %TrimSubstr(A.COMPETENCY,1,8) %Concat 'x' %Concat %TrimSubstr(C.REVIEW_RATING,1,1) ELSE ' ' END AS RPRO , A.COMPETENCY , A.PROFICIENCY FROM %Table(CONT_COMP) A , %Table(COMPETENCY_TBL) B , %Table(REVW_RATING_TBL) C , %Table(CONTACT) D WHERE A.SETID = D.SETID AND A.CONTACT_ID = D.CONTACT_ID AND B.COMPETENCY = A.COMPETENCY AND C.RATING_MODEL = B.RATING_MODEL AND A.PROFICIENCY >= C.REVIEW_RATING

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 SOID Character(29) VARCHAR2(29) NOT NULL Service Order Line Key
4 PRO Character(32) VARCHAR2(32) NOT NULL Proficiency
5 REQ Character(1) VARCHAR2(1) NOT NULL Purchasing
6 RPRO Character(32) VARCHAR2(32) NOT NULL Required Proficiency
7 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
8 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency