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

schedule surgery datesched_surg_dt

The prospectively planned date on which a surgical procedure is scheduled to be performed for a patient, recorded during surgical booking and pre-operative planning workflows. Used to coordinate operating room resources, anesthesia staffing, pre-operative testing timelines, and insurance authorization prior to the operative event.

sensitivity active indicatorsens_actv_ind

A binary flag indicating whether a recorded patient sensitivity, allergy, or adverse reaction to a substance is currently active and clinically relevant. A positive value triggers clinical decision support alerts during medication ordering and care planning, while an inactive status indicates the sensitivity has been resolved, refuted, or entered in error.

sensitivity active statussens_actv_sts

The current clinical status of a patient's recorded sensitivity or allergy to a substance, indicating whether the reaction is active, inactive, resolved, or entered in error. This status drives allergy alert behavior in medication ordering systems and supports accurate communication of patient safety information across care settings.

sensitivity admission datesens_admn_dt

The date on which a patient was admitted to a care facility at the time a sensitivity, allergy, or adverse substance reaction was first documented or identified. Used to establish a clinical timeline for the sensitivity record and correlate the onset of reaction documentation with the associated inpatient or emergency encounter.

sensitivity agesens_age

The patient's age in years at the time a sensitivity, allergy, or adverse reaction to a substance was first identified or documented in the clinical record. Used to support epidemiological analysis, age-related allergy pattern reporting, and clinical context when reviewing a patient's longitudinal sensitivity history.

sensitivity allowed amountsens_alwd_amt

The maximum reimbursable dollar amount approved by a payer for services rendered in connection with the diagnosis or treatment of a documented patient sensitivity or allergic reaction. Used in claims adjudication and remittance processing to determine the contractually allowable payment for sensitivity-related clinical encounters.

sensitivity amountsens_amt

The monetary value associated with a clinical or administrative transaction related to a documented patient sensitivity or allergic reaction, such as the billed charge or cost of treatment for an adverse substance reaction. Used in financial reporting and claims processing to quantify the economic impact of sensitivity-related care events.

sensitivity approved bysens_appr_by

The identifier or name of the clinician, pharmacist, or authorized user who reviewed and approved the documentation of a patient sensitivity, allergy, or adverse substance reaction in the clinical record. Used to establish accountability, support audit trails, and meet clinical documentation standards for allergy record validation.

sensitivity arrival timesens_arrv_tm

The recorded time at which a patient arrived at a care setting during an encounter where a sensitivity, allergy, or adverse substance reaction was documented or first identified. Used to establish the precise clinical timeline for sensitivity onset documentation and correlate reaction events with patient arrival data.

sensitivity arrived datesens_arrv_dt

The date on which a patient arrived at a clinical facility during the encounter in which a sensitivity, allergy, or adverse reaction to a substance was first identified or recorded. Used to anchor the sensitivity documentation to a specific care event and support longitudinal allergy history tracking across clinical encounters.

sensitivity assessmentsens_asmt

The structured clinical evaluation documenting a patient's reactivity to a specific substance, drug, or allergen. Captures clinician findings including reaction severity, exposure history, and diagnostic conclusions recorded in the allergy and intolerance module of the EHR.

sensitivity balancesens_bal

The remaining outstanding amount owed on a billing transaction associated with a patient's sensitivity or allergy-related clinical encounter. Tracks unpaid charges after payments and adjustments are applied within healthcare revenue cycle management systems.

sensitivity billed amountsens_bill_amt

The total dollar amount invoiced to a payer or patient for clinical services rendered in relation to a sensitivity evaluation or allergy-related encounter. Represents the gross charge before insurance adjustments, contractual write-offs, or patient payments are applied.

sensitivity birth datesens_birth_dt

The recorded date of birth of the patient associated with a sensitivity or allergy record. Used to validate patient identity, calculate age-appropriate reaction thresholds, and ensure accurate matching of sensitivity data to the correct individual across clinical systems.

sensitivity blood pressuresens_bp

The systolic and diastolic arterial pressure measurement captured during a sensitivity-related clinical encounter or allergic reaction assessment. Used to monitor hemodynamic response to allergen exposure, particularly in cases of anaphylaxis or severe hypersensitivity reactions.

sensitivity cancelled datesens_cncl_dt

The date on which a previously documented sensitivity or allergy record was cancelled, inactivated, or determined to be entered in error. Used in clinical data systems to maintain an accurate audit trail of allergy record lifecycle changes and support patient safety workflows.

sensitivity categorysens_cat

The high-level classification grouping assigned to a patient's sensitivity or adverse reaction, such as drug allergy, food allergy, environmental allergen, or contrast media reaction. Drives clinical decision support rules and allergy alert prioritization within EHR and pharmacy systems.

sensitivity chief complaintsens_cc

The primary symptom or presenting concern reported by the patient that prompted evaluation of a suspected sensitivity or allergic reaction. Captured in the clinical encounter record and used to guide differential diagnosis and document the clinical basis for the sensitivity finding.

sensitivity childsens_chld

A subordinate or dependent sensitivity record linked to a parent sensitivity entry in a hierarchical data structure. Represents a more specific allergen, substance variant, or reaction subtype that inherits attributes from its parent record within the allergy and intolerance data model.

sensitivity citysens_city

The municipality or city name associated with the patient or facility linked to a sensitivity record. Used for demographic identification, geographic epidemiological tracking of allergen prevalence, and accurate patient address verification across health information systems.

PreviousPage 618 of 806Next