COMPETENCY_STR

(SQL View)
 Index Back

Career/Competencies Link

View used to show all Competencies in Manage Competencies but not in Career Planning. Heavily updated during run-time by peoplecode

SELECT DISTINCT A.EMPLID ,A.EVALUATION_TYPE ,B.COMPETENCY ,B.EFFDT ,B.PROFICIENCY ,'S' 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='S' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMPETENCIES WHERE EMPLID = B.EMPLID AND EVALUATION_ID = B.EVALUATION_ID AND COMPETENCY = B.COMPETENCY AND EFFDT <= %CurrentDateIn) AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_REVW_RATING_TBL WHERE RATING_MODEL=C.RATING_MODEL AND 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