Steps to Load Data from US Bank

To load data from US Bank:

  1. Access the Load External Data page.

  2. Select a data source of US Bank.

  3. In the File Name field, enter the path and name of the US Bank data files.

  4. Select Load External Data.

US Bank produces multiple transaction types. PeopleSoft Expenses uses transaction types 2, 5, and 10.

Process Scheduler runs the Load External Data Application Engine process, which drives the staging process (EX_PUB_USB) and the loading process (EX_LOAD_USB). The staging process populates these staging tables that correspond to US Bank transaction types:

  • EX_USB_02_TA1

  • EX_USB_05_TA1

  • EX_USB_10_TA1

The loading process:

  1. Combines the EX_USB_INFO_XX staging tables into one table (EX_USB_ST_TA1).

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

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