CAREERPATH_VW

(SQL View)
 Index Back

EE Current Career Path View

CAREERPATH_VW is a view of CAREERPATH which retrieves the career paths from the current career plan for an employee. It is used to intialize Succession Plans.

SELECT A.EMPLID ,A.EFFDT ,A.EVALUATION_TYPE ,A.CAREER_MOVE ,A.JOB_OPTION_NBR ,A.POSITION_NBR ,A.JOBCODE ,A.DEPTID ,A.TARGETED_READY_DT ,A.READINESS ,A.BUSINESS_UNIT FROM PS_CAREERPATH A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH B WHERE B.EMPLID = A.EMPLID)

  • Parent record: CAREERPATH_EVAL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
    A=Approved/Official
    B=Subordinate
    C=Customer
    E=Executive Committee
    L=Learning
    M=Mentor
    P=Peer
    R=Supervisor/Manager
    S=Self
    4 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
    5 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number
    6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

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

    Prompt Table: JOBCODE_TBL

    8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    9 TARGETED_READY_DT Date(10) DATE Target Date
    10 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness Timeframe
    0=Ready Now
    1=Ready in 1 to 2 Years
    2=Ready in 3 to 5 Years
    E=Ready in an Emergency
    R=Retire in Current Position
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR