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

remittance labelremit_lbl

The human-readable display name assigned to a remittance record or payment explanation category within healthcare financial systems. Used to identify and classify Electronic Remittance Advice (ERA) transactions, adjustment reason codes, and payer payment explanations during claims reconciliation.

remittance procedure dateremit_proc_dt

The procedure service date as reflected on an Electronic Remittance Advice (ERA) or Explanation of Benefits (EOB). Used in claims payment reconciliation to match remitted procedure-level payments against original claim line service dates and identify date-related payment discrepancies or denials.

remittance surgery dateremit_surg_dt

The surgical procedure date as reflected on an Electronic Remittance Advice (ERA) or Explanation of Benefits (EOB). Used in claims reconciliation to verify that payer remittance correctly corresponds to the original surgical claim service date and that appropriate surgical reimbursement was applied.

report admission daterpt_admn_dt

The inpatient admission date associated with a structured clinical report such as a discharge summary or care transition document in EHR and claims systems. Data engineers use this field to align clinical report records with encounter timelines and validate episode-of-care attribution in analytics pipelines.

report discharge daterpt_dsch_dt

The inpatient discharge date recorded within a structured clinical report such as a discharge summary or care transition document in EHR and claims systems. Data engineers use this field to close episode-of-care windows, validate report timing, and support readmission risk calculation workflows.

report emergency indicatorrpt_emerg_ind

A flag indicating whether a structured clinical report is associated with an emergency encounter or requires urgent review. Used in clinical documentation systems to prioritize report routing, trigger expedited clinician notification workflows, and distinguish emergency visits from routine encounters in reporting.

report history present illnessrpt_hpi

The narrative description of a patient's current symptoms, onset, duration, and progression as documented within a structured clinical report. This History of Present Illness (HPI) section provides clinical context for the encounter and supports diagnostic reasoning, coding accuracy, and care continuity.

report labelrpt_lbl

The human-readable display name assigned to a structured clinical report within healthcare documentation systems. Used to identify report types such as discharge summaries, operative notes, radiology interpretations, or consultation reports across EHR, HIM, and clinical data warehouse environments.

report procedure daterpt_proc_dt

The date on which a clinical procedure was performed, as documented within a structured clinical report. Used in clinical documentation and coding workflows to establish the procedure service timeline, support medical record integrity, and ensure accurate procedure-level data for quality and claims reporting.

report rangerpt_rng

The defined numeric or date span associated with data included in a structured clinical report in EHR and analytics systems. Data engineers use this field to establish report boundaries, filter qualifying records, and ensure complete data capture within population health and quality measure reporting pipelines.

report resultrpt_rslt

The structured outcome value or status recorded within a clinical or administrative report in EHR, lab, and claims systems. Data engineers use this field to extract actionable findings, map results to standard code sets such as LOINC or SNOMED, and feed downstream quality and clinical decision support pipelines.

report surgery daterpt_surg_dt

The date on which a surgical procedure was performed, as documented within a structured clinical report such as an operative note or surgical summary. Used in clinical documentation systems to establish the surgical service timeline, support post-operative care coordination, and ensure accurate surgical record integrity.

requirement active indicatorreq_actv_ind

A flag indicating whether a specific mandatory specification, compliance rule, or operational requirement is currently in effect within healthcare data systems. Used to control which requirements are enforced during claims processing, prior authorization workflows, credentialing, or regulatory compliance validation at a given point in time.

requirement active statusreq_actv_sts

Indicates whether a prior authorization or clinical requirement is currently active, inactive, or suspended within utilization management workflows. Used to filter and process only valid, enforceable requirements during claims adjudication and care coordination reviews.

requirement admission datereq_admn_dt

Records the inpatient admission date associated with a prior authorization or clinical necessity requirement. Used in utilization management to validate that authorized services align with the actual hospital admission timeline for concurrent review and claims adjudication.

requirement assessmentreq_asmt

Captures the clinical assessment narrative submitted to support a prior authorization, medical necessity determination, or care management requirement. Includes clinician-documented findings used by reviewers to evaluate appropriateness of requested services against clinical criteria.

requirement discharge datereq_dsch_dt

Records the inpatient discharge date tied to a prior authorization or utilization management requirement. Used to calculate authorized length of stay, validate claims for covered inpatient days, and trigger post-discharge care management follow-up activities.

requirement durationreq_dur

Specifies the authorized time span during which a clinical requirement, prior authorization, or prescribed treatment is considered valid. Used in utilization management to enforce service limits and ensure claims submitted fall within the approved authorization window.

requirement emergency indicatorreq_emerg_ind

Flags whether a prior authorization requirement was triggered by an emergency condition, allowing expedited review timelines as mandated by state and federal regulations. Affects adjudication rules, retroactive authorization eligibility, and turnaround time requirements for utilization management.

requirement history present illnessreq_hpi

Stores the history of present illness narrative submitted as clinical documentation supporting a prior authorization or medical necessity requirement. This chronological account of symptom onset and progression informs utilization reviewers evaluating appropriateness of requested services.

PreviousPage 573 of 806Next