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

carrier detailcarr_dtl

Supplementary information associated with an insurance carrier record, capturing plan-level, contract-level, or administrative specifics beyond standard identification fields. Used in claims processing and network management systems to store granular carrier attributes needed for accurate adjudication and reporting.

carrier due datecarr_due_dt

The deadline by which an insurance carrier is required to submit payment, documentation, or a required response in a claims or contract workflow. Used in accounts receivable and claims follow-up systems to trigger escalation workflows and ensure timely carrier remittance and compliance with contractual obligations.

carrier durationcarr_dur

The calculated or recorded length of time associated with an insurance carrier relationship, coverage period, or specific carrier-level event. Used in contract management and claims analytics to measure carrier engagement windows, coverage spans, and eligibility periods for reporting and financial reconciliation.

carrier emailcarr_eml

The official electronic mail address on record for an insurance carrier, used for administrative correspondence, claims inquiries, and electronic data interchange notifications. Used in payer communication workflows to route eligibility questions, authorization requests, and remittance advisories to the appropriate carrier contact.

carrier end datecarr_end_dt

The date on which an insurance carrier's contract, coverage agreement, or participation in a specific plan or network officially terminates. Used in eligibility verification and claims adjudication systems to prevent payment of claims submitted after a carrier's participation period has expired.

carrier end timecarr_end_tm

The precise time at which an insurance carrier's coverage window, authorization period, or system session concludes on a given date. Used in real-time eligibility and prior authorization systems where time-sensitive carrier participation boundaries must be enforced alongside date-level termination criteria.

carrier enrollment statuscarr_enrl_sts

A coded value indicating the current participation or enrollment state of an insurance carrier within a health plan network or benefits program. Used in eligibility and contract management systems to determine whether a carrier is active, pending, suspended, or terminated for claims processing and member assignment purposes.

carrier entered bycarr_ent_by

The user identifier or system account responsible for initially creating or entering an insurance carrier record into the healthcare data system. Used in claims and enrollment audit trails to establish data provenance, support error resolution, and enforce accountability for carrier record creation and maintenance.

carrier ethnicitycarr_ethn

The ethnicity classification recorded in association with an insurance carrier-affiliated individual, such as a member, dependent, or key contact. Used in health equity reporting and population health analytics to support demographic stratification across carrier-sponsored plans and meet regulatory diversity reporting requirements.

carrier expiration datecarr_exp_dt

The date after which an insurance carrier's credentials, contract terms, or participation agreement are no longer considered valid within the healthcare system. Used in network management and claims adjudication to block processing of services associated with expired carrier authorizations and trigger renewal or renegotiation workflows.

carrier external identifiercarr_ext_id

A unique reference code assigned to an insurance carrier by an external system, trading partner, or regulatory body outside the internal healthcare platform. Used in interoperability and data exchange workflows to reconcile carrier records across disparate claims, eligibility, and clearinghouse systems using a shared cross-system identifier.

carrier faxcarr_fax

The facsimile telephone number on record for an insurance carrier, used to transmit claims documentation, prior authorization requests, and administrative correspondence. Used in payer communication workflows where electronic or paper-based fax transmission remains a required channel for regulatory or contractual carrier interactions.

carrier feecarr_fee

The administrative or transaction service charge assessed by an insurance carrier, typically recorded in claims processing or remittance data. Represents the cost associated with carrier-level services, network access, or administrative processing fees applied to healthcare transactions.

carrier first namecarr_first_nm

The given name of an individual contact or representative associated with an insurance carrier entity. Used in member enrollment, claims correspondence, and payer contract management systems to identify the primary carrier contact person by their first name.

carrier flagcarr_flg

A binary or coded indicator that marks a specific status condition for an insurance carrier record, such as active, terminated, or preferred network status. Used in claims adjudication and member enrollment systems to control carrier-level processing rules and eligibility logic.

carrier frequencycarr_freq

The interval or recurrence schedule associated with carrier-level transactions, reporting cycles, or billing submissions. Used in claims and remittance workflows to define how often a carrier submits, receives, or processes specific data exchanges within payer systems.

carrier full namecarr_full_nm

The complete official name of an insurance carrier entity, combining all name components into a single displayable value. Used across claims, enrollment, and payer contract systems to identify and present the carrier in a standardized, human-readable format for reporting and correspondence.

carrier gendercarr_gndr

The sex classification associated with an individual carrier contact or representative in insurance administration records. Captured in payer management and enrollment systems where carrier contacts are tracked as individual persons for correspondence, credentialing, or demographic reporting purposes.

carrier glucosecarr_gluc

A blood glucose measurement attributed to a carrier-related clinical record or individual. This field may appear in integrated clinical and payer data systems where health risk or biometric data from carrier-affiliated members is stored alongside insurance enrollment or case management records.

carrier group numbercarr_grp_nbr

The unique group identifier assigned to a collection of members or plans under a specific insurance carrier. Used in claims processing, member eligibility verification, and enrollment systems to link individuals to their employer-sponsored or carrier-defined group benefit plan.

PreviousPage 22 of 142Next