HR_CP_JP_CNODE

(SQL View)
 Index Back

Career Path Table - Job Code

Job code path for career path chart child node

SELECT BUSINESS_UNIT , JOBCODE , CAREER_MOVE , PRE_MOVE_OPTION , JOB_OPTION_NBR , BUSINESS_UNIT_JOBC , NEXT_POSN_JOBCODE FROM PS_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=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
    4 PRE_MOVE_OPTION Number(2,0) SMALLINT NOT NULL Previous Move Option
    5 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number
    6 BUSINESS_UNIT_JOBC Character(5) VARCHAR2(5) NOT NULL Business Unit for a Jobcode

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: BU_JOBCD_VW