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 labelonc_lbl

The human-readable display text associated with a coded value, category, or data element within a cancer specialty care record. Used in oncology clinical and reporting systems to present standardized terminology for tumor staging, treatment protocols, diagnosis classifications, and registry reporting in user interfaces and printed documentation.

oncology languageonc_lang

The preferred spoken or written communication language of a patient receiving cancer specialty care. Used in oncology systems to support interpreter service coordination, patient education material selection, informed consent documentation, and culturally appropriate communication throughout the cancer treatment and survivorship continuum.

oncology last nameonc_last_nm

The family surname of a patient or clinical contact associated with a cancer specialty care record. Used in oncology systems for patient identification, tumor registry submissions, accurate record matching across care episodes, and attribution in clinical correspondence, pathology reports, and treatment documentation.

oncology legal nameonc_legal_nm

The officially registered name of a patient as it appears on government-issued identification, recorded within a cancer specialty care record. Used in oncology systems to ensure accurate identity verification for insurance billing, tumor registry submissions, clinical trial enrollment, and legal medical documentation.

oncology levelonc_lvl

The hierarchical classification position assigned to a cancer specialty care service, diagnosis staging (e.g., TNM Stage I–IV), or benefit tier within a health plan. Used in EHR oncology modules, claims groupers, and utilization management systems to drive authorization rules and reimbursement tiers.

oncology license numberonc_lic_nbr

The state-issued professional license identifier for an oncology clinician, such as a medical oncologist, radiation oncologist, or oncology nurse practitioner. Used in clinical systems to validate practitioner credentials, support billing claim submissions, and ensure regulatory compliance within cancer specialty care documentation.

oncology marital statusonc_mar_sts

Records the legal marital status of a cancer patient at the time of oncology care, such as single, married, divorced, or widowed. Used in oncology clinical documentation to support psychosocial assessments, treatment planning, caregiver identification, and population health reporting for cancer patients.

oncology master identifieronc_mstr_id

The enterprise-wide unique identifier assigned to a cancer patient record that enables consistent linkage across oncology systems, tumor registries, clinical trial databases, and EHR platforms. Ensures accurate patient matching and longitudinal tracking throughout the continuum of cancer care and follow-up.

oncology maximumonc_max

Captures the upper boundary value for a clinical or operational metric within oncology care, such as maximum dosage thresholds for chemotherapy, radiation dose limits, or allowable lab result ranges. Used in treatment protocols and safety checks to prevent adverse events during cancer therapy.

oncology medical record numberonc_mrn

The facility-assigned medical record number uniquely identifying a cancer patient within the oncology care setting. Used to link clinical documentation, tumor registry entries, pathology reports, treatment histories, and billing records to a single patient across oncology encounters and departments.

oncology middle nameonc_mid_nm

Stores the middle name or initial of a cancer patient as recorded in oncology clinical systems. Used to accurately distinguish patients with similar names during identity verification, tumor registry submissions, clinical trial enrollment, and coordination of care across oncology treatment facilities.

oncology minimumonc_min

Captures the lower boundary value for a clinical or operational metric within oncology care, such as minimum absolute neutrophil counts required before chemotherapy administration or minimum dosing thresholds. Used in treatment safety protocols and clinical decision support for cancer therapy management.

oncology mobileonc_mob

Records the mobile phone number for a cancer patient or their designated contact within oncology care systems. Used to facilitate appointment reminders, treatment notifications, telehealth outreach, care coordination communications, and urgent contact during active cancer treatment episodes.

oncology modified byonc_mod_by

Captures the unique identifier of the user who last updated an oncology clinical or administrative record. Used for audit trail compliance, data integrity monitoring, and accountability tracking within oncology information systems, ensuring changes to cancer patient data are attributable and reviewable.

oncology modified dateonc_mod_dt

The timestamp recording the most recent update to a cancer specialty care record within EHR, oncology registry, or claims systems. Critical for data governance and ETL pipeline processing to detect incremental record changes in oncology case management and tumor registry databases.

oncology modified timeonc_mod_tm

Records the precise date and timestamp when an oncology clinical or administrative record was last updated. Used to maintain data integrity, support audit trail requirements, and track the sequence of changes to cancer patient records across oncology EHR and tumor registry systems.

oncology nameonc_nm

The display label or descriptive text identifying a cancer specialty care service, oncology program, drug regimen, or provider name within EHR, claims, or specialty pharmacy systems. Used in reporting interfaces, EOB documents, and oncology registry platforms to present human-readable identifiers.

oncology noteonc_nt

Free-text or structured annotation associated with a cancer specialty care encounter, treatment decision, or claims record. Stored in EHR clinical documentation systems and oncology case management platforms, these notes provide context for treatment rationale, patient response, and care coordination activities.

oncology numberonc_nbr

A numeric reference value assigned to cancer specialty care records, such as oncology case numbers, tumor registry accession numbers, or chemotherapy cycle counts. Used in EHR oncology modules, cancer registry systems, and claims platforms to uniquely identify and sequence treatment episodes.

oncology onset dateonc_onset_dt

Captures the date when a cancer patient's symptoms, diagnosis, or specific condition first presented or began. Used in oncology clinical documentation to establish disease timelines, calculate staging intervals, support epidemiological reporting, and determine treatment urgency for cancer care coordination.

PreviousPage 456 of 806Next