EMPLIDEMPL_RCDHR_SP_JPM_PRFVW(SQL View) |
Index Back |
|---|---|
Succession Planning Processingused as interface view into JPM searches by qualification matches position, by qualification matches job code and by qualific. matches incumbent. |
| SELECT a.EMPLID ,a.EMPL_RCD FROM PS_JOB_CURR_VW a WHERE a.EMPL_RCD = ( SELECT MIN(a2.EMPL_RCD) FROM PS_JOB_CURR_VW a2 WHERE a2.EMPLID = a.EMPLID) |
| # | 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 |