CAREERPATH_EVAL (SQL Table)	Index Back
Career Path Evaluator Use CAREERPATH_EVAL and CAREERPATH in Career Planning to set up potential career paths (sequences of jobcodes) for an employee. You can create multiple career path records for an employee. For example, there might exist an official, approved career path for the employee's present jobcode. The employee's supervisor might also suggest an alternate career path that varies from the norm. Both can exist. Simply set up one CAREERPATH_EVAL record for each type of career path. Then specify the actual jobcode sequence in CAREERPATH. Please note that the Approved career path is the one that will be used as a base in the Succession Planning module.

CAREERPATH_EVAL

(SQL Table)

Career Path Evaluator

Use CAREERPATH_EVAL and CAREERPATH in Career Planning to set up potential career paths (sequences of jobcodes) for an employee. You can create multiple career path records for an employee. For example, there might exist an official, approved career path for the employee's present jobcode. The employee's supervisor might also suggest an alternate career path that varies from the norm. Both can exist. Simply set up one CAREERPATH_EVAL record for each type of career path. Then specify the actual jobcode sequence in CAREERPATH. Please note that the Approved career path is the one that will be used as a base in the Succession Planning module.

Parent record: CAREERPLAN

# 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

#	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