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

Provider

NPI, credentialing, taxonomy and provider networks

1,236 provider terms

hospital childhosp_chld

Identifies a subordinate or satellite facility that is organizationally linked to a parent hospital entity within a health system hierarchy. Used in provider network configuration and claims processing to associate child facilities with parent organizations for contracting, credentialing, and consolidated reporting purposes.

hospital cityhosp_city

The city or municipality where an inpatient care facility is physically located. Used in claims processing, provider directories, and member eligibility systems to validate facility location, route claims correctly, and support geographic analysis of inpatient utilization.

hospital classhosp_cls

The classification category assigned to an inpatient facility based on ownership type, teaching status, or service scope, such as academic medical center, community hospital, or critical access. Used in claims adjudication and reimbursement rate determination to apply the correct payment methodology.

hospital codehosp_cd

The unique alphanumeric identifier assigned to an inpatient facility within a payer, state registry, or health system. Used across claims processing, utilization management, and provider network systems to consistently reference and track the facility in encounters, authorizations, and contracts.

hospital coinsurance amounthosp_coins_amt

The dollar amount representing the member's coinsurance responsibility for inpatient hospital services after the deductible is met. Calculated as a percentage of the allowed amount per the member's benefit plan, this value is used in claims adjudication and explanation of benefits generation.

hospital commenthosp_cmt

A free-text field capturing supplemental notes or operational remarks associated with an inpatient facility record. Used by claims examiners, utilization management staff, or credentialing teams to document exceptions, special billing arrangements, or facility-specific adjudication instructions.

hospital completed datehosp_cmpl_dt

The date on which an inpatient hospital stay, procedure, or administrative process was formally completed or discharged. Used in claims processing to validate length of stay, calculate benefit periods, and determine timely filing compliance for inpatient institutional claims.

hospital confidential indicatorhosp_conf_ind

A flag indicating that an inpatient facility record or associated patient encounter contains sensitive information requiring restricted access, such as substance abuse treatment or psychiatric care. Governs data sharing rules under 42 CFR Part 2 or HIPAA privacy standards in health information systems.

hospital copay amounthosp_cpay_amt

The fixed dollar amount a member is required to pay at the time of an inpatient hospital admission or per day of stay, as defined by their health plan benefit design. This value is applied during claims adjudication to calculate the member liability portion of the inpatient claim.

hospital costhosp_cst

The total expense incurred by a payer, health system, or employer for inpatient hospital services, including the allowed amount paid to the facility. Used in financial reporting, actuarial analysis, and population health cost modeling to evaluate inpatient utilization and care cost trends.

hospital counthosp_cnt

The numeric tally of inpatient hospital admissions, facilities, claims, or encounters within a defined population or time period. Used in utilization reporting, network adequacy assessments, and quality measurement to quantify inpatient activity for benchmarking and performance analysis.

hospital countryhosp_ctry

The country in which an inpatient facility is physically located. Used in claims processing and provider directory systems to support international or cross-border care scenarios, apply correct reimbursement rules, and ensure compliance with applicable healthcare regulations for the facility's jurisdiction.

hospital created byhosp_crtd_by

The username or system identifier of the user or automated process that initially created the inpatient facility record in the health information system. Used for data governance, audit trail compliance, and record integrity tracking to establish accountability for facility data entry.

hospital created datehosp_crtd_dt

The calendar date on which an inpatient facility record was first entered into the health information system or database. Used for audit trail purposes, data governance, and historical record management to establish when a facility was added to the network or registry.

hospital created timehosp_crtd_tm

The timestamp indicating the exact time an inpatient facility record was created in the health information system. Combined with the created date, this field supports precise audit logging, system reconciliation, and data lineage tracking for facility records in claims or credentialing platforms.

hospital creatininehosp_cr

The serum creatinine lab value measured during an inpatient hospital stay, used as a key indicator of renal function. Captured in clinical data systems to support acute kidney injury detection, medication dosing decisions, and quality metrics such as hospital-acquired condition monitoring.

hospital datehosp_dt

A generic date field associated with an inpatient hospital event, such as an admission, discharge, or service date. Used across claims, clinical, and utilization management systems to anchor inpatient encounters to a specific point in time for benefit determination and reporting purposes.

hospital datetimehosp_dttm

A combined date and time value associated with an inpatient hospital event, capturing both the calendar date and time of day. Used in clinical data systems and ADT feeds to precisely sequence inpatient events such as admissions, transfers, and discharges for care coordination and reporting.

hospital dea numberhosp_dea_nbr

The Drug Enforcement Administration registration number assigned to an inpatient facility authorizing it to prescribe, dispense, or administer controlled substances. Used in pharmacy benefit management and clinical systems to validate facility-level controlled substance transactions and regulatory compliance.

hospital death datehosp_death_dt

The date on which a patient died during or following an inpatient hospital stay. Used in clinical outcomes tracking, mortality reporting, claims finalization, and quality measurement programs such as risk-adjusted mortality rates and CMS inpatient quality reporting initiatives.

PreviousPage 15 of 62Next