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

problem riskprob_rsk

A clinician-assigned or algorithmically calculated risk level indicating the potential severity or complication likelihood of a patient's documented health condition. Used in EHR and care management systems to prioritize interventions, allocate resources, and support population health risk stratification.

problem routeprob_rte

Identifies the route of administration or clinical pathway associated with treating an active health condition documented in the patient problem list. Used in EHR systems to link treatment delivery methods to specific diagnoses for clinical decision support and care coordination.

problem scoreprob_scr

Calculated numeric rating assigned to an active health condition in EHR or risk stratification systems, reflecting clinical severity or complexity. Used in population health management platforms and value-based care programs to prioritize patient outreach, allocate resources, and support risk adjustment models.

problem sequenceprob_seq

Ordering number defining the positional rank of an active health condition within a patient's problem list in EHR systems. Used in Epic, Cerner, and clinical data integration pipelines to maintain consistent problem list ordering across encounters, supporting structured clinical documentation and downstream analytics.

problem severityprob_sev

Coded or descriptive indicator of clinical seriousness assigned to an active health condition in EHR problem lists, such as mild, moderate, or severe. Used in clinical documentation systems and risk stratification platforms to guide treatment intensity decisions, care plan development, and quality measure reporting.

problem sexprob_sex

Records the biological sex associated with an active health condition on the patient problem list, used to apply sex-specific clinical guidelines, screening criteria, and diagnostic logic. Supports population health analytics and clinical decision support rules tied to gender-specific diagnoses.

problem sourceprob_src

Origin reference identifying the system, clinician, or encounter that generated an active health condition entry in an EHR or clinical data repository. Used in data integration pipelines and Master Patient Index systems to establish data provenance, support deduplication logic, and maintain audit trails across source systems.

problem start dateprob_start_dt

Date value marking the clinical onset or first documentation of an active health condition in an EHR problem list or claims record. Used in longitudinal patient data platforms to calculate condition duration, support chronic disease tracking, and align with ICD coding requirements for onset-based reporting.

problem start timeprob_start_tm

Captures the precise time of day when an active health condition was first identified or recorded on the patient problem list. Complements the problem start date to provide full timestamp precision for acute conditions, emergency events, or inpatient diagnoses requiring time-level clinical documentation.

problem stateprob_st

Records the workflow or clinical state of an active health condition on the patient problem list, such as active, inactive, resolved, or chronic. Used in EHR systems to filter and display relevant diagnoses during clinical encounters and to drive care management and quality reporting workflows.

problem statusprob_sts

Current state value indicating whether an active health condition is active, inactive, resolved, or chronic within EHR problem list records. Used in clinical data systems and claims processing platforms to filter relevant diagnoses for encounter documentation, care planning, and quality measure calculation workflows.

problem strengthprob_str

Captures the medication strength or dosage concentration associated with an active health condition on the patient problem list. Used to link pharmaceutical treatment details to specific diagnoses, supporting medication reconciliation, chronic disease management, and clinical decision support in EHR systems.

problem subtotalprob_subtot

Represents a partial aggregated count or value associated with an active health condition on the patient problem list, typically used in reporting and analytics contexts. Supports summarization of condition-related encounters, episodes, or clinical events within defined patient population segments or time periods.

problem surgery dateprob_surg_dt

Records the date on which a surgical procedure was performed in direct relation to an active health condition documented on the patient problem list. Used in EHR and clinical data warehouses to link operative interventions to specific diagnoses for longitudinal care tracking and surgical outcome reporting.

problem targetprob_tgt

Destination reference identifying the clinical goal, system endpoint, or linked record associated with an active health condition in EHR and care management platforms. Used in care plan management systems and FHIR-based integrations to map conditions to treatment targets, supporting goal-directed care and interoperability workflows.

problem taxonomy codeprob_tax_cd

Stores a structured classification code used to categorize an active health condition on the patient problem list within a recognized clinical taxonomy such as ICD, SNOMED CT, or a custom coding schema. Enables standardized problem list reporting, interoperability, and cross-system clinical data exchange.

problem temperatureprob_temp

Records the patient body temperature measurement documented in association with an active health condition on the problem list. Used in clinical workflows to capture vital sign data linked to specific diagnoses, supporting fever monitoring, infection tracking, and condition severity assessment in EHR systems.

problem termination dateprob_term_dt

Records the date on which an active health condition was resolved, inactivated, or removed from the patient problem list. Used in EHR and clinical data warehouses to track the full episode duration of a diagnosis, supporting longitudinal care analysis, quality reporting, and chronic disease management workflows.

problem timeprob_tm

Time-of-day value recording when an active health condition was documented or observed within an EHR encounter record. Used in clinical event sequencing within hospital information systems and data warehouses to establish precise clinical timelines, supporting adverse event analysis and care coordination reporting.

problem timestampprob_ts

Combined date and time value capturing the precise moment an active health condition was recorded or updated in an EHR or clinical data system. Used in audit logging, event sequencing, and data integration pipelines to establish chronological provenance for condition records across source and target systems.

PreviousPage 513 of 806Next