HCTS_CP_MGR_PTH

(SQL View)
 Index Back

EE Manager Career Path View

HR_CP_MGR_PATH is a view of CAREERPATH which retrieves the career paths from the career path table for an employee based on evaluation type of "R" (Manager or Supervisor)

SELECT DISTINCT A.EMPLID ,A.EVALUATION_TYPE ,A.CAREER_MOVE ,A.PRE_MOVE_OPTION ,A.JOB_OPTION_NBR ,A.POSITION_NBR ,A.JOBCODE ,A.DEPTID ,A.TARGETED_READY_DT ,A.READINESS ,A.BUSINESS_UNIT ,B.CAREER_MOVE ,B.JOB_OPTION_NBR ,B.JOBCODE ,C.CAREER_MOVE ,C.JOB_OPTION_NBR ,C.JOBCODE , %subrec(CAR_PTH_FED_SBR, A ) FROM PS_CAREERPATH A LEFT OUTER JOIN PS_CAREERPATH B ON B.EMPLID = A.EMPLID AND B.EVALUATION_TYPE = A.EVALUATION_TYPE AND B.CAREER_MOVE = 2 AND B.PRE_MOVE_OPTION = A.JOB_OPTION_NBR LEFT OUTER JOIN PS_CAREERPATH C ON C.EMPLID = A.EMPLID AND C.EVALUATION_TYPE = A.EVALUATION_TYPE AND C.CAREER_MOVE = 3 AND C.PRE_MOVE_OPTION = B.JOB_OPTION_NBR AND C.PRE_MOVE_OPTION = A.JOB_OPTION_NBR WHERE A.EVALUATION_TYPE = 'R' AND A.CAREER_MOVE = 1 AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CAREERPATH A1 WHERE A1.EMPLID = A.EMPLID AND A1.EVALUATION_TYPE = A.EVALUATION_TYPE AND A1.EFFDT <= %CurrentDateIn)

  • 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 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
    3 HCTS_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

    Default Value: 1

    5 HCTS_JOB_OPT_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 HCTS_JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    9 TARGETED_READY_DT Date(10) DATE Targeted Ready Date
    10 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    R=Retirement
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    12 HCTS_CAREER_MOVE2 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
    13 HCTS_JOB_OPT_NBR2 Number(2,0) SMALLINT NOT NULL Option Number
    14 HCTS_JOBCODE2 Character(6) VARCHAR2(6) NOT NULL Job Code
    15 HCTS_CAREER_MOVE3 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
    16 HCTS_JOB_OPT_NBR3 Number(2,0) SMALLINT NOT NULL Option Number
    17 HCTS_JOBCODE3 Character(6) VARCHAR2(6) NOT NULL Job Code
    18 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

    Y/N Table Edit

    Default Value: N

    19 GVT_ESTIMATED_COST Number(10,2) DECIMAL(9,2) NOT NULL Estimated Cost
    20 GVT_ACTUAL_COST Number(10,2) DECIMAL(9,2) NOT NULL Actual Cost
    21 GVT_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
    1=Requested
    2=Approved
    3=Disapproved
    4=Deferred
    5=In Progress
    6=Completed
    22 GVT_REQD_ACTVTY Character(1) VARCHAR2(1) NOT NULL Activity Required

    Y/N Table Edit

    Default Value: N

    23 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified
    24 GVT_ACTVTY_REASON Character(2) VARCHAR2(2) NOT NULL Reason Activity Pursued
    CM=Compliance
    DV=Development
    EN=Enrichment
    JR=Job Requirement
    LC=License Renewal
    MD=Management Discretion
    RQ=Requalification
    SE=Skill Enhancement