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 created dateonc_crtd_dt

Timestamp marking when a cancer specialty care record was initially created in an oncology EHR, tumor registry, or claims system. Critical for data engineers performing audit trails, data lineage tracking, and incremental ETL loads to ensure accurate capture of new oncology records across source system integrations.

oncology created timeonc_crtd_tm

Timestamp recording the exact date and time an oncology record was first entered into the clinical or administrative system. Used for audit logging, data lineage tracking, and workflow sequencing in cancer care documentation, ensuring accurate chronological ordering of treatment records and clinical events.

oncology creatinineonc_cr

Serum creatinine lab value recorded in the context of oncology care, reflecting renal filtration function. Critical for dosing nephrotoxic chemotherapy agents such as cisplatin or carboplatin, assessing eligibility for contrast imaging studies, and monitoring kidney function throughout cancer treatment cycles.

oncology dateonc_dt

Generic calendar date value associated with a cancer specialty care event or record within oncology EHR, claims, or tumor registry systems. Data engineers use this field to establish timelines for diagnosis, treatment initiation, or administrative events when a more specific date attribute is not available in source data.

oncology datetimeonc_dttm

Combined date and time timestamp associated with a cancer specialty care event recorded in oncology EHR or clinical data systems. Used by data engineers to enable precise sequencing of treatment events, lab results, and clinical encounters, supporting time-series analysis and oncology care pathway reconstruction.

oncology dea numberonc_dea_nbr

Drug Enforcement Administration registration number assigned to a licensed prescriber or facility authorized to prescribe controlled substances in oncology care. Required for documenting prescriptions of opioid analgesics used in cancer pain management and for regulatory compliance in oncology pharmacy workflows.

oncology death dateonc_death_dt

Calendar date recording patient mortality associated with a cancer diagnosis or treatment episode, sourced from oncology EHR, tumor registry, or vital statistics feeds. Used by data engineers to calculate survival metrics, link to death records, and support oncology outcomes reporting and clinical quality measure calculations.

oncology deductible amountonc_ded_amt

Dollar amount the patient must pay out-of-pocket for oncology services before insurance coverage begins. Tracked in cancer care financial counseling and claims processing to assess patient financial burden, particularly relevant given high cumulative costs of chemotherapy, radiation, and oncology surgical episodes.

oncology deleted dateonc_del_dt

Date on which an oncology record was marked as deleted within the clinical or administrative system. Used for data governance, audit trail maintenance, and regulatory compliance in cancer data management, enabling tracking of record lifecycle changes without permanent removal of historical oncology information.

oncology deleted indicatoronc_del_ind

Boolean flag indicating whether an oncology record has been logically deleted from active use in the clinical or administrative system. Enables soft-deletion practices in cancer data management, preserving historical records for audit and compliance purposes while excluding them from active clinical and operational reporting.

oncology descriptiononc_desc

Textual explanation associated with a cancer specialty care record, diagnosis code, procedure, or treatment protocol within oncology EHR and tumor registry systems. Used by data engineers to populate data dictionaries, support code-to-description lookups, and provide human-readable context in oncology analytics dashboards and reports.

oncology detailonc_dtl

Granular supplemental information associated with a cancer specialty care record in oncology EHR, claims, or tumor registry systems, such as tumor characteristics, staging specifics, or treatment protocol details. Used by data engineers to enrich core oncology datasets for clinical analytics, quality reporting, and precision medicine initiatives.

oncology discharge dateonc_dsch_dt

The date a patient was formally released from a cancer specialty care facility or oncology inpatient unit, captured in EHR and claims systems. Used to measure length of stay, trigger post-discharge follow-up workflows, and support oncology outcomes reporting.

oncology due dateonc_due_dt

Date by which a payment, authorization, task, or scheduled action related to an oncology service is expected to be completed. Used in cancer care revenue cycle management and care coordination workflows to track billing deadlines, prior authorization expirations, or follow-up appointment scheduling obligations.

oncology durationonc_dur

Measured length of time associated with an oncology treatment, procedure, symptom, or care episode. Used to document infusion administration times, radiation session lengths, or symptom persistence periods, supporting clinical protocol adherence monitoring and outcomes analysis across cancer treatment programs.

oncology effective dateonc_eff_dt

The date on which a cancer specialty care record, authorization, benefit coverage, or treatment protocol becomes active within oncology EHR, PBM, or claims systems. Used by data engineers to apply date-range filtering, validate coverage periods, and join oncology records to member eligibility during ETL processing.

oncology emailonc_eml

Electronic mail address associated with an oncology provider, care coordinator, or patient contact stored in oncology EHR or care management systems. Used by data engineers to support provider directory integrations, patient outreach workflows, and communication audit records within cancer specialty care data pipelines.

oncology emergency indicatoronc_emerg_ind

Flag identifying that an oncology encounter or service was rendered under emergent or urgent circumstances, such as febrile neutropenia, oncologic emergency, or acute treatment toxicity. Used for clinical triage prioritization, emergency department utilization reporting, and care intensity classification in cancer population health analytics.

oncology end dateonc_end_dt

Date marking the completion or termination of a cancer specialty care episode, treatment protocol, authorization, or record validity period within oncology EHR and claims systems. Used by data engineers to define treatment duration windows, close open care periods, and support longitudinal oncology episode-of-care analytics.

oncology end timeonc_end_tm

The timestamp marking the completion of a cancer specialty care encounter, procedure, or treatment session. Used in oncology clinical systems to calculate visit duration, track infusion therapy completion, and support scheduling workflows for chemotherapy and radiation appointments.

PreviousPage 454 of 806Next