SUCC_PLAN_POSN (SQL Table)	Index Back
Succession Plan Header by Posn SUCC_PLAN_POSN 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 SUCCESSION_PLAN.

SUCC_PLAN_POSN

(SQL Table)

Succession Plan Header by Posn

SUCC_PLAN_POSN 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 SUCCESSION_PLAN.

Parent Record Of SUCCESSION_PLAN SUCCESS_RANK1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

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

3 NEXT_SUCCESSPLN_DT Date(10) DATE Next Succession Plan Date

4 AVAILABILITY_DT Date(10) DATE Date Available
Default Value: CAREERPLAN.RETIREMENT_DT

5 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen
Default Value: P

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	NEXT_SUCCESSPLN_DT	Date(10)	DATE	Next Succession Plan Date
4	AVAILABILITY_DT	Date(10)	DATE	Date Available Default Value: CAREERPLAN.RETIREMENT_DT
5	POSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Position Status A=Approved P=Proposed R=Frozen Default Value: P