COMPETENCY_COMP

(SQL View)
 Index Back

Career/Competencies Link

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

SELECT A.EMPLID ,A.EVALUATION_TYPE ,A.COMPETENCY ,A.EFFDT ,A.COMPETENCY_RATING FROM PS_CAREER_STRENGTH A WHERE A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_CAREERPLAN B WHERE A.EMPLID = B.EMPLID AND B.EFFDT <= %CurrentDateIn)

  • Parent record: CAREERPLAN

    • # 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

    Prompt Table: COMPETENCY_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 COMPETENCY_RATING Character(1) VARCHAR2(1) NOT NULL COMPETENCY_RATING
    1=Strong
    2=Acceptable
    3=Needs Improvement

    Prompt Table: REVW_RATING_TBL