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

Finance

Revenue, costs, budgets, invoices and capitation

1,293 finance terms

bill revisionbill_rev

A sequential version number indicating how many times a healthcare billing statement has been amended, corrected, or resubmitted. Used in claims management to track corrected claim submissions, distinguish original from adjusted bills, and maintain an audit history of changes made to charges or coding after initial submission.

bill riskbill_rsk

A risk score or categorical level assigned to a healthcare billing account reflecting the likelihood of non-payment, fraud, or compliance exposure. Used in revenue cycle and compliance management to flag high-risk accounts for enhanced review, inform collections strategy, and support proactive identification of billing irregularities.

bill scorebill_scr

A calculated numeric rating assigned to a patient billing statement, used in revenue cycle management to prioritize collections, assess claim complexity, or evaluate payment risk. Higher scores may indicate accounts requiring escalated follow-up or denial management intervention.

bill sequencebill_seq

A numeric ordering value assigned to a billing statement that identifies its position within a series of bills for the same encounter or account. Used in claims processing to distinguish original submissions from resubmissions, corrections, or split billing scenarios across a patient account.

bill severitybill_sev

A coded indicator on a billing statement reflecting the clinical severity of the patient's condition during the encounter, often derived from diagnosis codes or DRG assignment. Influences reimbursement levels in hospital inpatient billing and impacts case mix calculations for Medicare and commercial payers.

bill sexbill_sex

The patient's biological sex as recorded on the billing statement, used to validate clinical and diagnostic code combinations during claims adjudication. Payers use this field to apply gender-specific edits, ensuring billed procedures and diagnoses are appropriate for the patient's reported sex.

bill sourcebill_src

A coded value on a billing statement indicating the origin of the patient encounter or admission, such as emergency referral, physician referral, or transfer from another facility. Used in UB-04 institutional claims to populate the admission source field required by Medicare and commercial payers.

bill start datebill_start_dt

The date on which the billing period or covered service episode begins as recorded on the billing statement. In institutional claims, this represents the first date of service or admission date, defining the opening boundary of the claim period for payer adjudication and coordination of benefits.

bill start timebill_start_tm

The exact time at which the billed service or encounter began, recorded on the billing statement for time-sensitive services such as surgical procedures, emergency department visits, or observation stays. Used to calculate duration-based charges and support medical necessity review by payers.

bill statebill_st

The two-character state or province code associated with the billing address or place of service on the billing statement. Used in claims processing to apply state-specific reimbursement rules, tax requirements, and regulatory compliance standards for the jurisdiction where services were rendered.

bill statusbill_sts

An indicator reflecting the current processing state of a billing statement within the revenue cycle, such as draft, submitted, pending, adjudicated, denied, or paid. Used in accounts receivable management to track claim lifecycle and prioritize follow-up actions with payers or patients.

bill subtotalbill_subtot

A partial monetary sum on a billing statement representing charges for a specific subset of services, cost centers, or revenue code categories before adjustments, discounts, or tax are applied. Used in hospital billing to itemize charges by department or service type prior to calculating the final billed amount.

bill targetbill_tgt

The intended recipient or payer designated to receive the billing statement, such as a primary insurer, secondary payer, or patient responsible party. Used in revenue cycle workflows to route claims correctly through coordination of benefits sequencing and ensure appropriate payer-specific billing formats are applied.

bill taxonomy codebill_tax_cd

A ten-digit Health Care Provider Taxonomy Code recorded on the billing statement that identifies the rendering or billing provider's specialty and subspecialty classification. Required on HIPAA-compliant claims to validate provider credentials against billed services and support payer credentialing edits during adjudication.

bill temperaturebill_temp

The patient's body temperature measurement documented on the billing statement or associated encounter record, used to support medical necessity for temperature-sensitive diagnoses such as sepsis, fever workups, or hypothermia. May be required as clinical documentation to substantiate billed diagnosis and procedure codes.

bill termination datebill_term_dt

The date on which the billing period or covered service episode ends as recorded on the billing statement. In institutional claims, this represents the last date of service or discharge date, defining the closing boundary of the claim period used for length-of-stay calculations and payer adjudication.

bill timebill_tm

The specific time of day associated with the billing statement event, such as when a service was rendered, a claim was generated, or a charge was posted. Used in audit trails, concurrent review processes, and time-based billing scenarios including critical care, anesthesia, and emergency department services.

bill timestampbill_ts

A combined date and time value recording when a billing statement event occurred, such as claim creation, submission, or status change. Used in revenue cycle audit trails to establish precise chronological records for compliance reporting, payer dispute resolution, and timely filing deadline calculations.

bill titlebill_ttl

A formal name or descriptive label assigned to a billing statement, identifying the type of bill or the service category it represents. Used in billing system interfaces and patient-facing documents to distinguish between professional fee statements, facility bills, and itemized account summaries for clarity in revenue cycle communications.

bill totalbill_tot

The aggregate monetary amount of all charges on a billing statement before payer adjustments or patient payments are applied, representing the provider's full billed charges for the encounter. Used in revenue cycle reporting to measure gross charges, analyze payer contractual adjustments, and calculate net collection rates.

PreviousPage 16 of 65Next