PeopleSoft Enterprise HRMS 9.1 Application Fundamentals PeopleBook

Setting Up Banks and Bank Branches

This chapter provides an overview of bank and bank branch setup and discusses how to:

Set up banks and bank branches.
Set up IBAN information.
Specify source banks.
Report on banks and bank branches.

Understanding Bank and Bank Branch Setup

This section discusses:

Banking setup.
(GBR) Bank and building society setup in the UK.
The CI_BANK_EC component interface.

Banking Setup

To set up banks in HRMS:

Set up bank information on the Bank Table page (BANK_EC).
Specify bank branch information on the Branch Table page (BANK_BRANCH_EC).

Note. There is some additional banking setup required for the UK.

See (GBR) Bank and Building Society Setup in the UK.
Specify source banks for payroll processing on the Source Bank Accounts page.

(GBR) Bank and Building Society Setup in the UK

This section discusses how to set up the pages in the Bank/Branch component for British financial institutions. This setup is required prior to entering employee bank and building society information on the Bank Account Information page.

See Entering Bank Account Information.

You must set up every bank or building society that your organization deals with during the course of business. This information is stored in the BANK_EC_TBL and BANK_BRANCH_TBL tables. A third table, PYE_BANKACCT, stores the details of your payee's bank and building society accounts.

For UK banks, set up bank branches on the Bank Table page. For building societies, use the Bank Table page to identify the bank branch that handles clearing for the society. Use the Branch Table page and its associated Building Society Address page, to enter the building society details. This table shows how to complete these pages:

Type of Account	Bank Table Page	Branch Table Page and Building Society Address Page
Bank Branch	Enter the name, address, and phone number of the bank branch.	Leave blank.
Building Society	Enter the name, address, and phone number of the bank branch that handles clearing for the building society.	Enter the building society name and address and the number of the account that the building society has with the clearing bank that is identified on the Bank Table page.

Warning! You must set up a building society on the Branch Table page, linking the society to its clearing bank on the Bank Table page. If you don't set up building societies as described, the BACS interfaces and processes that are provided by Global Payroll for the UK do not generate valid data.

This example shows how a building society is defined on the Branch Table page:

Example Building Society Setup

In the example, the building society is linked to LloydsTSB bank (bank ID 30000) that handles clearing for the building society. The building society's clearing account is shown in the Account Number field.

The CI_BANK_EC Component Interface

Because there may be a large volume of bank information to set up, you can simplify the process by importing bank information from a Microsoft Excel spreadsheet into the bank setup tables with the use of the CI_BANK_EC component interface that PeopleSoft provides.

You download bank information from a website or service that provides bank information to an Excel spreadsheet and then import the information from the Excel spreadsheet to the CI_BANK_EC component interface, using the Excel to Component Interface utility. The CI_BANK_EC component interface loads the bank information into the BANK_EC table and BANK_BRANCH_TBL in PeopleSoft HRMS.

Note. It is your responsibility to determine which rows to update and which rows to add to the PeopleSoft HRMS database when using the Excel to Component Interface utility.

Setting Up Banks and Bank Branches

To set up banks, use the Bank component (BANK_EC). To set up bank branches, use the Bank Branch component (BANK_BRANCH_TBL).

Use the CI_BANK_EC component interface to load the banking data into the tables for this component interface.

See PeopleSoft Enterprise Human Resources PeopleBook: Enterprise Components

This section discusses how to:

Identify banks.
Define bank branches.
(BRA) Enter Brazilian bank branch information

Pages Used to Set Up Banks and Bank Branches

Page Name	Definition Name	Navigation	Usage
Bank Table	BANK_EC	Set Up HRMS, Common Definitions, Banking, Banks, Bank Table	Set up basic information for all financial institutions. You must complete the Bank Table page before you identify a bank with a source bank account.
Branch Table	BANK_BRANCH_EC	Set Up HRMS, Common Definitions, Banking, Banks, Branch Table	Define a bank's branches. Not all countries require bank branch information.
Bank Branch Address	BANK_BRA_ADR_SP	Click the Address Information link on the Branch Table page.	Enter the address for a bank branch.
Bank Branch Brazil	BANKBRANCH_BRA_SEC	Click the Other Information link for a Brazilian bank on the Branch Table page .	Enter additional information for Brazilian bank branches.

Identifying Banks

Access the Bank Table page (Set Up HRMS, Common Definitions, Banking, Banks, Bank Table).

Bank ID

System-displayed. There are different formats for each country. Some are numeric, and others are alphanumeric.

Bank Type

Select the type of bank. Values are Commercial, Community, General, Post Bank,and Savings.

Alternate Bank ID

Enter the bank's national ID, if applicable. If the bank participates in an international banking consortium or system, it is given an alternate bank ID that is used in international transactions.

Bank Name

Enter the name of the bank.

Bank Identifier Code

Enter the Bank Identifier Code (BIC) provided by SWIFT. When saved, the system checks that this entry is 8 or 11 characters long. The system does not validate the accuracy of the BIC, only its length.

Country

Select the country where the bank is located.

Address

The bank's address is displayed.

Edit Address

Click the Edit Address link to change address information for a bank.

Phone

Enter the phone number for the bank.

AC Bank Name (alternate character bank name)

This field appears if you enabled AC functionality on the Primary Permission List Preferences page. Japanese users enter the bank name in single-byte, Katakana format.

(GBR) Special Considerations for the UK

To set up UK bank branches, enter the following information:

Country Code	Enter GBR.
Bank ID	Enter the sort code for the bank branch. Note. If you're setting up a building society, enter the sort code of the bank branch that handles clearing for the building society. Clearing is normally handled by a bank's head office.
Bank Type	Optional for UK banks.
Alternate Bank ID	Leave blank for UK banks.
Bank Name	Enter a description of the branch. Include the location of the branch, not just the bank name.

Defining Bank Branches

Access the Branch Table page (Set Up HRMS, Common Definitions, Banking, Banks, Branch Table).

Branch ID

Enter the branch ID for the bank. Branch ID formats vary by country.

Branch Name

Enter the name of the bank branch.

Bank Identifier Code

Enter the Bank Identifier Code (BIC) provided by SWIFT. When saved, the system checks that this entry is 8 or 11 characters long. The system does not validate the accuracy of the BIC, only its length.

AC Branch Name (alternate character branch name)

This field appears if you enabled AC functionality on the Primary Permission List Preferences page. Japanese users enter the branch name in single-byte, Katakana format.

Address Information

Click the Address Information link to access the Bank Branch Address page.

Other Information

(BRA) Click the Other Information link to access the Bank Branch Brazil page.

(GBR) Special Considerations for the UK

To set up UK building societies, enter the following information on the Branch Table page:

Bld Soc ID (building society ID)	Enter a unique identifier for the building society.
Status	You can enter employee account details only for building societies with an active status.
Bld Soc Name (building society name)	Enter the full name of the building society.
Account Number	Enter the number of the building society's account at the clearing bank.
Address Information	Click the Address Information link to access the Building Society Address page, where you enter the building society's head office address.

Enter Brazilian Bank Branch Information

Access the Bank Branch Brazil page (click the Other Information link on the Branch Table page for a Brazilian bank).

Verifier Digit

Enter the bank-assigned verifier digit. File transfers may require the verifier digit.

Branch Location

Enter the bank branch location.

Contact Name

Enter the contact name for the bank branch.

Setting Up IBAN Information

To set up IBAN Information, use the IBAN Country Setup (SETUP_IBAN_TBL) component.

This section provides an overview of IBAN setup and discusses how to set up IBAN information.

Understanding IBAN Setup

The International Bank Account Number (IBAN) is an account number that uniquely identifies a bank account and is assigned according to ISO standards so that it can be used across national borders. PeopleSoft applications can include this information at the bank account level.

To set up IBAN functionality you must select the IBAN enabled field on the IBAN Country Setup page. You can also establish the rules used to create the Basic Bank Account Number (BBAN) on this page. After the IBAN feature is enabled, the IBAN field and Edit IBAN link appears on the Source Bank Account page and the Maintain Bank Account pages for the country.

Page Used to Set Up IBAN Information

Page Name	Definition Name	Navigation	Usage
IBAN Country Setup	SETUP_IBAN_TBL	Set Up HRMS, Common Definitions, Banking, IBAN Country Setup, IBAN Country Setup	Enable the IBAN feature for a specific country. Create BBAN validation rules.

Setting Up IBAN Information

Access the IBAN Country Setup page (Set Up HRMS, Common Definitions, Banking, IBAN Country Setup, IBAN Country Setup).

IBAN Enabled

Select this check box to enable the IBAN functionality for this country. If you enable IBAN, the IBAN field and the Edit IBAN link appears when you set up a source bank account page or a payee bank account with this country code.

IBAN Required

Select this check box to require an IBAN value for accounts in this country. If you select this check box, you must complete the IBAN fields when you set up a source bank account or a payee bank account with this country code.

See Specifying Source Banks.

See Entering Bank Account Information.

Basic Bank Account Number

Sequence	Enter the order in which the value will appear in the Basic Bank Account Number (BBAN).
Bank Account Field	Select the field used to compose the BBAN.
Start Position	Enter the position where the Bank Account Field will begin.
Length	Enter the number of characters allotted for this Bank Account Field.
Zero Pad	Select this option to fill any difference between Length and the actual Bank Account Field value with zeroes.

Specifying Source Banks

To specify source banks, use the Source Bank Accounts component (SRC_BANK).

This section provides an overview of source banks and discusses how to:

Define source banks.
Edit IBAN information.
(CAN and USA) Specify data for banks in Canada or the U.S.
(JPN) Specify the account type and company code.

Understanding Source Banks

Source banks are the money sources that payroll disbursements are drawn from. For each source bank, identify the appropriate bank and bank branch, account number, and EFT formats.

For certain countries, such as the U.S., Canada, and Japan, you must set up additional information for source banks, accessed through the Other Required Information link on the Source Bank Accounts page. For countries in Europe, you must define International Bank Account Number (IBAN) information, accessed through the Edit IBAN link on the Source Bank Accounts page.

Payroll Setup

PeopleSoft Enterprise Global Payroll users must link source banks to a pay entity.

See Defining Banking Instructions.

PeopleSoft Enterprise Payroll for North America users must link source banks to a pay group.

See Specifying Banks and Tips Processing.

Pages Used to Specify Source Banks

Page Name	Definition Name	Navigation	Usage
Source Bank Accounts	SRC_BANK	Set Up HRMS, Common Definitions, Banking, Source Bank Accounts, Source Bank Accounts	Assign a source bank ID and define information about the banks that pay out money.
International Bank Account Nbr	BANKACCT_IBAN_SEC	Click the Edit IBAN link on the Source Bank Accounts page.	(BEL, CHE, DEU, ESP, FRA, GBR, ITA, and NLD) Enter or edit the International Bank Account Number. Generation of the IBAN is the responsibility of the bank or bank branch servicing the account. This page is only available if the country selected on the Source Bank Accounts page is set up for IBAN on the IBAN Country Setup page.
Canada Bank Additional Data US Bank Additional Data page	SRC_BANK_PY_SP	Click the Other Required Information link on the Source Bank Accounts page.	(CAN and USA) Specify data for banks in Canada or the U.S. This page is only available if you select CAN or USA as the Country Code on the Source Bank Accounts page.
Japan Bank Additional Data	GPJP_SRC_BANK_SEC	Click the Other Required Information link for a Japanese bank on the Source Bank Accounts page.	(JPN) Specify the account type and company code for Japanese banks.

Defining Source Banks

Access the Source Bank Accounts page (Set Up HRMS, Common Definitions, Banking, Source Bank Accounts, Source Bank Accounts).

Description

Enter the name of the bank.

Country Code

Select the country code where the bank is located.

Bank ID

Select the bank ID.

Bank Branch ID

Select the bank branch ID, if applicable.

Account Number

Enter the bank account number. Each country has its own account number format.

Check Digit

Enter the value used to validate the bank ID, bank branch ID (if applicable), and account number. This field only appears for countries where check digits are used.

Note. This field is not for IBAN accounts. You enter the IBAN check digit on the International Bank Account Nbr page that you access when you click the Edit IBAN link on this page.

Account Name

Enter the name of the bank account.

Currency Code

Select the currency code.

IBAN

Displays the IBAN. This only appears if the country code is BEL, FRA, DEU, CHE, ITA, ESP, NLD, or GBR.

Edit IBAN

Click this link to access the International Bank Account Nbr (number) page where you can edit the IBAN.

Note. Generation of the IBAN is the exclusive responsibility of the bank or bank branch that services the account.

Depending on the country that you select, you may not have this page. It is used to record information for companies that operate in Europe.

See Editing IBAN Information.

Other Required Information

Click this link to access the Additional Data page. Depending on the country that you select, this page might not be available. It is used to record information for companies that operate only in the U.S., Canada, or Japan.

See (CAN and USA) Specifying Data for Banks in Canada or the U.S..

See (JPN) Specifying the Account Type and Company Code.

AC Account Name (alternate character account name)	This field appears if you enabled AC functionality on the Primary Permission List Preferences page. Japanese users enter the bank account name in single-byte, Katakana format.
EFT Domestic (electronic funds transfer domestic)	Specify which EFT format the source bank account accepts. Enter the EFT name for domestic transactions. If the payee or recipient account is domestic, the default EFT name is taken from the EFT Domestic field of the source bank account that you selected. With domestic accounts, the country code is the same as the country code that you selected during installation. Note. Not applicable in the U.S. or Canada.
Bank Transfer ID	Enter the bank transfer ID that is used to identify banks to clearing systems.
EFT Int'l (electronic funds transfer international)	Enter the EFT name for international transactions. If the payee or recipient account is foreign, the default EFT name is taken from the EFT Int'l field of the source bank account you selected. With foreign accounts, the country code is different from the country code that you selected during installation.

Note. The Payment ID Assignment page, found in this component, is specific to PeopleSoft Global Payroll and is documented in the PeopleSoft Global Payroll documentation.

Editing IBAN Information

Access the International Bank Account Nbr page (click the Edit IBAN link on the Source Bank Accounts page).

Note. Generation of the IBAN is the exclusive responsibility of the bank or bank branch that services the account.

Note. While saving, the system validates the data. The page will not be saved if any invalid values appear.

Country	Enter or edit the country code used to generate the IBAN.
Check Digit	Enter the number used to validate the IBAN.
Calculate Bank Account Number	Click this button to generate the IBAN. The system populates the Country and Basic Bank Account Number fields using data from the Source Bank Accounts page. You must complete the Check Digit field and correct the defaulted values if necessary.
Basic Bank Account Number	Enter or edit the account number used to generate the IBAN.

(CAN and USA) Specifying Data for Banks in Canada or the U.S.

Access the Canada Bank Additional Data page or the US Bank Additional Data page (click the Other Required Information link for a CAN or USA bank on the Source Bank Accounts page).

(USA) Prenote Wait Days

Wait Days

Enter the number of prenote wait days. What you enter here at the source bank level determines whether the prenotification process is required or not. If you enter 0 in this field, there won't be a prenote generated at the payee level. If you enter any number other than 0 in this field, a prenote is required.

When a company makes transfers to a new account (for example, an employee changes the account for automatic deposits), the banks recommend an initial run with a dummy record to establish that this is a valid (existing) account. The specified waiting period (after the dummy run but before the funds can be transferred to this account) is called the prenote wait days.

Note. enable the prenote process to validate the transit numbers, which you specify at the employee level.

Payroll for North America

The Payroll for North America group box only appears if you have PeopleSoft Payroll for North America installed. You only have to define this group box if you have PeopleSoft Payroll for North America.

Check Stock Form ID	If your company generates checks, select the form ID for this source bank account.
Advice Form ID	If your company generates direct deposits, select the form ID for this source bank account. When assigning numbers for checks or direct deposits, the Pay Confirmation and Paycheck Reprint processes reference this field to determine which check and advice numbers to use. Form IDs are defined in the Form Table.
Deposit Medium	Specify how transactions are transferred to the bank for processing. Options are Tape, EFT, (electronic funds transfer), Diskette, and Report. For PeopleSoft Payroll for North America: This field is for your information only; it does not affect the payroll process in any way.
(CAN) Routing Format	Enter the routing number. The routing number specifies how, on the tape or file to the bank, the routing number (bank ID) is presented. The number can have a leading 0 and can vary, depending on whether bank ID or the branch ID comes first. Select the format to apply to the direct payment routing numbers generated by the Direct Deposit Create File - SQR program DDP001CN. The system uses this format to deposit employees' paychecks directly into their personal bank accounts. Valid values are: Lead 0, Bank ID, Branch ID. Lead 0, Branch ID, Bank ID. Bank ID, Branch ID (no leading zero). Branch ID, Bank ID (no leading zero).

(JPN) Specifying the Account Type and Company Code

Access the Japan Bank Additional Data page (click the Other Required Information link for a Japanese bank on the Source Bank Accounts page).

Account Type

The source bank account type. Values are Checking and Regular.

Company Code

Enter the ID that is assigned to the company by the banking institution.

Reporting on Banks and Bank Branches

To report on banks and bank branches, use the Bank/Branch Report (RUN_PAY701) component.

This section lists the page used to report on banks and bank branches.

Page Used To Report on Banks and Bank Branches

Page Name	Definition Name	Navigation	Usage
Bank/Branch Report	PRCSRUNCNTL	Set Up HRMS, Common Definitions, Banking, Bank/Branch Report, Bank/Branch Report	Run the Bank/Branch report that lists information from the bank and bank branch table.

Bank ID	System-displayed. There are different formats for each country. Some are numeric, and others are alphanumeric.
Bank Type	Select the type of bank. Values are Commercial, Community, General, Post Bank,and Savings.
Alternate Bank ID	Enter the bank's national ID, if applicable. If the bank participates in an international banking consortium or system, it is given an alternate bank ID that is used in international transactions.
Bank Name	Enter the name of the bank.
Bank Identifier Code	Enter the Bank Identifier Code (BIC) provided by SWIFT. When saved, the system checks that this entry is 8 or 11 characters long. The system does not validate the accuracy of the BIC, only its length.
Country	Select the country where the bank is located.
Address	The bank's address is displayed.
Edit Address	Click the Edit Address link to change address information for a bank.
Phone	Enter the phone number for the bank.
AC Bank Name (alternate character bank name)	This field appears if you enabled AC functionality on the Primary Permission List Preferences page. Japanese users enter the bank name in single-byte, Katakana format.

Branch ID	Enter the branch ID for the bank. Branch ID formats vary by country.
Branch Name	Enter the name of the bank branch.
Bank Identifier Code	Enter the Bank Identifier Code (BIC) provided by SWIFT. When saved, the system checks that this entry is 8 or 11 characters long. The system does not validate the accuracy of the BIC, only its length.
AC Branch Name (alternate character branch name)	This field appears if you enabled AC functionality on the Primary Permission List Preferences page. Japanese users enter the branch name in single-byte, Katakana format.
Address Information	Click the Address Information link to access the Bank Branch Address page.
Other Information	(BRA) Click the Other Information link to access the Bank Branch Brazil page.

Verifier Digit	Enter the bank-assigned verifier digit. File transfers may require the verifier digit.
Branch Location	Enter the bank branch location.
Contact Name	Enter the contact name for the bank branch.

IBAN Enabled	Select this check box to enable the IBAN functionality for this country. If you enable IBAN, the IBAN field and the Edit IBAN link appears when you set up a source bank account page or a payee bank account with this country code.
IBAN Required	Select this check box to require an IBAN value for accounts in this country. If you select this check box, you must complete the IBAN fields when you set up a source bank account or a payee bank account with this country code.

Description	Enter the name of the bank.
Country Code	Select the country code where the bank is located.
Bank ID	Select the bank ID.
Bank Branch ID	Select the bank branch ID, if applicable.
Account Number	Enter the bank account number. Each country has its own account number format.
Check Digit	Enter the value used to validate the bank ID, bank branch ID (if applicable), and account number. This field only appears for countries where check digits are used. Note. This field is not for IBAN accounts. You enter the IBAN check digit on the International Bank Account Nbr page that you access when you click the Edit IBAN link on this page.
Account Name	Enter the name of the bank account.
Currency Code	Select the currency code.
IBAN	Displays the IBAN. This only appears if the country code is BEL, FRA, DEU, CHE, ITA, ESP, NLD, or GBR.
Edit IBAN	Click this link to access the International Bank Account Nbr (number) page where you can edit the IBAN. Note. Generation of the IBAN is the exclusive responsibility of the bank or bank branch that services the account. Depending on the country that you select, you may not have this page. It is used to record information for companies that operate in Europe. See Editing IBAN Information.
Other Required Information	Click this link to access the Additional Data page. Depending on the country that you select, this page might not be available. It is used to record information for companies that operate only in the U.S., Canada, or Japan. See (CAN and USA) Specifying Data for Banks in Canada or the U.S.. See (JPN) Specifying the Account Type and Company Code.

Account Type	The source bank account type. Values are Checking and Regular.
Company Code	Enter the ID that is assigned to the company by the banking institution.