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

technician unittech_unt

The specific hospital unit, department, or clinical area to which a pharmacy, radiology, or laboratory technician is assigned or deployed. Used in staffing, scheduling, and operational reporting systems to track technician placement across clinical service areas within a facility.

telehealth visit flagtelehlth_visit_flg

A flag identifying that a clinical encounter was delivered via telehealth technology rather than in-person, used to track telehealth utilization rates, compare clinical outcomes and patient satisfaction between telehealth and in-person modalities, and ensure appropriate telehealth-specific billing modifier codes are applied for reimbursement.

termination addressterm_addr

The mailing or residential address recorded for a member at the time their health plan coverage is terminated. Captured in member enrollment systems to support final correspondence, COBRA notification mailings, and regulatory reporting requirements associated with coverage end events.

termination ageterm_age

The age of a health plan member at the time their coverage is terminated. Recorded in member enrollment and eligibility systems to support analysis of coverage duration, age-based termination rules such as dependent aging-off events, and population health reporting.

termination allowed amountterm_alwd_amt

The maximum reimbursable dollar amount approved for claims associated with a member's coverage termination period. Used in claims adjudication and enrollment systems to establish financial liability boundaries for services rendered during or around the coverage end date.

termination amountterm_amt

The total monetary value associated with a member's health plan coverage termination, which may include final premium balances, refunds, or administrative fees. Captured in enrollment and billing systems to support financial reconciliation at the point of coverage end.

termination approval statusterm_appr_sts

Indicates the current approval state of a member's health plan coverage termination request within enrollment or benefits administration workflows. Tracks whether the termination has been submitted, pending review, approved, or denied by the plan administrator or HR department.

termination approved byterm_appr_by

Identifies the user, administrator, or system that authorized a health plan member's coverage termination. Recorded in enrollment and benefits administration systems to maintain an audit trail of who approved the termination action and when, supporting compliance and dispute resolution.

termination arrival timeterm_arrv_tm

The time recorded when a member or claimant arrives at a facility or administrative office in connection with a coverage termination process or final service encounter. Used in operational tracking systems to document the timing of termination-related interactions or final visits.

termination arrived dateterm_arrv_dt

The date on which a member or claimant arrives at a healthcare facility or plan office in relation to a coverage termination event or final service encounter. Captured in enrollment and encounter systems to document the chronology of termination-related activities and last interactions.

termination birth dateterm_birth_dt

The date of birth of the health plan member whose coverage is being terminated. Recorded in member enrollment and eligibility systems to verify identity, apply age-based termination rules such as dependent aging-off provisions, and support demographic reporting at coverage end.

termination blood pressureterm_bp

The blood pressure reading documented for a patient at the time of a clinical encounter associated with a coverage termination or final visit. Captured in clinical data systems to maintain a complete health record for the member through the end of their covered benefit period.

termination cancelled dateterm_cncl_dt

The date on which a previously submitted health plan coverage termination request was cancelled or reversed within the enrollment system. Used in member eligibility and benefits administration records to restore active coverage status and document the rescission of a termination action.

termination categoryterm_cat

Classifies the reason a member's health plan coverage ended into standardized groupings, such as voluntary disenrollment, non-payment, employer group dissolution, or death. Used in member enrollment systems to segment termination trends for actuarial analysis and regulatory reporting.

termination charge amountterm_chrg_amt

The monetary amount associated with a coverage termination transaction, such as a final premium charge, administrative fee, or balance due at the time of disenrollment. Captured in billing and enrollment systems to reconcile member accounts upon coverage end.

termination chief complaintterm_cc

The primary clinical complaint or presenting symptom documented at the final patient encounter or discharge event. Used in clinical systems to record the reason for the terminal visit, supporting care transition documentation, discharge summaries, and post-encounter coding workflows.

termination childterm_chld

Identifies a dependent child subscriber whose coverage is being terminated, typically due to aging out at 26, loss of dependent eligibility, or removal from a family plan. Used in member enrollment systems to manage dependent-level disenrollment separately from the primary subscriber.

termination cityterm_city

The municipality recorded as part of a member's or patient's address at the time their coverage or record was terminated. Used in enrollment and demographic systems to capture last known location for correspondence, COBRA notifications, and continuity of care coordination.

termination classterm_cls

The benefit class or coverage tier assigned to a member at the point of termination, such as individual, family, employee-only, or retiree. Used in enrollment systems to ensure correct final billing, COBRA eligibility determination, and benefit reconciliation upon disenrollment.

termination codeterm_cd

A standardized coded value identifying the specific reason a member's coverage or record was ended, such as voluntary withdrawal, non-payment, Medicare entitlement, or employer group termination. Used across enrollment and claims systems to drive downstream eligibility logic and regulatory reporting.

PreviousPage 273 of 325Next