HR_CP_WEAKNESS (SQL View)	Index Back
EE Career Weaknesses HR_CP_WEAKNESS is a view based upon CAREER_WEAKNESS. It is part of Career Planning Self Service product for an employee. Use it to identify an employee's weaknesses or areas requiring further development with regard to their job or career.

HR_CP_WEAKNESS

(SQL View)

EE Career Weaknesses

HR_CP_WEAKNESS is a view based upon CAREER_WEAKNESS. It is part of Career Planning Self Service product for an employee. Use it to identify an employee's weaknesses or areas requiring further development 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_WEAKNESS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREER_WEAKNESS 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_DVL

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_DVL
7	COMMENTS	Long Character	CLOB	Comment