Technical Overview of Bank Statement Data Transmittal

When you import bank statements, the data are transmitted to the PeopleSoft system, which automatically loads the data to the production tables.

To import data, you run the File Import Application Engine process (IMPORT_FILES) from the Import Bank Statements page; this automatically loads bank statements from a file. You specify information that the system needs to retrieve the files, such as file location, layout, and type, and run the process. The process obtains the file contents, converts the content to a PeopleSoft standard layout, and loads the data into staging tables. After the files are loaded into the staging tables, the Treasury Bank Statement Load Application Engine process (TR_BSP_LOAD) copies the information from the staging tables into the production tables. It also determines whether a statement is a duplicate statement. Information for duplicate statements appears on the PeopleTools Process Monitor Process List (PMN_PRCSLIST) and Message Log (PMN_BAT_MSGLOG) pages.

Note:

The system considers previous day statements as duplicates if a statement already exists with the same bank ID, bank account, and as of date.