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=1st Move
    2=2nd Move
    3=3rd Move
    4=4th Move
    5=5th Move
    6=6th Move
    7=7th Move
    8=8th Move
    9=9th Move
    5 PRE_MOVE_OPTION Number(2,0) SMALLINT NOT NULL Previous Move Option

    Default Value: 1

    6 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number

    Default Value: 1

    7 PRIVATE_PATH Character(1) VARCHAR2(1) NOT NULL Private Path
    N=N
    Y=Y

    Default Value: Y

    8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: DEPT_TBL

    11 TARGETED_READY_DT Date(10) DATE Targeted Ready Date
    12 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    R=Retirement
    13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    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