COMPETENCY_DVLP

(SQL View)
 Index Back

Career/Competencies Link

Shows an Employees Competencies which are defined as a Developmental area and which are of type Ability

SELECT DISTINCT A.EMPLID ,A.EVALUATION_TYPE ,B.COMPETENCY ,B.EFFDT ,B.PROFICIENCY ,'D' ,'N' FROM PS_CM_EVALUATIONS A , PS_COMPETENCIES B , PS_COMPETENCY_TBL C , PS_REVW_RATING_TBL D WHERE A.EMPLID=B.EMPLID AND A.EVALUATION_ID=B.EVALUATION_ID AND B.COMPETENCY=C.COMPETENCY AND D.RATING_MODEL=C.RATING_MODEL AND D.REVIEW_RATING=B.PROFICIENCY AND (D.CAREER_STRDVLP IN ('D',' ')) AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_REVW_RATING_TBL E WHERE E.RATING_MODEL=C.RATING_MODEL AND E.EFFDT <= %CurrentDateIn)

  • Parent record: PERSON

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

    Prompt Table: PERSON

    2 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
    A=Approved/Official
    B=Subordinate
    C=Customer
    E=Executive Committee
    L=Learning
    M=Mentor
    P=Peer
    R=Supervisor/Manager
    S=Self
    3 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
    6 CAREER_STRDVLP Character(1) VARCHAR2(1) NOT NULL Career Strength/ Development
    D=Development
    S=Strength
    7 COM_ACCOMP_FLAG Character(1) VARCHAR2(1) NOT NULL Competencies/Accomp. Flag