HR_VT_SUCPLN_VW

(SQL View)
 Index Back

SP360 Profile Succ Plan View

HR_VT_SUCPLN_VW is the view that retreives succession plans for a profile in SP360

SELECT succ.HR_SUCC_PLAN_ID ,succ.HR_SUCC_PLAN_TYPE ,succ.HR_SUCC_PLAN_CTL ,succ.EFFDT ,succ.HR_SUCC_PLAN_STS ,succ.DESCR FROM PS_HR_SUCC_PLN_HDR succ WHERE succ.HR_SUCC_PLAN_STS IN('I','O') AND EFFDT = ( SELECT MAX(sub.EFFDT) FROM PS_HR_SUCC_PLN_HDR sub WHERE sub.HR_SUCC_PLAN_ID = succ.HR_SUCC_PLAN_ID AND sub.HR_SUCC_PLAN_TYPE = succ.HR_SUCC_PLAN_TYPE AND sub.HR_SUCC_PLAN_CTL = succ.HR_SUCC_PLAN_CTL AND sub.EFFDT <= %CurrentDateIn)

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