EX_AIR_OUTST_VW(SQL View) |
Index Back |
|---|---|
Airline Ticket Outstanding |
| SELECT A.EMPLID , C.DATA_SOURCE_EX , C.TRANS_NBR , C.TRANS_DT , C.AIR_TKT_RECON_STAT , B.AIR_TKT_GRACE_PRD FROM PS_EX_EE_ORG_DTL A , PS_BUS_UNIT_TBL_EX B , PS_EX_TRANS C , PS_EX_TYPES_TBL D WHERE A.EE_VAL_FLG='Y' AND A.BUSINESS_UNIT_GL=B.BUSINESS_UNIT_GL AND A.EMPLID=C.EMPLID AND C.EXPENSE_TYPE=D.EXPENSE_TYPE AND D.EXPENSE_TYPE_EDIT='AIR' AND C.AIR_TKT_RECON_STAT='N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATA_SOURCE_EX |
Character(3) | VARCHAR2(3) NOT NULL |
External Data Sources for PS Expenses
AIR=Airline Ticket AMA=American Express AMG=American Express AMH=American Express-Hotel Folio AMM=American Express - Member List AMX=American Express CNS=CONUS DC=Diners Club IPH=iReceipts MC=MasterCard CDFv2 MCX=MasterCard CDFv3 MSG=Text Message NAP=PS NA Payroll PDA=PDA RNZ=Runzheimer SAB=Sabre UBT=User Chatbot USB=US Bank USR=User Input VI4=Visa VIS=Visa |
| 3 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 4 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 5 | AIR_TKT_RECON_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Airline Ticket Reconciliation Status
C=Cancelled N=Not Reconciled R=Reconciled |
| 6 | AIR_TKT_GRACE_PRD | Number(3,0) | SMALLINT NOT NULL | Airline Ticket Grace Period |