HR_TPOOL_MBR1

(SQL View)
 Index Back

Talent Pool Members

Members assigned to a Talent Pool along with Impact of Loss and Risk of Leaving and Gender

SELECT A.HR_TP_ID , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.STATUS , A.HR_TP_READINESS , A.HR_TP_IMP_OF_LOSS , C.RISK_OF_LEAVING , B.HR_SUCC_PLAN_CTL , B.HR_SUCC_PLAN_ID , B.HR_SUCC_PLAN_TYPE , ' ' , ' ' FROM PS_HR_TPOOL T , PS_HR_TPOOL_MBR A LEFT OUTER JOIN PS_HR_SP_EFFDT_VW B ON B.HR_SUCC_PLAN_TYPE = '2' AND A.EMPLID = B.HR_SUCC_PLAN_CTL LEFT OUTER JOIN PS_HR_CP_PLAN C ON A.EMPLID = C.EMPLID WHERE T.HR_TP_ID = A.HR_TP_ID AND T.EFFDT = A.EFFDT AND T.STATUS = 'A' AND A.STATUS = 'A' AND %EffdtCheck(HR_TPOOL T1, T, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HR_TP_ID Character(30) VARCHAR2(30) NOT NULL Talent Pool ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %RECNAME_EDIT

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
6 HR_TP_READINESS Character(1) VARCHAR2(1) NOT NULL Displays Readiness of a Talent Pool Member.
0=Ready Now
1=1 - 2 Years
2=3 - 5 Years
E=Emergency
N=Undefined
R=Retirement
7 HR_TP_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
8 RISK_OF_LEAVING Character(1) VARCHAR2(1) NOT NULL Risk of Leaving
1=High
2=Medium
3=Low
9 HR_SUCC_PLAN_CTL Character(11) VARCHAR2(11) NOT NULL Succession Plan Control Value
10 HR_SUCC_PLAN_ID Character(11) VARCHAR2(11) NOT NULL Succession Plan ID
11 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
1=Job Code
2=Person
3=Position
12 KEY_PERSON Character(1) VARCHAR2(1) NOT NULL Key Person
N=No
Y=Yes
13 HR_VT_CREATE_BTN Character(1) VARCHAR2(1) NOT NULL Succession Plan Create button