The CI_BANK_EC Component Interface

Bank information can change frequently due to mergers and changes in bank locations or bank IDs (also known as routing numbers).

Because a large volume of bank information may need to be set up, you can simplify the process by importing bank information from a Microsoft Excel spreadsheet into the bank setup tables using the banking component interface that PeopleSoft Global Payroll provides.

These steps summarize the setup and use of the CI_BANK_EC component interface:

1. You download bank information from a website or service that provides bank information to a Microsoft Excel spreadsheet.

2. You import the bank information from the Microsoft Excel spreadsheet to the CI_BANK_EC component interface using the Excel to Component Interface utility.

3. The CI_BANK_EC component interface loads bank information into the BANK_EC table and BANK_BRANCH_TBL in HCM.

   Note:

   You are responsible for determining which rows to update and which rows to add to the HCM database when using the Excel to Component Interface utility.

See PeopleTools: Component Interfaces