MeridianMERIDIAN

Numeric Code

representation.identifier.numeric_code

All-digit string where the digit pattern is meaningful and leading zeros must be preserved. Covers ISO country numeric codes (840, 036), FIPS codes, product category codes, and similar classification systems. The critical property is that these values MUST remain as VARCHAR — casting to integer strips leading zeros and destroys the code's identity. Defers to geography.address.postal_code and identity.person.phone_number when those more specific types apply, and to the identity.industry.* leaves (identity.industry.naics) for industry classification codes.

Domain
representation
Category
identifier
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "840" --mode column
→ representation.identifier.numeric_code

DuckDB

Detect
SELECT ft_infer('840');
-- → 'representation.identifier.numeric_code'
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) = 'representation.identifier.numeric_code';

JSON Schema

finetype taxonomy representation.identifier.numeric_code -o json-schema
{
  "$id": "https://meridian.online/schemas/representation.identifier.numeric_code",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "All-digit string where the digit pattern is meaningful and leading zeros must be preserved. Covers ISO country numeric codes (840, 036), FIPS codes, product category codes, and similar classification systems. The critical property is that these values MUST remain as VARCHAR — casting to integer strips leading zeros and destroys the code's identity. Defers to geography.address.postal_code and identity.person.phone_number when those more specific types apply, and to the identity.industry.* leaves (identity.industry.naics) for industry classification codes.",
  "examples": [
    "840",
    "036",
    "06",
    "06075",
    "0001",
    "99"
  ],
  "pattern": "^[0-9]+$",
  "title": "Numeric Code",
  "type": "string",
  "x-finetype-label": "representation.identifier.numeric_code",
  "x-finetype-pii": false
}

Examples

8400360606075000199

Aliases

codeclassification_codecategory_code

Type Registry