RS_ED_WKR_COMP

(SQL View)
 Index Back

ETL Worker Competencies

COMPETENCIES contains the competency ratings for employee.

SELECT C.EMPLID , C.COMPETENCY , D.DESCR , C.PROFICIENCY , C.INTEREST_LEVEL , C.YEARS_OF_EXP , E.DESCR FROM PS_RS_ED_ETL_LOG L , PS_RS_EVALUATIONS A , PS_INSTALLATION_RS B , PS_COMPETENCIES C , PS_COMPETENCY_TBL D , PS_REVW_RATING_TBL E , PS_EID_ETL_LASTRUN F WHERE L.DOCUMENT = A.EMPLID AND 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.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.EID_DS_ID = 'Resources' AND L.DTTM_MODIFIED >= F.LAST_RUN_DTM

  • Parent record: RS_EVALUATIONS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL

    5 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level

    Default Value: 0

    Prompt Table: INT_RATING_VW
    Set Control Field: REVIEW_RATING

    6 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    7 PRO Character(32) VARCHAR2(32) NOT NULL Proficiency