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

observation valueobs_val

The discrete numeric, coded, or textual result of a clinical measurement or diagnostic test, such as a blood glucose reading of 110 mg/dL. Used in EHR, lab, and interoperability systems to capture and transmit patient findings in structured formats like HL7 ORU or FHIR Observation resources.

observation versionobs_ver

Identifies the specific version number of a clinical observation record, distinguishing between original entries and subsequent revisions within a versioned data model. Supports regulatory audit requirements, clinical data lineage tracking, and ensures downstream systems consume the correct iteration of an amended observation.

observation zipobs_zip

Stores the five or nine digit US postal code associated with the facility or care site where a clinical observation was recorded. Used for geographic analysis of clinical findings, population health segmentation, epidemiological reporting, and linking observation data to regional demographic and socioeconomic datasets.

obstetric active indicatorob_actv_ind

Binary flag indicating whether an obstetric care episode or pregnancy record is currently active within the clinical system. Used to filter active pregnancies from historical or closed records in maternal health tracking, prenatal visit scheduling, and labor and delivery workflows.

obstetric active statusob_actv_sts

Categorical status value representing the current activity state of an obstetric care episode, such as active, inactive, or closed. Supports maternal care coordination by identifying pregnancies currently under clinical management versus those that have concluded through delivery, loss, or transfer of care.

obstetric admission dateob_admn_dt

The calendar date a patient was admitted to a hospital or birthing facility for pregnancy-related care, recorded in EHR and claims systems. Critical for calculating length of stay, determining DRG assignment for obstetric encounters, and tracking maternal care timelines in perinatal data analytics.

obstetric ageob_age

The maternal patient age at the time of obstetric care encounter or pregnancy registration. Used in risk stratification for prenatal care, as maternal age is a clinically significant factor in identifying high-risk pregnancies, screening thresholds, and appropriate care pathways for both mother and fetus.

obstetric allowed amountob_alwd_amt

The maximum reimbursable dollar amount approved by the payer for obstetric services rendered, including prenatal visits, labor and delivery, and postpartum care. Used in claims adjudication to determine payment after applying contractual adjustments, deductibles, and plan-specific maternity benefit structures.

obstetric amountob_amt

The monetary value associated with a financial transaction within obstetric care workflows, including prenatal visits, delivery charges, or maternity bundled payments in claims and billing systems. Data engineers use this field in revenue cycle pipelines to support maternity program cost analysis and DRG-based reimbursement reconciliation.

obstetric approval statusob_appr_sts

The authorization or approval state assigned to an obstetric service request or care episode, indicating whether clinical or administrative review has been completed. Used in utilization management workflows to confirm that maternity services such as elective procedures or extended stays meet payer criteria.

obstetric approved byob_appr_by

The identifier of the clinician, supervisor, or administrative user who granted approval for an obstetric service, order, or clinical documentation entry. Captured for audit trail purposes in maternal care workflows, including prior authorization decisions and clinical protocol sign-offs within labor and delivery or prenatal systems.

obstetric arrival timeob_arrv_tm

The recorded timestamp at which a pregnant patient arrived at a clinical facility, typically a labor and delivery unit or obstetric triage. Used to calculate time-to-assessment intervals, monitor throughput, and support compliance with maternal care quality measures such as triage response benchmarks.

obstetric arrived dateob_arrv_dt

The calendar date on which a pregnant patient arrived at a healthcare facility for obstetric care, including scheduled prenatal visits, unscheduled triage, or labor and delivery admission. Used to establish the encounter timeline and link clinical events to the correct episode of maternal care.

obstetric assessmentob_asmt

The structured or free-text clinical evaluation completed by a provider during an obstetric encounter, summarizing findings related to maternal and fetal status. Encompasses gestational age assessment, risk factor review, physical examination results, and clinical impressions documented in prenatal or intrapartum records.

obstetric balanceob_bal

The outstanding financial balance remaining on an obstetric care account after payments and adjustments are applied in revenue cycle and claims systems. Data engineers use this field in accounts receivable pipelines to monitor maternity care billing cycles, including global OB billing packages and trimester-based payment plans.

obstetric billed amountob_bill_amt

The total gross charges submitted by a healthcare facility or provider on a claim for obstetric services, prior to payer adjustments or contractual discounts. Represents the starting amount in the claims adjudication process for maternity-related services including prenatal care, delivery, and postpartum encounters.

obstetric birth dateob_birth_dt

The recorded date of birth for a patient within obstetric care workflows in EHR and prenatal tracking systems. Used by data engineers to calculate gestational age, validate eligibility for maternity programs, and support HEDIS prenatal and postpartum care quality measure logic in clinical analytics pipelines.

obstetric blood pressureob_bp

The recorded systolic and diastolic arterial blood pressure measurement obtained during an obstetric encounter. A critical vital sign in maternal care used to screen for gestational hypertension, preeclampsia, and eclampsia, and to monitor hemodynamic status throughout pregnancy, labor, delivery, and the postpartum period.

obstetric cancelled dateob_cncl_dt

The calendar date on which a scheduled obstetric appointment, procedure, or service was cancelled by the patient or clinical staff. Used in scheduling systems to track cancellation patterns, manage labor and delivery capacity, and support follow-up workflows ensuring pregnant patients are rescheduled for missed prenatal care.

obstetric categoryob_cat

The grouping classification applied to obstetric care records in EHR, claims, and clinical data systems, such as antepartum, intrapartum, or postpartum. Data engineers use this field to segment maternity care data within population health pipelines, quality reporting, and value-based care program analytics targeting maternal health outcomes.

PreviousPage 445 of 806Next