CAREERMOVE_TBL (SQL Table)	Index Back
Career Move 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.

CAREERMOVE_TBL

(SQL Table)

Career Move 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 Of CAREERPATH_TBL CAREERP_EFDT_VW

# 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