CAREER_WK_VW

(SQL View)
 Index Back

Career/Competencies Link

View of Employees Weaknesses. Used to allow updating of CAREER_WEAKNESS table when in update display mode during link from Manage Competencies module.

SELECT A.EMPLID ,A.EFFDT ,A.EVALUATION_TYPE ,A.CAREER_COMPETENCY ,A.COMPETENCY_RATING ,A.COMMENTS FROM PS_CAREER_WEAKNESS A WHERE A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_CAREERPLAN B WHERE B.EMPLID=A.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 DATE_POSTED Date(10) DATE Date Posted
    3 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
    4 CAREER_COMPETENCY Character(12) VARCHAR2(12) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

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

    Prompt Table: REVW_RATING_TBL

    6 COMMENTS Long Character CLOB Comment