EX_TKT_RECON_VW(SQL View) |
Index Back |
|---|
| SELECT C.EMPLID , A.SHEET_ID , C.TRANS_NBR , C.AIR_TKT_RECON_STAT FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_LINE B , PS_EX_TRANS C WHERE B.AIRFARE_RCPT_NBR=C.AIRFARE_RCPT_NBR AND A.EMPLID=C.EMPLID AND A.SHEET_ID=B.SHEET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | TRANS_NBR | Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 4 | AIR_TKT_RECON_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Airline Ticket Reconciliation Status
C=Cancelled N=Not Reconciled R=Reconciled |