TPOOL_METR_RDY(SQL View) |
Index Back |
|---|---|
Talent Pool Search RecordSearch Record for Talent Pool feature |
| SELECT A.HR_TP_ID , A.EMPLID , A.EMPL_RCD , A.HR_TP_READINESS , B.HR_SUCC_PLAN_CTL , B.HR_SUCC_PLAN_ID , B.HR_SUCC_PLAN_TYPE , C.TIME_REMAINING , C.UNITS_OF_TIME 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | 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 |
| 5 | HR_SUCC_PLAN_CTL | Character(11) | VARCHAR2(11) NOT NULL | Succession Plan Control Value |
| 6 | HR_SUCC_PLAN_ID | Character(11) | VARCHAR2(11) NOT NULL | Succession Plan ID |
| 7 | HR_SUCC_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Succession Plan Type
1=Job Code 2=Person 3=Position |
| 8 | TIME_REMAINING | Number(2,0) | SMALLINT NOT NULL | Time Remaining in Role |
| 9 | UNITS_OF_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Units of Time
1=Months 2=Years |