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 identifiersess_id

The unique alphanumeric key assigned to a specific therapy or treatment session, used to distinguish individual encounter records across clinical, billing, and operational systems. Enables session-level tracking, linkage to claims and clinical notes, and longitudinal analysis of patient care episodes.

session indexsess_idx

A sequential numeric position assigned to a therapy or treatment session within a series of related encounters, such as a multi-visit rehabilitation program or chemotherapy cycle. Used to track progression through a structured care protocol and support clinical outcome measurement over time.

session indicatorsess_ind

A coded or boolean value that signals a specific condition, type, or processing state of a therapy or treatment session, such as whether the session is an initial evaluation, a follow-up, or a telehealth encounter. Used to drive routing logic, billing rules, and clinical workflow decisions.

session instructionsess_instr

Directive or guidance text associated with a therapy or treatment session, including pre-session preparation steps, post-session care instructions, or clinical protocols to be followed during the encounter. Supports patient education, care coordination, and clinician adherence to standardized treatment plans.

session keysess_key

A surrogate or natural lookup reference value used to join or retrieve a therapy or treatment session record across related tables in clinical data systems. Supports relational data integrity, enabling linkage of session records to patients, providers, diagnoses, charges, and scheduling data.

session labelsess_lbl

A human-readable display text or short descriptive tag applied to a therapy or treatment session to identify its type, purpose, or status within scheduling systems, clinical dashboards, and care coordination tools, such as 'Initial Evaluation,' 'Follow-Up,' or 'Discharge Session.'

session languagesess_lang

The preferred or documented spoken or written language associated with a patient or participant in a therapy or treatment session. Used to coordinate interpreter services, deliver appropriate patient education materials, and ensure language-concordant care during clinical encounters.

session last namesess_last_nm

The family or surname of the individual associated with a therapy or treatment session record, such as the patient or treating clinician. Used alongside given name fields to uniquely identify session participants in clinical documentation, scheduling, and encounter-level reporting.

session legal namesess_legal_nm

The officially registered full name of the patient or individual associated with a therapy or treatment session, as it appears on legal or government-issued identification. Used to ensure accurate patient matching, insurance eligibility verification, and compliance with clinical documentation standards.

session levelsess_lvl

A classification indicating the complexity, intensity, or hierarchical tier of a therapy or treatment session, such as a level of care designation or evaluation and management code level. Used in clinical documentation, utilization management, and billing to reflect the scope of services delivered during the encounter.

session license numbersess_lic_nbr

The professional license identifier of the clinician or therapist conducting a therapy or treatment session, issued by a state licensing board. Used in credentialing verification, clinical documentation, and claims adjudication to confirm the treating provider's authorization to deliver the billed services.

session marital statussess_mar_sts

The marital status of the patient recorded at the time of a therapy or treatment session. Captured during clinical intake or registration to support behavioral health assessments, care planning, and social determinants of health documentation within EHR systems.

session master identifiersess_mstr_id

The enterprise master patient or encounter identifier assigned to a specific therapy or treatment session. Used to correlate session records across disparate clinical and administrative systems, enabling longitudinal tracking of care delivery and continuity across the healthcare enterprise.

session maximumsess_max

The upper threshold value defined for a therapy or treatment session, such as maximum allowable units, dosage ceiling, or benefit limit. Used in clinical authorization workflows and utilization management to enforce care plan boundaries and payer-approved session constraints.

session middle namesess_mid_nm

The middle name or initial of the patient or participant associated with a therapy or treatment session. Used in identity matching and demographic verification to distinguish individuals with similar names during clinical registration and session record reconciliation.

session minimumsess_min

The lower threshold value defined for a therapy or treatment session, such as minimum required units, dosage floor, or attendance requirement. Used in clinical protocols and care plan management to ensure patients receive at least the medically necessary level of therapeutic intervention.

session mobilesess_mob

The mobile phone number associated with the patient or contact person for a therapy or treatment session. Used in appointment scheduling, telehealth coordination, and patient outreach workflows to facilitate direct communication regarding upcoming or completed clinical sessions.

session modified bysess_mod_by

The user identifier of the clinician, administrator, or system that last updated the therapy or treatment session record. Supports audit trail requirements and accountability in clinical data governance by tracking which user made the most recent change to the session record.

session modified datesess_mod_dt

The calendar date on which a therapy or treatment session record was most recently updated in the clinical system. Used in audit logging, data reconciliation, and change tracking to establish a chronological history of record modifications for compliance and data integrity purposes.

session modified timesess_mod_tm

The timestamp indicating the exact time a therapy or treatment session record was last modified. Combined with the modified date to provide precise audit trail documentation, supporting regulatory compliance, data governance, and conflict resolution in concurrent clinical data environments.

PreviousPage 635 of 806Next