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

complication full namecmpl_full_nm

The complete name of the patient or associated individual linked to a secondary adverse condition record, combining all name components. Used in clinical documentation, patient matching, and identity verification workflows to ensure accurate attribution of complication events within healthcare systems.

complication gendercmpl_gndr

Biological sex classification of the patient at the time a secondary adverse condition was documented. Used in clinical data analysis to identify sex-based risk patterns and treatment differences associated with post-procedure or disease-related complications.

complication glucosecmpl_gluc

Blood glucose measurement recorded in association with a secondary adverse condition or complication event. Critical for identifying metabolic contributors to complications such as surgical site infections, delayed healing, or diabetic crises documented during inpatient or outpatient encounters.

complication hemoglobincmpl_hgb

Hemoglobin concentration measured in relation to a documented secondary adverse condition. Used clinically to assess anemia, blood loss, or hematologic abnormalities that may have caused, contributed to, or resulted from a post-procedural or disease-associated complication.

complication history present illnesscmpl_hpi

Structured narrative describing the onset, progression, and clinical context of a secondary adverse condition as reported by the patient or clinician. Captures the chronological account of symptoms and contributing factors associated with the documented complication in the medical record.

complication keycmpl_key

Unique lookup reference value used to identify and retrieve a specific secondary adverse condition record within clinical or analytical data systems. Serves as the primary join key for linking complication data across clinical documentation, coding, and outcomes reporting tables.

complication labelcmpl_lbl

Human-readable display text used to describe or name a secondary adverse condition within clinical interfaces and reporting outputs. Provides a standardized descriptive identifier for the complication that supports clinical documentation, coding workflows, and patient safety reporting.

complication languagecmpl_lang

Preferred spoken or written language of the patient associated with a documented secondary adverse condition. Used to ensure appropriate communication, consent documentation, and clinical instructions are delivered in the patient's primary language during complication management and follow-up care.

complication last namecmpl_last_nm

Family surname of the patient associated with a documented secondary adverse condition. Used to identify and match the patient record to the complication event within clinical data systems, supporting accurate attribution of adverse outcomes during care delivery or post-encounter review.

complication legal namecmpl_legal_nm

Officially registered full legal name of the patient linked to a documented secondary adverse condition. Used for identity verification and record matching when reporting complications to regulatory bodies, quality programs, or payers requiring legally validated patient identifiers.

complication license numbercmpl_lic_nbr

Professional license identifier of the clinician responsible for documenting or managing a secondary adverse condition. Used in quality reporting and accountability workflows to attribute complication events to the licensed provider of record at the time of the adverse outcome.

complication marital statuscmpl_mar_sts

Legal or relationship status of the patient at the time a secondary adverse condition was recorded. Used in social determinants of health assessments and outcomes research to evaluate how social support structures may influence complication rates, recovery, and care plan adherence.

complication master identifiercmpl_mstr_id

Enterprise master identifier used to uniquely identify and cross-reference a secondary adverse condition across multiple clinical and administrative systems. Enables consistent tracking of complication records throughout the care continuum, including EHR, claims, and quality reporting platforms.

complication maximumcmpl_max

Upper boundary value for a clinical measurement or threshold associated with a secondary adverse condition. Used to define acceptable or critical ranges in complication monitoring protocols, triggering clinical alerts or escalation pathways when observed values exceed established safety limits.

complication middle namecmpl_mid_nm

Middle name or initial of the patient associated with a documented secondary adverse condition. Supports accurate patient identity matching and disambiguation when linking complication records to the correct individual across clinical, billing, and quality reporting data systems.

complication minimumcmpl_min

Lower boundary value for a clinical measurement or threshold associated with a secondary adverse condition. Used in complication surveillance and monitoring protocols to define the acceptable floor for clinical indicators, flagging abnormal values that may signal deterioration or emerging adverse events.

complication mobilecmpl_mob

Mobile phone contact number for the patient associated with a documented secondary adverse condition. Used to facilitate outreach for follow-up care, complication monitoring, appointment scheduling, and patient notification related to the management of the identified adverse condition.

complication modified bycmpl_mod_by

Username or system identifier of the individual or process that last updated a secondary adverse condition record. Used in audit trail documentation to maintain data integrity, support compliance reviews, and track clinician or administrative changes to complication records over time.

complication modified timecmpl_mod_tm

Timestamp indicating when a secondary adverse condition record was most recently updated in the clinical or administrative system. Used for audit logging, data lineage tracking, and identifying the most current version of a complication record during quality review and reporting processes.

complication onset datecmpl_onset_dt

Calendar date on which the signs or symptoms of a secondary adverse condition were first observed or reported. Used clinically and in quality analytics to establish complication timelines, assess proximity to procedures or treatments, and support root cause analysis of adverse outcomes.

PreviousPage 109 of 806Next