EMPLIDEMPL_RCDUX_EMPRCDMAX_VW(SQL View) |
Index Back |
|---|---|
Max Employee Rcd VWView of the maximum employee record for an employee |
| SELECT DISTINCT A1.EMPLID , A1.EMPL_RCD FROM PS_JOB A1 WHERE A1.HR_STATUS = 'A' AND A1.EMPL_RCD= ( SELECT MAX(A2.EMPL_RCD) FROM PS_JOB A2 WHERE A1.EMPLID=A2.EMPLID) AND A1.EFFDT= ( SELECT MAX(A3.EFFDT) FROM PS_JOB A3 WHERE A1.EMPLID=A3.EMPLID AND A3.EMPL_RCD = A1.EMPL_RCD AND A3.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 |