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

orthopedic noteortho_nt

Free-text annotation associated with an orthopedic specialist's record, capturing supplemental clinical, administrative, or credentialing information not accommodated by structured fields. Used in provider management systems to document exceptions, clarifications, or special considerations in musculoskeletal care contexts.

orthopedic numberortho_nbr

A system-assigned or externally defined reference number uniquely identifying an orthopedic specialist within an administrative or clinical platform. Used for provider lookup, claims processing, and cross-system referencing in musculoskeletal specialty care and payer enrollment workflows.

orthopedic onset dateortho_onset_dt

The date on which a patient's musculoskeletal condition, injury, or symptoms first began, as documented by an orthopedic specialist. Critical for determining medical necessity, coordinating workers' compensation claims, and establishing treatment timelines in orthopedic clinical and billing records.

orthopedic oxygen saturationortho_o2sat

The measured peripheral blood oxygen saturation level recorded during an orthopedic patient encounter, expressed as a percentage. Captured as a perioperative or post-surgical vital sign to monitor patient stability during musculoskeletal procedures, rehabilitation, or inpatient orthopedic care episodes.

orthopedic paid amountortho_pd_amt

The dollar amount reimbursed by a payer to an orthopedic specialist or facility for musculoskeletal services rendered. Recorded in claims adjudication and remittance systems to reflect actual payment after contractual adjustments, patient cost-sharing, and benefit plan calculations have been applied.

orthopedic paid dateortho_pd_dt

The date on which payment was issued to an orthopedic specialist or facility for musculoskeletal services rendered. Recorded in claims adjudication and remittance systems to support accounts receivable reconciliation, payment cycle reporting, and payer performance tracking.

orthopedic parentortho_prnt

Identifies the hierarchical superior record in an orthopedic specialty taxonomy, linking a sub-specialty or procedure category to its parent classification. Used in clinical data systems to organize musculoskeletal care pathways, referral networks, and specialty billing structures.

orthopedic percentageortho_pct

Captures a proportional ratio specific to orthopedic specialty data, such as implant success rates, surgical complication rates, or cost-sharing allocations for musculoskeletal procedures. Used in outcomes reporting, quality benchmarking, and orthopedic value-based care program analytics.

orthopedic periodortho_prd

Defines the discrete time interval associated with orthopedic specialty activity, such as a post-operative recovery window, a physical therapy authorization span, or a musculoskeletal condition monitoring cycle used in clinical and claims reporting contexts.

orthopedic phoneortho_ph

Stores the direct telephone contact number for an orthopedic specialty practice, clinic, or care coordination unit. Used in patient scheduling systems, referral management workflows, and care team communication directories for musculoskeletal service coordination.

orthopedic preferred nameortho_pref_nm

The standardized display name for an orthopedic specialty, sub-specialty, or procedure type as shown in patient-facing portals, clinical documentation, and reporting interfaces. Ensures consistent labeling of musculoskeletal services across health information systems.

orthopedic priceortho_prc

Records the cost amount associated with an orthopedic service, implant, or procedure, including negotiated rates, fee schedule amounts, or list prices for musculoskeletal interventions. Used in claims adjudication, contracting, and orthopedic episode-of-care cost analysis.

orthopedic primary indicatorortho_prim_ind

A boolean or coded flag designating whether an orthopedic condition, procedure, or diagnosis is the primary focus of a clinical encounter or claim. Used to distinguish principal musculoskeletal diagnoses from secondary findings in claims processing and outcomes tracking.

orthopedic priorityortho_prty

Indicates the urgency or clinical importance ranking assigned to an orthopedic case, referral, or procedure request. Used in surgical scheduling, prior authorization queues, and musculoskeletal care management systems to triage patients by medical necessity and acuity.

orthopedic procedure dateortho_proc_dt

Records the date on which an orthopedic surgical or clinical procedure was performed, such as joint replacement, fracture repair, or arthroscopy. Used in claims adjudication, surgical registry reporting, and post-operative outcomes tracking for musculoskeletal care episodes.

orthopedic pulseortho_pulse

Captures the patient heart rate measurement recorded during an orthopedic clinical encounter, pre-operative assessment, or post-surgical monitoring event. Used in perioperative documentation and musculoskeletal patient vital sign records to support anesthesia and surgical safety protocols.

orthopedic quantityortho_qty

Records the numeric count or volume associated with orthopedic services or supplies, such as the number of implant components, physical therapy units authorized, or procedures billed. Used in claims processing, inventory management, and orthopedic utilization reporting.

orthopedic raceortho_race

Captures the self-reported racial identity of a patient receiving orthopedic care, used in musculoskeletal health equity analysis, orthopedic outcomes stratification, and federal reporting requirements to identify and address disparities in bone and joint disease treatment access.

orthopedic rangeortho_rng

Defines the minimum and maximum boundaries for a measured orthopedic clinical value, such as acceptable joint range-of-motion scores, implant sizing parameters, or post-operative pain scale thresholds used in functional outcome assessments and clinical decision support.

orthopedic rateortho_rt

Specifies a per-unit price or frequency measure for orthopedic services, such as a per-visit reimbursement rate, an implant cost per procedure, or a physical therapy session rate. Used in orthopedic contract negotiations, claims pricing, and specialty care cost modeling.

PreviousPage 479 of 806Next