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 modified timeenc_mod_tm

The date and timestamp recording when the encounter record was most recently updated in the clinical or administrative system. Used for audit logging, data synchronization, change management tracking, and compliance purposes to maintain an accurate history of record modifications.

encounter nameenc_nm

Human-readable label or standardized display name assigned to a healthcare service interaction for identification within EHR and claims systems. Used in user interfaces, reporting dashboards, and data integration mappings to present encounter records in a consistent, interpretable format across healthcare data platforms.

encounter noteenc_nt

The free-text or structured annotation documenting clinical observations, assessments, and plans recorded during a patient encounter in EHR systems such as Epic or Cerner. Stored in clinical note tables and linked to encounter records via encounter identifiers, these notes are sourced for NLP pipelines, quality reporting, and clinical documentation improvement workflows.

encounter numberenc_nbr

The externally facing business identifier assigned to a patient encounter within hospital or clinic operational systems, distinct from internal surrogate keys. Used in EHR, claims, and billing systems to correlate records across revenue cycle management, EDI transactions, and downstream analytics integrations such as claim adjudication and remittance processing.

encounter onset dateenc_onset_dt

The date on which the patient's symptoms, condition, or illness first began, as documented during the clinical encounter. Used in diagnosis coding, chronic disease management, claims adjudication, and epidemiological tracking to establish the clinical timeline of a patient's presenting condition.

encounter oxygen saturationenc_o2sat

The peripheral oxygen saturation percentage measured via pulse oximetry during a clinical encounter, reflecting the proportion of oxygenated hemoglobin in the blood. Used as a critical vital sign in triage, respiratory assessments, inpatient monitoring, and chronic disease management documentation.

encounter paid amountenc_pd_amt

The total dollar amount remitted by a payer or patient toward the charges associated with a clinical encounter. Used in revenue cycle management, payment reconciliation, accounts receivable tracking, and financial reporting to reflect actual reimbursement received against billed charges.

encounter paid dateenc_pd_dt

The date on which payment was received and posted for charges associated with a clinical encounter. Used in revenue cycle management, cash flow analysis, payer performance monitoring, and accounts receivable aging reports to track the timeliness of reimbursement from insurers or patients.

encounter parentenc_prnt

The hierarchical reference linking a subordinate encounter record to its superior or originating encounter in EHR and claims data systems. Supports parent-child encounter relationships such as inpatient visits with associated ancillary services or outpatient referrals, enabling accurate episode-of-care grouping, cost attribution, and longitudinal patient journey analytics.

encounter percentenc_pct

Percentage value for encounter within Utilization processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

encounter periodenc_prd

The defined time span representing the start and end datetime of a healthcare service interaction as recorded in EHR and claims systems. Maps to the FHIR Encounter.period element and is used to calculate length of stay, determine claim date ranges, support concurrent encounter detection, and drive utilization management and authorization workflows.

encounter phoneenc_ph

The telephone contact number associated with a specific healthcare service encounter, capturing the facility, provider, or patient contact number recorded in EHR or practice management systems. Used in care coordination workflows, member outreach programs, and operational reporting to facilitate post-encounter follow-up and provider directory data validation.

encounter planenc_pln

The documented clinical treatment plan established by the provider during the encounter, outlining intended interventions, medications, referrals, or follow-up actions. A core component of SOAP-format clinical notes used to guide ongoing patient care and support care coordination across the care team.

encounter policy numberenc_pol_nbr

The insurance policy identifier associated with the patient's health coverage at the time of the clinical encounter. Used in claims submission, eligibility verification, prior authorization, and payment reconciliation to accurately link encounter services to the appropriate insurance contract and subscriber.

encounter preferred nameenc_pref_nm

The name by which the patient prefers to be addressed, as captured during encounter registration, which may differ from their legal name. Used to support patient-centered care, cultural sensitivity, and accurate communication across clinical documentation, scheduling, and patient engagement workflows.

encounter previousenc_prev

A reference linking a current encounter record to the most recent prior encounter for the same patient within EHR or care management systems. Supports longitudinal care tracking, readmission risk analysis, care gap identification, and chronological sequencing of patient events across episodes of care in clinical and claims data pipelines.

encounter priceenc_prc

The charged or contracted cost for services rendered during a clinical encounter, reflecting either the facility's standard fee schedule or a negotiated payer rate. Used in revenue cycle management, cost transparency reporting, patient estimates, and financial analytics to assess service-level pricing.

encounter primary indicatorenc_prim_ind

A flag designating whether the encounter, diagnosis, procedure, or associated record represents the primary or principal element among multiple linked records. Used in claims processing, clinical documentation prioritization, and reporting to distinguish the main reason for a visit from secondary or co-occurring conditions.

encounter priorityenc_prty

A coded value representing the clinical urgency or triage classification assigned to a healthcare service interaction, such as routine, urgent, or emergency, as recorded in EHR systems. Maps to FHIR Encounter.priority and is used in utilization management, ER throughput analytics, authorization processing, and care coordination prioritization workflows.

encounter procedure dateenc_proc_dt

The date on which a clinical procedure or surgical intervention was performed during or associated with a healthcare encounter. Used in claims adjudication, operative documentation, surgical scheduling, and outcomes reporting to establish the exact date of service for billing and clinical record accuracy.

PreviousPage 234 of 806Next