KEY_RISK_METR

(SQL View)
 Index Back

Key Person Metrics

Key Person Metrics

SELECT A.OPRID , A.ROWSECCLASS , A.EMPLID , A.EMPL_RCD , B.HR_SUCC_PLAN_ID , B.HR_SUCC_PLAN_TYPE , B.HR_SUCC_PLAN_CTL , B.EFFDT , 0 , C.IMPACT_OF_LOSS , C.RISK_OF_LEAVING , A.BUSINESS_UNIT , A.COMPANY , A.DEPTID , A.LOCATION , A.SETID_DEPT , A.SETID_LOCATION FROM PS_KEY_PERS_SRCH_D A LEFT OUTER JOIN PS_HR_SUCC_PLN_HDR B ON B.HR_SUCC_PLAN_TYPE = '2' AND A.EMPLID = B.HR_SUCC_PLAN_CTL LEFT OUTER JOIN PS_CAREERPLAN C ON A.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 HR_SUCC_PLAN_ID Character(11) VARCHAR2(11) NOT NULL Succession Plan ID
6 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
1=Job Code
2=Person
3=Position
7 HR_SUCC_PLAN_CTL Character(11) VARCHAR2(11) NOT NULL Succession Plan Control Value
8 EFFDT Date(10) DATE Effective Date

Default Value: %date

9 NO_OF_SUCC Number(3,0) SMALLINT NOT NULL Denotes the number of Successors
10 IMPACT_OF_LOSS Character(1) VARCHAR2(1) NOT NULL Impact of Loss
1=High
2=Medium
3=Low
11 RISK_OF_LEAVING Character(1) VARCHAR2(1) NOT NULL Risk of Leaving
1=High
2=Medium
3=Low
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
16 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
17 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID