HR_SUCC_PLN_DTL (SQL Table)	Index Back
Succession Plan Candidates SUCCESSION_PLAN contains the list of employees or external candidates who are likely successors for a position. It also captures their readiness and whether or not they are blocked by the current incumbent. This is the main record in the Succession Planning application.

HR_SUCC_PLN_DTL

(SQL Table)

Succession Plan Candidates

SUCCESSION_PLAN contains the list of employees or external candidates who are likely successors for a position. It also captures their readiness and whether or not they are blocked by the current incumbent. This is the main record in the Succession Planning application.

Parent record: HR_SUCC_PLN_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_SUCC_PLAN_ID Character(11) VARCHAR2(11) NOT NULL Succession Plan ID
Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_ID

2 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
1=Job Code
2=Person
3=Position
Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_TYPE

3 HR_SUCC_PLAN_CTL Character(11) VARCHAR2(11) NOT NULL Succession Plan Control Value
Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_CTL
Prompt Table: %EDITTABLE

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: HR_SUCC_PLN_HDR.EFFDT

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: %EDITTABLE3

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

8 HR_SP_CAND_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Candidate Type
A=Applicant
P=Person
Default Value: P

9 RANK Number(3,0) SMALLINT NOT NULL Rank

10 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

11 TARGETED_READY_DT Date(10) DATE Targeted Ready Date
Default Value: READINESS_VW.TARGETED_READY_DT

12 BLOCKED Character(1) VARCHAR2(1) NOT NULL Blockage for Succession Planning
Y/N Table Edit

13 HR_SP_IMP_OF_LOSS Character(1) VARCHAR2(1) NOT NULL Impact of Loss: indicates the impact to an organization if an employee terminates. Used on Succession Planning and Talent Pool
1=High
2=Medium
3=Low

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_SUCC_PLAN_ID	Character(11)	VARCHAR2(11) NOT NULL	Succession Plan ID Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_ID
2	HR_SUCC_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Type 1=Job Code 2=Person 3=Position Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_TYPE
3	HR_SUCC_PLAN_CTL	Character(11)	VARCHAR2(11) NOT NULL	Succession Plan Control Value Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_CTL Prompt Table: %EDITTABLE
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: HR_SUCC_PLN_HDR.EFFDT
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: %EDITTABLE3
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
8	HR_SP_CAND_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Candidate Type A=Applicant P=Person Default Value: P
9	RANK	Number(3,0)	SMALLINT NOT NULL	Rank
10	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
11	TARGETED_READY_DT	Date(10)	DATE	Targeted Ready Date Default Value: READINESS_VW.TARGETED_READY_DT
12	BLOCKED	Character(1)	VARCHAR2(1) NOT NULL	Blockage for Succession Planning Y/N Table Edit
13	HR_SP_IMP_OF_LOSS	Character(1)	VARCHAR2(1) NOT NULL	Impact of Loss: indicates the impact to an organization if an employee terminates. Used on Succession Planning and Talent Pool 1=High 2=Medium 3=Low