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 countsgn_cnt

Records the total number of times a specific observable clinical sign has been documented for a patient across encounters or within a defined time period. Used in clinical data warehouses to support frequency analysis, trending, and population health management reporting.

sign countrysgn_ctry

Captures the country associated with the location where an observable clinical sign was recorded or the patient's country of origin at the time of documentation. Used in clinical data systems to support international patient tracking, epidemiological analysis, and geographic reporting.

sign created bysgn_crtd_by

Identifies the user ID or username of the clinician or system user who initially created the observable clinical sign record in the EHR or clinical data system. Used for audit trail purposes, accountability tracking, and data provenance within clinical documentation workflows.

sign created datesgn_crtd_dt

Records the calendar date on which the observable clinical sign record was first entered into the EHR or clinical data system. Used to establish the data provenance timeline and support audit logging, record retention policies, and longitudinal clinical data analysis.

sign created timesgn_crtd_tm

Records the precise time at which the observable clinical sign record was first entered into the EHR or clinical data system. Used alongside the created date to establish an exact timestamp for audit trail integrity, workflow sequencing, and clinical event chronology.

sign creatininesgn_cr

Captures the serum or urine creatinine measurement recorded as an observable clinical sign, used to assess kidney filtration function and detect renal impairment. Documented in EHR lab and clinical sign workflows, this value supports chronic kidney disease staging and medication dosing decisions.

sign datesgn_dt

Records the calendar date on which an observable clinical sign was assessed or documented during a patient encounter. Used across EHR and clinical data warehouse systems to establish the temporal context of sign observations for trending, clinical decision support, and retrospective analysis.

sign datetimesgn_dttm

Stores the combined date and time stamp at which an observable clinical sign was recorded or assessed during a patient encounter. Provides precise temporal context for sign data used in clinical event sequencing, real-time monitoring workflows, and longitudinal clinical data analysis.

sign dea numbersgn_dea_nbr

Stores the DEA registration number associated with the clinician or prescriber linked to a sign record, particularly relevant when the sign documentation is connected to controlled substance prescribing. Used to maintain regulatory traceability between clinical assessments and controlled substance authorization in EHR systems.

sign death datesgn_death_dt

Records the date of patient death associated with or documented alongside an observable clinical sign record, used to capture mortality outcomes linked to specific clinical findings. Supports mortality reporting, clinical outcome analysis, and end-of-life care documentation in EHR and data warehouse systems.

sign deleted datesgn_del_dt

Records the date on which an observable clinical sign record was marked as deleted or inactivated within the EHR or clinical data system. Used to maintain a soft-delete audit trail, supporting data governance, record lifecycle management, and historical accuracy in clinical data warehouses.

sign deleted indicatorsgn_del_ind

Flag identifying whether an observable clinical sign record has been logically removed from active use in the clinical documentation system. Supports audit trails and data governance by preserving historical sign records while excluding them from active clinical assessments and reporting workflows.

sign descriptionsgn_desc

Human-readable text describing an observable clinical sign, such as diaphoresis, cyanosis, or edema, as documented in a patient encounter. Used in clinical documentation to communicate the nature and characteristics of the sign to care team members and for structured reporting in EHR systems.

sign detailsgn_dtl

Granular clinical information captured about an observable sign during patient assessment, including severity, location, onset pattern, or associated characteristics. Supports detailed clinical documentation in EHR systems and enables precise tracking of sign presentation changes across patient encounters over time.

sign discharge datesgn_dsch_dt

Date on which an observable clinical sign was last documented or resolved at the time of patient discharge from a care setting. Used in clinical outcome tracking to correlate sign resolution with inpatient stays and to support discharge summary documentation and post-acute care transitions.

sign due datesgn_due_dt

Scheduled date by which an observable clinical sign requires reassessment, follow-up documentation, or clinical intervention. Used in care management workflows to ensure timely monitoring of evolving signs and to trigger clinical alerts when reassessment deadlines approach or are missed in the EHR.

sign durationsgn_dur

Measured length of time an observable clinical sign has been present or was active during a patient encounter, expressed in minutes, hours, or days. Supports clinical decision-making by providing temporal context for sign progression, chronicity assessment, and differential diagnosis in clinical documentation systems.

sign emailsgn_eml

Electronic mail address associated with the clinical sign record, typically linked to the documenting clinician or responsible care team member. Used in clinical communication workflows to route notifications, alerts, or follow-up instructions related to an observable sign identified during patient assessment.

sign emergency indicatorsgn_emerg_ind

Flag identifying whether an observable clinical sign warrants urgent or emergent clinical intervention, such as signs indicating acute cardiac or respiratory compromise. Used in triage and clinical alert systems to prioritize patient care responses and escalate documentation to appropriate emergency care pathways.

sign end datesgn_end_dt

Date on which an observable clinical sign was last recorded as present or was documented as resolved during a patient encounter or care episode. Used in longitudinal patient records to establish the temporal boundary of sign activity and support clinical trend analysis across multiple encounters.

PreviousPage 640 of 806Next