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 end timesgn_end_tm

Precise timestamp indicating when an observable clinical sign was last documented as active or was recorded as resolved during a patient encounter. Supports accurate clinical sequencing, nursing documentation, and time-sensitive clinical event tracking within EHR systems and clinical data warehouses.

sign entered bysgn_ent_by

Identifier of the clinician, nurse, or authorized healthcare user who recorded an observable clinical sign in the documentation system. Used for accountability, audit trail maintenance, and clinical workflow tracking to ensure that sign data is attributed to the appropriate credentialed care team member.

sign ethnicitysgn_ethn

Ethnicity classification associated with the patient for whom an observable clinical sign was documented. Used in population health analytics and clinical research to identify ethnic group variations in sign prevalence, disease presentation patterns, and health outcome disparities across patient populations.

sign expiration datesgn_exp_dt

Date after which an observable clinical sign record or its associated clinical protocol is no longer considered valid or applicable for patient care decisions. Used in clinical knowledge management systems to retire outdated sign documentation entries and maintain accuracy of active clinical reference data.

sign external identifiersgn_ext_id

Unique reference code assigned to an observable clinical sign by an external system, such as a referring facility, interoperability platform, or standards body like SNOMED CT. Enables cross-system tracking and reconciliation of sign records during health information exchange and care coordination workflows.

sign faxsgn_fax

Facsimile number associated with the clinical sign record, typically linked to the documenting provider or care facility transmitting sign-related clinical documentation. Used in healthcare communication workflows to route paper-based or electronic fax correspondence related to patient sign assessments and referrals.

sign feesgn_fee

Service charge associated with the clinical assessment or documentation of an observable sign during a patient encounter. Used in revenue cycle management to link clinical sign evaluations to billable services, supporting accurate medical coding, claims submission, and reimbursement processing in healthcare billing systems.

sign first namesgn_first_nm

Given name of the clinician or care team member associated with the documentation of an observable clinical sign during a patient encounter. Used in clinical attribution workflows to identify the individual responsible for sign assessment and to support staff-level reporting and accountability tracking.

sign flagsgn_flg

Binary or categorical marker applied to an observable clinical sign record to indicate a specific status, such as requiring review, clinical significance, or data quality concern. Used in clinical workflow management to filter, prioritize, and route sign records for appropriate follow-up action within EHR systems.

sign full namesgn_full_nm

Complete name of the clinician or care team member responsible for documenting an observable clinical sign during a patient encounter. Used in clinical attribution, staff credentialing verification, and audit trail reporting to ensure full identification of the individual who recorded the sign assessment.

sign gendersgn_gndr

Gender classification of the patient associated with an observable clinical sign documentation record. Used in population health analytics and clinical research to analyze gender-based differences in sign presentation, disease prevalence, and care outcomes across patient cohorts in clinical data warehouses.

sign glucosesgn_gluc

Recorded blood glucose measurement captured as an observable clinical vital sign. Documents point-in-time blood sugar levels in mg/dL or mmol/L used for monitoring diabetes, hypoglycemia, or metabolic conditions within clinical encounter documentation.

sign hemoglobinsgn_hgb

Recorded blood hemoglobin concentration captured as an observable clinical vital sign. Documents measured g/dL values used to assess anemia, oxygen-carrying capacity, and overall hematologic status within clinical encounter and lab result documentation.

sign history present illnesssgn_hpi

Narrative clinical documentation describing the onset, duration, severity, and progression of a patient's current condition or chief complaint. Captured during clinical encounters as a structured component of the medical history within EHR documentation workflows.

sign identifiersgn_id

Unique system-generated or assigned identifier that distinguishes a specific observable clinical sign record across clinical data systems. Used to reference, link, and track individual sign observations within EHR encounters, clinical data warehouses, and interoperability exchanges.

sign indexsgn_idx

Positional or sequential number assigned to an observable clinical sign within a structured data set or encounter record. Used to order, sort, or reference multiple sign observations recorded during a single clinical encounter or patient episode in clinical data systems.

sign indicatorsgn_ind

Boolean or coded flag that denotes the presence, absence, or active status of an observable clinical sign for a patient encounter. Used in clinical decision support, quality reporting, and care management workflows to signal whether a specific sign condition applies.

sign instructionsgn_instr

Clinician-authored or system-generated guidance text associated with an observable clinical sign, specifying how to measure, interpret, or respond to the sign. Supports standardized clinical workflows and bedside care protocols within EHR and nursing documentation systems.

sign keysgn_key

Lookup or reference key value used to retrieve and cross-reference an observable clinical sign record within clinical data systems. Enables consistent mapping of sign data across EHR tables, clinical data warehouses, and interoperability interfaces using standardized key structures.

sign labelsgn_lbl

Human-readable display text associated with an observable clinical sign, used to present the sign name or category within clinical interfaces, reports, and dashboards. Supports consistent terminology rendering across EHR screens and clinical data warehouse outputs.

PreviousPage 641 of 806Next