APPLIDFO_APP_ADDR_DB2(SQL View) |
Index Back |
|---|
| SELECT A.APPLID , A.CITY_OTHER , A.STATE_OTHER , A.POSTAL_OTHER FROM PS_APPL_DATA_EFFDT A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_APPL_DATA_EFFDT B WHERE A.APPLID = B.APPLID AND B.EFFDT < %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPLID |
Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 2 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
| 3 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL | State Other |
| 4 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |