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

sensitivity classsens_cls

The pharmacological or chemical classification tier assigned to the substance causing a patient's sensitivity, such as penicillin-class antibiotics or NSAIDs. Enables cross-reactive allergy alerting in pharmacy and clinical decision support systems when related substances are prescribed.

sensitivity codesens_cd

The standardized coded value identifying a specific allergen or substance associated with a patient's documented sensitivity, drawn from coding systems such as SNOMED CT, RxNorm, or NDF-RT. Enables interoperable allergy data exchange across EHR, pharmacy, and claims systems.

sensitivity commentsens_cmt

Free-text narrative entered by a clinician or clinical staff member to provide additional context, clarification, or supplemental detail about a patient's documented sensitivity or allergic reaction. Captures nuances not expressible through structured coded fields in the allergy record.

sensitivity completed datesens_cmpl_dt

The date on which a sensitivity evaluation, allergy testing procedure, or related clinical workup was finalized and results were recorded. Used to track the timeline of diagnostic completion and support clinical documentation compliance within allergy and immunology workflows.

sensitivity confidential indicatorsens_conf_ind

A flag designating that a patient's sensitivity or allergy record contains confidential information requiring restricted access, such as sensitivities linked to substance use treatment or behavioral health. Controls record visibility in accordance with HIPAA and applicable confidentiality regulations.

sensitivity countsens_cnt

The total number of documented sensitivity or allergy records associated with a patient, encounter, or substance category within a given clinical data set. Used for reporting, population health analysis, and measuring the prevalence of specific allergens across patient populations.

sensitivity countrysens_ctry

The country name or code associated with the patient or clinical facility linked to a sensitivity record. Supports international patient demographic identification, cross-border health information exchange, and geographic analysis of allergen exposure patterns in clinical data systems.

sensitivity created bysens_crtd_by

The unique identifier of the user, clinician, or system that originally entered the sensitivity or allergy record into the clinical data system. Supports audit trail requirements, data provenance tracking, and accountability for allergy documentation accuracy within EHR platforms.

sensitivity created datesens_crtd_dt

The calendar date on which a patient's sensitivity or allergy record was first entered into the clinical data system. Used for audit trail maintenance, longitudinal allergy history tracking, and identifying the origination point of allergy documentation within EHR and data warehouse environments.

sensitivity created timesens_crtd_tm

The precise timestamp recording when a patient's sensitivity or allergy record was first created in the clinical system. Supports detailed audit logging, data provenance analysis, and chronological sequencing of allergy record events within EHR and clinical data warehouse environments.

sensitivity creatininesens_cr

The serum creatinine level recorded in association with a patient sensitivity or allergic reaction event. Used in clinical data systems to assess kidney function at the time of a sensitivity reaction, supporting nephrotoxic drug screening and contraindication decisions.

sensitivity datesens_dt

The calendar date on which a patient sensitivity, allergy, or adverse substance reaction was identified, recorded, or first observed. Used in EHR and clinical data warehouses to establish the onset timeline of a sensitivity for medication safety screening and longitudinal allergy history tracking.

sensitivity datetimesens_dttm

The combined date and timestamp recording when a patient sensitivity or adverse substance reaction was identified or documented in the clinical system. Enables precise temporal tracking of allergy onset or documentation in EHR workflows, supporting clinical decision support and medication safety alerts.

sensitivity dea numbersens_dea_nbr

The Drug Enforcement Administration registration number associated with a controlled substance linked to a patient sensitivity or adverse reaction record. Used to identify the specific regulated substance involved in the allergic or adverse event within clinical and pharmacy data systems.

sensitivity death datesens_death_dt

The date of a patient's death when recorded in association with a sensitivity or severe adverse reaction record, such as anaphylaxis. Used in clinical data systems to document fatal outcomes linked to substance sensitivities for pharmacovigilance, mortality analysis, and allergy record closure.

sensitivity deleted datesens_del_dt

The date on which a patient sensitivity or allergy record was marked as deleted or removed from the active clinical record. Used in EHR and clinical data warehouses to maintain an audit trail of record lifecycle changes, supporting data governance and longitudinal allergy history reconciliation.

sensitivity deleted indicatorsens_del_ind

A flag indicating whether a patient sensitivity or allergy record has been logically deleted from the active clinical record. Used in EHR and clinical data systems to filter inactive or retracted allergy entries while preserving the full audit history for compliance and patient safety review.

sensitivity descriptionsens_desc

The free-text or coded textual description of a patient's sensitivity or allergic reaction, including the substance involved and the nature of the reaction. Used in clinical documentation to communicate allergy details in human-readable format across EHR systems and care team workflows.

sensitivity detailsens_dtl

Granular clinical information associated with a patient sensitivity record, such as reaction type, severity, onset mechanism, and clinical notes. Used in EHR and clinical data systems to provide a comprehensive account of an allergic or adverse substance reaction beyond summary-level allergy documentation.

sensitivity discharge datesens_dsch_dt

The date a patient was discharged from an inpatient or observation encounter that was associated with a sensitivity or adverse substance reaction event. Used in clinical data systems to correlate allergy and sensitivity records with specific hospitalizations for outcomes analysis and care transition documentation.

PreviousPage 619 of 806Next