EMPLIDRS_SCHD_SRCH_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID ,P.NAME FROM %Table(RS_WORKER_TBL) A , %Table(RS_WRKR_EFFDT) C ,%Table(PERSONAL_DATA) P WHERE A.EMPLID = P.EMPLID AND A.EMPLID = C.EMPLID AND C.EFFDT = ( SELECT MAX(M.EFFDT) FROM %Table(RS_WRKR_EFFDT) M WHERE M.EMPLID = A.EMPLID AND M.EFFDT <= %CurrentDateIn) AND C.WRKR_INELIGIBLE = 'N' |
| # | 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 |