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

system emergency indicatorsys_emerg_ind

A flag identifying whether an encounter or patient event processed through the source clinical system was classified as an emergency, used in claims and utilization data to distinguish emergency from elective care for quality reporting, reimbursement, and resource planning purposes.

system history present illnesssys_hpi

The narrative description of a patient's current condition and symptom progression as documented within the source clinical system, forming a core component of the clinical note that contextualizes the chief complaint and guides diagnostic and treatment decision-making during the encounter.

system labelsys_lbl

The human-readable display name or descriptive text assigned to an element within a clinical or health information system, used to identify records, fields, or interface components in a way that is meaningful to clinicians and administrative staff during documentation and data review.

system procedure datesys_proc_dt

The date on which a clinical procedure was performed as recorded by the source health information system, used in encounter and claims data to establish the timing of diagnostic or therapeutic interventions for billing accuracy, clinical sequencing, and outcomes measurement.

system rangesys_rng

The defined minimum and maximum acceptable values for a clinical measurement or result as established within the source health information system, used to flag abnormal findings, validate data integrity, and support clinical decision support rules across diagnostic and monitoring workflows.

system resultsys_rslt

The outcome or measured value returned by a clinical test, procedure, or diagnostic process as recorded in the source health information system, used in laboratory, radiology, and clinical data workflows to document findings and inform subsequent care decisions and documentation.

system surgery datesys_surg_dt

The date on which a surgical procedure was performed as captured by the source clinical system, used in operative and claims data to establish procedure timing for reimbursement processing, surgical outcomes tracking, post-operative care scheduling, and quality metric reporting.

task active indicatortsk_actv_ind

A binary flag indicating whether a clinical or administrative task assignment is currently active and pending completion, used in care management and workflow systems to filter open work items from closed or cancelled tasks and support staff workload monitoring and prioritization.

task active statustsk_actv_sts

The current lifecycle state of a clinical or administrative task assignment, such as open, in-progress, on-hold, or completed, used in care coordination and workflow management systems to track task progression, assign accountability, and report on operational throughput and bottlenecks.

task admission datetsk_admn_dt

The inpatient admission date associated with a clinical or administrative task assignment, used in care management and utilization workflows to link task activities to a specific inpatient encounter, supporting case management coordination, length-of-stay monitoring, and discharge planning activities.

task discharge datetsk_dsch_dt

The inpatient discharge date linked to a clinical or administrative task assignment, used in care management workflows to associate task completion timelines with patient discharge events, supporting transitions-of-care planning, post-discharge follow-up scheduling, and utilization management reporting.

task emergency indicatortsk_emerg_ind

Flag identifying whether a clinical workflow task requires immediate or urgent attention. Used in care management and clinical operations systems to prioritize work queues, trigger escalation protocols, and ensure time-sensitive tasks receive expedited handling by appropriate staff.

task history present illnesstsk_hpi

Narrative text field capturing the chronological description of a patient's current condition as documented within a clinical workflow task. Records symptom onset, progression, and relevant history to provide clinical context for task assignees managing care coordination or follow-up activities.

task instructiontsk_instr

Directional guidance text associated with a specific clinical or administrative workflow task. Contains step-by-step directions, protocols, or special handling requirements that inform the assigned staff member how to complete the task accurately within care management or operational systems.

task labeltsk_lbl

Human-readable display text used to identify and categorize a clinical or administrative workflow task within care management systems. Provides a concise, descriptive title that appears in work queues, dashboards, and reports to help staff quickly identify the nature and purpose of assigned tasks.

task notetsk_nt

Free-text annotation field attached to a clinical or administrative workflow task, capturing supplemental information, status updates, or communication between staff members. Used in care management systems to document task progress, exceptions, or context that falls outside structured data fields.

task procedure datetsk_proc_dt

Date on which a clinical procedure associated with a workflow task was performed or is scheduled to be performed. Used in care coordination and utilization management systems to track procedure timelines, ensure timely follow-up, and align task completion with clinical event sequences.

task rangetsk_rng

Defines the acceptable minimum and maximum value boundaries for a measurable element associated with a clinical workflow task, such as a lab result or vital sign threshold. Used in care management systems to flag out-of-range findings and trigger appropriate clinical review or escalation actions.

task resulttsk_rslt

Recorded outcome or finding associated with a completed clinical workflow task, such as a diagnostic result, assessment conclusion, or action resolution. Used in care management and clinical operations systems to document task completion status and support downstream clinical decision-making and reporting.

task surgery datetsk_surg_dt

Date on which a surgical procedure linked to a clinical workflow task was performed or is scheduled. Used in care coordination, utilization management, and surgical scheduling systems to track operative event timelines, coordinate pre- and post-operative tasks, and ensure appropriate follow-up care assignments.

PreviousPage 712 of 806Next