HR_CP_STRENGTH (SQL View)	Index Back
EE Career Strengths HR_CP_STRENGTH is a view based upon CAREER_STRENGTH. It is part of Career Planning Self Service product for an employee. Use it to identify an employee's strengths with regard to their job or career.

HR_CP_STRENGTH

(SQL View)

EE Career Strengths

HR_CP_STRENGTH is a view based upon CAREER_STRENGTH. It is part of Career Planning Self Service product for an employee. Use it to identify an employee's strengths with regard to their job or career.

SELECT A.EMPLID , A.EFFDT ,A.EVALUATION_TYPE , A.JPM_CAT_TYPE , A.CAREER_COMPETENCY , A.COMPETENCY_RATING , A.COMMENTS FROM PS_CAREER_STRENGTH A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREER_STRENGTH B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn)

# 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 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
Prompt Table: HR_CP_CONTENT_P

5 CAREER_COMPETENCY Character(12) VARCHAR2(12) NOT NULL Competency
Prompt Table: HR_CP_COMP_P

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

7 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	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile. Prompt Table: HR_CP_CONTENT_P
5	CAREER_COMPETENCY	Character(12)	VARCHAR2(12) NOT NULL	Competency Prompt Table: HR_CP_COMP_P
6	COMPETENCY_RATING	Character(1)	VARCHAR2(1) NOT NULL	COMPETENCY_RATING 1=Strong 2=Acceptable 3=Needs Improvement Prompt Table: REVW_RATING_STR
7	COMMENTS	Long Character	CLOB	Comment