Skip to content

SWIFT/BIC

Type Registry

SWIFT/BIC

identity.payment.swift_bic

Society for Worldwide Interbank Financial Telecommunication code (also called Bank Identifier Code). 8 or 11 character code identifying financial institutions. Format: 4-letter bank code + 2-letter country code (ISO 3166) + 2-character location code + optional 3-character branch code.

Domain identity›payment
Casts to VARCHAR
Scope Universal

Try it

CLI 
$ finetype infer -i "DEUTDEFF"
→ identity.payment.swift_bic

DuckDB

Detect 
SELECT finetype('DEUTDEFF');
-- → 'identity.payment.swift_bic'
Cast expression 
UPPER(CAST({col} AS VARCHAR))
Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.payment.swift_bic';

Struct Expansion

bank_code: SUBSTRING({col}, 1, 4)
branch_code: CASE WHEN LENGTH({col}) = 11 THEN SUBSTRING({col}, 9, 3) ELSE NULL END
country_code: SUBSTRING({col}, 5, 2)
location_code: SUBSTRING({col}, 7, 2)

JSON Schema

finetype schema identity.payment.swift_bic 
{
  "$id": "https://noon.sh/schemas/identity.payment.swift_bic",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Society for Worldwide Interbank Financial Telecommunication code (also called Bank Identifier Code). 8 or 11 character code identifying financial institutions. Format: 4-letter bank code + 2-letter country code (ISO 3166) + 2-character location code + optional 3-character branch code.",
  "examples": [
    "DEUTDEFF",
    "BNPAFRPP",
    "CHASUS33XXX",
    "BOFAUS3N"
  ],
  "pattern": "^[A-Z]{4}[A-Z]{2}[A-Z0-9]{2}([A-Z0-9]{3})?$",
  "title": "SWIFT/BIC",
  "type": "string"
}

Examples

DEUTDEFFBNPAFRPPCHASUS33XXXBOFAUS3N

Also known as

bicswift_code

Types in identity