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

effective assessmenteff_asmt

The clinician's documented evaluation of a patient's condition at the time of an encounter, capturing diagnostic impressions and clinical findings. Used in clinical documentation workflows to support care planning, coding accuracy, and continuity of care across treatment episodes.

effective balanceeff_bal

The remaining patient or payer financial obligation after applying payments, adjustments, and credits to a billed claim or account. Used in revenue cycle management to track outstanding receivables, drive collections workflows, and reconcile accounts in healthcare billing systems.

effective billed amounteff_bill_amt

The total dollar amount submitted by a healthcare provider on a claim for services rendered, before payer adjudication, contractual adjustments, or patient cost-sharing are applied. Used in claims processing and revenue cycle reporting to establish the starting point for payment reconciliation.

effective birth dateeff_birth_dt

The recorded date of birth for a patient or member as recognized within a specific coverage or enrollment period. Used in eligibility verification, age-based benefit determination, risk stratification, and claims adjudication to validate member identity and apply age-dependent coverage rules.

effective blood pressureeff_bp

The systolic and diastolic arterial pressure measurement recorded for a patient during a clinical encounter or monitoring episode. Used in clinical documentation, chronic disease management programs, and quality measure reporting to track cardiovascular health status over time.

effective cancelled dateeff_cncl_dt

The date on which a scheduled service, authorization, enrollment, or coverage record was officially cancelled or voided. Used in member enrollment systems, prior authorization workflows, and appointment management to establish the precise termination point of a previously active record.

effective categoryeff_cat

A classification label applied to a record, benefit, service, or entity to group it within a defined taxonomy for administrative or clinical purposes. Used in benefits administration, claims routing, and reporting systems to segment data by type, program, or service line for analysis.

effective charge amounteff_chrg_amt

The gross dollar amount charged for a specific healthcare service or procedure before any payer discounts, contractual adjustments, or cost-sharing are deducted. Used in claims adjudication and hospital billing systems to initiate the payment reconciliation process against fee schedules.

effective chief complainteff_cc

The primary symptom, condition, or reason for a patient's visit as documented at the point of care, typically in the patient's own words or as recorded by clinical staff at triage or intake. Used in clinical documentation and encounter classification to drive diagnostic workup and care pathways.

effective childeff_chld

A subordinate record or dependent entity linked to a parent record within a hierarchical data structure, such as a dependent member under a subscriber or a sub-encounter within a parent visit. Used in member enrollment, family benefit management, and relational claims data models.

effective cityeff_city

The name of the municipality associated with a patient, member, or facility address as recorded within a specific effective date range. Used in member enrollment, provider directory management, and claims processing to support geographic analysis, network adequacy, and correspondence routing.

effective classeff_cls

The benefit tier, coverage level, or service classification assigned to a plan, member, drug, or procedure within the context of a specific effective period. Used in pharmacy benefit management, health plan administration, and claims adjudication to apply the correct cost-sharing rules.

effective codeeff_cd

A standardized identifier or classification code associated with a record during a defined effective period, such as a diagnosis code, procedure code, or benefit code. Used across claims, clinical, and enrollment systems to categorize, route, and adjudicate healthcare transactions consistently.

effective coinsurance amounteff_coins_amt

The dollar value representing the member's percentage-based cost-sharing obligation for a covered service after the deductible is met, calculated from the allowed amount on an adjudicated claim. Used in explanation of benefits statements, member cost estimates, and benefits administration reporting.

effective commenteff_cmt

A free-text narrative field associated with a record during its active effective period, capturing supplemental context, workflow notes, or administrative annotations not accommodated by structured data fields. Used in care management, claims review, and enrollment systems to document exceptions or additional detail.

effective completed dateeff_cmpl_dt

The date on which a service, authorization, treatment episode, or administrative process was fully completed and closed within the system of record. Used in prior authorization tracking, care management workflows, and claims processing to measure cycle times and confirm service delivery.

effective confidential indicatoreff_conf_ind

A flag designating that a record or data element contains sensitive information requiring restricted access in accordance with privacy regulations such as HIPAA or 42 CFR Part 2. Used in clinical and administrative systems to enforce role-based access controls on behavioral health, substance use, or other sensitive records.

effective counteff_cnt

A numeric value representing the total number of occurrences, units, or instances associated with a record or event during its effective period. Used in utilization management, claims quantity validation, and population health reporting to quantify service frequency, member volume, or transaction totals.

effective countryeff_ctry

The country associated with the record as of its coverage start date. Used in member enrollment and eligibility systems to identify the nation of residence or policy issuance, supporting geographic segmentation, compliance reporting, and cross-border benefit administration.

effective created byeff_crtd_by

The username or system identifier of the user who created the record as of its effective start date. Captured in enrollment, claims, and eligibility systems to maintain an audit trail of data entry accountability and support data governance and compliance reviews.

PreviousPage 86 of 325Next