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

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

history enrollment statushx_enrl_sts

Captures the enrollment status associated with a member's historical record within a health plan or care program. Used in data warehouses to track prior enrollment periods, enabling longitudinal analysis of coverage continuity, gaps in insurance, and member population trends.

immunization enrollment statusimmun_enrl_sts

Indicates a member's current enrollment status in an immunization management program or vaccine benefit, such as a public health immunization registry or plan-sponsored vaccination initiative. Tracks active or inactive participation to support preventive care reporting and compliance.

implant active indicatorimpl_actv_ind

A binary flag indicating whether a surgically placed medical device, such as a pacemaker, joint replacement, or cochlear implant, is currently active within a patient's clinical record. Used to distinguish functioning implants from those that have been removed, replaced, or deactivated.

implant active statusimpl_actv_sts

Describes the current operational state of a surgically placed medical device within a patient's clinical record. Indicates whether the implant is functioning, inactive, explanted, or pending activation, supporting device tracking, clinical decision-making, and regulatory compliance reporting.

implant ageimpl_age

Represents the elapsed time since a medical device was surgically implanted in a patient, typically measured in years or months. Used in clinical and claims systems to assess device longevity, anticipate replacement schedules, and evaluate outcomes for implantable devices such as joint prostheses or cardiac devices.

implant allowed amountimpl_alwd_amt

The maximum reimbursable dollar amount a health plan will pay for a surgically placed medical device as defined by the plan's fee schedule or contract terms. Used during claims adjudication to determine the payer's payment obligation for implant-related procedures before cost-sharing is applied.

implant amountimpl_amt

The total monetary value associated with a surgically placed medical device, representing the billed or actual cost of the implant on a healthcare claim. Used in claims processing and cost analysis to capture device-specific expenses separate from the surgical procedure charges.

implant approval statusimpl_appr_sts

Indicates the current authorization state of a surgically placed medical device, such as pending, approved, or denied. Tracks regulatory or clinical sign-off required before implant procurement or surgical placement, supporting compliance and surgical workflow documentation.

implant approved byimpl_appr_by

Records the name or system identifier of the clinician, administrator, or automated process that authorized a surgically placed medical device. Used in surgical workflow audits to maintain accountability and traceability of implant approval decisions prior to or following a procedure.

implant arrival timeimpl_arrv_tm

Captures the specific time a surgically placed medical device physically arrived at the facility or surgical suite. Critical for tracking implant supply chain logistics, ensuring device availability before scheduled procedures, and documenting chain of custody for regulatory compliance.

implant arrived dateimpl_arrv_dt

Records the calendar date a surgically placed medical device was received at the healthcare facility. Used in surgical inventory management to confirm timely delivery, reconcile purchase orders, and ensure the implant is available and sterile before a scheduled procedure.

implant assessmentimpl_asmt

Contains the clinician's documented evaluation of a surgically placed medical device, including device condition, patient response post-implantation, or pre-surgical suitability notes. Supports clinical decision-making, surgical planning, and post-operative follow-up documentation within the patient record.

implant balanceimpl_bal

Represents the outstanding financial amount owed on a surgically placed medical device after payments and adjustments have been applied. Used in hospital billing systems to track remaining patient or payer liability associated with implant procurement and surgical placement costs.

implant billed amountimpl_bill_amt

The total dollar amount invoiced to a payer or patient for a surgically placed medical device, including device acquisition and associated surgical costs. Used in revenue cycle management to track implant-related charges submitted on institutional or professional claims.

implant birth dateimpl_birth_dt

Records the date of birth of the patient who received a surgically placed medical device. Used to associate implant records with the correct patient demographic profile, supporting device registry reporting, recall notifications, and long-term implant outcome tracking.

implant blood pressureimpl_bp

Documents the patient's arterial blood pressure measurement recorded in the context of a surgically placed medical device encounter, such as pre-operative screening or post-implant monitoring. Supports clinical documentation requirements for cardiac implants and hemodynamic device assessments.

implant cancelled dateimpl_cncl_dt

Records the date on which a planned surgically placed medical device procedure or order was officially cancelled. Used in surgical scheduling and inventory management to trigger device returns, release reserved stock, and update case status within the operating room management system.

implant categoryimpl_cat

Classifies a surgically placed medical device into a high-level grouping such as orthopedic, cardiac, neurological, or ophthalmologic. Enables standardized reporting, inventory segmentation, and regulatory compliance tracking across implant types within clinical and supply chain systems.

implant charge amountimpl_chrg_amt

The gross charge value assigned to a surgically placed medical device before payer adjustments, contractual discounts, or patient payments are applied. Used in hospital billing and cost accounting to establish the starting financial obligation for implant-related surgical services.

implant chief complaintimpl_cc

Captures the patient's primary reported symptom or clinical concern that prompted evaluation or intervention involving a surgically placed medical device. Used in clinical documentation to establish medical necessity for implant procedures and support prior authorization requests.

PreviousPage 72 of 142Next