DNI_BIC view
The view DNI_BIC provides a logical view of the DNI_BIC_INFO table, which contains information about financial institutions.
A checkmark
in one of the following columns in Table 1 indicates:
- Mandatory
- The corresponding field is mandatory.
- BICDir
- The corresponding field is filled when BIC Directory 2018 data is imported.
- BankDir+
- The corresponding field is filled when BankDirectoryPlus data is imported.
| Field name in view | Data type | Mandatory | Corresponding field in core data file | BICDir | BankDir+ | Description |
|---|---|---|---|---|---|---|
| BIC_RECORD_KEY | VARCHAR (12) | ✓ |
BICDir: the BIC and BRANCH CODE are used as the record key BankDir+ RECORD KEY |
✓ | ✓ | The unique key of the record in the file. Chosen by SWIFT. |
| INSTITUTION_NAME | VARCHAR (105) | ✓ | INSTITUTION NAME | ✓ | ✓ | Institution name |
| CITY_HEADING | VARCHAR (35) |
BICDir:
CITY HEADING BankDir+: CITY |
✓ | ✓ | City name | |
| BRANCH_INFORMATION | VARCHAR (70) | BRANCH INFORMATION | ✓ | ✓ | Branch information | |
| BIC_CODE | CHAR(8) |
BICDir:
BIC CODE BankDir+: BIC8 |
✓ | ✓ | Bank identifier code, which identifies a financial institution, its country, and its location. | |
| BRANCH_CODE | CHAR(3) |
BICDir:
BRANCH CODE BankDir+: BRANCH BIC |
✓ | ✓ | BIC branch code associated with the BIC. XXX indicates the main office. | |
| UNIQUE_BIC_CODE | CHAR(8) | BICDir and BankDir+: the data from BIC_CODE is copied into this field. |
✓ | ✓ | BIC that is unique within the data file. | |
| UNIQUE_BRANCH_CODE | CHAR(3) | BICDir and BankDir+: the data from BRANCH_CODE is copied into this field. |
✓ | ✓ | Branch code of the unique BIC. | |
| IBAN_BIC_CODE | CHAR(8) | N/A | The BIC issued with the IBANs to financial institution clients | |||
| IBAN_BRANCH_CODE | CHAR(3) | N/A | Branch code associated with the IBAN BIC. | |||
| ROUT_BIC_CODE | CHAR(8) | N/A | The routing or processing BIC to which a payment is to be sent. | |||
| ROUT_BRANCH_CODE | CHAR(3) | N/A | Branch code associated with the routing bank code. | |||
| PARENT_BANK_CODE | VARCHAR (12) |
BICDir: N/A
BankDir+: GROUP PARENT KEY |
✓ | Code that identifies the parent financial institution. | ||
| CTY_CODE | CHAR(2) | BICDir: N/A BankDir+: ISO COUNTRY CODE |
✓ | ISO country code of the financial institution. | ||
| NAT_ID | VARCHAR (15) |
BICDir: N/A BankDir+: NATIONAL ID |
✓ | National identifier of the financial institution. | ||
| UNIQUE_NAT_ID | VARCHAR (15) | N/A | National identifier that is unique in the data file for each country code, for search purposes. | |||
| IBAN_CTY_CODE | CHAR(2) | N/A | ISO country code prefix of the IBAN that the financial institution issues. | |||
| IBAN_NAT_ID | VARCHAR (15) | N/A | The national ID as included in the IBAN. | |||
| UNIQUE_IBAN_NAT_ID | VARCHAR (15) | N/A | IBAN national ID. | |||
| OTHER_NAT_ID_1 | VARCHAR (17) | N/A | Additional national IDs. | |||
| OTHER_NAT_ID_2 | VARCHAR (17) | N/A | ||||
| CHIPS_UID | INTEGER | CHIPS UID | ✓ | CHIPS universal ID for the financial institution. | ||
| SUBTYPE_INDICATOR | CHAR(4) |
BICDir:
SUBTYPE INDICATION BankDir+: SUBTYPE INDICATOR |
✓ | ✓ | Type of financial institution. | |
| SERVICE_CODES | VARCHAR (60) |
BICDir:
VALUE-ADDED SERVICES BankDir+: SERVICE CODES |
✓ | ✓ | Codes that identify the services to which the financial institution subscribes. | |
| BRANCH_QUALIFIER | VARCHAR (35) |
BICDir:
EXTRA INFORMATION BankDir+: BRANCH QUALIFIERS |
✓ | ✓ | BIC branch qualifier. Check the corresponding directory specification for details about data included in this field. | |
| SPECIAL_CODE | CHAR(6) | N/A | Code that specifies information about the financial institution from the national record | |||
| PHYSICAL_ADDRESS_1 | VARCHAR (35) |
BICDir:
PHYSICAL ADDRESS 1 BankDir+: STREET ADDRESS 1 |
✓ | ✓ | Physical addresses | |
| PHYSICAL_ADDRESS_2 | VARCHAR (35) |
BICDir:
PHYSICAL ADDRESS 2 BankDir+: STREET ADDRESS 2 |
✓ | ✓ | ||
| PHYSICAL_ADDRESS_3 | VARCHAR (35) |
BICDir:
PHYSICAL ADDRESS 3 BankDir+: STREET ADDRESS 3 |
✓ | ✓ | ||
| PHYSICAL_ADDRESS_4 | VARCHAR (35) |
BICDir:
PHYSICAL ADDRESS 4 BankDir+: STREET ADDRESS 4 |
✓ | ✓ | ||
| ZIP_CODE | VARCHAR (15) | BankDir+: ZIP CODE | ✓ | Zip code. | ||
| LOCATION | VARCHAR (105) |
BICDir:
LOCATION BankDir+: CPS |
✓ | ✓ | Location. | |
| CTY_NAME | VARCHAR (70) | COUNTRY NAME | ✓ | ✓ | Country name. | |
| POB_NUMBER | VARCHAR (35) | POB NUMBER | ✓ | ✓ | POB number. | |
| POB_ZIP_CODE | VARCHAR (15) | N/A | POB zip code. | |||
| POB_LOCATION | VARCHAR (105) | BICDir: POB LOCATION BankDir+: N/A | ✓ | POB location. | ||
| POB_CTY_NAME | VARCHAR (70) | BICDir: POB COUNTRY NAME BankDir+: N/A | ✓ | POB country name. | ||
| NAT_ID_EXPIRY_DATE | DATE | N/A | The date on which the national ID was removed by the national authority. This field is reserved by SWIFT for future use. | |||
| UPDATE_DATE | DATE | N/A | The date on which the corresponding record in the reference date file was last updated. | |||
| WRITE_PROTECTED | CHAR(1) | ✓ | (not in file) | Do not update this record when re-importing reference data:
|
||
| IGNORE_FOR_QUERY | CHAR(1) | ✓ | (not in file) | Ignore this record in FTM SWIFT.
|
||
| ACTIVATION_DATE | DATE | (not in file) | Date on which the record becomes active. If empty, the record is active. For BankDir+ this field is empty. For BICDir, this field contains the activation date of the file, if this date is not yet reached when the file is imported and the record did not exist in the table before. Only when this date is reached, the record is used by FTM SWIFT. |