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 durationaddr_dur

The length of time an address record was or is expected to remain active within a healthcare system. Used in member enrollment and provider directory management to calculate residency periods, support eligibility determinations, and analyze address stability patterns across covered populations or credentialed provider rosters.

address effectiveaddr_eff

The start date from which a member or provider address record is considered valid in healthcare enrollment and claims systems. Used alongside address expiration dates to construct point-in-time address histories for eligibility audits, geographic attribution, and retroactive claims processing in payer data platforms.

address effective dateaddr_eff_dt

The date on which an address record becomes valid and active within a healthcare system. Used in member enrollment, provider directories, and claims processing to define when a new or updated address should be used for correspondence, eligibility verification, and claims routing purposes.

address emailaddr_eml

The electronic mail address associated with a member, provider, or facility record in a healthcare system. Used in member enrollment, provider directories, and care management platforms for digital correspondence, appointment reminders, explanation of benefits delivery, and secure communications routing.

address end dateaddr_end_dt

The date on which an address record ceases to be valid within a healthcare system. Used in member enrollment, provider directories, and claims processing to define when a previously active address should no longer be used for correspondence, eligibility checks, or claims adjudication and routing.

address end timeaddr_end_tm

The time at which an address record is no longer considered active within a healthcare system. Combined with an end date, this field precisely closes the validity window of an address, supporting audit trails, real-time eligibility systems, and intraday address transitions in member or provider records.

address entered byaddr_ent_by

The identifier of the user or system that originally input an address record into a healthcare platform. Used in member enrollment, provider directories, and claims systems to maintain accountability, support audit logging, and trace data entry back to a specific operator or automated process for quality assurance purposes.

address ethnicityaddr_ethn

An ethnicity classification linked to an address record context, typically used in population health and member enrollment systems to associate demographic data with geographic locations. Supports health equity reporting, outreach targeting, and social determinants of health analyses across specific communities or service areas.

address expirationaddr_exp

The end date after which an address record is no longer considered valid for a member, patient, or provider in healthcare enrollment and claims systems. Used by data engineers to manage slowly changing dimension logic, identify outdated contact data, and ensure accurate eligibility and claims routing workflows.

address expiration dateaddr_exp_dt

The date after which an address record is no longer considered valid or usable within a healthcare system. Used in member enrollment and provider directory management to automatically retire outdated addresses, trigger re-verification workflows, and prevent correspondence or claims from being routed to invalid locations.

address external identifieraddr_ext_id

The reference ID assigned by an external system to uniquely identify a physical location record. Used to cross-reference and reconcile address data across disparate healthcare platforms such as claims systems, member enrollment databases, and provider directories.

address faxaddr_fax

The facsimile telephone number associated with a specific physical address record. Used in healthcare workflows to route clinical documents, referrals, prior authorization requests, and other correspondence to the correct facility, office, or department location.

address feeaddr_fee

The service charge applied to a specific physical address record, such as a billing location or facility site. Used in healthcare financial systems to associate cost or fee schedule information with a registered address for billing, claims, or administrative cost allocation purposes.

address first nameaddr_first_nm

The given or first name of the individual associated with a specific physical address record. Used in member enrollment, claims, and correspondence systems to personalize mailings, verify identity, and ensure accurate delivery of healthcare communications to the correct recipient.

address flagaddr_flg

A binary indicator applied to a physical address record to denote a specific status or condition, such as whether the address is active, verified, returned mail, or flagged for review. Used in member enrollment and claims systems to manage address validity and communication workflows.

address frequencyaddr_freq

The rate or interval at which a physical address record is used, updated, or referenced within healthcare data systems. Used in member enrollment and data quality workflows to track how often a given address appears across claims, correspondence, and administrative transactions.

address full nameaddr_full_nm

The complete formatted name of the individual or entity associated with a physical address record, combining all name components. Used in member enrollment, claims correspondence, and provider directory systems to display the correct addressee on healthcare communications and documents.

address genderaddr_gndr

The gender designation of the individual associated with a specific physical address record. Used in member enrollment and healthcare communications systems to ensure accurate demographic matching when verifying identity, routing correspondence, or reconciling address data across health plan systems.

address glucoseaddr_gluc

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

address group numberaddr_grp_nbr

The insurance group or plan identifier linked to a specific physical address record. Used in member enrollment and claims systems to associate a mailing or service address with the correct employer group, health plan, or coverage segment for benefits administration and correspondence routing.

PreviousPage 10 of 320Next