Steps to Load Data from Visa International

To load data from Visa International:

  1. Access the Load External Data page.

  2. Select a data source of Visa.

  3. (Optional) In the File Name field, enter the path and name of the Visa International data file.

  4. Select Load External Data.

Visa International produces multiple transaction types with InfoSpan software. PeopleSoft Expenses uses transaction types 2, 3, 4, 5, 9, and 14, 15, 26 from InfoSpan version 3.0 and 4.0.

PeopleSoft Expenses uses transaction types 2, 3, 4, 5, 9, 14, 15, 32 from InfoSpan version 4.4.

Process Scheduler runs the Load External Data Application Engine process, which drives the staging process (EX_PUB_VISA) and the loading program (EX_LOAD_VISA). The staging process populates the staging tables that correspond to Visa transaction types.

The loading process:

  1. Combines the staging tables into one table (EX_VSTG_TA1).

  2. Checks for invalid values and loads errors into the EX_VISA_STG_ERR table.

  3. Completes the load process by loading data into the EX_TRANS table.

The Lodging Summary (type 09) record type contains summary information on Visa commercial card transactions conducted at hotels or places of lodging.

The Lodging Detail (type 26 for Visa 4.0, type 32 for Visa 4.4) record type contains detailed information on Visa commercial card transactions conducted at hotels or places of lodging.

Visa CDF File Record type 14 and 15 contains air travel data. The passenger itinerary (T14) record type contains summary travel information on an air or rail trip paid with a Visa commercial card. The leg-specific information (T15) record type contains summary travel information on an air or rail trip.

The Car Rental Summary (type 02) record type contains summary information for Visa commercial card transactions conducted at car rental merchants.