SUCCESS_BLCK_VW (SQL View)	Index Back
Successn-Cands w/Min Readiness SUCCESS_BLCK_VW is a view which selects the minimum readiness for each candidate in an active(Official) succession plan. This represents the "readiest" they are for any position in the plan, and thus how long it is likely to be before they are promoted. This view is brought into the Succession Plan panel to display the readiness of the key position incumbent. The incumbent's readiness is also used to determine if the candidates below are blocked from advancing.

SUCCESS_BLCK_VW

(SQL View)

Successn-Cands w/Min Readiness

SUCCESS_BLCK_VW is a view which selects the minimum readiness for each candidate in an active(Official) succession plan. This represents the "readiest" they are for any position in the plan, and thus how long it is likely to be before they are promoted. This view is brought into the Succession Plan panel to display the readiness of the key position incumbent. The incumbent's readiness is also used to determine if the candidates below are blocked from advancing.

SELECT A.EMPLID ,A.EFFDT ,A.RANK ,A.HR_SP_READINESS ,A.TARGETED_READY_DT FROM PS_HR_SUCC_PLN_DTL A , PS_HR_SUCC_PLN_HDR B WHERE B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_HR_SUCC_PLN_HDR B1 WHERE B1.HR_SUCC_PLAN_ID = B.HR_SUCC_PLAN_ID AND B1.HR_SUCC_PLAN_TYPE = B.HR_SUCC_PLAN_TYPE AND B1.HR_SUCC_PLAN_CTL = B.HR_SUCC_PLAN_CTL AND B1.EFFDT <= %CurrentDateIn) AND B.HR_SUCC_PLAN_STS = 'O' AND A.HR_SUCC_PLAN_ID = B.HR_SUCC_PLAN_ID AND A.HR_SUCC_PLAN_TYPE = B.HR_SUCC_PLAN_TYPE AND A.HR_SUCC_PLAN_CTL = B.HR_SUCC_PLAN_CTL AND A.EFFDT = B.EFFDT AND A.HR_SP_READINESS = ( SELECT MIN(HR_SP_READINESS) FROM PS_HR_SUCC_PLN_DTL A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT)

# 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 RANK Number(3,0) SMALLINT NOT NULL Rank

4 HR_SP_READINESS Character(1) VARCHAR2(1) NOT NULL Displays Readiness of a Succession Plan Candidate.
0=Ready Now
1=1 - 2 Years
2=3 - 5 Years
E=Emergency

5 TARGETED_READY_DT Date(10) DATE Targeted Ready Date

#	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	RANK	Number(3,0)	SMALLINT NOT NULL	Rank
4	HR_SP_READINESS	Character(1)	VARCHAR2(1) NOT NULL	Displays Readiness of a Succession Plan Candidate. 0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency
5	TARGETED_READY_DT	Date(10)	DATE	Targeted Ready Date