Managing reference data

Reference data is data, published by SWIFT, that includes information about:

Financial institutions
ISO currency codes
ISO country codes
SWIFTNet FINPlus services

SWIFT publishes reference data in directories as a series of compressed files, each of which is called a directory package. The name of the supported directory packages depends on the type of information it contains:

Information type	Directory package name	Support for XML packages
BIC Directory 2018	BICDIR2018_yyyymmdd_TXT.zip	no
BankDirectoryPlus	BANKDIRECTORYPLUS_yyyymmdd_TXT.zip	no
SWIFTRef ReachPlus for FINplus	REACHPLUS_V1_FINPLUS_yyyymmdd_TXT.zip	no

where:

yyyymmdd: The activation date of the contents of the package, that is, the date on which the data became or will become active in the SWIFT environment.
Note: For BankDirectoryPlus, this date is not necessarily the same as the activation date of all records. Some records in the file may specify their own activation date.

The scope of the BankDirectoryPlus, BIC Directory 2018 and SWIFTRef ReachPlus for FINplus directory packages can be either FULL or DELTA files. A full package contains a complete set of all reference data, whereas a DELTA file represents a monthly package containing only the data that was added, deleted, or changed since the previous package.

You can import reference data to the FTM SWIFT database, where it can be used by:

The MER Facility to do the following:
- Create lists of BICs from which users can select the appropriate BIC
- Look up the participants for a SWIFTNet FINplus service when a BIC code is entered
- Select the remote address (distinguished name) from the list of selected correspondents
RMA to obtain information about the institution which belongs to the own or correspondent BIC of a relationship, or to identify stale authorisations
The message printing service to obtain additional information about a BIC, which it adds to the printed message
The message validation service to check the validity of currency and country entries. Without this information, the Message Validation Service checks only the syntax of currency and country entries.

To avoid the need for several identical copies of the reference data, this data can be shared among several instances. This is done by choosing the runtime database of one instance to serve as the source of all reference data for all other instances.

Each package contains, among other files, the following core data files, which are used by FTM SWIFT:

Scope	Directory package type	Core data file	File Type	Abbreviated as
FULL	BankDirectoryPlus Contains a complete set of BankDirectoryPlus, ISO currency, and ISO country data.	BANKDIRECTORYPLUS_ V3_FULL_yyyymmdd.txt	bank file	B3 file
		CURRENCY_CODE_ yyyymmdd.txt	currency file	CU file
		COUNTRY_CODE_ yyyymmdd.txt	country file	CT file
	BIC Directory 2018 Contains a complete set of BIC Directory 2018, ISO currency, and ISO country data.	BICDIR2018_V1_FULL_ yyyymmdd.txt	bank file	FI file
		CURRENCY_CODE_ yyyymmdd.txt	currency file	CU file
		COUNTRY_CODE_ yyyymmdd.txt	country file	CT file
DELTA	BankDirectoryPlus Contains only that BankDirectoryPlus bank data that was added, deleted, or changed since the previous file was made available. Contains a complete set of ISO currency, and ISO country data.	BANKDIRECTORYPLUS_ V3_DELTA_yyyymmdd.txt	bank delta file	B3 file
		CURRENCY_CODE_ yyyymmdd.txt	currency file	CU file
		COUNTRY_CODE_ yyyymmdd.txt	country file	CT file
	BIC Directory 2018 Contains only BIC Directory 2018 bank data that was added, deleted, or changed since the previous file was made available. Contains a complete set of ISO currency, and ISO country data.	BICDIR2018_V1_DELTA_ yyyymmdd.txt	bank delta file	FI delta file
		CURRENCY_CODE_ yyyymmdd.txt	currency file	CU file
		COUNTRY_CODE_ yyyymmdd.txt	country file	CT file
FULL	SWIFTRef ReachPlus for FINplus	REACHPLUS_V1_FINPLUS_ MONTHLY_FULL_ _yyyymmdd.txt	reachplus file	RP file
DELTA	SWIFTRef ReachPlus for FINplus	REACHPLUS_V1_FINPLUS_ MONTHLY_DELTA_ yyyymmdd.txt	reachplus file	RP delta file

Note: Delta files only exist for bank and SWIFTRef ReachPlus for FINplus files. Currency and country files always contain all data. The Reference Data Utility supports only monthly delta files.

Use the Reference Data Utility (RDU) to import reference data to the FTM SWIFT database. Initially, you must import data from a full package. Later on, you can update your reference data by importing data from monthly delta packages that were issued after the full package. Because each monthly delta package contains only those changes relative to the previous package, you cannot skip delta packages. However, if you miss a delta package, you can always obtain the most current data by importing the most recent full package.

If you load SWIFTRef directories over FileAct, ensure that the correct request type for the FileAct request is used. Only TXT formats can be used with FTM SWIFT. Loading can be done in one of the following ways:

Loading unpacked files: Unpack the downloaded ZIP files before running the Reference Data Utility. After unpacking the downloaded files, load the individual contents, for example Country Codes.
Loading ZIP files directly: If the downloaded ZIP files contain the reference data in TXT format, it can be directly loaded using the Reference Data Utility. As the ZIP content is checked regarding core data files, the error message DNPR2153E will be displayed because not all files are contained. To ignore this error message, use the -Dcom.ibm.dnp.rdu.ignorePkgCheck=YES command line option when running RDU.

The Reference Data component in the Administration and Operations (AO) application can be used to display and modify reference data after it has been imported to the FTM SWIFT database. For more information, see Managing reference data.