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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

consumable resultcons_rslt

The recorded outcome or measurement associated with the use of a single-use medical supply item during a clinical procedure, such as test output from a diagnostic strip or device. Stored in clinical data repositories to link supply usage with patient care results and billing records.

consumable routecons_rte

The administration pathway by which a single-use medical supply item is applied or delivered to a patient, such as intravenous, topical, or oral. Documented in clinical supply and medication administration records to ensure accurate charge capture and patient safety compliance.

consumable surgery datecons_surg_dt

The calendar date on which a single-use medical supply item was utilized during a surgical procedure. Recorded in operative and supply chain documentation systems to support surgical case costing, OR charge capture, and reconciliation of supply usage against surgical billing claims.

copay admission datecpay_admn_dt

The inpatient or facility admission date tied to a copay obligation, recorded in hospital billing systems, claims adjudication platforms, and EHR encounter records. Used by data engineers to align copay liability with the correct benefit period, deductible accumulator logic, and inpatient cost-sharing rules in claims processing workflows.

copay discharge datecpay_dsch_dt

The date a patient is released from a facility inpatient or outpatient encounter, used to calculate and post the applicable copay amount in claims adjudication and member billing systems. Critical for PBM and payer platforms reconciling cost-sharing obligations at episode close.

copay emergency indicatorcpay_emerg_ind

A binary flag on a claims or benefits record indicating whether the patient responsibility copay amount applies to an emergency department visit. Determines whether the higher emergency copay tier defined in the member's health plan benefit structure is applied during adjudication.

copay history present illnesscpay_hpi

The narrative description of a patient's current medical condition as it relates to a copay-bearing encounter, captured in claims or clinical records to support medical necessity review. Used during utilization management or appeals to contextualize the copay obligation tied to a specific visit.

copay labelcpay_lbl

The human-readable display name for a specific copay amount or tier defined within a health plan benefit structure, such as 'Primary Care Copay' or 'Specialist Copay'. Used in member-facing materials, EOB documents, and claims adjudication systems to identify the applicable cost-sharing category.

copay procedure datecpay_proc_dt

The date on which a clinical procedure was performed that triggered a patient copay obligation under the member's health plan. Used in claims adjudication and member billing systems to associate the copay amount with the correct service date for EOB generation and payment reconciliation.

copay rangecpay_rng

The minimum and maximum bounds of a patient's fixed cost-sharing amount as defined in plan benefit tables within PBM, claims, and eligibility systems. Used to validate copay amounts fall within contracted or regulatory thresholds during adjudication.

copay resultcpay_rslt

The final calculated outcome of a copay determination after applying plan benefit rules, accumulator balances, and eligibility data within claims adjudication systems. Used in EOB generation, remittance reporting, and downstream financial reconciliation analytics.

copay surgery datecpay_surg_dt

The date on which a surgical procedure was performed that triggered a patient copay obligation under the member's health plan benefit structure. Recorded in claims processing systems to accurately assign the surgical copay tier and align patient cost-sharing with the corresponding operative encounter.

counselor active indicatorcnsl_actv_ind

A binary flag identifying whether a licensed counselor or behavioral health professional currently holds an active status within the provider credentialing or network management system. Used in directory maintenance and claims routing to verify eligibility for patient assignment and reimbursement.

counselor active statuscnsl_actv_sts

A coded or descriptive value representing the current operational standing of a licensed counselor within a behavioral health network or provider credentialing system, such as Active, Suspended, or Terminated. Used to manage care team assignments, claims eligibility, and provider directory accuracy.

counselor admission datecnsl_admn_dt

The date on which a licensed counselor was formally admitted or onboarded into a behavioral health facility, care program, or provider credentialing system. Used in workforce management and clinical documentation to establish the counselor's program participation timeline and caseload assignment start date.

counselor agecnsl_age

The calculated or recorded age in years of a licensed counselor or behavioral health professional, derived from their date of birth. Captured in provider demographic and credentialing records to support workforce analytics, licensure tracking, and behavioral health network reporting requirements.

counselor allowed amountcnsl_alwd_amt

The maximum reimbursable dollar amount a health plan will pay for behavioral health counseling services rendered by a licensed counselor, as defined by the contracted fee schedule. Used in claims adjudication to calculate plan payment after applying member cost-sharing responsibilities.

counselor amountcnsl_amt

The monetary value associated with a behavioral health counseling service rendered by a licensed counselor, representing either the billed charge, contracted rate, or payment amount depending on context. Used in claims processing and provider payment systems to track financial transactions for counseling encounters.

counselor approved bycnsl_appr_by

The identifier or name of the user, supervisor, or credentialing authority who granted approval for a licensed counselor's record, action, or service request within a behavioral health management or provider credentialing system. Supports audit trail requirements and authorization accountability.

counselor arrival timecnsl_arrv_tm

The recorded timestamp indicating when a licensed counselor arrived at a clinical site, behavioral health facility, or patient care setting. Captured in scheduling and clinical operations systems to support appointment adherence tracking, session start documentation, and workforce productivity reporting.

PreviousPage 134 of 806Next