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

encounter created byenc_crtd_by

The unique identifier of the system user or clinical staff member who initially created the encounter record in the healthcare information system. Used in audit trails to establish accountability, support compliance reviews, and trace the origin of encounter documentation for quality and legal purposes.

encounter created dateenc_crtd_dt

System-generated timestamp recording when a healthcare service interaction record was first created in the EHR or claims platform. Used for audit trail maintenance, data lineage tracking, workflow sequencing, and identifying processing lag between service delivery and administrative record generation in payer and provider systems.

encounter created timeenc_crtd_tm

The precise timestamp recording when an encounter record was first entered into the healthcare information system. Used in audit logging, workflow sequencing, and data integrity validation to establish the chronological origin of clinical documentation relative to the actual date and time of service.

encounter creatinineenc_cr

The serum or urine creatinine value measured during a patient encounter, serving as a key biomarker for assessing kidney function and detecting renal impairment. Stored in clinical data systems to support chronic kidney disease monitoring, medication dosing decisions, and longitudinal lab trend analysis.

encounter currentenc_curr

Status indicator or flag identifying whether a healthcare service interaction record represents the most recent or active encounter for a patient within an EHR or claims system. Used in longitudinal care tracking, member attribution models, and clinical decision support workflows to ensure current data is prioritized over historical records.

encounter dateenc_dt

Business date representing when a healthcare service interaction occurred within Claims processing systems. Used in EHR, claims adjudication, and PBM platforms for reporting, audit trails, revenue cycle management, and downstream analytics integrations.

encounter datetimeenc_dttm

Combined date and time timestamp capturing the precise moment a healthcare service interaction began or was recorded. Used in EHR and claims systems to sequence clinical events, resolve duplicate encounters, and support real-time integrations with downstream analytics platforms.

encounter dea numberenc_dea_nbr

The Drug Enforcement Administration registration number associated with the prescribing clinician involved in a patient encounter. Used in controlled substance prescribing workflows and pharmacy records to verify prescriber authorization and support regulatory compliance and drug diversion monitoring.

encounter death dateenc_death_dt

The recorded date of patient death associated with a specific healthcare service interaction. Used in EHR, claims, and member enrollment systems to trigger eligibility terminations, finalize claims adjudication, and support mortality reporting and analytics workflows.

encounter deductible amountenc_ded_amt

The portion of an encounter's allowed charges applied toward the patient's annual deductible before insurance coverage activates. Tracked in claims adjudication systems to accurately calculate patient financial liability and coordinate benefits across multiple payers or plan year accumulation periods.

encounter deleted dateenc_del_dt

The date on which an encounter record was marked as deleted or voided within the healthcare information system. Retained for audit trail and compliance purposes to document when erroneous, duplicate, or invalid encounter records were removed from active reporting and billing workflows.

encounter deleted indicatorenc_del_ind

A flag denoting that an encounter record has been logically removed from active use within the healthcare information system without physical deletion. Enables data integrity controls by preserving historical records for auditing and compliance while excluding voided encounters from clinical reporting and claims processing.

encounter descriptionenc_desc

Free-text or standardized narrative describing the nature, purpose, or type of a healthcare service interaction. Used in EHR and claims systems to supplement coded data such as ICD or CPT codes, supporting clinical documentation, billing workflows, and encounter classification in analytics platforms.

encounter detailenc_dtl

Granular line-level or supplemental information associated with a healthcare service interaction, including procedure details, diagnoses, and service units. Used in claims, EHR, and utilization management systems to support adjudication, auditing, and detailed downstream reporting and analytics.

encounter discharge dateenc_dsch_dt

The date on which a patient was formally released from an inpatient facility following a healthcare service interaction. Used in claims, EHR, and utilization management systems to calculate length of stay, trigger post-discharge workflows, and support DRG-based reimbursement processing.

encounter due dateenc_due_dt

The date by which patient or payer payment for services rendered during an encounter is expected, as established by billing terms or plan contractual agreements. Used in accounts receivable workflows to monitor outstanding balances, trigger payment reminders, and manage revenue cycle performance metrics.

encounter durationenc_dur

The total elapsed time from the start to the end of a patient encounter, typically measured in minutes. Used in clinical productivity analysis, provider scheduling optimization, and care quality reporting to evaluate visit efficiency, resource allocation, and compliance with care delivery standards.

encounter effectiveenc_eff

Indicator or attribute denoting whether a healthcare service interaction is currently active and valid within the processing system. Used in EHR, claims, and member enrollment platforms to control record applicability during adjudication, reporting periods, and downstream data integration workflows.

encounter effective dateenc_eff_dt

The date on which a healthcare service encounter record becomes valid and applicable for processing within claims, EHR, or member enrollment systems. Used to establish temporal boundaries for adjudication, eligibility verification, benefit application, and historical reporting in analytics pipelines.

encounter emailenc_eml

Electronic mail address associated with a healthcare service interaction, typically linked to the patient, provider, or facility contact for that encounter. Used in EHR and patient engagement systems to support appointment confirmations, care coordination communications, and contact record management in data pipelines.

PreviousPage 231 of 806Next