EMPLIDHR_TP_KEY_PERS(SQL View) |
Index Back |
|---|---|
Key Person SearchPERS_SRCH_GBL is used as a search view to select person records for you to use when you access a panel. This view shows you records only for persons in departments that your operator class is allowed to access. All PER_ORG Types are returned. Modified to identify Persons included on Talent Pools defined specifically for use with Succession Plans. |
| SELECT B.EMPLID ,B.EMPL_RCD FROM PS_HR_TPOOL_MBR B ,PS_HR_TPOOL C ,PS_HR_TP_CAT_TBL D WHERE C.HR_TP_ID = B.HR_TP_ID AND C.EFFDT = B.EFFDT AND B.STATUS = 'A' AND C.STATUS = 'A' AND C.HR_TP_CAT_ID = D.HR_TP_CAT_ID AND D.STATUS = 'A' AND D.HR_SP_KEY_SRCH_FLG = 'Y' AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_HR_TP_CAT_TBL D1 WHERE D1.HR_TP_CAT_ID = D.HR_TP_CAT_ID AND D1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |