CAREERPATH_TBL

(SQL Table)
 Index Back

Career Path Table - Job Code

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. CAREERMOVE_TBL must be set up before you enter data in CAREERPATH_TBL.

  • Parent record: CAREERMOVE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: JOBCODE_TBL

    3 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
    4 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number
    5 BUSINESS_UNIT_JOBC Character(5) VARCHAR2(5) NOT NULL Business Unit for a Jobcode

    Prompt Table: BUS_UNIT_TBL_HR

    6 NEXT_POSN_JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code-Next Position

    Prompt Table: BU_JOBCD_VW