HR_CP_POTENTIAL (SQL View)	Index Back
EE Career Potential HR_CP_POTENTIAL is a view based upon CAREER_POTENTL. It is part of Career Planning Self Service product for an employee. Use it to record potential ratings by persons assessing an employee's overall career potential and promotability.

HR_CP_POTENTIAL

(SQL View)

EE Career Potential

HR_CP_POTENTIAL is a view based upon CAREER_POTENTL. It is part of Career Planning Self Service product for an employee. Use it to record potential ratings by persons assessing an employee's overall career potential and promotability.

SELECT A.EMPLID , A.EFFDT , A.REVIEW_DT , A.POTENTIAL , A.REVIEWER_COMMENTS FROM PS_CAREER_POTENTL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREER_POTENTL 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 REVIEW_DT Date(10) DATE NOT NULL Review Date

4 POTENTIAL Character(1) VARCHAR2(1) NOT NULL Career Potential
H=High Potential Candidate
L=Lateral Transfer
O=Officer Potential
P=Promotable
W=Currently Well Placed

5 REVIEWER_COMMENTS Long Character CLOB Reviewer Comments

#	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	REVIEW_DT	Date(10)	DATE NOT NULL	Review Date
4	POTENTIAL	Character(1)	VARCHAR2(1) NOT NULL	Career Potential H=High Potential Candidate L=Lateral Transfer O=Officer Potential P=Promotable W=Currently Well Placed
5	REVIEWER_COMMENTS	Long Character	CLOB	Reviewer Comments