HR_TP_IDEFFDTDefault Value: %date
HR_TP_CAT_IDEMPLIDPrompt Table: HR_TP_PERS_SRCH
EMPL_RCDPrompt Table: HR_TP_PERS_SRCH
HR_TP_MBR_VW(SQL View) |
Index Back |
|---|---|
talent pool - view on memberused on succession plan / processing - view to retrieve list of TP memebers flagged as searchable on succession plans |
| SELECT t.hr_tp_id ,t.effdt ,t.hr_tp_cat_id ,tm.emplid ,tm.empl_rcd FROM PS_HR_TPOOL t , PS_HR_TPOOL_mbr tm WHERE t.hr_sp_cand_srch = 'Y' AND t.status = 'A' AND tm.status = 'A' AND t.hr_tp_id = tm.hr_tp_id AND t.effdt = tm.effdt AND t.effdt = ( SELECT MAX(sub.effdt) FROM PS_HR_TPOOL sub WHERE sub.hr_tp_id = t.hr_tp_id AND effdt <= %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 NOT NULL |
Effective Date
Default Value: %date |
| 3 | HR_TP_CAT_ID |
Character(30) | VARCHAR2(30) NOT NULL | Talent Pool Category |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HR_TP_PERS_SRCH |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: HR_TP_PERS_SRCH |