HR_SUCC_PLN_VW (SQL View)	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_VW

(SQL View)

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.

SELECT HR_SUCC_PLAN_ID ,HR_SUCC_PLAN_TYPE ,HR_SUCC_PLAN_CTL ,EFFDT ,DESCR FROM PS_HR_SUCC_PLN_HDR WHERE HR_SUCC_PLAN_STS IN('I','O')

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description