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 oxygen saturationcmpl_o2sat

Peripheral blood oxygen saturation percentage recorded in association with a secondary adverse condition. Used to assess respiratory status and tissue oxygenation during complication events such as post-operative respiratory distress, sepsis, or cardiac complications requiring immediate clinical intervention.

complication paid amountcmpl_pd_amt

The dollar amount reimbursed by a payer for treatment of a secondary adverse condition arising during or after a primary medical event. Captured on claims to support cost tracking, financial reconciliation, and quality reporting for complication-related care episodes.

complication paid datecmpl_pd_dt

The calendar date on which payment was issued by the payer for a claim associated with treating a secondary adverse condition. Used in claims adjudication workflows to reconcile payment timelines and monitor reimbursement cycles for complication-related services.

complication preferred namecmpl_pref_nm

The standardized display label assigned to a secondary adverse condition for use in clinical documentation, patient records, and reporting interfaces. Ensures consistent human-readable identification of complications across EHR systems, clinical data warehouses, and care coordination platforms.

complication pricecmpl_prc

The billed or contracted cost associated with treating a secondary adverse condition, reflecting either the provider's charge or the negotiated rate. Used in claims and revenue cycle management to support pricing analysis, cost benchmarking, and financial reporting for complication-related encounters.

complication procedure datecmpl_proc_dt

The calendar date on which a clinical procedure was performed to treat or address a secondary adverse condition. Captured in claims and clinical records to establish treatment timelines, support quality audits, and enable outcomes analysis for complication-related interventions.

complication pulsecmpl_pulse

The patient's heart rate measurement, expressed in beats per minute, recorded in association with a secondary adverse condition. Used in clinical documentation and vital sign tracking to monitor patient stability and assess the physiological impact of complications during an encounter.

complication racecmpl_race

The patient's self-reported or recorded racial classification captured in the context of a secondary adverse condition. Used in clinical and population health data to support health equity analysis, disparity reporting, and demographic stratification of complication outcomes across patient cohorts.

complication ratingcmpl_rtg

A scored or categorical assessment indicating the severity or clinical significance of a secondary adverse condition. Used in quality measurement, risk stratification, and utilization review workflows to prioritize interventions and benchmark complication outcomes across facilities or care episodes.

complication ratiocmpl_ratio

A calculated proportional value comparing the occurrence or cost of secondary adverse conditions relative to a defined baseline, such as total encounters or procedures. Used in quality analytics and outcomes reporting to evaluate complication rates and support performance benchmarking across care settings.

complication received datecmpl_rcvd_dt

The calendar date on which documentation or a claim related to a secondary adverse condition was received by the payer or processing system. Used in claims intake workflows to track submission timeliness, measure adjudication lag, and support audit trails for complication-related transactions.

complication resolution datecmpl_resol_dt

The calendar date on which a secondary adverse condition was clinically resolved or closed in the patient's record. Used in clinical documentation and outcomes tracking to measure complication duration, evaluate treatment effectiveness, and support longitudinal care management reporting.

complication respirationcmpl_resp

The patient's respiratory rate, expressed in breaths per minute, recorded in association with a secondary adverse condition. Captured as a vital sign in clinical documentation to monitor pulmonary status, assess patient deterioration, and track physiological response during complication management.

complication revisioncmpl_rev

The version or iteration number indicating updates made to a secondary adverse condition record in a clinical or claims system. Supports audit trail maintenance, version control, and data integrity tracking when complication documentation is amended following initial submission or entry.

complication riskcmpl_rsk

A scored or categorical measure indicating the likelihood or potential severity of a secondary adverse condition occurring in a patient. Used in clinical decision support, care management, and quality reporting to stratify patients, guide preventive interventions, and benchmark complication vulnerability across populations.

complication routecmpl_rte

The designated pathway by which a treatment, medication, or intervention is administered in response to a secondary adverse condition, such as oral, intravenous, or topical. Captured in clinical records and pharmacy data to ensure accurate medication administration documentation and treatment protocol adherence.

complication sexcmpl_sex

The patient's biological sex recorded in association with a secondary adverse condition. Used in clinical documentation, epidemiological analysis, and health equity reporting to stratify complication rates and outcomes by sex, supporting population health management and clinical quality improvement initiatives.

complication start timecmpl_start_tm

The specific time of day at which a secondary adverse condition was first identified or documented during a clinical encounter. Captured in EHR and clinical event records to establish precise onset timing, support incident reporting, and enable temporal analysis of complication patterns across care episodes.

complication statecmpl_st

The U.S. state or territory associated with the location where a secondary adverse condition was identified or treated. Used in geographic analysis, regulatory reporting, and population health data to enable regional benchmarking and state-level quality measurement of complication incidence and outcomes.

complication strengthcmpl_str

The concentration or potency of a medication or therapeutic agent administered in response to a secondary adverse condition, typically expressed in mg or units per dose. Captured in pharmacy and clinical records to ensure accurate dosing documentation and support medication safety review.

PreviousPage 110 of 806Next