HR_CP_JCODE_P

(SQL View)
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.

SELECT A.BUSINESS_UNIT_JOBC , A.JOBCODE , A.DESCR FROM PS_BU_JOBCD_VW A WHERE A.EFF_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_CAREERPATH_TBL B WHERE A.BUSINESS_UNIT_JOBC = B.BUSINESS_UNIT AND A.JOBCODE = B.JOBCODE)

  • Related Language Record: HR_CPJCODEP_LNG
  • 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
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description