EX_CNTRY_MAP_VW(SQL View) |
Index Back |
|---|---|
Expenses Country Map ViewExpenses Country Map View |
| SELECT DATA_SOURCE_EX , COUNTRY , COUNTRY_NAME FROM PS_EX_COUNTRY_MAP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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 |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 3 | COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Country |