CAREERP_EFDT_VW

(SQL View)
 Index Back

Career Plan EFFDT View

View joining CAREERPATH_TBL and JOBCODE_TBL to retrieve effective date for the next position jobcode.

SELECT A.BUSINESS_UNIT ,A.JOBCODE ,A.CAREER_MOVE ,A.JOB_OPTION_NBR ,A.BUSINESS_UNIT_JOBC ,A.NEXT_POSN_JOBCODE ,B.EFFDT ,C.SETID FROM PS_CAREERPATH_TBL A, PS_JOBCODE_TBL B, PS_SET_CNTRL_REC C WHERE (A.NEXT_POSN_JOBCODE=B.JOBCODE AND C.SETID=B.SETID) AND (A.BUSINESS_UNIT_JOBC=C.SETCNTRLVALUE AND C.RECNAME='JOBCODE_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

    7 EFFDT Date(10) DATE Effective Date
    8 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID