CAREERPATH

(SQL Table)
 Index Back

EE Career Path

Use CAREERPATH_EVAL and CAREERPATH in Career Planning to set up potential career paths (sequences of jobcodes) for an employee. You can create multiple career path records for an employee. For example, there might exist an official, approved career path for the employee's present jobcode. The employee's supervisor might also suggest an alternate career path that varies from the norm. Both can exist. Simply set up one CAREERPATH_EVAL record for each type of career path. Then specify the actual jobcode sequence in CAREERPATH. Please note that the 'Approved' career path is the one that will be used as a base in the Succession Planning module. CAREERPATH data can be automatically defaulted from the CAREERMOVE_TBL and the CAREERPATH_TBL. Use a combination of CAREERMOVE_TBL and CAREERPATH_TBL to define sequential paths of jobcodes through which an employee can advance from their present jobcode. Use CAREERMOVE_TBL to set up each 'move' from a jobcode. For example, move #1 would be the next job after their current one, and move #2 would be the next one after that. Use CAREERPATH_TBL to set up the lower layer of 'options' for each move on CAREERMOVE_TBL. If the desired career path is a strict hierarchy, there will be only one option for each move. If there is more than one choice for each move, then multiple options can be entered. The option sequence number can be filled in if there is a particular order to the options, in terms of first and second choice or likelihood to occur. This data is part of the Career Planning module.

  • Parent record: CAREERPATH_EVAL

    • # 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 CAREER_MOVE Character(1) VARCHAR2(1) NOT NULL Career Move
    1=First Move from Current Job
    2=Second Move from Current Job
    3=Third Move from Current Job
    4=Fourth Move from Current Job
    5=Fifth Move from Current Job
    6=Sixth Move from Current Job
    7=Seventh Move from Current Job
    8=Eighth Move from Current Job
    9=Ninth Move from Current Job
    5 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number
    6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POS_DATA_VW

    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    9 TARGETED_READY_DT Date(10) DATE Target Date
    10 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness Timeframe
    0=Ready Now
    1=Ready in 1 to 2 Years
    2=Ready in 3 to 5 Years
    E=Ready in an Emergency
    R=Retire in Current Position
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    12 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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