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

service procedure datesvc_proc_dt

The business date on which a specific clinical procedure was rendered within a provider encounter, distinct from claim submission or adjudication dates. Used in EHR, claims, and revenue cycle management systems to determine episode of care timelines, apply correct fee schedules, and validate authorization windows during claims processing.

service rangesvc_rng

Defines the allowable value span or date range associated with a clinical service, such as acceptable lab result thresholds or the authorized period during which a service may be rendered. Used in utilization management and claims editing systems to validate service appropriateness and enforce authorization boundaries.

service resultsvc_rslt

Captures the clinical outcome or finding produced by a specific service encounter, such as a diagnostic conclusion, procedure finding, or therapeutic response measurement. Used in clinical data warehouses to support quality reporting, outcomes analysis, care gap identification, and population health management across service episodes.

service surgery datesvc_surg_dt

Records the specific date on which an operative procedure was performed as part of a clinical service episode. Used in claims adjudication, surgical scheduling systems, and clinical data warehouses to validate billing timelines, coordinate perioperative care documentation, and support surgical outcomes reporting and quality metrics.

session active indicatorsess_actv_ind

A binary flag indicating whether a therapy or treatment session record is currently active within the clinical or scheduling system. Used to filter session records in reporting and workflow queues, distinguishing active treatment sessions from cancelled, completed, or voided encounters in behavioral health and outpatient care management systems.

session active statussess_actv_sts

Indicates the current operational state of a therapy or treatment session, such as scheduled, in-progress, completed, or cancelled. Used in clinical scheduling and care management systems to drive workflow routing, reporting filters, and billing eligibility determinations for outpatient, behavioral health, and rehabilitation treatment sessions.

session admission datesess_admn_dt

Records the date a patient began a formal treatment session episode, particularly in behavioral health, rehabilitation, or intensive outpatient programs. Used to establish episode start points for authorization tracking, length-of-stay calculations, claims adjudication, and longitudinal treatment outcome analysis within clinical data systems.

session agesess_age

Captures the patient's age in years at the time of a therapy or treatment session. Used in clinical analytics and population health systems to stratify treatment outcomes by age cohort, validate age-appropriate care protocols, and support demographic reporting for behavioral health, rehabilitation, and chronic disease management programs.

session allowed amountsess_alwd_amt

The maximum dollar amount a payer will reimburse for a therapy or treatment session based on contracted rates, fee schedules, or benefit plan rules. Used in claims adjudication and financial reporting systems to calculate member cost-sharing obligations, provider payment amounts, and session-level expenditure for behavioral health and outpatient treatment programs.

session amountsess_amt

The total monetary charge associated with a therapy or treatment session as submitted on a claim or recorded in the clinical billing system. Used in financial reporting, claims adjudication, and payment reconciliation workflows to evaluate session-level costs, compare billed versus allowed amounts, and support revenue cycle management.

session approved bysess_appr_by

Identifies the credentialed user, supervisor, or system role that authorized a therapy or treatment session record, particularly relevant in behavioral health where clinical supervision requirements mandate cosignature workflows. Used in audit trails, compliance reporting, and quality oversight processes to verify session documentation meets regulatory and accreditation standards.

session arrival timesess_arrv_tm

Records the exact clock time a patient physically arrived for a scheduled therapy or treatment session. Used in clinical scheduling systems to calculate wait times, measure throughput efficiency, and support operational reporting across rehabilitation, behavioral health, and outpatient care settings.

session arrived datesess_arrv_dt

Records the calendar date a patient physically arrived for a scheduled therapy or treatment session. Used in clinical scheduling and EHR systems to confirm appointment attendance, support no-show analysis, and track care continuity across rehabilitation, behavioral health, and outpatient treatment programs.

session assessmentsess_asmt

Captures the clinician's narrative evaluation documented during a therapy or treatment session, reflecting the patient's current condition, progress toward goals, and clinical judgment. Used in EHR systems to support SOAP documentation, care plan updates, and clinical decision-making across therapy disciplines.

session birth datesess_birth_dt

Records the patient's date of birth as captured or referenced within a therapy or treatment session record. Used in clinical systems to verify patient identity, confirm age-appropriate treatment protocols, calculate age at time of service, and support demographic accuracy in session-level documentation.

session blood pressuresess_bp

Records the patient's arterial blood pressure measurement captured during a therapy or treatment session, typically expressed as systolic over diastolic values in mmHg. Used in clinical documentation to monitor cardiovascular status, assess treatment tolerance, and track vital sign trends across session encounters.

session cancelled datesess_cncl_dt

Records the calendar date on which a scheduled therapy or treatment session was officially cancelled. Used in clinical scheduling systems to track cancellation patterns, calculate late cancellation rates, support rescheduling workflows, and measure the impact of cancellations on care continuity and resource utilization.

session categorysess_cat

Classifies a therapy or treatment session into a defined grouping such as initial evaluation, follow-up, group therapy, or discharge visit. Used in clinical and administrative systems to organize session types for scheduling logic, utilization reporting, billing categorization, and care program management.

session chief complaintsess_cc

Documents the primary symptom, concern, or reason for visit as reported by the patient at the time of a therapy or treatment session. Used in clinical documentation to guide the session's clinical focus, support diagnostic coding, and establish the presenting problem for each encounter in the patient's care record.

session childsess_chld

Identifies a subordinate or dependent session record linked to a parent session within a hierarchical scheduling or clinical data structure. Used in EHR and scheduling systems to represent split sessions, associated follow-up encounters, or sub-appointments that are organizationally tied to a primary session record.

PreviousPage 632 of 806Next