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 admission datesgn_admn_dt

The date on which a patient was admitted to a facility in association with the documentation of an observable clinical sign. Used in inpatient clinical records to establish the temporal context of sign onset relative to hospitalization, supporting clinical correlation, severity assessment, and DRG assignment.

sign agesgn_age

The patient's age at the time an observable clinical sign was documented or assessed. Used in clinical analytics and population health systems to stratify sign prevalence and severity by age group, support age-adjusted benchmarking, and inform clinical decision support rules for age-appropriate findings.

sign allowed amountsgn_alwd_amt

The maximum reimbursable dollar amount established by a payer for services associated with the documentation or assessment of an observable clinical sign. Used in claims adjudication to calculate member cost-sharing, provider payment, and contractual adjustments when sign-related procedures are billed.

sign amountsgn_amt

The monetary value associated with clinical services rendered in connection with documenting or evaluating an observable clinical sign. Used in claims and billing systems to capture charges or payments linked to sign assessment procedures, supporting financial reconciliation and cost-of-care analysis.

sign approved bysgn_appr_by

The identifier or name of the clinician or authorized user who reviewed and approved the documentation of an observable clinical sign. Used in EHR audit and clinical governance workflows to establish accountability, meet regulatory documentation requirements, and support co-signature workflows for supervised care settings.

sign arrival timesgn_arrv_tm

The time at which a patient arrived at a clinical setting in association with the observation or assessment of a clinical sign. Used in emergency department and ambulatory care systems to calculate door-to-assessment intervals, support triage workflows, and measure compliance with time-sensitive care protocols.

sign arrived datesgn_arrv_dt

The calendar date on which a patient arrived at a clinical facility in connection with the documentation of an observable clinical sign. Used in encounter and triage records to establish the timeline of clinical assessment, correlate sign findings with visit dates, and support length-of-stay and throughput reporting.

sign assessmentsgn_asmt

The clinician's narrative or structured evaluation of an observable clinical sign, documenting interpretation, severity, and clinical significance. Used in EHR progress notes and SOAP documentation to record clinical reasoning, guide diagnosis, support care planning, and meet medical necessity documentation requirements.

sign birth datesgn_birth_dt

The date of birth of the patient associated with the documentation of an observable clinical sign. Used in clinical records to verify patient identity, calculate age at time of sign assessment, support age-specific clinical decision rules, and ensure accurate demographic linkage across clinical data systems.

sign blood pressuresgn_bp

The recorded systolic and diastolic arterial pressure measurement captured as an observable vital sign during a clinical encounter. Used in EHR vital signs flowsheets and chronic disease management programs to monitor cardiovascular status, trigger clinical alerts, and track hypertension management outcomes over time.

sign cancelled datesgn_cncl_dt

The date on which the documentation or assessment of an observable clinical sign was cancelled or voided in the clinical system. Used in EHR audit trails and clinical workflow management to record order or documentation cancellations, support record correction processes, and maintain an accurate longitudinal patient history.

sign categorysgn_cat

Classifies an observable clinical sign into a functional grouping such as vital signs, neurological signs, or cardiovascular signs. Used in EHR and clinical data warehouses to organize and filter sign data for clinical decision support and population health reporting.

sign chief complaintsgn_cc

Identifies the primary symptom or clinical concern that prompted documentation of a specific observable sign during a patient encounter. Links the recorded sign to the patient-reported complaint driving the clinical assessment and care workflow in the EHR.

sign childsgn_chld

Identifies a subordinate or dependent sign record in a hierarchical sign taxonomy, where the child sign is a more specific manifestation or sub-component of a parent sign. Used to support drill-down clinical analysis and structured sign documentation in EHR systems.

sign citysgn_city

Captures the municipality name associated with the location where an observable clinical sign was recorded or the facility at which the patient presented. Used for geographic analysis of clinical sign occurrence patterns across care sites and regional health reporting.

sign classsgn_cls

Designates the classification tier assigned to an observable clinical sign, such as objective, subjective, or physiological, within a structured clinical taxonomy. Supports clinical documentation workflows and enables consistent sign categorization across EHR and data warehouse systems.

sign codesgn_cd

Stores the standardized code representing a specific observable clinical sign, drawn from coding systems such as SNOMED CT or LOINC. Used to uniquely identify and exchange sign data consistently across EHR platforms, clinical data warehouses, and interoperability frameworks.

sign commentsgn_cmt

Contains free-text clinical notes entered by a clinician to provide additional context or nuance about an observable sign beyond structured data fields. Used in EHR documentation to capture qualitative observations that cannot be represented by coded values alone.

sign completed datesgn_cmpl_dt

Records the calendar date on which documentation or assessment of an observable clinical sign was finalized by the clinician or clinical staff. Used in EHR and clinical data warehouses to track sign workflow completion timelines and support audit and quality reporting.

sign confidential indicatorsgn_conf_ind

A flag indicating whether an observable clinical sign record contains sensitive information requiring restricted access, such as behavioral health or substance use findings. Controls visibility of sign data within EHR systems to enforce patient privacy and regulatory compliance.

PreviousPage 639 of 806Next