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 due dateortho_due_dt

The target or deadline date associated with an orthopedic clinical task, follow-up appointment, or administrative obligation. Used in musculoskeletal care management to ensure timely post-operative check-ins, imaging reviews, physical therapy referrals, and compliance with treatment protocols.

orthopedic durationortho_dur

The measured length of time associated with an orthopedic event, such as surgical procedure time, anesthesia duration, rehabilitation program length, or immobilization period. Supports clinical outcome analysis, resource utilization reporting, and efficiency benchmarking in musculoskeletal care delivery.

orthopedic emailortho_eml

The electronic mail address associated with a patient, clinician, or facility contact within an orthopedic record. Used to facilitate appointment reminders, post-operative care communications, referral coordination, and secure messaging between musculoskeletal care team members and patients.

orthopedic emergency indicatorortho_emerg_ind

A binary flag identifying whether an orthopedic encounter or procedure was classified as an emergency, such as acute fracture, traumatic joint dislocation, or spinal cord injury. Used for triage prioritization, resource allocation, and distinguishing emergent from elective musculoskeletal care in reporting.

orthopedic end dateortho_end_dt

The date marking the conclusion of an orthopedic treatment episode, authorization period, or clinical program. Used to define the boundaries of musculoskeletal care timelines, close active records, and support outcomes analysis for procedures such as physical therapy courses or surgical recovery plans.

orthopedic end timeortho_end_tm

The time at which an orthopedic procedure, clinical encounter, or scheduled event concluded. Used alongside the end date to calculate procedure duration, measure operating room utilization, and support accurate surgical case documentation within musculoskeletal care and perioperative data systems.

orthopedic entered byortho_ent_by

Identifies the user who entered or last updated the orthopedic clinical record. Captures the username or staff ID responsible for data entry in musculoskeletal care documentation, supporting audit trails and accountability in orthopedic EHR workflows.

orthopedic ethnicityortho_ethn

Records the self-reported ethnic background of a patient receiving orthopedic care. Used in musculoskeletal clinical and population health reporting to monitor care equity, identify disparities in orthopedic outcomes, and meet regulatory demographic reporting requirements.

orthopedic expiration dateortho_exp_dt

Captures the date on which an orthopedic-related record, authorization, referral, or device prescription becomes invalid. Used to enforce validity periods in musculoskeletal care management workflows and ensure expired authorizations are not applied to active orthopedic treatment plans.

orthopedic external identifierortho_ext_id

Stores the reference identifier assigned by an external system, such as a referring hospital, imaging center, or payer, for an orthopedic case or patient record. Enables cross-system tracking and reconciliation of musculoskeletal care episodes across integrated healthcare platforms.

orthopedic faxortho_fax

Records the facsimile contact number associated with an orthopedic practice, specialist, or facility. Used to route referrals, prior authorization requests, and clinical documentation for musculoskeletal care coordination between ordering providers and orthopedic specialists.

orthopedic feeortho_fee

Represents the charge amount associated with an orthopedic procedure, consultation, or service rendered. Used in musculoskeletal billing workflows to record the billed amount prior to adjudication, supporting claims processing and orthopedic revenue cycle management.

orthopedic first nameortho_first_nm

Stores the given name of a patient or clinician associated with an orthopedic record. Used in musculoskeletal care documentation to identify individuals in a human-readable format across clinical, scheduling, and referral management workflows.

orthopedic flagortho_flg

A binary indicator used to mark a patient record or encounter as having a specific orthopedic condition, risk, or status. Applied in musculoskeletal care workflows to trigger clinical alerts, filter populations for orthopedic care management, or denote special handling requirements.

orthopedic full nameortho_full_nm

Stores the complete name, including first and last name, of a patient or clinician associated with an orthopedic record. Used across musculoskeletal care documentation, correspondence, and reporting workflows to present a fully formatted, human-readable identifier.

orthopedic genderortho_gndr

Records the gender identity or biological sex of a patient receiving orthopedic care. Used in musculoskeletal clinical documentation, demographic reporting, and outcomes analysis where gender may be a relevant factor in orthopedic risk stratification or treatment planning.

orthopedic glucoseortho_gluc

Records a patient's blood glucose measurement captured in the context of an orthopedic evaluation or procedure. Relevant to musculoskeletal care as elevated glucose levels affect surgical outcomes, wound healing, and infection risk in orthopedic interventions such as joint replacement.

orthopedic hemoglobinortho_hgb

Records the hemoglobin level of a patient within an orthopedic care context. Clinically relevant for musculoskeletal surgical planning and postoperative monitoring, as hemoglobin values inform transfusion thresholds and anemia management decisions surrounding orthopedic procedures.

orthopedic history present illnessortho_hpi

Contains the structured narrative describing the onset, duration, and progression of a patient's current musculoskeletal complaint as documented during an orthopedic encounter. Forms a core component of the orthopedic clinical note and informs diagnosis and treatment planning.

orthopedic identifierortho_id

The primary unique key assigned to an orthopedic record, case, or patient encounter within the clinical or administrative system. Used to link musculoskeletal care records across referrals, imaging orders, surgical scheduling, and billing workflows throughout the orthopedic episode of care.

PreviousPage 477 of 806Next