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

sign resolution datesgn_resol_dt

The date on which an observable clinical sign was determined to have resolved or returned to normal limits following clinical intervention or natural progression. Used in longitudinal patient records to track the duration and clinical course of documented signs across care episodes.

sign respirationsgn_resp

The recorded respiratory rate or breathing pattern measurement captured as a clinical vital sign during patient assessment, typically expressed in breaths per minute. A key component of vital sign documentation used to evaluate respiratory status and detect deterioration in acute and ambulatory care settings.

sign resultsgn_rslt

The outcome value or finding recorded following the observation or measurement of a clinical sign, such as a blood pressure reading or oxygen saturation percentage. Represents the actual measured or assessed value associated with the sign at the time of clinical encounter documentation.

sign revisionsgn_rev

The version or iteration number indicating how many times a clinical sign record has been updated or amended since initial documentation. Used in clinical audit trails to track corrections, addenda, or updates made to sign observations within electronic health records and clinical data systems.

sign risksgn_rsk

A structured assessment of the danger level or clinical concern associated with a recorded sign observation, such as flagging critically abnormal vital signs. Used in clinical decision support and risk stratification workflows to prioritize patient follow-up and intervention based on sign severity.

sign routesgn_rte

The anatomical site or physiological pathway through which a clinical sign was observed or measured, such as oral temperature or radial pulse. Documents the method of sign assessment to ensure clinical consistency and comparability across repeated measurements in patient monitoring workflows.

sign scoresgn_scr

A calculated numeric value derived from one or more clinical sign measurements using a standardized clinical scoring system, such as an early warning score or Glasgow Coma Scale component. Supports risk stratification and clinical decision-making by aggregating sign data into actionable composite values.

sign sequencesgn_seq

The positional ordering number assigned to a clinical sign within a series of observations recorded during a patient encounter or monitoring episode. Used in clinical data systems to maintain the correct chronological or protocol-defined order of sign measurements for accurate trend analysis.

sign severitysgn_sev

A graded classification indicating the clinical seriousness of an observed sign, ranging from mild to critical based on established clinical criteria or deviation from normal reference ranges. Used to prioritize clinical response and document acuity levels associated with patient sign findings across care settings.

sign sexsgn_sex

The biological sex classification of the patient associated with a recorded clinical sign observation, used to apply sex-specific reference ranges and support demographic stratification. Ensures that sign values are interpreted against appropriate normative data in clinical documentation and population health reporting.

sign sourcesgn_src

The originating system, device, clinician, or care setting from which a clinical sign observation was captured or transmitted, such as a bedside monitor, wearable sensor, or manual nursing assessment. Used to assess data reliability and support interoperability across clinical information systems.

sign start datesgn_start_dt

The date on which a clinical sign was first observed or documented in the patient record. Used in EHR and clinical data systems to establish the onset timeline of observable physical or physiological indicators such as vital sign abnormalities or neurological signs.

sign start timesgn_start_tm

The specific time at which a clinical sign was first observed or recorded during a patient encounter. Captures the precise onset moment of observable physical indicators, supporting clinical decision-making, acuity tracking, and time-sensitive care documentation in inpatient and outpatient settings.

sign statesgn_st

The clinical progression state of an observable sign at a given point in time, such as whether the sign is newly presenting, resolving, persistent, or worsening. Used in clinical documentation to track the trajectory of physical findings across encounters and care episodes.

sign statussgn_sts

The current clinical or workflow status of a documented observable sign, such as active, resolved, ruled out, or under investigation. Used in EHR and clinical data warehouses to reflect the current standing of a physical finding within a patient's longitudinal health record.

sign strengthsgn_str

The measured intensity or severity level of an observable clinical sign, such as the degree of a reflex response, muscle strength grade, or pulse quality. Used in clinical documentation to quantify and compare the magnitude of physical findings across assessments and care episodes.

sign subtotalsgn_subtot

A partial aggregated value representing a subset of clinical sign measurements or occurrences within a defined grouping, time period, or care episode. Used in clinical analytics and reporting to summarize sign data at an intermediate level before final totals are calculated across the full dataset.

sign surgery datesgn_surg_dt

The date of a surgical procedure that is directly associated with or precipitated by a documented clinical sign. Used in clinical data systems to link observable physical findings to operative interventions, supporting surgical outcomes tracking and perioperative care documentation.

sign targetsgn_tgt

The intended clinical threshold, anatomical location, or treatment goal associated with an observable sign. Used in clinical documentation and care planning systems to define the expected or desired state of a physical finding relative to a treatment plan or clinical intervention.

sign taxonomy codesgn_tax_cd

A standardized classification code used to categorize an observable clinical sign within a recognized clinical terminology or coding system. Supports consistent identification, grouping, and reporting of physical findings across EHR systems, clinical registries, and interoperability frameworks.

PreviousPage 644 of 806Next