OPRIDEMPLIDEMPL_RCDHR_SP_POS_CPVW(SQL View) |
Index Back |
|---|---|
Succession Plan - Processingused to retreive people with position in careerpath |
| SELECT SEC.OPRID , a.EMPLID , b.EMPL_RCD , a.POSITION_NBR , a.BUSINESS_UNIT FROM PS_CAREERPATH a , PS_JOB_CURR_VW b ,PS_EMPLMT_SRCH_COR SEC WHERE a.POSITION_NBR > ' ' AND a.EVALUATION_TYPE IN ('A','R') AND a.EMPLID = b.EMPLID AND a.EFFDT = ( SELECT MAX(sub.EFFDT) FROM PS_CAREERPATH sub WHERE sub.EMPLID = a.EMPLID AND sub.EFFDT = a.EFFDT AND sub.EVALUATION_TYPE = a.EVALUATION_TYPE AND sub.CAREER_MOVE = a.CAREER_MOVE AND sub.JOB_OPTION_NBR = a.JOB_OPTION_NBR) AND b.EMPLID = SEC.EMPLID AND b.EMPL_RCD = SEC.EMPL_RCD AND SEC.HR_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | HR_SP_SRCH_KEY1 | Character(10) | VARCHAR2(10) NOT NULL | Succession Planning Search Key 1 |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |