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

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,545 claims terms

insurer faxins_fax

The facsimile telephone number associated with an insurance payer or carrier entity. Used in claims operations and utilization management to transmit prior authorization requests, medical records, and coverage documentation between health plans and healthcare facilities.

insurer feeins_fee

The monetary charge or administrative cost associated with an insurance payer transaction, contract arrangement, or service agreement. Used in payer contract management and revenue cycle systems to track financial obligations between health plans, third-party administrators, and contracted entities.

insurer first nameins_first_nm

The given or first name of the primary insured individual or named policyholder on an insurance record. Used in member enrollment systems, claims processing, and eligibility verification to identify and match individual policyholders to their associated coverage records.

insurer flagins_flg

A binary or coded indicator that marks a specific condition, status, or exception associated with an insurance payer record. Used in claims processing and payer management systems to trigger workflow actions such as coordination of benefits reviews, fraud alerts, or eligibility holds.

insurer frequencyins_freq

The coded value indicating how often an insurance benefit, reimbursable service, or claims submission cycle recurs within a defined coverage period. Used in benefit plan configuration and claims adjudication to enforce limits on covered service utilization such as annual or monthly benefit maximums.

insurer full nameins_full_nm

The complete legal name of an insurance company, health plan, or payer entity as registered with regulatory authorities. Used across claims systems, member enrollment platforms, and payer directories to unambiguously identify the insuring organization responsible for benefit adjudication.

insurer genderins_gndr

The gender identity or sex classification recorded for the primary insured individual or policyholder on an insurance record. Used in member enrollment systems and population health reporting to support demographic analysis, actuarial modeling, and health equity assessments across covered populations.

insurer glucoseins_gluc

The blood glucose measurement recorded for the primary insured or covered member in a health management or disease management program context. Used by insurers administering chronic condition programs such as diabetes management to track clinical outcomes and assess population health risk.

insurer group numberins_grp_nbr

The unique identifier assigned to a group insurance plan, typically tied to an employer, union, or association sponsoring coverage for its members. Used in claims adjudication and eligibility verification to link individual insured members to their correct group benefit plan and coverage terms.

insurer hemoglobinins_hgb

The hemoglobin measurement recorded for a covered member within an insurer-administered health or disease management program. Used by health plans managing chronic conditions such as anemia or diabetes to monitor clinical indicators and evaluate intervention effectiveness across the insured population.

insurer identifierins_id

The unique alphanumeric code assigned to an insurance company or payer entity within a healthcare data system. Used in claims processing, eligibility transactions, and payer enrollment to precisely identify the responsible insurer when adjudicating benefits and routing reimbursement across trading partners.

insurer indexins_idx

A numeric position or sequence value assigned to an insurer record within a dataset, list, or multi-payer structure. Used in coordination of benefits scenarios and member enrollment systems to order multiple insurance coverages and establish primary, secondary, or tertiary payer priority for claims adjudication.

insurer indicatorins_ind

A coded flag or boolean value that designates a specific status, classification, or condition applicable to an insurance payer record. Used in claims and enrollment systems to signal payer type designations such as Medicare supplement status, coordination of benefits priority, or participation in value-based arrangements.

insurer keyins_key

Surrogate primary key that uniquely identifies an insurer record in the data warehouse. Used to join insurer attributes across claims, enrollment, and eligibility tables without relying on mutable business identifiers such as payer ID or plan code.

insurer languageins_lang

Preferred spoken or written language of the insured member, recorded during enrollment or registration. Used to route member communications, explanation of benefits documents, and care coordination correspondence in the member's primary language per CMS language access requirements.

insurer last nameins_last_nm

Family surname of the insured individual as recorded on the insurance policy or membership enrollment application. Used to match member identity across claims, eligibility files, and coordination of benefits records when verifying coverage or adjudicating claims.

insurer legal nameins_legal_nm

Officially registered legal name of the insurance carrier or payer entity as filed with state insurance regulatory authorities. Used on contracts, provider agreements, remittance advice documents, and regulatory submissions to identify the payer in legally binding contexts.

insurer levelins_lvl

Hierarchical classification of the insurer's position within a multi-tier payer structure, such as primary, secondary, or tertiary coverage. Determines the order in which payers are billed during coordination of benefits processing on medical or pharmacy claims.

insurer license numberins_lic_nbr

State-issued license number assigned to the insurance carrier authorizing it to underwrite health coverage in a given jurisdiction. Required for regulatory compliance reporting, provider contract validation, and verification of payer credentials during claims adjudication setup.

insurer marital statusins_mar_sts

Marital status of the insured member as reported at the time of enrollment, such as single, married, divorced, or widowed. Influences dependent eligibility determinations, special enrollment period qualifications, and household composition calculations under group health plan rules.

PreviousPage 77 of 178Next