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.

CAREERPLAN

(SQL Table)

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 to Career Path Table
Y/N Table Edit
Default Value: N

5 DEFAULT_TRAIN_PLAN Character(1) VARCHAR2(1) NOT NULL Default Training Plan
Y/N Table Edit
Default Value: N

6 TRAVELLING Character(1) VARCHAR2(1) NOT NULL Willing to Travel
Y/N Table Edit
Default Value: N

7 RELOCATE Character(1) VARCHAR2(1) NOT NULL Willing to Relocate
Y/N Table Edit
Default Value: N

8 INTERNATIONAL Character(1) VARCHAR2(1) NOT NULL Take International Assignment
Y/N Table Edit
Default Value: N

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR

10 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR

11 DESIRED_LOCATN1 Character(10) VARCHAR2(10) NOT NULL First Choice
Prompt Table: LOCATION_TBL

12 DESIRED_LOCATN2 Character(10) VARCHAR2(10) NOT NULL Second Choice
Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT2

13 AVAILABILITY_DT Date(10) DATE Date Available

14 RETIREMENT_DT Date(10) DATE Projected Retirement Date

15 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

16 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

17 GVT_SUBMIT_SUPV Character(1) VARCHAR2(1) NOT NULL Submit To Manager
Y/N Table Edit
Default Value: N

18 SUBMIT_PLAN Character(1) VARCHAR2(1) NOT NULL Submit Plan

19 GVT_SUBMIT_HR Character(1) VARCHAR2(1) NOT NULL Submit To HR Dev Staff
Y/N Table Edit
Default Value: N

20 APPROVE_PLAN Character(1) VARCHAR2(1) NOT NULL Approve The Plan

21 DISAPPROVE_PLAN Character(1) VARCHAR2(1) NOT NULL Disapprove the Plan

#	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 to Career Path Table Y/N Table Edit Default Value: N
5	DEFAULT_TRAIN_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Default Training Plan Y/N Table Edit Default Value: N
6	TRAVELLING	Character(1)	VARCHAR2(1) NOT NULL	Willing to Travel Y/N Table Edit Default Value: N
7	RELOCATE	Character(1)	VARCHAR2(1) NOT NULL	Willing to Relocate Y/N Table Edit Default Value: N
8	INTERNATIONAL	Character(1)	VARCHAR2(1) NOT NULL	Take International Assignment Y/N Table Edit Default Value: N
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
10	BUSINESS_UNIT2	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
11	DESIRED_LOCATN1	Character(10)	VARCHAR2(10) NOT NULL	First Choice Prompt Table: LOCATION_TBL
12	DESIRED_LOCATN2	Character(10)	VARCHAR2(10) NOT NULL	Second Choice Prompt Table: LOCATION_TBL Set Control Field: BUSINESS_UNIT2
13	AVAILABILITY_DT	Date(10)	DATE	Date Available
14	RETIREMENT_DT	Date(10)	DATE	Projected Retirement Date
15	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
16	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
17	GVT_SUBMIT_SUPV	Character(1)	VARCHAR2(1) NOT NULL	Submit To Manager Y/N Table Edit Default Value: N
18	SUBMIT_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Submit Plan
19	GVT_SUBMIT_HR	Character(1)	VARCHAR2(1) NOT NULL	Submit To HR Dev Staff Y/N Table Edit Default Value: N
20	APPROVE_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Approve The Plan
21	DISAPPROVE_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Disapprove the Plan