RS_WRKR_COMP_VW

(SQL View)
 Index Back

Worker Competencies View

Contains the competency ratings for each employee. Only the most current competency ratings from self-evaluations are included.

SELECT C.EMPLID , C.COMPETENCY , A.DESCR , A.DESCRLONG , E.EVALUATION_ID , C.EFFDT , C.YR_ACQUIRED , C.YR_LAST_USED , C.HOW_VERIFIED , C.PROFICIENCY , A.RATING_MODEL , C.INTEREST_LEVEL , C.YEARS_OF_EXP , C.SELECT_CMP FROM %Table(COMPETENCIES) C , %Table(RS_EVALUATIONS) E , %Table(COMPETENCY_TBL) A , %Table(INSTALLATION_RS) I WHERE C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM %Table(COMPETENCIES) C2 , %Table(RS_EVALUATIONS) E2 , %Table(INSTALLATION_RS) I2 WHERE E2.EMPLID = E.EMPLID AND E2.EVALUATION_TYPE = I2.EVALUATION_TYPE AND C2.EMPLID = E2.EMPLID AND C2.EVALUATION_ID = E2.EVALUATION_ID AND C2.COMPETENCY = C.COMPETENCY AND C2.EFFDT <= %CurrentDateIn) AND E.EMPLID = C.EMPLID AND E.EVALUATION_ID = C.EVALUATION_ID AND E.EVALUATION_TYPE = I.EVALUATION_TYPE AND A.COMPETENCY = C.COMPETENCY

  • Related Language Record: RS_WRKR_COMP_VL

    • # 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 DESCRLONG Long Character CLOB Long Description
    5 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID
    6 EFFDT Date(10) DATE Effective Date
    7 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
    8 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
    9 HOW_VERIFIED Character(1) VARCHAR2(1) NOT NULL Verified By
    E=Employee Claim
    J=On the Job Training
    N=Not Verified
    O=Employer Observation
    T=By Test
    V=NVQ Authority
    10 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL

    11 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
    12 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level

    Prompt Table: INT_RATING_VW
    Set Control Field: REVIEW_RATING

    13 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    14 SELECT_CMP Character(1) VARCHAR2(1) NOT NULL Include Competency for Search

    Y/N Table Edit

    Default Value: N