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

standard emailstd_eml

The normalized electronic mail address associated with a contact, system notification recipient, or entity linked to a reference standard record in a healthcare data system. Used in administrative workflows, regulatory correspondence, and health information exchange to facilitate communication related to guideline updates or compliance requirements.

standard end datestd_end_dt

The date on which a reference standard, coding guideline, or payer policy is no longer active or applicable within a healthcare data system. Used in claims adjudication and benefit administration to determine the validity period of a standard, ensuring correct version application for clinical and financial transactions.

standard end timestd_end_tm

The precise time at which a reference standard, guideline, or clinical protocol ceases to be active within a healthcare data system. Used alongside the end date to support exact validity period tracking in time-sensitive claims processing, clinical scheduling, and health plan policy administration workflows.

standard entered bystd_ent_by

The username or identifier of the individual who manually entered or submitted a reference standard or guideline record into the healthcare data system. Used in data governance and audit trail workflows to maintain accountability for data entry accuracy in clinical coding systems, claims platforms, and health information repositories.

standard ethnicitystd_ethn

The standardized ethnicity classification code or value associated with a patient or member record, normalized to a recognized coding framework such as OMB or CDC standards. Used in member enrollment, clinical analytics, and population health reporting to support health equity analysis, disparity identification, and regulatory compliance.

standard expiration datestd_exp_dt

The date on which a clinical, regulatory, or operational standard ceases to be valid or enforceable. Used in healthcare data systems to manage versioning of coding standards, clinical guidelines, and reimbursement policies, ensuring outdated rules are retired from active processing.

standard external identifierstd_ext_id

A reference code or identifier assigned by an external system, body, or trading partner to uniquely identify a clinical or operational standard. Enables cross-system reconciliation of standards such as ICD, CPT, or SNOMED codes across payers, providers, and health information exchanges.

standard faxstd_fax

The normalized or standardized facsimile number associated with a contact entity such as a facility, health plan, or administrative office. Used in healthcare data management to ensure consistent formatting of fax numbers for routing referrals, authorizations, and claims correspondence.

standard feestd_fee

The established or benchmark charge amount associated with a healthcare service, procedure, or administrative transaction. Used in claims processing and reimbursement workflows to compare billed amounts against contracted rates, fee schedules, or Medicare-published allowable amounts.

standard first namestd_first_nm

The normalized given name of an individual such as a member, patient, or credentialed clinician, formatted according to data standardization rules. Used in member enrollment, claims adjudication, and identity matching to ensure consistent name representation across healthcare systems.

standard flagstd_flg

A binary indicator that designates whether a record, code, or transaction conforms to an established healthcare standard or meets a specific processing criterion. Used in claims, enrollment, and clinical data workflows to trigger downstream logic or exception handling based on compliance status.

standard full namestd_full_nm

The complete normalized name of an individual or entity, combining all name components such as first, middle, and last name into a single standardized field. Used in member enrollment, provider credentialing, and claims processing to support identity verification and record matching.

standard genderstd_gndr

The normalized sex or gender classification of a member, patient, or enrollee, coded according to standard value sets such as HL7 administrative gender codes. Used in member enrollment, claims adjudication, and clinical analytics to ensure consistent demographic representation across healthcare data systems.

standard glucosestd_gluc

The reference or benchmark blood glucose measurement used to evaluate a patient's result against established clinical thresholds, such as fasting glucose normal ranges or HbA1c targets. Used in chronic disease management programs, HEDIS quality measures, and lab result normalization workflows.

standard group numberstd_grp_nbr

The normalized identifier assigned to an employer group or insurance coverage group within a health plan. Used in member enrollment and claims processing to link individual members to their sponsoring group contract, enabling benefit adjudication, reporting, and premium billing at the group level.

standard hemoglobinstd_hgb

The reference or benchmark hemoglobin measurement used to assess a patient's lab result against clinically established normal ranges or disease management thresholds. Used in chronic condition monitoring, HEDIS quality reporting, and lab data normalization to standardize values across clinical and claims data systems.

standard identifierstd_id

The primary normalized key used to uniquely identify a record such as a member, claim, provider, or code set entry within a healthcare data system. Ensures consistent referencing across enrollment, claims, clinical, and administrative domains and supports data integration across trading partner systems.

standard indexstd_idx

A numeric position or ranking value assigned to a record within an ordered set of healthcare standards, code lists, or clinical guidelines. Used in data processing pipelines and reference table management to control sequencing, priority ordering, or lookup resolution across healthcare information systems.

standard indicatorstd_ind

A coded or Boolean value that signals whether a specific condition, status, or compliance criterion is met for a healthcare record or transaction. Used in claims adjudication, quality reporting, and enrollment processing to drive rule-based logic and flag records requiring special handling or review.

standard keystd_key

A normalized lookup or reference value used to join or retrieve related records within healthcare data systems. Serves as a consistent linking attribute across claims, enrollment, clinical, and administrative tables, enabling accurate data integration and reporting across payer, provider, and health information exchange environments.

PreviousPage 244 of 325Next