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"
→ finance.banking.bsb

DuckDB

Detect
SELECT finetype('062-000');
-- → 'finance.banking.bsb'
Cast expression
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) = '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 schema finance.banking.bsb
{
  "$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-broad-type": "VARCHAR",
  "x-finetype-pii": true,
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

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

Aliases

bank_state_branch

Type Registry