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 paid datesgn_pd_dt

Records the calendar date on which payment was received or processed for a clinical sign assessment or associated clinical service. Used in healthcare billing and revenue cycle management workflows to track reimbursement timelines and reconcile claims linked to observable clinical indicator evaluations.

sign parentsgn_prnt

Identifies the hierarchical parent record or category to which an observable clinical indicator belongs within a clinical taxonomy or sign catalog. Used to organize signs into structured groupings, enabling navigation of nested sign relationships and supporting clinical decision support logic in EHR systems.

sign percentagesgn_pct

Captures a percentage-based measurement associated with an observable clinical indicator, such as body surface area affected, improvement percentage, or relative severity expressed as a ratio. Used in clinical documentation to quantify the extent or degree of a sign observed during patient assessment.

sign periodsgn_prd

Defines the time interval or duration associated with an observable clinical indicator, such as the duration a sign has been present or the observation window during which it was assessed. Used in clinical documentation to characterize the temporal pattern of signs, supporting diagnosis and treatment planning.

sign phonesgn_ph

Stores a telephone contact number associated with a clinical sign record or its responsible party within the healthcare data system. May reference the contact for the clinician, department, or facility accountable for documenting or following up on a specific observable clinical indicator in the patient record.

sign preferred namesgn_pref_nm

The clinician- or system-designated preferred display label for an observable clinical indicator, used when multiple synonymous names exist. Ensures consistent terminology in clinical documentation, patient-facing materials, and reporting interfaces by establishing a standardized preferred term within the EHR sign catalog.

sign pricesgn_prc

Records the billed or standard charge associated with the assessment or documentation of a clinical sign or its related clinical service. Used in healthcare revenue cycle and chargemaster workflows to capture the list price before adjustments, contractual allowances, or payer-specific reimbursement rates are applied.

sign primary indicatorsgn_prim_ind

A flag that designates whether an observable clinical indicator is the primary sign associated with a patient encounter, diagnosis, or clinical episode. Used in clinical documentation and reporting to distinguish the principal finding from secondary or incidental signs recorded during a patient assessment.

sign prioritysgn_prty

Indicates the clinical urgency or importance ranking assigned to an observable clinical indicator within the EHR or clinical workflow system. Used to triage and order the attention given to signs during patient assessments, ensuring high-priority findings such as critical vital sign deviations are addressed promptly.

sign procedure datesgn_proc_dt

Records the calendar date on which a clinical procedure associated with assessing or evaluating an observable clinical indicator was performed. Used in clinical documentation and claims processing to establish when the procedure occurred, supporting medical record accuracy, billing, and longitudinal care tracking.

sign pulsesgn_pulse

Records the patient's heart rate measurement in beats per minute as an observable vital sign captured during clinical assessment. This key physiological indicator reflects cardiovascular function and is routinely documented in EHR systems alongside other vital signs to monitor patient status and detect cardiac abnormalities.

sign quantitysgn_qty

The numeric count or volume measurement associated with an observable clinical sign, such as the number of occurrences or units recorded during patient assessment. Used in clinical documentation to capture measurable aspects of vital signs or physical findings.

sign racesgn_race

The patient racial classification associated with a recorded clinical sign observation, used to support demographic stratification and health equity analysis. Enables population-level reporting on how clinical signs present across different racial groups in clinical data systems.

sign rangesgn_rng

The minimum and maximum boundary values defining normal or expected limits for a clinical sign measurement, such as acceptable blood pressure or temperature thresholds. Used in clinical decision support to flag abnormal vital sign readings that fall outside established reference intervals.

sign ratesgn_rt

The frequency or speed measurement of a clinical sign observation, such as heart rate in beats per minute or respiratory rate in breaths per minute. Captured during patient encounters to document physiological measurements critical for assessing patient stability and clinical status.

sign ratingsgn_rtg

A standardized scored assessment value assigned to a clinical sign based on defined clinical scales or scoring criteria, such as pain intensity ratings or neurological response grades. Used in clinical documentation to quantify subjective or semi-objective sign observations consistently across encounters.

sign ratiosgn_ratio

The proportional relationship between two clinical sign measurements, such as the ankle-brachial index or inspiratory-to-expiratory ratio. Used in clinical documentation to express comparative physiological values that support diagnostic interpretation of observed patient signs.

sign reasonsgn_rsn

The clinical justification or explanatory text documenting why a particular sign was recorded, modified, or flagged during a patient encounter. Provides context for clinicians reviewing sign history and supports audit trails in electronic health record and clinical data warehouse environments.

sign received datesgn_rcvd_dt

The calendar date on which a clinical sign observation or related data was received into the health system, whether from a remote monitoring device, external care setting, or transferred record. Used to establish data provenance and support temporal analysis of clinical sign information.

sign referencesgn_ref

An external identifier or pointer linking a clinical sign record to a related document, order, encounter, or source system. Used in clinical data integration to maintain traceability between sign observations and the originating clinical event or external reference standard.

PreviousPage 643 of 806Next