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

schedule claim statussched_clm_sts

The current adjudication state of a claim linked to a scheduled healthcare service or appointment, indicating whether the claim is pending, approved, denied, or paid. Supports claims management for elective, pre-authorized, or recurring scheduled care services.

schedule payment amountsched_pmt_amt

The dollar amount paid by a health plan for a claim associated with a scheduled or pre-authorized healthcare service. Reflects the adjudicated reimbursement after applying member cost-sharing and contractual rates for planned care encounter billing.

schedule payment statussched_pmt_sts

The current state of payment for a claim linked to a scheduled or pre-authorized healthcare service, indicating whether payment is pending, remitted, denied, or under review. Used in financial tracking of planned care billing and payer reimbursement workflows.

sensitivity adjustment amountsens_adj_amt

The dollar value of any billing or contractual adjustment applied to a claim involving treatment or testing related to patient sensitivities, such as allergy or drug sensitivity management. Reflects payer adjustments or corrections in medical or pharmacy claims processing.

sensitivity claim datesens_clm_dt

The date a healthcare claim for services related to a patient's documented sensitivity, such as allergy testing, desensitization treatment, or adverse reaction management, was submitted to a payer. Used in claims tracking for sensitivity-related care billing timelines.

sensitivity claim statussens_clm_sts

The current adjudication state of a medical claim for sensitivity-related services, such as allergy testing or adverse drug reaction treatment, indicating whether the claim is pending, approved, denied, or settled by the payer in claims management workflows.

sensitivity deductible amountsens_ded_amt

The portion of a claim cost for sensitivity-related services, such as allergy testing or drug sensitivity treatment, applied toward a member's annual deductible. Represents the member's out-of-pocket liability before health plan coverage applies to these services.

sensitivity payment amountsens_pmt_amt

The dollar amount paid by a health plan for a claim associated with sensitivity-related healthcare services, including allergy testing, immunotherapy, or adverse reaction management. Reflects the adjudicated reimbursement after member cost-sharing in medical claims processing.

sensitivity payment statussens_pmt_sts

Indicates the current payment processing state for a claim or encounter related to an allergy or substance sensitivity reaction. Tracks whether reimbursement for sensitivity-related services such as allergy testing or desensitization treatments has been submitted, adjudicated, paid, denied, or is pending within the claims processing workflow.

sensitivity review systemssens_ros

Documents the organ systems reviewed during clinical assessment of a patient's allergy or substance sensitivity reaction. Captured as part of the review of systems during encounters involving allergic responses, capturing respiratory, dermatologic, gastrointestinal, and immunologic system findings relevant to sensitivity diagnosis and treatment planning.

sensitivity service datesens_svc_dt

Records the date on which clinical services were delivered to evaluate or treat a patient's allergy or substance sensitivity. Used in claims processing and clinical records to establish the timeline for allergy testing, immunotherapy, or sensitivity-related interventions for billing accuracy and longitudinal care tracking.

serology adjustment amountsero_adj_amt

Represents the dollar amount added or subtracted from the original billed charge for a serology laboratory test, such as antibody or antigen detection studies. Applied during claims adjudication to reflect contractual discounts, coordination of benefits, or correction of billing errors associated with serology diagnostic services.

serology claim datesero_clm_dt

Records the date a claim was submitted to a payer for reimbursement of serology laboratory services, including antibody titer tests, blood type matching, or infectious disease serology panels. Used in claims management workflows to track submission timelines, payer response windows, and compliance with filing deadlines.

serology claim statussero_clm_sts

Indicates the current adjudication state of a claim submitted for serology laboratory services such as antibody or antigen testing. Status values may include submitted, pending, approved, denied, or paid, enabling billing staff to monitor claim progression and resolve issues related to serology test reimbursement.

serology deductible amountsero_ded_amt

Captures the portion of serology laboratory service charges applied toward a member's annual insurance deductible before the health plan begins covering costs. Used in claims adjudication to calculate patient financial responsibility for antibody tests, blood grouping, and other serology diagnostics under the member's benefit plan.

serology payment amountsero_pmt_amt

Records the actual dollar amount disbursed by the health plan or payer for serology laboratory services, including antibody screening and infectious disease serology tests. Reflects the final reimbursement after applying contractual adjustments, deductibles, and co-insurance to the original billed amount for serology procedures.

serology payment statussero_pmt_sts

Indicates the current state of payment for a claim associated with serology laboratory services such as blood antibody testing or serological disease panels. Reflects whether payment has been issued, is pending, was denied, or requires additional processing steps within the payer's claims reimbursement workflow.

serology review systemssero_ros

Documents the body systems evaluated during a clinical encounter that includes serology testing such as antibody panels or blood group studies. Captured as part of the provider's review of systems, noting relevant findings across hematologic, immunologic, and infectious disease systems to support medical necessity and clinical documentation standards.

serology service datesero_svc_dt

Records the specific date on which serology laboratory services, such as antibody titer testing or blood type and crossmatch procedures, were performed for a patient. Used in claims billing and clinical documentation to establish the date of service for reimbursement accuracy, prior authorization validation, and longitudinal lab result tracking.

service active indicatorsvc_actv_ind

A binary flag indicating whether a specific healthcare service record is currently active and in use within the system. Used in member enrollment, care management, and clinical data platforms to filter active service lines from historical or terminated entries, ensuring reporting and billing processes reference only valid, current service records.

PreviousPage 148 of 178Next