HR_CP_CARSTR_VW

(SQL View)
 Index Back

CP IDP Career Strengths

Data used for Career Planning Individual Development Plan report.

SELECT EMPLID , EFFDT , EVALUATION_TYPE ,' ' , JPM_CAT_TYPE , CAREER_COMPETENCY ,' ' , COMPETENCY_RATING , ' ' FROM PS_CAREER_STRENGTH

  • 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    5 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

    Prompt Table: JPM_CAT_TYPES

    6 CAREER_COMPETENCY Character(12) VARCHAR2(12) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 COMPETENCY_RATING Character(1) VARCHAR2(1) NOT NULL COMPETENCY_RATING
    1=Strong
    2=Acceptable
    3=Needs Improvement

    Prompt Table: REVW_RATING_STR

    9 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2