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

obstetric typeob_typ

A coded classification identifying the category of an obstetric encounter, service, or episode in EHR and claims systems. Common values include vaginal delivery, cesarean section, antepartum, or postpartum, used for DRG grouping, maternal quality measure stratification, and obstetric claims adjudication workflows.

obstetric updated dateob_upd_dt

Timestamp indicating the most recent modification made to an obstetric clinical record, care plan, or maternal health data entry. Used for audit trail maintenance and data integrity validation to ensure that the most current prenatal or delivery-related information is reflected in downstream reporting systems.

obstetric urgencyob_urg

Clinical indicator reflecting the time-sensitivity level assigned to an obstetric encounter, procedure, or intervention request. Used in labor and delivery and prenatal care workflows to prioritize maternal care needs, triage decisions, and resource allocation based on the acuity of the obstetric condition presented.

obstetric valueob_val

A discrete clinical or administrative data point captured within an obstetric record in EHR or perinatal registry systems. Represents measurements such as gestational age, fundal height, fetal heart rate, or parity counts, supporting prenatal assessment documentation and maternal outcomes analysis in data pipelines.

obstetric versionob_ver

Sequential version number assigned to an obstetric clinical record or care plan to track revisions over time. Used in maternal health data systems to distinguish between iterations of a prenatal care document or obstetric protocol, supporting accurate version control and historical record comparison.

obstetric zipob_zip

Five or nine-digit postal code associated with a pregnant patient's residence or the obstetric care facility location. Used in maternal health reporting and population analytics to identify geographic patterns in prenatal care access, birth outcomes, and obstetric service utilization across communities.

oncology active indicatoronc_actv_ind

Binary flag denoting whether an oncology patient record, treatment plan, or cancer diagnosis is currently active within the clinical data system. Used in cancer registry and care management workflows to filter active cases from resolved or historical oncology records for treatment monitoring and reporting.

oncology active statusonc_actv_sts

Categorical status value indicating the current activity state of an oncology case, treatment protocol, or cancer patient enrollment. Used in tumor registry and oncology care management systems to distinguish patients currently undergoing treatment from those in remission, surveillance, or discharged from active cancer care.

oncology addressonc_addr

The physical location of a cancer specialty care facility or provider, stored in EHR and claims systems to route referrals, coordinate care, and validate network participation. Used in provider directories and claims adjudication to confirm oncology service delivery sites.

oncology adjustment amountonc_adj_amt

Dollar value representing a financial modification applied to an oncology claim or billing transaction, such as a contractual write-off, coordination of benefits reduction, or payment correction. Used in oncology revenue cycle management to reconcile billed charges against actual reimbursement for cancer-related services.

oncology admission dateonc_admn_dt

The date a patient was formally admitted to a cancer specialty care facility or oncology unit, recorded in EHR and claims systems. Used to calculate length of stay, coordinate chemotherapy or radiation scheduling, and support oncology episode-of-care analytics.

oncology ageonc_age

Patient's age at the time of oncology diagnosis, treatment initiation, or clinical encounter. Captured in cancer registry and oncology clinical data systems to support age-stratified outcomes analysis, treatment protocol eligibility determination, and epidemiological reporting on cancer incidence across age demographics.

oncology allowed amountonc_alwd_amt

Maximum dollar amount a payer will reimburse for a covered oncology service based on the contracted fee schedule or benefit plan terms. Used in oncology claims adjudication to determine patient cost-sharing obligations and provider reimbursement for chemotherapy, radiation, surgical oncology, and related cancer treatments.

oncology amountonc_amt

The monetary value associated with cancer specialty care services, including chemotherapy, radiation, and immunotherapy charges. Captured in EHR billing modules and medical claims systems (837P/837I) to track oncology-specific cost data for financial reporting and analytics.

oncology approval statusonc_appr_sts

Current authorization state of an oncology treatment request, prior authorization, or clinical protocol submission. Used in oncology utilization management workflows to track whether cancer treatments such as chemotherapy regimens or targeted therapies have received payer or clinical committee approval before services are rendered.

oncology approved byonc_appr_by

Identifier of the clinician, medical director, or administrative user who granted authorization for an oncology treatment plan, prior authorization request, or clinical protocol. Used in oncology utilization management and audit workflows to maintain accountability and traceability of approval decisions for cancer care services.

oncology arrival timeonc_arrv_tm

Recorded time at which an oncology patient arrived for a scheduled or unscheduled clinical encounter, such as an infusion center visit or outpatient cancer treatment appointment. Used in oncology operations and scheduling systems to measure patient throughput, wait times, and treatment administration timeliness.

oncology arrived dateonc_arrv_dt

Calendar date on which an oncology patient arrived at a treatment facility for a cancer-related clinical encounter or infusion therapy session. Used in oncology scheduling and clinical data systems to establish encounter timelines, track treatment adherence, and support longitudinal cancer care reporting.

oncology assessmentonc_asmt

Clinician-documented evaluation of an oncology patient's condition, treatment response, or disease progression captured at a cancer care encounter. Includes observations on tumor status, side effect severity, performance score, and clinical findings used to inform ongoing cancer treatment planning and protocol adjustments.

oncology balanceonc_bal

The outstanding financial balance remaining for cancer specialty care services after payments, adjustments, and remittances have been applied. Used in claims adjudication and accounts receivable systems to monitor unpaid oncology charges across payers and patient responsibility buckets.

PreviousPage 452 of 806Next