EMPLIDFO_MTH_SCHD_SRC(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , B.NAME , B.CITY , B.STATE , B.POSTAL FROM %Table(RS_WORKER_TBL) A , %Table(FO_CANDIDATE_W) B WHERE A.EMPLID = B.CANDIDATE_ID |
| # | 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 |
| 3 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |