EMPLIDRS_ACT_EMPL(SQL View) |
Index Back |
|---|---|
View of Active EmployeesThis view returns the active employees on the system. |
| SELECT PERS_DATA.EMPLID , PERS_DATA.NAME FROM PS_PERSONAL_DATA PERS_DATA WHERE PERS_DATA.EMPLID IN ( SELECT JOB.EMPLID FROM PS_JOB JOB WHERE JOB.EMPL_STATUS = 'A' AND JOB.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = JOB.EMPLID AND J1.EMPL_RCD = JOB.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND JOB.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = JOB.EMPLID AND J2.EMPL_RCD = JOB.EMPL_RCD AND J2.EFFDT = JOB.EFFDT)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |