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

address admission dateaddr_admn_dt

The date a patient was admitted to a facility associated with a specific address record, linking a physical location to an inpatient encounter. Used in clinical and administrative data systems to establish the temporal relationship between a patient's address on file and the start of a hospital or facility-based episode of care.

address discharge dateaddr_dsch_dt

The date a patient was discharged from a facility associated with a specific address record, marking the end of an inpatient or facility-based episode linked to that location. Used in administrative and clinical systems to close the address-encounter relationship and support billing, care transitions, and post-discharge follow-up workflows.

address emergency indicatoraddr_emerg_ind

A flag that identifies whether a patient's address record is associated with an emergency care encounter or designates an emergency contact location. Used in clinical and administrative systems to distinguish emergency-related address entries from standard residential or mailing addresses, supporting triage documentation and urgent care coordination workflows.

address history present illnessaddr_hpi

Narrative description of the history of present illness associated with a specific address record, linking a patient's clinical condition onset and progression to a physical location. Used in EHR systems to correlate geographic data with clinical documentation for epidemiological and care coordination purposes.

address labeladdr_lbl

Formatted display text used to render a physical location record in user interfaces, printed correspondence, and mailing outputs. Combines structured address components such as street, city, state, and ZIP into a standardized human-readable format for member communications, claims processing, and provider directory displays.

address procedure dateaddr_proc_dt

Date on which a clinical procedure was performed, as associated with a specific address record in the patient's location history. Used to correlate treatment events with the patient's address at time of service, supporting care continuity tracking, claims adjudication, and population health management workflows.

address rangeaddr_rng

Numeric or alphanumeric span defining valid street number boundaries for a geographic address segment. Used in address validation, geocoding, and member eligibility systems to verify that a submitted address falls within a recognized delivery range, supporting accurate claims routing and member correspondence.

address resultaddr_rslt

Outcome of an address verification, standardization, or geocoding process applied to a physical location record. Indicates whether the address was validated, corrected, or flagged as undeliverable. Used in member enrollment, claims processing, and care management systems to ensure accurate member contact and correspondence delivery.

address surgery dateaddr_surg_dt

Date on which a surgical procedure was performed, linked to the patient's address record active at the time of the operation. Used to associate operative events with a patient's residential or facility location history, supporting post-surgical follow-up coordination, claims adjudication, and longitudinal care record management.

adjustment admission dateadj_admn_dt

The inpatient or facility admission date recorded on an adjusted claim in hospital billing and claims adjudication systems. Used to reconcile the original admission date against the modified claim, ensuring correct DRG assignment, length-of-stay calculations, and authorization alignment during adjustment review.

adjustment discharge dateadj_dsch_dt

The corrected or modified hospital discharge date applied during claims adjudication in EHR and payer systems. Used to reconcile inpatient stay durations after billing corrections, coordinating with DRG reimbursement calculations and UB-04 claim reprocessing workflows.

adjustment emergency indicatoradj_emerg_ind

Flag identifying whether a claims adjustment transaction was initiated due to an emergency condition or urgent processing requirement. Used in claims adjudication systems to prioritize financial modifications, trigger expedited review workflows, and ensure compliance with regulatory timelines for emergency-related payment corrections.

adjustment history present illnessadj_hpi

Clinical narrative documenting the history of present illness that prompted a claims adjustment transaction. Used to support medical necessity reviews during the adjustment process, providing context for why a claim was modified, reprocessed, or reversed within the payer adjudication or appeals workflow.

adjustment labeladj_lbl

Descriptive display text identifying the type or reason for a claims or financial adjustment transaction. Used in claims processing, remittance advice, and reporting systems to communicate the nature of a payment modification to providers, members, and internal financial teams in a standardized, human-readable format.

adjustment procedure dateadj_proc_dt

Date of the clinical procedure that is the subject of a claims adjustment transaction. Used in claims adjudication systems to verify service timing, apply correct fee schedules, validate timely filing compliance, and ensure the financial modification aligns with the original date of service on the affected claim.

adjustment rangeadj_rng

The minimum and maximum value boundaries defining the allowable span for a financial modification in claims or payment processing systems. Used in PBM platforms, remittance processing, and payer adjudication engines to validate that adjustment amounts fall within contractually or regulatorily permissible thresholds.

adjustment resultadj_rslt

The calculated or determined outcome of a financial modification applied to a claim, remittance, or payment record. Used in payer adjudication engines, EHR revenue cycle systems, and PBM platforms to capture whether an adjustment produced a balance due, overpayment recovery, or zero-balance resolution for downstream reconciliation.

adjustment surgery dateadj_surg_dt

Date of the surgical procedure referenced in a claims adjustment transaction. Used in claims adjudication and payment correction workflows to validate that the operative service date aligns with authorization periods, contract terms, and benefit eligibility, ensuring accurate reprocessing of surgery-related claim modifications.

admission account numberadmn_acct_nbr

Unique numeric or alphanumeric identifier assigned to a patient's hospital inpatient admission for billing and account tracking purposes. Used across revenue cycle management, claims submission, and clinical systems to link all charges, services, and financial transactions to a single inpatient encounter throughout the patient's stay.

admission active indicatoradmn_actv_ind

Binary flag indicating whether a hospital inpatient admission record is currently active within the system. Used in census management, bed tracking, and clinical workflow systems to distinguish open admissions requiring ongoing care coordination from closed or discharged encounters in reporting and operational dashboards.

PreviousPage 26 of 806Next