EMPLIDTRAVEL_AUTH_IDSHEET_IDADVANCE_IDLANGUAGE_CDEX_EXP_OPEN_LV5(SQL View) |
Index Back |
|---|---|
UnSubmitted Expense Report |
| SELECT A.EMPLID , ' ' , A.SHEET_ID , ' ' , A1.LANGUAGE_CD , A1.PURPOSE_DESCR FROM ps_EX_SHEETHDR_VW2 A , ps_EX_SHEETHDR_VWL A1 , PS_EX_SHEET_LINE B WHERE A.SHEET_ID = B.SHEET_ID AND A.SHEET_STATUS IN ('PND','MFS') AND A.SHEET_ID = A1.SHEET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TRAVEL_AUTH_ID |
Character(10) | VARCHAR2(10) NOT NULL | Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels. |
| 3 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 4 | ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | PURPOSE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business Purpose |