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 ratioonc_ratio

Calculated proportional value used in cancer care analytics, such as lymph node involvement ratio, tumor-to-normal tissue ratio, or dose-to-volume ratios in radiation oncology. Supports staging accuracy, treatment planning decisions, and clinical outcome measurement in oncology data systems.

oncology reasononc_rsn

The coded or free-text explanation associated with a cancer specialty care decision, claim denial, prior authorization determination, or treatment modification. Stored in EHR clinical documentation, utilization management systems, and claims adjudication platforms to support audit trails and oncology care justification workflows.

oncology received dateonc_rcvd_dt

Date on which an oncology-related document, referral, specimen, or authorization request was received by the treating facility or cancer center. Used in cancer care coordination workflows to measure turnaround times, referral lag, and compliance with timely care standards.

oncology referenceonc_ref

An external pointer or cross-reference linking a cancer specialty care record to related data sources such as oncology clinical trial identifiers, NCCN guideline references, prior authorization numbers, or NPI provider identifiers. Used in EHR systems, claims platforms, and oncology registry databases to maintain data traceability and interoperability.

oncology resolution dateonc_resol_dt

Date on which a cancer-related condition, symptom, adverse event, or treatment episode was formally resolved or closed. Used in oncology clinical records to calculate episode duration, track remission timelines, and support longitudinal cancer registry reporting and survivorship documentation.

oncology respirationonc_resp

Respiratory rate measurement recorded during oncology patient encounters, expressed as breaths per minute. Captured as a vital sign in cancer care settings to monitor treatment tolerance, detect pulmonary toxicities from chemotherapy or immunotherapy, and assess overall patient stability during visits.

oncology resultonc_rslt

The clinical outcome or diagnostic finding from a cancer-related test, treatment, or procedure, stored in EHR and tumor registry systems. Includes pathology findings, tumor marker values, and treatment response assessments used for staging, care planning, and quality reporting.

oncology review systemsonc_ros

Documents the body systems reviewed during a cancer specialty clinical encounter, such as respiratory, cardiovascular, or gastrointestinal. Used in oncology EHR documentation to support medical decision-making, treatment planning, and clinical note completeness for cancer patients.

oncology revisiononc_rev

Version or iteration number indicating updates made to an oncology treatment plan, pathology report, staging determination, or clinical protocol. Tracks changes over the course of cancer care to maintain audit trails and ensure clinical teams reference the most current approved documentation.

oncology riskonc_rsk

Clinically assessed risk level assigned to a cancer patient based on tumor characteristics, genetic markers, comorbidities, and treatment history. Used in oncology care management to stratify patients into low, intermediate, or high-risk categories for treatment intensity, surveillance frequency, and clinical trial eligibility.

oncology routeonc_rte

Documented administration pathway for cancer therapies, including intravenous, oral, subcutaneous, intrathecal, or topical delivery methods. Critical in oncology pharmacy and infusion center records for chemotherapy protocol compliance, dosing safety verification, and treatment session documentation.

oncology scoreonc_scr

A calculated numeric rating derived from cancer-specific clinical assessments, such as ECOG performance status, Gleason score, or genomic risk scores, recorded in EHR and oncology registry systems. Used to guide treatment decisions, stratify patient risk, and support value-based oncology programs.

oncology sequenceonc_seq

An ordering number assigned to cancer diagnoses or treatments within a patient's history, used in tumor registries and EHR systems to distinguish primary from subsequent malignancies. Critical for SEER reporting, treatment timeline reconstruction, and multi-cancer patient analytics.

oncology service dateonc_svc_dt

The actual calendar date on which a cancer-related clinical service was rendered to a patient, captured in EHR, claims, and oncology registry systems. Used to sequence chemotherapy cycles, radiation sessions, and surgical events for longitudinal treatment analysis.

oncology severityonc_sev

A coded indicator representing the clinical seriousness or staging level of a cancer diagnosis, sourced from EHR tumor registries, pathology reports, and claims data. Informs risk stratification models, care management prioritization, and oncology quality measure reporting.

oncology sexonc_sex

Patient's biological sex as recorded in oncology clinical and administrative records. Used in cancer registry submissions, hormonal therapy eligibility, sex-specific cancer screening protocols, and epidemiological reporting to analyze incidence and treatment outcome differences across sexes.

oncology sourceonc_src

The originating system, provider, or document from which cancer-related clinical data was captured, such as EHR, tumor registry, pathology lab, or claims feed. Critical for data lineage tracking, deduplication logic, and oncology analytics pipeline validation.

oncology start dateonc_start_dt

The date marking the initiation of a cancer treatment episode, regimen, or clinical program, recorded in EHR oncology modules and claims systems. Used to calculate treatment duration, time-to-treatment metrics, and chemotherapy cycle alignment in oncology data pipelines.

oncology start timeonc_start_tm

Recorded clock time marking the beginning of an oncology treatment session, procedure, or clinical event, such as chemotherapy infusion start or radiation delivery initiation. Used in oncology scheduling systems and infusion center workflows for treatment duration tracking and nursing documentation.

oncology stateonc_st

U.S. state or territory associated with a cancer patient's residence, treating facility, or referring provider. Used in oncology data systems for geographic analysis of cancer incidence, state-specific registry reporting, Medicaid billing jurisdiction, and population health program targeting.

PreviousPage 458 of 806Next