Financials State of Kansas - FMS Page 1 of 4

AP Bank ID Qualifiers CAP017

Item Overview:

The Bank ID Qualifiers page displays the country-specific numeric value for a bank. This value controls how the bank and counterparty pages edit and display bank information. This information drives bank account edits, which can vary by country for each bank type. In some cases, a country may have more than one ID.

Each bank ID qualifier indicates a specific type of bank with specific identifying information. For example, when the system encounters a bank ID qualifier of 001 (indicating a U.S. bank), the system validates that a valid check digit was entered for an ABA transit routing number for the bank qualifier.

Menu Path:

Banking > Banks and Branches > Bank ID Qualifiers

Page Screenshots:

Component: BANK_ID_QUALS

Page: BNK_ID_QUAL_PNL

Record Information:

Table Name / PS Table Name /

Table Purpose

Bank ID Qualifier / BNK_ID_QUAL_TBL / View the ID qualifiers that the system uses to edit bank values.

Approach:

· The system will use the Bank ID Qualifiers as delivered for the USA.

· The State will need to identify all the countries where funds are transferred.

Information Source:

· PeopleSoft delivered values

· Treasurer

· Legacy system

Data Entry Method:

_____ On-Line Pages

__X__ Excel Spreadsheet

_____ Conversion

Field Approach:

Record Name: BNK_ID_QUAL_TBL
Field Name / Approach
BANK_ID_QUAL / Use PeopleSoft delivered values “001” for U.S. Bank.
COUNTRY / The value will be “USA”.
IBAN_ENABLED / The value will be “N”.
DESCR / The field will be used to describe each Bank ID Qualifier.
DESCRSHORT / The field will be used to describe each Bank ID Qualifier.

RTM Cross-Reference:

· AP 025.000 System provides the ability to retain voucher number, warrant number, or EFT ID information and associated mailing address or EFT bank information together.

· AP 118.000 System provides the ability to support the use of multiple bank accounts in a vendor record.

· AP 187.000 System provides the ability to accommodate management of bank transmission files (sorts pre-notes and EFT payments by ACH clearing account and sends file at appropriate time).

· AP 191.000 System provides the ability to use multiple banks with multiple accounts for both warrants and EFTs.

Assumptions:

· The State of Kansas only needs one bank ID qualifier for the US.

· The bank ID qualifier for the US does not need to be International Bank Account Number (IBAN) enabled.

· The State of Kansas does not need any bank ID qualifiers for countries other than the US.

· Updates to Bank ID Qualifiers configuration values are maintained centrally.

Issues:

· None

Input Provided By:

Name / Title, Department

Change Log:

Date / Author / Change Description
1/20/2009 / Kristie Herrick / Initial Design

Note: The Template Change Log should be maintained in reverse chronological order. Hence, the most recent changes are on the top of the list.

SIGNOFFS

Configuration Team Leads

______Date: _____/_____/_____

Accenture Configuration Lead

______Date: _____/_____/_____

State of Kansas Configuration Lead

Module Team Leads

______Date: _____/_____/_____

Team Leads

______Date: _____/_____/_____

V:\FMS_Project\Shared\Finance Team\Accounts Payable\Design Phase\Configuration Design Docs\Ready for Module Lead Review\Reviewed by Jo Ann and Shawn\CAP017_Bank_ID_Qualifiers.docx 5/12/20091/26/20094:20:30 PM3:25:23 PM

Page 1 of 4