HCTS_SUCCPLN_VW (SQL View)	Index Back
Talent Summary Talent Summary

HCTS_SUCCPLN_VW

(SQL View)

Talent Summary

SELECT A.HR_SUCC_PLAN_ID , A.HR_SUCC_PLAN_TYPE , A.HR_SUCC_PLAN_CTL , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.STATUS , A.HR_SP_CAND_TYPE , A.RANK , A.HR_SP_READINESS , A.TARGETED_READY_DT , A.BLOCKED , A.HR_SP_IMP_OF_LOSS , B.HR_SUCC_PLAN_STS FROM PS_HR_SUCC_PLN_DTL A , PS_HR_SUCC_PLN_HDR B WHERE 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 B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HR_SUCC_PLN_HDR C WHERE C.HR_SUCC_PLAN_ID = B.HR_SUCC_PLAN_ID AND C.HR_SUCC_PLAN_TYPE = B.HR_SUCC_PLAN_TYPE AND C.HR_SUCC_PLAN_CTL = B.HR_SUCC_PLAN_CTL)

# 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: %date

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

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

#	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: %date
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
14	HR_SUCC_PLAN_STS	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Status D=Draft I=Inactive O=Official Default Value: D