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 start dateaddr_start_dt

The date on which an address record becomes active and valid for a member, patient, or facility in enrollment or provider directory systems, marking when correspondence, claims, and care coordination communications should be directed to that location.

address start timeaddr_start_tm

The precise time at which an address record becomes active in member enrollment or provider directory systems, used in conjunction with the start date to support intraday address transitions and accurate timestamp logging in audit trails.

address stateaddr_st

The two-character US state or territory code associated with a member, patient, or facility address, used in claims adjudication, member eligibility verification, network adequacy assessments, and state-specific regulatory compliance reporting.

address statusaddr_sts

Indicates whether an address record is currently active, inactive, undeliverable, or pending verification in member enrollment or provider directory systems, controlling whether the address is used for claims correspondence and member communications.

address street addressaddr_st_addr

The primary street-level location including house number, street name, and unit or suite designation for a member, patient, or facility, used in claims processing, member eligibility verification, and delivery of insurance correspondence and care management materials.

address strengthaddr_str

A data quality metric indicating the completeness and standardization level of an address record, reflecting how fully the address components such as street, city, state, and ZIP code have been validated against postal authority standards in enrollment systems.

address subtotaladdr_subtot

A partial aggregation of address-related records or transactions within a batch processing context, used in member enrollment and data governance workflows to validate record counts before finalizing address updates across healthcare information systems.

address system identifieraddr_sys_id

A unique system-generated key assigned to an address record within a healthcare data platform, enabling consistent cross-system reference and deduplication of address data across member enrollment, claims, provider directory, and care management applications.

address targetaddr_tgt

The intended recipient entity or system destination for an address record, identifying whether the address applies to a member, subscriber, dependent, or facility within enrollment and claims systems to ensure accurate correspondence routing.

address taxonomy codeaddr_tax_cd

A NUCC Health Care Provider Taxonomy code linked to a facility or service location address, classifying the type of healthcare service delivered at that site for use in provider directory management, network adequacy analysis, and claims routing.

address temperatureaddr_temp

A data quality indicator reflecting the recency and reliability of an address record, where recently verified addresses are considered active and deliverable versus stale records flagged for re-validation in member enrollment and provider directory maintenance workflows.

address termination dateaddr_term_dt

The date on which an address record becomes inactive for a member, patient, or facility in enrollment or provider directory systems, indicating when correspondence and claims communications should cease being directed to that location and a new address should be applied.

address timeaddr_tm

The specific time of day recorded for an address record, capturing when a location entry was logged or became effective. Used in member enrollment, provider directories, and patient demographic systems to maintain accurate temporal records of address data changes.

address timestampaddr_ts

The combined date and time value marking when an address record was created, modified, or became effective. Used in member enrollment, claims processing, and patient demographic systems to maintain a precise audit trail of location data updates across healthcare systems.

address titleaddr_ttl

The formal label or heading assigned to an address record, such as Home, Work, or Mailing, used to distinguish multiple address entries for a single member, patient, or entity within enrollment, billing, and care coordination systems.

address totaladdr_tot

The aggregate sum of address records associated with a member, patient, or entity within a healthcare data system. Used in member enrollment and demographic management to quantify the number of address entries maintained across active and historical records.

address total countaddr_tot_cnt

The cumulative number of address records associated with a specific member, patient, or entity. Used in member enrollment and demographic auditing to measure how many address entries exist, supporting data quality reviews and deduplication workflows.

address typeaddr_typ

A coded classification that identifies the category of an address record, such as residential, mailing, billing, or temporary. Used in member enrollment, claims adjudication, and care management to route correspondence and apply the correct address for each business purpose.

address unitaddr_unt

The apartment, suite, unit, or secondary identifier within a street address that further specifies the physical location of a member, patient, or facility. Used in member enrollment, claims billing, and provider directory systems to ensure accurate mail delivery and site identification.

address updated dateaddr_upd_dt

The calendar date on which an address record was most recently modified within the healthcare data system. Used in member enrollment, claims, and patient demographics to track data currency, support audits, and ensure correspondence is directed to the most current location on file.

PreviousPage 14 of 320Next