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 classortho_cls

The classification tier assigned to an orthopedic service, implant, procedure, or patient record, such as elective versus emergent or inpatient versus outpatient. Used in musculoskeletal care management to prioritize resources, apply reimbursement rules, and support utilization reporting.

orthopedic codeortho_cd

A standardized alphanumeric identifier, such as an ICD, CPT, or HCPCS code, representing a specific orthopedic diagnosis, procedure, or service. Used in musculoskeletal claims processing, clinical documentation, and reporting to ensure consistent classification across healthcare systems.

orthopedic commentortho_cmt

A free-text notation entered by a clinician or administrative user to provide supplemental context about an orthopedic encounter, order, or patient record. Used in musculoskeletal workflows to capture nuanced observations, follow-up instructions, or coordination notes not covered by structured fields.

orthopedic completed dateortho_cmpl_dt

The date on which an orthopedic service, procedure, treatment course, or documentation workflow was fully completed. Used in musculoskeletal care management to confirm service delivery, trigger billing events, close open orders, and support outcome measurement timelines.

orthopedic confidential indicatorortho_conf_ind

A flag identifying an orthopedic patient record or encounter as confidential, restricting access based on privacy requirements such as sensitive diagnoses or legal holds. Used in musculoskeletal data systems to enforce role-based access controls and regulatory compliance.

orthopedic countortho_cnt

The total number of orthopedic encounters, procedures, referrals, or related records within a defined population or time period. Used in musculoskeletal utilization analysis, capacity planning, quality reporting, and benchmarking of service volume across orthopedic care programs.

orthopedic countryortho_ctry

The country associated with an orthopedic record, such as a patient address, facility location, or referring entity. Used in musculoskeletal care data to support international patient tracking, cross-border referrals, and geographic reporting within orthopedic clinical systems.

orthopedic created byortho_crtd_by

The unique identifier of the user who initially created an orthopedic record in the clinical system. Captures the responsible clinician or administrator for audit trail purposes, supporting accountability and data governance within musculoskeletal care workflows and EHR documentation.

orthopedic created dateortho_crtd_dt

The calendar date on which an orthopedic record was first entered into the clinical system. Used for audit tracking, data lineage, and longitudinal analysis of musculoskeletal case management, helping establish the timeline of patient care and administrative documentation.

orthopedic created timeortho_crtd_tm

The timestamp indicating when an orthopedic record was first created in the clinical system. Combined with the created date, this supports precise audit logging, workflow sequencing, and chronological tracking of musculoskeletal care documentation and clinical data entry events.

orthopedic creatinineortho_cr

The serum creatinine lab value documented within an orthopedic patient record, used to assess renal function prior to imaging contrast administration, anesthesia planning, or NSAID prescribing. Critical for pre-surgical risk stratification in musculoskeletal and joint replacement care.

orthopedic dateortho_dt

A general-purpose date field associated with an orthopedic encounter, procedure, or clinical event. Captures key temporal milestones in musculoskeletal care, such as appointment dates, treatment dates, or evaluation dates, supporting scheduling, reporting, and longitudinal outcome tracking.

orthopedic datetimeortho_dttm

A combined date and time stamp associated with an orthopedic clinical event, procedure, or system transaction. Enables precise chronological sequencing of musculoskeletal care activities, supporting surgical scheduling, real-time documentation workflows, and time-sensitive clinical decision tracking.

orthopedic dea numberortho_dea_nbr

The Drug Enforcement Administration registration number associated with an orthopedic prescriber, used to authorize and track controlled substance prescriptions such as opioids in post-surgical or chronic musculoskeletal pain management. Required for regulatory compliance and prescription monitoring programs.

orthopedic death dateortho_death_dt

The recorded date of death for a patient within an orthopedic clinical record. Used to close active treatment episodes, update longitudinal musculoskeletal care histories, and support mortality outcome analysis in joint replacement, trauma, and spinal surgery patient populations.

orthopedic deleted dateortho_del_dt

The date on which an orthopedic record was flagged or marked as deleted within the clinical system. Supports data lifecycle management and audit compliance by preserving a historical marker of when musculoskeletal records were inactivated without permanent removal from the database.

orthopedic deleted indicatorortho_del_ind

A flag denoting whether an orthopedic record has been logically deleted from the active dataset. Allows musculoskeletal care systems to retain historical data for audit and reporting purposes while excluding inactive or erroneous records from operational clinical views and analytics workflows.

orthopedic descriptionortho_desc

A free-text or coded narrative describing an orthopedic procedure, diagnosis, device, or clinical finding in human-readable format. Used to communicate musculoskeletal condition details across care teams, support clinical documentation, and populate patient-facing summaries and referral correspondence.

orthopedic detailortho_dtl

Granular clinical or administrative information associated with an orthopedic record, capturing specifics such as procedure parameters, implant specifications, or visit notes. Provides supporting context beyond summary-level fields within musculoskeletal care documentation and surgical planning systems.

orthopedic discharge dateortho_dsch_dt

The date a patient was formally discharged following an orthopedic inpatient stay or surgical procedure. Used to calculate length of stay, trigger post-discharge care plans, and measure recovery milestones for musculoskeletal conditions including joint replacement, fracture repair, and spinal surgery.

PreviousPage 476 of 806Next