NPI (National Provider Identifier)
Type Registry
NPI (National Provider Identifier)
identity.medical.npi 10-digit numeric identifier for US healthcare providers, issued by CMS. Includes a Luhn check digit as the 10th digit. Required for HIPAA transactions. Format: exactly 10 digits starting with 1 or 2.
Domain identity›medical
Casts to VARCHAR
Scope Universal
Try it
CLI
$ finetype infer -i "1234567893"
→ identity.medical.npi DuckDB
Detect
SELECT finetype('1234567893');
-- → 'identity.medical.npi' 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) = 'identity.medical.npi'; JSON Schema
finetype schema identity.medical.npi {
"$id": "https://noon.sh/schemas/identity.medical.npi",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "10-digit numeric identifier for US healthcare providers, issued by CMS. Includes a Luhn check digit as the 10th digit. Required for HIPAA transactions. Format: exactly 10 digits starting with 1 or 2.",
"examples": [
"1234567893",
"1003000126",
"1992789456"
],
"maxLength": 10,
"minLength": 10,
"pattern": "^[12]\\d{9}$",
"title": "NPI (National Provider Identifier)",
"type": "string"
} Examples
123456789310030001261992789456 Also known as
national_provider_identifierprovider_id