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

oncology oxygen saturationonc_o2sat

Records the peripheral blood oxygen saturation percentage (SpO2) measured for a cancer patient, typically via pulse oximetry. Used in oncology clinical monitoring to assess respiratory status, evaluate treatment-related toxicities, and guide supportive care decisions during chemotherapy or radiation therapy.

oncology paid amountonc_pd_amt

Records the dollar amount paid for oncology services rendered to a cancer patient, reflecting actual reimbursement from insurers, patient payments, or other payers. Used in oncology revenue cycle management to reconcile claims, track financial performance, and analyze cost of cancer care delivery.

oncology paid dateonc_pd_dt

Captures the date on which payment was received or posted for oncology services rendered to a cancer patient. Used in oncology revenue cycle management to track claim reimbursement timelines, monitor payer performance, and reconcile accounts receivable within cancer center financial reporting.

oncology parentonc_prnt

The superior hierarchical relationship linking a cancer specialty care record to its parent entity, such as a primary diagnosis linked to a treatment plan, or a child claim line linked to a parent oncology authorization. Used in EHR data models and claims systems to maintain referential integrity across oncology workflows.

oncology percentageonc_pct

A ratio or proportional value used in cancer specialty care contexts, such as tumor involvement percentage, cost-sharing percentages for oncology benefits, or response rate metrics. Captured in EHR clinical documentation, health plan benefit configuration systems, and oncology outcomes reporting platforms.

oncology periodonc_prd

The defined time span associated with a cancer specialty care treatment cycle, benefit period, or authorization window, such as a 21-day chemotherapy cycle or annual oncology drug benefit limit. Used in EHR scheduling systems, PBM platforms, and utilization management tools to enforce treatment and coverage timelines.

oncology phoneonc_ph

The telephone contact number associated with a cancer specialty care provider, oncology clinic, or patient record within EHR, provider directory, and claims systems. Used by care coordination platforms and specialty pharmacy systems to facilitate communication between oncology care teams, patients, and payers.

oncology planonc_pln

Documents the structured treatment plan developed for a cancer patient, including intended therapies, chemotherapy regimens, radiation protocols, surgical interventions, and supportive care strategies. Used in oncology clinical documentation to guide multidisciplinary care team coordination and track planned versus delivered cancer treatments.

oncology policy numberonc_pol_nbr

Records the health insurance policy number associated with a cancer patient's coverage at the time of oncology services. Used in oncology billing and revenue cycle processes to submit claims, verify benefits, coordinate benefits between payers, and track insurance coverage throughout cancer treatment episodes.

oncology preferred nameonc_pref_nm

Stores the name a cancer patient prefers to be addressed by during oncology care, which may differ from their legal name. Used in patient-facing communications, clinical documentation, and care team interactions to respect patient identity preferences and improve the patient experience in cancer care settings.

oncology priceonc_prc

Records the established charge or cost amount for oncology services, procedures, medications, or treatments provided to a cancer patient. Used in oncology financial management to support charge capture, cost transparency reporting, contract negotiations with payers, and analysis of cancer care expenditures.

oncology primary indicatoronc_prim_ind

A flag designating whether a record represents the primary entry among multiple related oncology records, such as identifying a primary diagnosis, primary insurance, or primary treating oncologist. Used to ensure accurate priority ordering in cancer care documentation, billing workflows, and clinical reporting systems.

oncology priorityonc_prty

The importance or urgency ranking assigned to a cancer specialty care task, prior authorization request, or treatment order within EHR workflow and utilization management systems. Used to triage oncology cases in care management platforms and ensure time-sensitive treatments such as chemotherapy are processed promptly.

oncology procedure dateonc_proc_dt

Records the date on which a specific oncology procedure was performed for a cancer patient, such as chemotherapy administration, biopsy, radiation treatment, or surgical intervention. Used in clinical documentation, tumor registry reporting, billing claims, and treatment timeline analysis for cancer care management.

oncology pulseonc_pulse

Records the heart rate in beats per minute measured for a cancer patient during an oncology encounter or monitoring episode. Used to assess cardiovascular status, detect treatment-related cardiotoxicity from chemotherapy agents, and support clinical decision-making for cancer patients undergoing active therapy or follow-up care.

oncology quantityonc_qty

The count or volume measurement for cancer specialty care services, such as chemotherapy drug units dispensed, number of radiation fractions delivered, or infusion sessions administered. Captured in EHR order management systems, specialty pharmacy dispensing platforms, and claims data for utilization and cost analysis.

oncology raceonc_race

Patient's self-reported racial identity as documented in oncology clinical records. Used in cancer registry reporting, tumor board analysis, and health equity studies to identify disparities in cancer incidence, treatment access, screening rates, and survival outcomes across racial groups.

oncology rangeonc_rng

The minimum and maximum value boundaries applied to cancer specialty care data elements, such as acceptable dosing ranges for chemotherapy regimens, lab value reference ranges for oncology biomarkers, or cost thresholds. Used in EHR clinical decision support rules and claims editing systems to validate oncology data integrity.

oncology rateonc_rt

The unit price or reimbursement rate applied to cancer specialty care services, including chemotherapy drug costs per milligram, infusion facility rates, or contracted oncology fee schedule amounts. Used in claims adjudication engines, PBM pricing tables, and provider contract management systems to calculate oncology reimbursements.

oncology ratingonc_rtg

Standardized assessment score assigned to a cancer patient's condition, performance status, or treatment response. Commonly references ECOG, Karnofsky, or tumor grade scales used in oncology clinical workflows to guide treatment planning, protocol eligibility, and prognosis evaluation.

PreviousPage 457 of 806Next