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

session statussess_sts

A coded value representing the current lifecycle state of a therapy or treatment session, such as scheduled, in-progress, completed, cancelled, or no-show. Used in clinical workflow systems to manage care coordination, track appointment adherence, and support operational reporting.

session strengthsess_str

The concentration or dosage strength of a medication or therapeutic agent administered during a clinical session, typically expressed in units such as mg, mg/mL, or mcg. Used in pharmacy and infusion therapy records to ensure accurate drug administration and support clinical safety checks.

session subtotalsess_subtot

A partial sum of charges, units, or costs associated with specific components of a therapy or treatment session prior to final billing adjustments, discounts, or contractual allowances. Used in revenue cycle management to support claims adjudication and session-level financial reconciliation.

session surgery datesess_surg_dt

The calendar date on which a surgical procedure was performed as part of or in association with a specific clinical session. Used in surgical and perioperative data systems to track operative timing, support post-surgical care coordination, and enable outcomes reporting tied to procedure dates.

session targetsess_tgt

The intended clinical goal, anatomical site, therapeutic objective, or intervention target defined for a specific therapy or treatment session. Used in oncology, radiation therapy, and rehabilitation settings to document and measure alignment between planned treatment objectives and actual care delivered.

session taxonomy codesess_tax_cd

A standardized NUCC Healthcare Provider Taxonomy code identifying the specialty or clinical discipline of the provider delivering a therapy or treatment session. Used in claims processing and credentialing systems to validate provider qualifications, support billing edits, and enable specialty-level utilization analysis.

session temperaturesess_temp

The patient's body temperature measurement recorded during a therapy or treatment session, typically expressed in Fahrenheit or Celsius. Used in clinical documentation to capture vital sign data, monitor for fever or hypothermia, and support clinical decision-making and acuity assessment during care delivery.

session termination datesess_term_dt

The calendar date on which a therapy or treatment session formally ends or is closed in the clinical system. Used to calculate session duration, determine episode-of-care boundaries, support billing finalization, and enable longitudinal tracking of treatment completion across patient care records.

session timesess_tm

The specific time of day associated with a therapy or treatment session event, distinct from start or end time. Used in clinical and operational data systems to record the precise timing of key session activities, support time-based billing validation, and enable scheduling and workflow analysis.

session timestampsess_ts

A combined date and time value capturing the precise moment a therapy or treatment session event was recorded or occurred in the clinical system. Used for audit trails, chronological sequencing of care events, interoperability logging, and ensuring data integrity across clinical and claims platforms.

session titlesess_ttl

The formal name or descriptive label assigned to a therapy or treatment session, such as a specific program name, intervention type, or clinical protocol designation. Used in clinical scheduling, care management, and reporting systems to identify and categorize session types across patient populations.

session totalsess_tot

The cumulative monetary or unit sum associated with a therapy or treatment session, such as total charges, units rendered, or service minutes. Used in clinical billing and care management systems to aggregate session-level data for reimbursement, utilization review, and treatment planning.

session total countsess_tot_cnt

The total number of therapy or treatment sessions completed or authorized within a defined period, such as a care plan or authorization cycle. Used in utilization management and clinical documentation to track session consumption against approved limits and measure treatment progress.

session typesess_typ

A categorical classification that identifies the nature of a therapy or treatment session, such as individual therapy, group therapy, evaluation, or follow-up. Used in clinical scheduling, documentation, and billing systems to apply appropriate coding, reimbursement rules, and reporting workflows.

session updated datesess_upd_dt

The most recent date on which a therapy or treatment session record was modified in the clinical or billing system. Used in audit trails and data synchronization processes to identify changed records, support version control, and ensure downstream systems reflect the latest session information.

session urgencysess_urg

A coded or descriptive indicator of the clinical time sensitivity for a therapy or treatment session, such as routine, urgent, or emergent. Used in scheduling and care coordination systems to prioritize session booking, resource allocation, and clinician response based on patient acuity or referral need.

session versionsess_ver

A sequential number or identifier that tracks the iteration of a therapy or treatment session record following updates or amendments. Used in clinical data warehouses and EHR audit systems to maintain record history, support regulatory compliance, and distinguish current records from prior versions.

session zipsess_zip

The five or nine-digit postal code identifying the geographic location where a therapy or treatment session was delivered or scheduled. Used in population health reporting, network adequacy analysis, and claims adjudication to determine service area, assign regional rates, and support geographic utilization analysis.

sign active indicatorsgn_actv_ind

A binary flag indicating whether an observable clinical sign, such as a vital measurement or physical finding, is currently active and relevant to the patient's ongoing care. Used in EHR clinical documentation to filter current versus historical sign data during assessment and clinical decision support.

sign active statussgn_actv_sts

A coded status value indicating the current lifecycle state of an observable clinical sign, such as active, resolved, or inactive. Used in clinical documentation systems to support longitudinal tracking of patient findings, flag signs requiring follow-up, and filter records for clinical review or reporting.

PreviousPage 638 of 806Next