CAREER_STRENGTH (SQL Table)	Index Back
EE Career Strengths CAREER_STRENGTH is part of Career Planning for an employee. Use it to identify an employee's strengths with regard to their job or career.

CAREER_STRENGTH

(SQL Table)

EE Career Strengths

CAREER_STRENGTH is part of Career Planning for an employee. Use it to identify an employee's strengths with regard to their job or career.

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

4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
Prompt Table: COMPETENCY_TBL

5 COMPETENCY_RATING Character(1) VARCHAR2(1) NOT NULL COMPETENCY_RATING
1=Strong
2=Acceptable
3=Needs Improvement
Prompt Table: REVW_RATING_STR

6 COMMENTS Long Character CLOB Comment

#	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
4	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: COMPETENCY_TBL
5	COMPETENCY_RATING	Character(1)	VARCHAR2(1) NOT NULL	COMPETENCY_RATING 1=Strong 2=Acceptable 3=Needs Improvement Prompt Table: REVW_RATING_STR
6	COMMENTS	Long Character	CLOB	Comment