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 entered byonc_ent_by

The username or identifier of the clinical staff member who entered or last modified a cancer specialty care record. Used in oncology data systems to maintain audit trails, ensure clinical documentation accountability, and support quality review processes within tumor registry and EHR workflows.

oncology ethnicityonc_ethn

The patient's self-reported ethnic background recorded within a cancer specialty care encounter. Used in oncology registries and clinical systems to support cancer disparity research, population health stratification, and compliance with tumor registry reporting standards such as SEER and NAACCR requirements.

oncology expiration dateonc_exp_dt

Date after which a cancer specialty care authorization, benefit, formulary exception, or protocol record is no longer valid within oncology EHR, PBM, or claims systems. Used by data engineers to enforce validity constraints during ETL processing and identify expired oncology records requiring renewal or suppression in reporting datasets.

oncology external identifieronc_ext_id

A reference identifier assigned by an external system, such as a referring facility, cancer registry, or health information exchange, used to link a cancer specialty care record across disparate healthcare platforms. Supports interoperability and longitudinal patient tracking across oncology care networks.

oncology faxonc_fax

The facsimile number associated with an oncology care entity, such as a cancer center, treating physician, or referring practice. Used in clinical workflows to transmit pathology reports, treatment summaries, prior authorizations, and referral documentation between oncology care team members.

oncology feeonc_fee

The service charge amount associated with a cancer specialty care encounter, procedure, or treatment. Used in oncology billing workflows to capture costs for chemotherapy administration, radiation therapy sessions, surgical oncology procedures, and related clinical services submitted on professional or facility claims.

oncology first nameonc_first_nm

The given or first name of a patient or clinical contact associated with a cancer specialty care record. Used in oncology systems to display patient identity, support accurate record matching, and ensure proper attribution in tumor registry documentation, care coordination, and clinical correspondence.

oncology flagonc_flg

Binary or categorical indicator applied to a cancer specialty care record within oncology EHR, claims, or tumor registry systems to denote a specific condition, data quality issue, or processing status. Used by data engineers to filter, route, or prioritize oncology records during ETL workflows and downstream analytical reporting.

oncology frequencyonc_freq

The administration schedule or dosing interval for a cancer treatment regimen, such as daily, weekly, or every 21 days. Used in oncology clinical systems to define chemotherapy cycle protocols, schedule infusion appointments, and support medication administration records for antineoplastic therapies.

oncology full nameonc_full_nm

The complete name, combining first, middle, and last name components, of a patient or clinical contact within a cancer specialty care record. Used in oncology systems for patient identification, tumor registry submissions, clinical correspondence, and display across care coordination and reporting workflows.

oncology genderonc_gndr

The patient's gender identity or sex classification recorded within a cancer specialty care encounter. Used in oncology clinical systems and tumor registries to support treatment planning, cancer risk stratification, hormone-sensitive malignancy documentation, and compliance with NAACCR and SEER reporting standards.

oncology glucoseonc_gluc

The blood glucose measurement recorded for a patient during a cancer specialty care encounter. Used in oncology clinical systems to monitor metabolic status in patients receiving corticosteroids, targeted therapies, or other treatments known to affect glycemic control during active cancer treatment.

oncology group numberonc_grp_nbr

The insurance group identifier associated with a patient's health plan coverage at the time of a cancer specialty care encounter. Used in oncology billing and prior authorization workflows to verify benefits, process claims for chemotherapy, radiation, and surgical oncology services, and coordinate payer communications.

oncology hemoglobinonc_hgb

The measured hemoglobin concentration in a patient's blood, recorded during a cancer specialty care encounter. Used in oncology clinical systems to assess anemia risk, determine transfusion thresholds, evaluate treatment tolerability for chemotherapy regimens, and monitor hematologic toxicity during active cancer treatment.

oncology history present illnessonc_hpi

A structured narrative documenting the onset, progression, and current status of a patient's cancer diagnosis and related symptoms at the time of an oncology encounter. Used in clinical documentation to capture disease trajectory, treatment response history, and symptom burden for oncologist review and care planning.

oncology identifieronc_id

Unique key value assigned to a cancer specialty care record, patient, provider, or treatment episode within oncology EHR, tumor registry, or claims systems. Used by data engineers as a primary or foreign key to join oncology records across disparate source systems and maintain entity resolution integrity in integrated data warehouses.

oncology indexonc_idx

Numeric or alphanumeric positional value assigned to a cancer specialty care record within an ordered dataset in oncology EHR or tumor registry systems. Used by data engineers to maintain sort order, support array-based data structures, and enable sequential processing of oncology treatment cycles or multi-row clinical event records.

oncology indicatoronc_ind

A boolean flag in claims, EHR, or member enrollment data that identifies whether a record, member, or claim line is associated with a cancer diagnosis or specialty oncology service. Used in PBM and health plan systems to trigger oncology case management workflows and specialty drug benefit rules.

oncology instructiononc_instr

Clinical or administrative guidance text specific to cancer specialty care, including chemotherapy administration protocols, dosing instructions, or prior authorization requirements. Stored in EHR order entry systems and PBM specialty pharmacy platforms to ensure accurate treatment execution and compliance.

oncology keyonc_key

A lookup or reference value used to index or retrieve a specific cancer specialty care record within oncology clinical or administrative systems. Used to link related data entities such as diagnosis codes, treatment protocols, tumor registry entries, and encounter records across oncology data warehouses.

PreviousPage 455 of 806Next