1. HCM Data Loading Business Objects
  2. Examples of Loading Bank Branches

Examples of Loading Bank Branches

A bank is a financial institution that can have multiple branches. External bank accounts are associated with bank branches. Bank, Bank Branch, and External Bank Account are business objects whose details are stored in non-HCM tables.

However, you can load them using HCM Data Loader. This topic describes aspects of the Bank Branch object that you must understand to load bank branches successfully.

Loading Bank Branches

Bank branch data can be supplied in a BankBranch.dat file for processing by HCM Data Loader. The Bank Branch Number attribute, for which the field name on the Manage Bank Branches page varies by country, uniquely identifies the bank branch. It may be a required attribute, depending on country-specific validations.

You can supply one of the following combinations of attributes to provide a unique reference to the bank branch and the associated bank:

  • Bank Branch Name, Country Code, and either Bank Name or Bank Number

  • Bank Branch Number, Country Code, and either Bank Name or Bank Number

Alternatively, supply a source key to identify the branch and the bank it belongs to.

This example BankBranch.dat file creates a Bank Branch using the Bank Branch Number, Bank Name, and Country Code user keys.

METADATA|BankBranch|BankBranchNumber|BankBranchName|BankName|CountryCode|EftSwiftCode
MERGE|BankBranch|111111A|Toronto 3|Vision Bank|CA|12345678

This example BankBranch.dat file creates a Bank Branch, using source keys to identify the branch and bank.

METADATA|BankBranch|SourceSystemOwner|SourceSystemId|BankId(SourceSystemId)|BankBranchNumber|BankBranchName|BankName|CountryCode|EftSwiftCode
MERGE|BankBranch|VISION|111111A|CA10001A|111111A|Toronto|CA|12345678
Note: When you create a bank branch using HCM Data Loader, it's created with an institution type of Bank Branch. You can only maintain and reference bank branches with this institution type. If you create the bank branch using any other method, the HCM Data Loader can't find the branch when you try creating a bank account later.

Deleting Bank Branches

You can't delete Bank Branch objects using HCM Data Loader. However, you can inactivate bank branches that are no longer required or were entered in error. This feature, which isn't available on the Manage Bank Branches pages, enables you to maintain an audit trail.

Note: When you inactivate a bank, any updates to other attributes are ignored.

This example BankBranch.dat file provides an end date to inactivate a bank branch.

METADATA|BankBranch|BankBranchNumber|BankName|CountryCode|EndDate
MERGE|BankBranch|111111A|Vision Bank|CA|2015/04/01

Related Topics