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 citysess_city

Records the city associated with the location where a therapy or treatment session was delivered or the patient's city of residence as captured in the session record. Used in clinical and administrative systems to support geographic reporting, facility-level analytics, and patient demographic documentation at the session level.

session classsess_cls

Indicates the classification tier assigned to a therapy or treatment session, such as individual, group, telehealth, or intensive outpatient. Used in clinical scheduling and billing systems to differentiate service delivery models, apply appropriate reimbursement rules, and support utilization management reporting across care programs.

session codesess_cd

Stores a standardized alphanumeric code that uniquely identifies the type or nature of a therapy or treatment session within clinical and administrative systems. Used to classify sessions for scheduling, billing, and reporting purposes, and serves as a key reference value for linking session records across EHR and data warehouse environments.

session commentsess_cmt

Captures unstructured free-text notes entered by clinical or administrative staff in relation to a therapy or treatment session. Used in EHR and scheduling systems to document session-specific observations, coordination notes, patient instructions, or contextual details that do not fit within structured data fields in the session record.

session completed datesess_cmpl_dt

Records the calendar date on which a therapy or treatment session was fully delivered and marked complete in the clinical system. Used to confirm service fulfillment, trigger billing workflows, support productivity reporting, and measure timeliness of care delivery across outpatient, rehabilitation, and behavioral health settings.

session confidential indicatorsess_conf_ind

Flags a therapy or treatment session record as containing sensitive or restricted clinical information requiring heightened privacy controls, such as behavioral health, substance use, or sexual health content. Used in EHR access control systems to limit record visibility and ensure compliance with HIPAA and applicable state confidentiality regulations.

session countsess_cnt

Represents the total number of therapy or treatment sessions recorded for a patient, episode of care, or authorization period. Used in clinical and administrative systems to track utilization against authorized visit limits, monitor care plan progress, and support reporting on session frequency across treatment programs and payer contracts.

session countrysess_ctry

Records the country associated with the location where a therapy or treatment session was delivered or the patient's country of residence as documented in the session record. Used in clinical and administrative systems to support international patient management, geographic reporting, and demographic accuracy in session-level documentation.

session created bysess_crtd_by

Stores the unique identifier of the user or system that originally created the therapy or treatment session record in the clinical or scheduling system. Used for audit trail purposes, data governance, and accountability tracking to identify who initiated the session entry and when changes to the original record may have occurred.

session created datesess_crtd_dt

Records the calendar date on which a therapy or treatment session record was first created in the clinical or scheduling system. Used in audit logging, data governance, and operational reporting to establish record origin timestamps, track scheduling lead times, and support data lineage analysis across EHR and clinical data warehouse environments.

session created timesess_crtd_tm

Records the exact clock time at which a therapy or treatment session record was first created in the clinical or scheduling system. Used alongside the session created date to establish precise record origin timestamps for audit trail compliance, data governance workflows, and operational analysis of scheduling and documentation activity patterns.

session creatininesess_cr

Serum creatinine level recorded at the time of a specific dialysis or renal therapy session, used to assess kidney function and treatment adequacy. Monitored across sessions to evaluate disease progression and guide clinical decision-making in nephrology care settings.

session datesess_dt

Calendar date on which a specific therapy or treatment session was conducted, such as dialysis, infusion, or rehabilitation. Used to sequence clinical encounters chronologically, support scheduling workflows, and calculate treatment frequency and intervals in clinical data systems.

session datetimesess_dttm

Precise timestamp combining date and time indicating when a specific therapy or treatment session occurred. Supports accurate sequencing of clinical events, audit trails, and time-sensitive clinical calculations such as treatment duration and inter-session intervals in clinical data systems.

session dea numbersess_dea_nbr

Drug Enforcement Administration registration number associated with the prescribing or administering clinician for a specific therapy session. Used to ensure regulatory compliance when controlled substances are involved in treatment, and to link sessions to licensed practitioners in clinical records.

session death datesess_death_dt

Date of patient death recorded in association with a therapy or treatment session record, used to close active treatment episodes and trigger downstream workflows. Critical for outcomes analysis, mortality reporting, and ensuring no further sessions are scheduled in clinical data systems.

session deleted datesess_del_dt

Date on which a therapy or treatment session record was marked as deleted or voided in the clinical system. Supports audit trail integrity by preserving the timestamp of record removal, enabling data governance reviews and reconciliation in clinical and administrative data warehouses.

session deleted indicatorsess_del_ind

Boolean or coded flag indicating whether a therapy or treatment session record has been voided, cancelled, or logically deleted from the clinical system. Used to filter active records from reporting datasets while preserving historical data integrity for audit and compliance purposes.

session descriptionsess_desc

Free-text or standardized narrative describing the nature, purpose, or content of a specific therapy or treatment session, such as the type of dialysis modality or infusion administered. Supports clinical documentation, care coordination, and human-readable reporting in clinical data systems.

session detailsess_dtl

Granular clinical or administrative information associated with a specific therapy or treatment session, capturing specifics such as modality parameters, observations, or interventions performed. Provides supplementary context beyond summary-level session data in clinical records and data warehouses.

PreviousPage 633 of 806Next