MeridianMERIDIAN

BSB Number

Australian Bank-State-Branch number. 6-digit identifier formatted as ###-### that identifies a bank branch in the Australian financial system. First two digits identify the bank, third digit identifies the state, last three digits identify the branch.

BSB Number

finance.banking.bsb

Australian Bank-State-Branch number. 6-digit identifier formatted as ###-### that identifies a bank branch in the Australian financial system. First two digits identify the bank, third digit identifies the state, last three digits identify the branch.

Domain
finance
Category
banking
Casts to
VARCHAR
Scope
Locale-specific
Locales
EN_AU

Try it

CLI
$ finetype infer -i "062-000" --mode column
→ finance.banking.bsb

DuckDB

Detect
SELECT ft_infer('062-000');
-- → 'finance.banking.bsb'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'finance.banking.bsb';

Struct Expansion

Expression
bank_code: SUBSTRING({col}, 1, 2)
branch_code: SUBSTRING({col}, 5, 3)
state_code: SUBSTRING({col}, 3, 1)

JSON Schema

finetype taxonomy finance.banking.bsb -o json-schema
{
  "$id": "https://meridian.online/schemas/finance.banking.bsb",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Australian Bank-State-Branch number. 6-digit identifier formatted as ###-### that identifies a bank branch in the Australian financial system. First two digits identify the bank, third digit identifies the state, last three digits identify the branch.",
  "examples": [
    "062-000",
    "033-001",
    "012-003",
    "082-001",
    "063-010",
    "013-252"
  ],
  "pattern": "^\\d{3}-\\d{3}$",
  "title": "BSB Number",
  "type": "string",
  "x-finetype-label": "finance.banking.bsb",
  "x-finetype-pii": false
}

Examples

062-000033-001012-003082-001063-010013-252

Aliases

bank_state_branch

Type Registry