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 namesess_nm

The human-readable label or title assigned to a therapy or treatment session, such as the session type, program name, or protocol designation. Used in clinical scheduling interfaces, patient-facing portals, and reporting dashboards to identify and distinguish session records clearly.

session notesess_nt

Free-text or structured annotation documented by a clinician or care team member for a therapy or treatment session. Captures clinical observations, patient responses, progress updates, or administrative remarks that supplement structured session data within the clinical record.

session numbersess_nbr

A sequential or system-assigned numeric reference uniquely identifying a therapy or treatment session within a care episode or treatment plan. Used to track session progression, enforce benefit limits, and correlate clinical documentation with claims and authorization records.

session onset datesess_onset_dt

The date on which the condition, symptom, or clinical issue being addressed in the therapy or treatment session first presented. Supports medical necessity documentation, diagnosis coding accuracy, and longitudinal tracking of patient health status across a course of treatment.

session oxygen saturationsess_o2sat

The peripheral oxygen saturation percentage measured during a therapy or treatment session, typically via pulse oximetry. Recorded as a vital sign to monitor patient respiratory status, assess treatment response, and support clinical decision-making in respiratory, cardiac, or intensive care settings.

session paid amountsess_pd_amt

The dollar amount paid by a payer, patient, or guarantor for a specific therapy or treatment session. Used in revenue cycle management and claims adjudication reporting to reconcile expected reimbursement against actual payments received and identify balance billing or underpayment scenarios.

session paid datesess_pd_dt

The date on which payment was received or posted for a therapy or treatment session. Used in revenue cycle and accounts receivable workflows to monitor payment timeliness, calculate days in accounts receivable, and reconcile session-level remittance data against adjudicated claims.

session parentsess_prnt

The reference to the parent session, encounter, or episode of care to which a subordinate therapy or treatment session belongs. Used to maintain hierarchical relationships in clinical data models, enabling grouping of related sessions under a single episode for reporting and care coordination.

session percentagesess_pct

A percentage value associated with a therapy or treatment session, such as coinsurance rate, completion rate, benefit utilization, or outcome score proportion. Used in financial calculations, care plan progress monitoring, and utilization reporting within clinical and administrative data systems.

session periodsess_prd

The defined time interval or duration associated with a therapy or treatment session, such as the authorized treatment window, billing period, or scheduled session length. Used in care plan management, benefit authorization, and scheduling systems to define temporal boundaries for clinical services.

session phonesess_ph

The primary telephone number associated with the patient or responsible contact for a therapy or treatment session. Used for appointment reminders, care coordination outreach, and clinical follow-up communications to ensure patient engagement and continuity of care between scheduled sessions.

session preferred namesess_pref_nm

The clinician- or patient-designated display label for a specific therapy or treatment session, used to distinguish it from other sessions in a care plan. Supports human-readable identification in scheduling, clinical documentation, and longitudinal treatment tracking workflows.

session pricesess_prc

The monetary charge assigned to a discrete therapy or treatment session, reflecting the billed or contracted cost for services rendered. Used in revenue cycle management, patient billing, and cost analysis reporting to reconcile clinical activity with financial transactions.

session primary indicatorsess_prim_ind

A boolean or coded flag identifying whether a given therapy or treatment session is designated as the principal encounter within a series or care episode. Used to distinguish the primary session from supplemental or follow-up sessions in clinical and claims reporting workflows.

session prioritysess_prty

A ranked value indicating the clinical urgency or scheduling precedence assigned to a therapy or treatment session. Guides care coordination decisions by differentiating urgent, routine, or elective sessions within clinical workflow management and patient scheduling systems.

session procedure datesess_proc_dt

The calendar date on which a clinical procedure was performed during a therapy or treatment session. Used in clinical documentation, claims adjudication, and quality reporting to establish the timeline of care and support accurate procedure-to-date mapping.

session pulsesess_pulse

The patient's heart rate, measured in beats per minute, recorded at the time of a therapy or treatment session. Captured as a vital sign to monitor cardiovascular status, assess patient stability, and support clinical decision-making during and after session delivery.

session quantitysess_qty

The numeric count of units, doses, or service instances delivered or consumed within a therapy or treatment session. Used in clinical documentation and billing workflows to quantify the volume of care provided and support accurate charge capture and utilization reporting.

session racesess_race

The racial or ethnic identity of the patient as recorded at the time of a therapy or treatment session. Used to support health equity analysis, population health reporting, and compliance with federal demographic data collection requirements across clinical and administrative datasets.

session rangesess_rng

The defined minimum and maximum boundary values applicable to a clinical measurement or parameter recorded during a therapy or treatment session. Used to validate observed values against expected norms and flag out-of-range results for clinical review and quality monitoring.

PreviousPage 636 of 806Next