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

organization created byorg_crtd_by

Identifies the user account or system process that created the healthcare organization record in the data system. Used for audit trail tracking, data governance, and accountability in healthcare information systems managing payer, provider, or facility entity records.

organization created dateorg_crtd_dt

The calendar date on which the healthcare organization record was initially created in the system. Used for audit trail purposes, data lineage tracking, and historical analysis of when payer, facility, or network entity records were first established in the data warehouse.

organization created timeorg_crtd_tm

The timestamp indicating the exact time a healthcare organization record was first created in the system. Combined with the created date, this supports precise audit logging, data lineage tracking, and sequencing of record creation events across healthcare entity management systems.

organization creatinineorg_cr

A laboratory biomarker value representing creatinine levels used to assess kidney function, captured at the organizational or facility level for population health, quality reporting, or chronic kidney disease management programs tracked across a health system or payer network.

organization currentorg_curr

The present active state or snapshot of an organization's attributes within healthcare data systems, including provider networks, payer contracts, or member enrollment records. Used to reflect real-time organizational data in EHR and claims administration platforms.

organization dateorg_dt

A generic calendar date value associated with a healthcare organization record, representing a key business or operational date relevant to the entity's lifecycle, reporting period, or transactional activity within payer, provider network, or facility management systems.

organization datetimeorg_dttm

A combined date and time value associated with a healthcare organization record, capturing the precise moment of a business event or system transaction. Used in audit logging, workflow sequencing, and event tracking within payer, facility, or network management data systems.

organization dea numberorg_dea_nbr

The Drug Enforcement Administration registration number assigned to a healthcare organization, such as a hospital, pharmacy, or clinic, authorizing the entity to prescribe, dispense, or handle controlled substances. Required for pharmacy claims processing and regulatory compliance reporting.

organization death dateorg_death_dt

The date on which a healthcare organization entity was formally dissolved, terminated, or became inactive in the system. Used in network management, contract administration, and historical reporting to mark the end of an organization's operational existence within the healthcare data environment.

organization deductible amountorg_ded_amt

The dollar amount representing the deductible threshold applicable to a healthcare organization's benefit plan or contract arrangement. Used in claims adjudication, financial reporting, and plan administration to track the out-of-pocket amount required before insurance coverage takes effect.

organization deleted dateorg_del_dt

The calendar date on which a healthcare organization record was marked as deleted or logically removed from the active data set. Used for soft-delete tracking, data retention compliance, and audit history in healthcare entity management and network administration systems.

organization deleted indicatororg_del_ind

A flag identifying whether a healthcare organization record has been logically deleted from the active data set without physical removal. Supports soft-delete data management practices, ensuring historical records remain accessible for audit, reporting, and referential integrity in healthcare data systems.

organization descriptionorg_desc

A free-text or structured narrative providing a human-readable explanation of the healthcare organization, including its type, services, or operational scope. Used in directories, network management systems, and reporting tools to communicate the entity's purpose and characteristics to users and downstream systems.

organization detailorg_dtl

Granular information associated with a healthcare organization record, capturing specific attributes such as specialty type, accreditation status, or service offerings. Used in provider network management, credentialing, and payer contracting systems to maintain comprehensive entity-level data for operational and reporting purposes.

organization due dateorg_due_dt

The deadline date by which a healthcare organization must fulfill a financial obligation, submit required documentation, or complete a contractual requirement. Used in accounts payable, claims processing, contract management, and compliance tracking within payer and health system administrative workflows.

organization durationorg_dur

The calculated or recorded length of time associated with a healthcare organization's activity, contract term, accreditation period, or operational status. Used in network management, contract administration, and reporting to measure the span of time an entity has been active, enrolled, or engaged within the health system.

organization effectiveorg_eff

The date or status marking the start of an organization's active participation or configuration in healthcare data systems. Used in provider network management, payer contracts, and member enrollment to define when organizational records become operationally valid.

organization effective dateorg_eff_dt

The date on which a healthcare organization's record, contract, credential, or network participation status becomes active and operationally valid. Used in provider network management, payer contracting, and enrollment systems to determine when an entity's terms, rates, or participation rights take effect.

organization emailorg_eml

The official electronic mail address associated with a healthcare organization, used for business communications, electronic notifications, credentialing correspondence, and administrative contact. Stored in network management, provider directories, and payer systems to facilitate direct communication with the entity's administrative or operational staff.

organization emergency indicatororg_emerg_ind

A flag identifying whether a healthcare organization is designated to provide emergency services or has been flagged for urgent operational attention within the data system. Used in network adequacy analysis, member referral routing, and facility directory management to distinguish emergency-capable entities.

PreviousPage 161 of 325Next