mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,390 operations terms

address hemoglobinaddr_hgb

A data element erroneously labeled as hemoglobin within an address record context. This likely represents a data model anomaly or mapping error. Hemoglobin values belong in clinical or lab result records and should not be stored within physical address data structures in healthcare systems.

address identifieraddr_id

The unique numeric or alphanumeric key assigned to a physical address record within a healthcare data system. Used as the primary reference to distinguish, retrieve, and link address data across member enrollment, claims, provider directory, and correspondence management platforms.

address indexaddr_idx

The sequential or positional number assigned to a physical address record, used when multiple addresses exist for a single entity. Used in member enrollment and claims systems to order, retrieve, and differentiate multiple address entries such as home, mailing, and temporary locations.

address indicatoraddr_ind

A coded or boolean value that designates the type, status, or classification of a physical address record, such as primary, secondary, mailing, or residential. Used in member enrollment and claims systems to control which address is used for correspondence, billing, or service delivery.

address instructionaddr_instr

Supplemental delivery or routing text associated with a physical address record, such as suite numbers, building names, or special delivery notes. Used in member enrollment and healthcare correspondence systems to ensure accurate delivery of clinical documents, EOBs, and plan communications.

address keyaddr_key

The primary or surrogate key value used to uniquely identify and retrieve a physical address record in a healthcare data system. Used in member enrollment, claims, and provider data systems to join address information across tables and maintain referential integrity in relational databases.

address languageaddr_lang

The preferred written language associated with a physical address record, indicating the language in which communications should be sent to that location. Used in member enrollment systems to route translated healthcare documents, EOBs, and notices to members with limited English proficiency.

address last nameaddr_last_nm

The family or surname of the individual associated with a specific physical address record. Used in member enrollment, claims, and healthcare correspondence systems to verify recipient identity, match records across systems, and ensure accurate delivery of plan documents and clinical communications.

address legal nameaddr_legal_nm

The officially registered legal name of the individual or entity associated with a physical address record. Used in member enrollment and healthcare billing systems to ensure compliance with regulatory correspondence requirements and accurate identification on claims, contracts, and plan documents.

address leveladdr_lvl

The hierarchical classification of a physical address record within a structured data model, such as enterprise, region, facility, or department level. Used in healthcare data systems to organize addresses within organizational hierarchies for reporting, network management, and correspondence routing purposes.

address license numberaddr_lic_nbr

The professional or facility license number associated with a specific address record, used to link a physical location to its regulatory credentials. Supports compliance tracking and provider directory validation across member enrollment and claims processing systems.

address marital statusaddr_mar_sts

A data quality or demographic attribute linked to an address record that captures the marital status associated with the individual residing at or registered to that location. Used in member enrollment systems to support eligibility determination and dependent coverage verification.

address master identifieraddr_mstr_id

The enterprise-wide unique identifier assigned to an address record within a master data management system, ensuring consistent reference to a single physical location across claims, enrollment, and clinical data platforms to eliminate duplicate or conflicting address entries.

address maximumaddr_max

The upper boundary value defined for an address-related data field, used to enforce validation rules or range constraints on address attributes such as unit numbers or postal codes within member enrollment, claims, or provider directory management systems.

address medical record numberaddr_mrn

The medical record number linked to a specific address record, associating a patient's unique clinical identifier with their registered physical location. Used to coordinate care delivery, correspondence, and record retrieval across hospital and ambulatory healthcare data systems.

address middle nameaddr_mid_nm

The middle name or initial associated with the individual linked to an address record, used to improve matching accuracy and reduce ambiguity when identifying members or patients during eligibility verification, claims adjudication, or patient identity resolution workflows.

address minimumaddr_min

The lower boundary value defined for an address-related data field, used to enforce validation rules or range constraints on address attributes within member enrollment, claims processing, or provider directory systems to ensure data integrity and completeness.

address mobileaddr_mob

The mobile phone number associated with an address record, used to support outreach, appointment reminders, and care coordination communications. Captured in member enrollment and patient demographic systems to facilitate contact with individuals at or registered to a specific location.

address modified byaddr_mod_by

The user identifier of the individual or system process that last updated an address record, providing an audit trail for data governance and compliance purposes. Used in member enrollment, claims, and provider directory systems to track accountability for address data changes.

address modified dateaddr_mod_dt

The calendar date on which an address record was most recently updated, used to track data currency and support audit trail requirements. Critical in member enrollment and claims systems to ensure correspondence, eligibility determinations, and payments reflect the most current location information.

PreviousPage 11 of 320Next