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 coinsurance amountaddr_coins_amt

Member's share of healthcare costs associated with a specific address record after the deductible has been met, calculated as a percentage of the allowed amount. Used in claims adjudication and member billing to reflect cost-sharing obligations tied to services at a given location.

address commentaddr_cmt

Free-text notation or annotation attached to an address record in a healthcare system, capturing supplementary information such as delivery instructions, address clarifications, or administrative notes relevant to patient registration, member enrollment, or provider directory management.

address completed dateaddr_cmpl_dt

Date on which processing, verification, or an associated service linked to a specific address record was finalized in a healthcare system. Used in member enrollment, claims processing, or care management workflows to timestamp when address-related tasks or transactions were fully resolved.

address confidential indicatoraddr_conf_ind

Flag designating that a specific address record is sensitive and subject to restricted access within a healthcare system. Applied in patient registration and member enrollment to protect the location of individuals at risk, such as domestic violence survivors, preventing unauthorized disclosure of residential information.

address countaddr_cnt

Numeric value representing the total number of address records associated with a patient, member, or entity in a healthcare system. Used in data quality audits, member enrollment management, and patient registration to identify duplicate entries or track the volume of addresses on file.

address countryaddr_ctry

Country name or standardized country code component of an address record in a healthcare system. Used in patient registration, member enrollment, and claims processing to identify the nation of residence or correspondence, supporting international members and cross-border healthcare transactions.

address created byaddr_crtd_by

Username or system identifier of the user or automated process that originally created an address record in a healthcare system. Used for audit trail purposes in patient registration, member enrollment, and provider directory management to support data governance and accountability tracking.

address created dateaddr_crtd_dt

The date a physical address record was first entered into the healthcare system. Used in member enrollment, provider directories, and claims processing to establish when a mailing or residential address became part of the administrative record, supporting audit trails and data lineage tracking.

address created timeaddr_crtd_tm

The timestamp indicating when a physical address record was first entered into the healthcare system. Captures the precise time of record creation to support audit logging, data lineage, and chronological sequencing of address changes in member enrollment or provider directory systems.

address creatinineaddr_cr

A prefix or contextual qualifier associated with creatinine lab result records, linking the kidney function biomarker to a specific location or facility context. Used in clinical data systems to associate serum or urine creatinine values with the site where the specimen was collected or processed.

address currentaddr_curr

The most recent valid mailing or residential address on file for a member, patient, or provider in EHR, claims, and enrollment systems. Used in eligibility verification, claims adjudication, provider directory maintenance, and USPS address validation workflows during member data management processes.

address dateaddr_dt

The calendar date associated with a specific address record in a healthcare system. Used in member enrollment, claims, and provider directories to record when an address was applicable, supporting eligibility verification, correspondence routing, and historical address tracking across coverage periods.

address datetimeaddr_dttm

The combined date and time value associated with an address record event in a healthcare system. Used in member enrollment and provider directories to precisely timestamp address-related transactions, supporting audit trails, data synchronization, and temporal sequencing of location record changes.

address dea numberaddr_dea_nbr

The Drug Enforcement Administration registration number associated with a specific practice location or dispensing site. Links a DEA-controlled substance prescribing authority to a physical address, used in pharmacy systems and prescriber directories to validate controlled substance prescription eligibility by location.

address death dateaddr_death_dt

The date of death recorded in association with an address record, typically used in member enrollment systems to close active address associations upon a beneficiary's death. Supports disenrollment processing, claims adjudication, and estate correspondence routing in health plan administrative workflows.

address deleted dateaddr_del_dt

The date on which an address record was logically removed from active use in a healthcare system. Used in member enrollment, provider directories, and claims platforms to maintain historical address data while flagging records as inactive, supporting audit trails and regulatory compliance requirements.

address deleted indicatoraddr_del_ind

A flag denoting whether an address record has been logically removed from active use in a healthcare system. Used in member enrollment and provider directories to suppress deleted addresses from current workflows while retaining historical records for auditing, claims research, and regulatory reporting purposes.

address descriptionaddr_desc

A human-readable text label or narrative that clarifies the nature or purpose of an address record, such as billing address, home address, or temporary residence. Used in member enrollment and provider directory systems to distinguish between multiple address types associated with a single entity.

address detailaddr_dtl

Supplementary information associated with a physical address record, such as apartment numbers, suite identifiers, floor designations, or care-of notations. Used in member enrollment, claims, and provider directory systems to ensure complete and accurate mail delivery and location identification across healthcare administrative workflows.

address due dateaddr_due_dt

The date by which an address update or verification is required within a healthcare administrative system. Used in member enrollment and provider credentialing workflows to track deadlines for address confirmation, supporting regulatory compliance, returned mail resolution, and timely delivery of correspondence and EOBs.

PreviousPage 9 of 320Next