CAREERPLAN

(SQL Table)
 Index Back

EE Career Plan

Use CAREERPLAN to define an employee's career plan. There are numerous subordinate records that deal with various facets of a career plan such as a potential job path, obstacles to mobility, an employee's position in a force ranking, career potential, short-term and long-term career goals, mentoring, strengths and weaknesses, training, and a personal development plan. This data is part of the Career Planning module. You can create multiple CAREERPLAN records for an employee, each with a different effective date.

  • 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 DEFAULT_CAREERPATH Character(1) VARCHAR2(1) NOT NULL

    Default Value: N

    5 DEFAULT_TRAIN_PLAN Character(1) VARCHAR2(1) NOT NULL

    Default Value: N

    6 AVAILABILITY_DT Date(10) DATE Availability Date
    7 RETIREMENT_DT Date(10) DATE Projected Retirement Date
    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 GVT_CAR_PLAN_STAT Character(1) VARCHAR2(1) NOT NULL Career Plan Status
    1=Under Development
    2=Submitted to Supervisor
    3=Approved by Supervisor
    4=Disapproved by Supervisor
    5=Approved by HR
    6=Disapproved by HR

    Default Value: 1

    10 GVT_SUBMIT_SUPV Character(1) VARCHAR2(1) NOT NULL Submit To Manager

    Y/N Table Edit

    Default Value: N

    11 SUBMIT_PLAN Character(1) VARCHAR2(1) NOT NULL Submit Plan
    12 GVT_SUBMIT_HR Character(1) VARCHAR2(1) NOT NULL Submit To HR Dev Staff

    Y/N Table Edit

    Default Value: N

    13 APPROVE_PLAN Character(1) VARCHAR2(1) NOT NULL Approve The Plan
    14 DISAPPROVE_PLAN Character(1) VARCHAR2(1) NOT NULL Disapprove the Plan
    15 IMPACT_OF_LOSS Character(1) VARCHAR2(1) NOT NULL Impact of Loss
    1=High
    2=Medium
    3=Low
    16 RISK_OF_LEAVING Character(1) VARCHAR2(1) NOT NULL Risk of Leaving
    1=High
    2=Medium
    3=Low
    17 TIME_REMAINING Number(2,0) SMALLINT NOT NULL Time Remaining in Role
    18 UNITS_OF_TIME Character(1) VARCHAR2(1) NOT NULL Units of Time
    1=Months
    2=Years
    19 REPLACEMENT_DT Date(10) DATE Date of Replacement
    20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.