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,492 operations terms

address primary indicatoraddr_prim_ind

A flag designating whether a given address record is the primary location on file for a member, patient, or entity. Used in member enrollment and claims processing to determine which address to use for correspondence, billing statements, and explanation of benefits mailings.

address priorityaddr_prty

A ranking value that determines the order in which address records should be used when multiple addresses exist for a member, patient, or entity. Used in member enrollment and claims correspondence workflows to route communications to the most appropriate location on file.

address pulseaddr_pulse

A system-generated activity indicator associated with an address record, reflecting how recently or frequently the address has been accessed, updated, or verified. Used in data quality workflows to flag stale or inactive address records requiring outreach or validation.

address quantityaddr_qty

The count of address records associated with a member, patient, facility, or entity within a healthcare system. Used in member enrollment and data governance workflows to track how many distinct locations are on file and manage address deduplication or consolidation.

address raceaddr_race

A demographic attribute linked to an address record used in population health and social determinants of health analysis. Captures the racial or ethnic composition associated with a geographic location to support health equity reporting, care gap analysis, and community health initiatives.

address rateaddr_rt

The reimbursement or service rate applicable to a specific address or geographic location, used in claims adjudication and contract management. Reflects location-based fee schedules where payment amounts vary by region, facility type, or service area designation.

address ratingaddr_rtg

A quality or risk score assigned to an address record based on validation results, deliverability assessments, or geographic risk factors. Used in member enrollment and population health management to evaluate the reliability of address data and identify locations requiring verification.

address ratioaddr_ratio

A calculated proportional value derived from address-level data, such as the ratio of verified to unverified addresses within a population segment. Used in data quality reporting and member enrollment analytics to measure address accuracy rates across healthcare systems.

address reasonaddr_rsn

The explanation or justification for why an address record was added, modified, or flagged within a healthcare system. Used in member enrollment and audit workflows to document the business rationale behind address changes, such as returned mail, member request, or eligibility update.

address received dateaddr_rcvd_dt

The date on which an address record or address update was received and entered into a healthcare system. Used in member enrollment and correspondence tracking to establish a timeline for when location information became available for claims processing or eligibility verification.

address referenceaddr_ref

An external identifier or cross-reference code linking an address record to a related entity in another healthcare system, such as a claims platform, enrollment database, or provider directory. Used to maintain referential integrity across systems when sharing or reconciling location data.

address resolution dateaddr_resol_dt

The date on which an address discrepancy, undeliverable mail flag, or address verification issue was resolved. Used in member enrollment and outreach workflows to track how long address problems remained open and confirm when accurate location data was restored to the record.

address respirationaddr_resp

A data quality metric reflecting how frequently an address record is refreshed, validated, or updated within a healthcare system. Used in member enrollment and data governance workflows to monitor the active maintenance cycle of address records and flag those requiring re-verification.

address revisionaddr_rev

The version or iteration number of an address record, incremented each time the address is updated or corrected in a healthcare system. Used in member enrollment audit trails and change history tracking to maintain a versioned record of all modifications made to a physical location on file.

address riskaddr_rsk

A risk classification assigned to an address record based on factors such as geographic hazard zones, fraud indicators, high-cost service areas, or social vulnerability indices. Used in population health management and member enrollment to stratify members by location-based risk for targeted interventions.

address routeaddr_rte

The delivery route code assigned to a physical address, used by postal services and healthcare mail delivery systems to direct correspondence such as member insurance cards, explanation of benefits, and clinical communications to the correct location.

address scheduled dateaddr_sched_dt

The date on which an address record update or verification is scheduled to take effect in member enrollment or provider directory systems, supporting planned address transitions such as member relocation or facility moves.

address scheduled timeaddr_sched_tm

The specific time at which an address record change or verification is scheduled to be processed in member enrollment or provider directory systems, enabling precise coordination of address updates within daily batch processing workflows.

address scoreaddr_scr

A numeric quality or confidence rating assigned to an address record based on validation against postal databases such as USPS CASS certification, indicating the accuracy and deliverability of the address for member correspondence and claims processing.

address sequenceaddr_seq

A numeric value that defines the priority order when multiple addresses exist for a member, patient, or facility, determining which address is used first for mail delivery, claims correspondence, or emergency contact purposes in enrollment systems.

PreviousPage 13 of 325Next