HR_CP_CARMNT_VW

(SQL View)
 Index Back

CP IDP Career Mentors

Data used for Career Planning Individual Development Plan report.

SELECT EMPLID , EFFDT , EST_COMPLETION_DT , SEQ_NUM , MENTOR_NAME , MENTOR_TITLE , MENTOR_TYPE , 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_MENTOR

  • 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 MENTOR_NAME Character(50) VARCHAR2(50) NOT NULL Mentor Name
    6 MENTOR_TITLE Character(50) VARCHAR2(50) NOT NULL Mentor Title
    7 MENTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Mentor Type
    1=Mentor
    2=Coach
    3=Endorser
    4=Reviewer/Rater
    5=Supervisor
    6=Functional Specialist
    7=Teacher
    8=Other
    8 CAREER_GOAL Character(120) VARCHAR2(120) NOT NULL Career Goal
    9 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date
    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    11 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One
    12 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    13 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    20 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified
    21 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