HR_CP_PLAN

(SQL View)
 Index Back

EE Career Plan

HR_CP_PLAN is based upon CAREERPLAN to define an employee's career plan for Manager Career Planning Self Service product.

SELECT A.EMPLID , A.EFFDT , A.NEXT_CAREERPLAN_DT , A.AVAILABILITY_DT , A.RETIREMENT_DT , A.IMPACT_OF_LOSS , A.RISK_OF_LEAVING , A.GVT_CARPLAN_RSN , ' ' , UNITS_OF_TIME , TIME_REMAINING FROM PS_CAREERPLAN A WHERE A.EFFDT = ( SELECT MAX (B.EFFDT) FROM PS_CAREERPLAN B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn)

  • Parent record: PERSON

    • # 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 NEXT_CAREERPLAN_DT Date(10) DATE Career Plan Review Date
    4 AVAILABILITY_DT Date(10) DATE Availability Date
    5 RETIREMENT_DT Date(10) DATE Projected Retirement Date
    6 IMPACT_OF_LOSS Character(1) VARCHAR2(1) NOT NULL Impact of Loss
    1=High
    2=Medium
    3=Low
    7 RISK_OF_LEAVING Character(1) VARCHAR2(1) NOT NULL Risk of Leaving
    1=High
    2=Medium
    3=Low
    8 GVT_CARPLAN_RSN Character(1) VARCHAR2(1) NOT NULL Reason Career Plan Initiated
    B=Bargaining Unit Agreement
    C=Career Ladder
    D=Developmental Program
    E=Employee Requested
    P=Career Program
    R=Periodic Review
    S=Supervisor Initiated
    9 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    10 UNITS_OF_TIME Character(1) VARCHAR2(1) NOT NULL Units of Time
    1=Months
    2=Years
    11 TIME_REMAINING Number(2,0) SMALLINT NOT NULL Time Remaining in Role