EMPLIDGPFR_DSN_EELN_V(SQL View) |
Index Back |
|---|---|
DSN - Employee Last Name ViewDSN - Employee Last Name View |
| SELECT EMPLID ,FIRST_NAME ,LAST_NAME FROM PS_NAMES A WHERE NAME_TYPE='PRI' AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_NAMES B WHERE A.EMPLID=B.EMPLID AND A.NAME_TYPE=B.NAME_TYPE AND B.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 3 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |