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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

ct dea numberct_dea_nbr

The Drug Enforcement Administration registration number associated with a contact record in the healthcare system. Used to validate and track controlled substance prescribing authority, linking the contact entity to their DEA-issued identifier for regulatory compliance and pharmacy workflows.

ct death datect_death_dt

The recorded date of death for a contact person within the healthcare system, such as a member, patient, or dependent. Used in enrollment, eligibility, and claims processing to terminate coverage, close records, and ensure accurate demographic data across downstream systems.

ct deleted datect_del_dt

The date on which a contact record was logically deleted or inactivated within the healthcare data system. Used in audit trails and data governance workflows to track when a record was removed from active use, supporting data retention policies and historical reporting.

ct deleted indicatorct_del_ind

A flag indicating whether a contact record has been logically deleted or inactivated in the healthcare system. Used in data management workflows to filter active versus inactive records in reporting, eligibility processing, and system integrations without physically removing the underlying data.

ct descriptionct_desc

A human-readable text description associated with a contact record in the healthcare system. Used to provide context, clarify the nature or purpose of the contact entry, and support display in user interfaces, administrative reports, and data integration workflows.

ct detailct_dtl

Supplemental or granular information associated with a contact record in the healthcare system. Captures additional attributes or notes beyond standard fields, supporting administrative workflows, care coordination, and detailed reporting requirements across clinical and operational data systems.

ct discharge datect_dsch_dt

The date on which a patient associated with a contact record was discharged from an inpatient or facility-based care setting. Used in claims adjudication, utilization management, and care management workflows to calculate length of stay and coordinate post-discharge follow-up.

ct due datect_due_dt

The date by which a specific action, payment, or task associated with a contact record is expected to be completed. Used in billing, accounts receivable, and care management workflows to track deadlines, trigger follow-up activities, and monitor compliance with scheduled obligations.

ct durationct_dur

The length of time associated with a contact-related event or activity in the healthcare system, such as a care episode, authorization period, or enrollment span. Used in utilization management, claims processing, and reporting to measure and analyze time-based healthcare interactions.

ct emailct_eml

The electronic mail address associated with a contact record in the healthcare system. Used to facilitate secure communications for appointment reminders, member outreach, care coordination, and administrative correspondence across health plan, clinical, and member services workflows.

ct emergency indicatorct_emerg_ind

A flag designating whether a contact record or associated healthcare event is classified as an emergency. Used in claims adjudication, utilization management, and clinical workflows to apply appropriate processing rules, reimbursement rates, and regulatory requirements for emergency care situations.

ct end datect_end_dt

The date on which a contact record's associated period, relationship, or activity concludes within the healthcare system. Used in eligibility, enrollment, authorization, and contract management workflows to define the boundary of a valid timeframe for a given contact-related entity.

ct end timect_end_tm

The specific time at which a contact-related event or activity concludes in the healthcare system. Used alongside end date in scheduling, encounter documentation, authorization, and utilization management workflows to capture precise temporal boundaries of healthcare interactions.

ct entered byct_ent_by

The identifier of the user or system that created or submitted a contact record in the healthcare data system. Used in audit logging, data governance, and quality assurance workflows to maintain accountability, support record tracing, and identify data entry sources for compliance purposes.

ct ethnicityct_ethn

The ethnicity classification associated with a contact person, such as a member or patient, in the healthcare system. Used in population health analytics, health equity reporting, regulatory submissions, and care management programs to support demographic analysis and culturally competent care delivery.

ct expiration datect_exp_dt

The date on which a contact record or an associated credential, authorization, or agreement becomes invalid within the healthcare system. Used in eligibility verification, provider credentialing, contract management, and compliance workflows to enforce timely renewals and prevent use of expired information.

ct external identifierct_ext_id

A reference identifier assigned to a contact record by an external system, such as a trading partner, vendor, or source platform. Used in data integration, interoperability, and reconciliation workflows to cross-reference records across disparate healthcare systems and maintain consistent entity linkage.

ct faxct_fax

The facsimile telephone number associated with a contact record in the healthcare system. Used to facilitate document transmission for clinical referrals, prior authorizations, medical records requests, and administrative communications between health plans, providers, and member services teams.

ct feect_fee

The monetary charge associated with a service or transaction linked to a contact record in the healthcare system. Used in billing, claims adjudication, and financial reporting workflows to capture the cost of care, administrative fees, or other charges attributed to the contact entity.

ct first namect_first_nm

The given or first name of an individual associated with a contact record in the healthcare system, such as a member, patient, or dependent. Used in identity verification, member communications, eligibility lookups, and demographic reporting across health plan and clinical data workflows.

PreviousPage 145 of 806Next