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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

order effective dateord_eff_dt

The date on which a clinical order becomes active and actionable within EHR and CPOE systems. Used in HL7 ORC/OBR segments and claims adjudication to determine order validity windows, authorization alignment, and care timeline sequencing across Epic, Cerner, and downstream data warehouses.

order medical record numberord_mrn

The unique patient medical record number associated with a clinical order, linking the order to the correct patient record across healthcare systems. Used to ensure accurate patient identification, order routing, and longitudinal tracking of clinical service requests within EHR and order management systems.

order scheduled dateord_sched_dt

The calendar date on which a clinical order or associated service is planned to be performed or fulfilled. Used in scheduling, care coordination, and operational reporting to track appointment timelines, resource allocation, and adherence to clinically indicated service windows.

order scheduled timeord_sched_tm

The specific time of day at which a clinical order or associated service is planned to be performed. Used alongside the scheduled date in scheduling systems to manage resource availability, staff assignments, and patient flow for ordered procedures, tests, or appointments.

order street addressord_st_addr

The physical street address associated with the location where a clinical order is to be fulfilled or where the ordering encounter took place. Used in order routing, facility identification, and multi-site care coordination to ensure services are directed to the correct clinical or outpatient location.

order unitord_unt

The standardized measurement unit assigned to a clinical service request in EHR and CPOE systems. Defines quantity dimensions such as milligrams, milliliters, or units for medication and lab orders, ensuring accurate dispensing, billing, and clinical documentation.

organization account numberorg_acct_nbr

A unique numeric or alphanumeric identifier assigned to a healthcare entity, such as a hospital, clinic, or payer, for use in financial and administrative systems. Used to link transactions, claims, contracts, and billing records to the correct organizational account across revenue cycle and enterprise data platforms.

organization active indicatororg_actv_ind

A binary flag indicating whether a healthcare entity is currently active and eligible for use in transactions, contracting, or administrative workflows. Used in provider directories, payer systems, and enterprise data management to filter inactive organizations from operational processes and reporting.

organization active statusorg_actv_sts

Describes the current operational status of a healthcare entity, such as active, inactive, suspended, or terminated. Used in credentialing, network management, and claims processing to determine whether an organization is eligible to participate in care delivery, contracting, or reimbursement activities.

organization addressorg_addr

The full physical or mailing address of a healthcare entity, including street, city, state, and ZIP code. Used in provider directories, claims processing, member communications, and facility management systems to identify the location of hospitals, clinics, payers, or administrative offices.

organization adjustment amountorg_adj_amt

The dollar value of a financial adjustment applied to a healthcare entity's account, such as a contractual write-off, billing correction, or payment reconciliation. Used in revenue cycle management and financial reporting to track deviations between billed charges and final settled amounts at the organizational level.

organization ageorg_age

The number of years a healthcare entity has been in operation since its founding or establishment date. Used in credentialing, contracting, and vendor management workflows to assess organizational maturity, eligibility for participation in programs, and historical operational context within enterprise data systems.

organization allowed amountorg_alwd_amt

The maximum dollar amount a payer will reimburse a healthcare entity for a specific service or claim based on contracted rates or fee schedules. Used in claims adjudication, financial reporting, and contract compliance to determine payment limits and calculate member cost-sharing responsibilities.

organization amountorg_amt

A general monetary value associated with a healthcare entity's financial transaction, account balance, or aggregated payment record. Used across revenue cycle, claims, and financial reporting systems to capture various monetary figures tied to organizational-level billing, reimbursement, or cost accounting activities.

organization approval statusorg_appr_sts

Indicates the current authorization or credentialing state of a healthcare entity, such as pending review, approved, conditionally approved, or denied. Used in network enrollment, contracting, and compliance workflows to track whether an organization has met requirements for participation in care delivery or payer agreements.

organization approved byorg_appr_by

Identifies the individual or role responsible for authorizing or credentialing a healthcare entity within administrative or compliance workflows. Used in audit trails, approval routing, and governance reporting to document accountability for organizational approvals in contracting, enrollment, or network participation processes.

organization arrival timeorg_arrv_tm

The recorded time at which a patient or representative arrived at a healthcare facility or organizational site for a scheduled or unscheduled encounter. Used in operational reporting, patient flow analysis, and wait time tracking to measure access performance and staffing efficiency at the facility level.

organization arrived dateorg_arrv_dt

The calendar date on which a patient or representative arrived at a healthcare facility for a clinical encounter or administrative visit. Used in patient flow tracking, scheduling systems, and operational analytics to support length-of-stay calculations, access reporting, and facility utilization measurement.

organization assessmentorg_asmt

A structured evaluation of a healthcare entity's capabilities, compliance, or performance against defined criteria such as accreditation standards, network requirements, or quality benchmarks. Used in credentialing, vendor management, and quality reporting workflows to document findings and support organizational participation decisions.

organization averageorg_avg

A calculated metric representing the mean value of a specific measure across an organization within healthcare analytics and reporting systems. Used in quality benchmarking, cost analysis, and provider performance dashboards in EHR and claims data platforms.

PreviousPage 159 of 325Next