HR_SUCC_PLN_HDR (SQL Table)	Index Back
Succession Plan Header HR_SUCC_PLN_HDR is the header record which contains the effective date of the Succession Plan for this position. There would be one record for each effective-dated plan. The child record which contains the likely successors is named HR_SUCC_PLN_DTL.

HR_SUCC_PLN_HDR

(SQL Table)

Succession Plan Header

HR_SUCC_PLN_HDR is the header record which contains the effective date of the Succession Plan for this position. There would be one record for each effective-dated plan. The child record which contains the likely successors is named HR_SUCC_PLN_DTL.

Related Language Record: HR_SUCC_PLN_LNG

Parent Record Of HR_SPDTL_MSS_VW HR_SPDTL_NPC_VW HR_SP_RATEBX_VW HR_SP_RB_SELECT HR_SP_RB_SEL_VW HR_SUCC_PLN_DTL HR_SUCC_RANK_VW HR_VT_RATEBX_VW HR_VT_RBOX01_VW HR_VT_RBOX02_VW

# 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: NEW

2 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
1=Job Code
2=Person
3=Position

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

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 HR_SUCC_PLAN_STS Character(1) VARCHAR2(1) NOT NULL Succession Plan Status
D=Draft
I=Inactive
O=Official
Default Value: D

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 DESCRLONG Long Character CLOB Long Description

8 NEXT_SUCCESSPLN_DT Date(10) DATE Next Succession Plan Date

9 AVAILABILITY_DT Date(10) DATE Availability Date
Default Value: CAREERPLAN.RETIREMENT_DT

10 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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: NEW
2	HR_SUCC_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Type 1=Job Code 2=Person 3=Position
3	HR_SUCC_PLAN_CTL	Character(11)	VARCHAR2(11) NOT NULL	Succession Plan Control Value Prompt Table: %EDITTABLE
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	HR_SUCC_PLAN_STS	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Status D=Draft I=Inactive O=Official Default Value: D
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCRLONG	Long Character	CLOB	Long Description
8	NEXT_SUCCESSPLN_DT	Date(10)	DATE	Next Succession Plan Date
9	AVAILABILITY_DT	Date(10)	DATE	Availability Date Default Value: CAREERPLAN.RETIREMENT_DT
10	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.