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 dateprob_dt

The calendar date on which an active health condition was first documented or last updated in the patient problem list within EHR systems such as Epic or Cerner. Used by data engineers to sequence clinical events, calculate condition duration, and support longitudinal patient health analytics.

problem datetimeprob_dttm

The combined date and timestamp recording when an active health condition was documented in EHR problem list tables. Captures hour and minute precision to support clinical event sequencing, audit trail requirements, and time-sensitive condition tracking across inpatient and ambulatory data pipelines.

problem dea numberprob_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician linked to a clinical problem entry. Relevant when controlled substance prescriptions are directly connected to a documented condition, supporting regulatory compliance, prescribing authority verification, and controlled substance monitoring.

problem death dateprob_death_dt

The recorded date of patient death associated with an active or chronic health condition in EHR and claims systems. Used by data engineers to close open problem list records, trigger enrollment termination workflows, and support mortality outcome analysis in population health and actuarial datasets.

problem deleted dateprob_del_dt

The date a health condition or diagnosis record was permanently deleted from the patient's problem list in the EHR. Distinguishes hard deletions from cancellations or inactivations, supporting audit trail integrity, data governance compliance, and historical reconciliation of problem list changes over time.

problem deleted indicatorprob_del_ind

A flag indicating that a health condition or diagnosis entry on the patient's problem list has been permanently deleted from the clinical record. Enables soft-delete logic in EHR systems, preserving audit trail data while excluding the condition from active clinical displays and reporting workflows.

problem descriptionprob_desc

The human-readable textual narrative describing an active health condition as documented in EHR problem list or claims encounter records. Maps to standardized clinical terminology such as SNOMED CT or ICD-10 and is used by data engineers for NLP processing, code validation, and clinical data normalization pipelines.

problem detailprob_dtl

Granular clinical attributes associated with an active health condition in EHR problem list or care management systems, including severity, body site, laterality, or clinical stage. Used by data engineers to enrich condition records beyond primary diagnosis codes for risk stratification and quality measure reporting.

problem discharge dateprob_dsch_dt

The inpatient discharge date associated with an active clinical problem or diagnosis in an EHR or care management system. Links episode-of-care endpoints to specific conditions, supporting post-acute care transitions, readmission risk calculations, and longitudinal condition episode analysis across clinical and claims data systems.

problem due dateprob_due_dt

The target date by which a clinical action, follow-up assessment, or intervention associated with a documented health condition is expected to be completed. Used in care management workflows to schedule reassessments, monitor chronic condition management timelines, and trigger alerts for overdue problem-related activities.

problem durationprob_dur

The length of time a patient has experienced or been diagnosed with a specific health condition documented on the problem list. Captures clinically reported or calculated onset-to-documentation intervals, supporting chronicity assessment, diagnostic reasoning, and population health analysis of condition burden over time.

problem emailprob_eml

The electronic mail address associated with a patient, provider, or care coordinator linked to an active health condition record in EHR or care management platforms. Used by data engineers to route automated condition-related alerts, care gap notifications, and patient outreach communications within integration workflows.

problem emergency indicatorprob_emerg_ind

A flag designating that a health condition on the patient's problem list requires immediate clinical attention or represents an acute emergency presentation. Used in EHR triage workflows and care prioritization systems to alert providers to high-acuity conditions requiring urgent intervention during patient encounters.

problem end dateprob_end_dt

The date on which an active health condition was resolved, inactivated, or removed from the patient problem list in EHR systems such as Epic, Cerner, or Athena. Used by data engineers to calculate condition duration, close open records, and filter active versus historical diagnoses in clinical analytics datasets.

problem end timeprob_end_tm

The precise timestamp recording when a clinical problem or health condition episode concluded or was marked as resolved in the EHR. Supports accurate calculation of condition duration, episode-of-care analytics, and longitudinal tracking of patient health status across problem list management workflows.

problem entered byprob_ent_by

The identifier of the staff member or clinical user who entered a health condition onto the patient's problem list, which may differ from the diagnosing clinician. Supports workflow auditing, data quality review, and accountability tracking for problem list documentation across clinical and administrative roles.

problem ethnicityprob_ethn

The patient's self-reported or documented ethnic background associated with a clinical problem record. Used in epidemiological analysis, health disparity research, and population health reporting to identify ethnic variation in disease prevalence, clinical outcomes, and treatment patterns for specific documented conditions.

problem expiration dateprob_exp_dt

The date after which a documented health condition record is no longer considered clinically valid or actionable within EHR or care management systems. Used by data engineers to purge stale problem list entries, enforce data retention policies, and maintain accurate active condition counts in population health platforms.

problem external identifierprob_ext_id

A unique identifier assigned by an external system, such as a referring facility, HIE, or interoperability platform, to reference a specific clinical problem or health condition. Enables cross-system problem list reconciliation, care coordination, and data exchange between disparate EHR and clinical information systems.

problem faxprob_fax

The facsimile number associated with a clinical entity, provider, or facility linked to a documented health condition on the patient's problem list. Used to facilitate secure transmission of condition-related clinical documentation, referral information, or care summaries to external providers involved in managing the specific problem.

PreviousPage 509 of 806Next