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

organization labelorg_lbl

The human-readable display name or short descriptor assigned to a healthcare organization within administrative and clinical systems. Used in reporting dashboards, provider directories, and member-facing materials to identify facilities, health systems, or affiliated entities in a consistent and recognizable format.

organization procedure dateorg_proc_dt

The date on which a clinical procedure was performed at or attributed to a specific healthcare organization. Used in encounter records, claims processing, and quality reporting systems to align procedure documentation with the responsible facility, supporting reimbursement, outcomes tracking, and regulatory submissions.

organization surgery dateorg_surg_dt

The date on which a surgical procedure was performed at or attributed to a specific healthcare organization. Used in operative records, claims adjudication, and surgical outcomes reporting to associate the procedure with the performing facility and support reimbursement, credentialing, and quality measurement workflows.

orthopedic active indicatorortho_actv_ind

A binary flag indicating whether an orthopedic case, treatment plan, or patient record related to musculoskeletal care is currently active within the clinical system. Used in care management and clinical data platforms to filter active orthopedic cases for follow-up, reporting, and care coordination purposes.

orthopedic active statusortho_actv_sts

The current activity state of an orthopedic case or musculoskeletal treatment episode, such as active, inactive, or closed. Used in specialty care management systems to track the lifecycle of orthopedic treatment plans, support caseload management, and generate accurate reporting on open versus resolved musculoskeletal conditions.

orthopedic admission dateortho_admn_dt

The date on which a patient was admitted to a healthcare facility specifically for orthopedic or musculoskeletal treatment, such as joint replacement or fracture repair. Used in inpatient encounter records and surgical scheduling systems to establish the start of an orthopedic stay and support length-of-stay and outcomes analysis.

orthopedic ageortho_age

The age of a patient at the time of an orthopedic encounter or assessment, recorded in years. Used in musculoskeletal clinical workflows to support age-appropriate treatment planning, surgical risk stratification, and outcomes tracking across orthopedic care episodes.

orthopedic allowed amountortho_alwd_amt

The maximum dollar amount a payer will reimburse for an orthopedic procedure or service after applying contractual adjustments. Used in claims processing to calculate member cost-sharing obligations such as copays, coinsurance, and deductibles for musculoskeletal services.

orthopedic amountortho_amt

The monetary value associated with an orthopedic service, procedure, or claim transaction. Captures billed, paid, or adjusted financial figures tied to musculoskeletal care, supporting cost analysis, reimbursement reconciliation, and orthopedic service line financial reporting.

orthopedic approved byortho_appr_by

The identifier or name of the clinician, supervisor, or administrative user who authorized an orthopedic order, referral, treatment plan, or documentation entry. Used in musculoskeletal care workflows to maintain accountability and audit trails for clinical decisions.

orthopedic arrival timeortho_arrv_tm

The recorded time at which a patient arrived for a scheduled or unscheduled orthopedic appointment or procedure. Used in musculoskeletal care operations to measure wait times, track punctuality, and support scheduling efficiency and patient flow analysis.

orthopedic arrived dateortho_arrv_dt

The calendar date on which a patient arrived for an orthopedic visit, procedure, or surgical episode. Used in musculoskeletal care settings to establish encounter timelines, support scheduling records, and enable date-based reporting on orthopedic patient activity.

orthopedic assessmentortho_asmt

The structured or free-text clinical evaluation documented by an orthopedic provider during a patient encounter. Captures the clinician's interpretation of musculoskeletal findings, diagnosis reasoning, functional status, and treatment response as part of the clinical note.

orthopedic birth dateortho_birth_dt

The date of birth of a patient receiving orthopedic care, used to calculate age, verify patient identity, and support demographic analysis. Essential for age-stratified musculoskeletal reporting, pediatric versus adult care distinctions, and longitudinal outcomes research.

orthopedic blood pressureortho_bp

The systolic and diastolic arterial pressure reading recorded during an orthopedic encounter or pre-procedural assessment. Used in musculoskeletal care settings to evaluate surgical readiness, monitor patient safety during rehabilitation, and document vital signs in clinical records.

orthopedic cancelled dateortho_cncl_dt

The date on which an orthopedic appointment, procedure, or surgical case was cancelled. Used in musculoskeletal scheduling systems to track cancellation patterns, measure access to care gaps, and support rescheduling workflows and utilization reporting.

orthopedic categoryortho_cat

The classification grouping assigned to an orthopedic service, condition, or record, such as spine, joint replacement, sports medicine, or trauma. Used to organize musculoskeletal data for specialty-specific reporting, care pathway assignment, and clinical program management.

orthopedic chief complaintortho_cc

The primary musculoskeletal symptom or concern reported by the patient at the start of an orthopedic encounter, such as joint pain, limited range of motion, or fracture. Drives the clinical assessment and documents the patient's presenting reason for seeking orthopedic care.

orthopedic childortho_chld

A subordinate or dependent record linked to a parent orthopedic encounter, order, or referral within a hierarchical data structure. Used in musculoskeletal data systems to represent follow-up visits, sub-procedures, or related care episodes tied to a primary orthopedic record.

orthopedic cityortho_city

The name of the municipality associated with an orthopedic patient's residence, clinic location, or care delivery site. Used in musculoskeletal population health analysis, geographic access reporting, and demographic segmentation of orthopedic patient populations.

PreviousPage 475 of 806Next