HR_CP_CARDEV_VW

(SQL View)
 Index Back

CP IDP Career Development Plan

Data used for Career Planning Individual Development Plan report.

SELECT EMPLID , EFFDT , EST_COMPLETION_DT , SEQ_NUM , JPM_CAT_TYPE , CAREER_COMPETENCY , CAREER_GOAL , ACT_COMPLETION_DT , ' ' , ' ' , ' ' , ' ' , ' ' , GVT_SELF_DEVELOP , GVT_ESTIMATED_COST , GVT_ACTUAL_COST , GVT_ACT_STATUS , GVT_REQD_ACTVTY , NEED_IDENTIFIED_DT , GVT_ACTVTY_REASON FROM PS_CAREER_DEVELOP

  • 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 EST_COMPLETION_DT Date(10) DATE NOT NULL Estimated Completion Date
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    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 CAREER_GOAL Character(120) VARCHAR2(120) NOT NULL Career Goal
    8 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    11 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    12 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    13 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    14 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

    Y/N Table Edit

    Default Value: N

    15 GVT_ESTIMATED_COST Number(10,2) DECIMAL(9,2) NOT NULL Estimated Cost
    16 GVT_ACTUAL_COST Number(10,2) DECIMAL(9,2) NOT NULL Actual Cost
    17 GVT_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
    1=Requested
    2=Approved
    3=Disapproved
    4=Deferred
    5=In Progress
    6=Completed
    18 GVT_REQD_ACTVTY Character(1) VARCHAR2(1) NOT NULL Activity Required

    Y/N Table Edit

    Default Value: N

    19 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified
    20 GVT_ACTVTY_REASON Character(2) VARCHAR2(2) NOT NULL Reason Activity Pursued
    CM=Compliance
    DV=Development
    EN=Enrichment
    JR=Job Requirement
    LC=License Renewal
    MD=Management Discretion
    RQ=Requalification
    SE=Skill Enhancement