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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

form assessmentfrm_asmt

The structured or free-text clinical evaluation recorded by a provider on a clinical documentation form, capturing the clinician's interpretation of patient symptoms, findings, and diagnoses. Used in SOAP-format documentation to drive care planning, coding, and downstream clinical decision support.

form balancefrm_bal

The outstanding financial amount remaining after payments and adjustments on a standardized healthcare form submission. Used in claims processing, EHR billing systems, and accounts receivable workflows to track unpaid liabilities associated with specific claim or encounter form records.

form billed amountfrm_bill_amt

The total gross dollar amount charged by a provider for services documented on a specific clinical or administrative form before payer adjustments or contractual discounts. Used in claims processing and revenue cycle management to initiate the adjudication and payment reconciliation process.

form birth datefrm_birth_dt

The member or patient date of birth as recorded on standardized healthcare data collection forms. Used in EHR, claims, and member enrollment systems for identity verification, eligibility validation, age-based benefit determination, and coordination of benefits across payer and provider platforms.

form blood pressurefrm_bp

The systolic and diastolic arterial blood pressure measurement recorded on a clinical documentation form during a patient encounter. Used in vital signs tracking, chronic disease management, and clinical decision support workflows to monitor cardiovascular health and trigger care interventions.

form cancelled datefrm_cncl_dt

The calendar date on which a clinical or administrative form was voided or withdrawn from processing. Used in audit trails, workflow management, and reporting systems to track form lifecycle events and support investigations into documentation corrections or service cancellations.

form categoryfrm_cat

The classification grouping assigned to a standardized healthcare data collection form, distinguishing form types such as clinical assessments, prior authorization requests, or claims submissions. Used in EHR and payer systems to route, process, and report on form data by functional category.

form charge amountfrm_chrg_amt

The dollar value assigned to a specific service or procedure captured on a clinical or administrative form, representing the provider's listed fee before any payer adjustments. Used in revenue cycle and claims management workflows to initiate billing and calculate net reimbursement.

form chief complaintfrm_cc

The primary symptom, condition, or reason for visit as reported by the patient and recorded on a clinical documentation form at the start of an encounter. Used to guide clinical assessment workflows, support triage prioritization, and inform medical coding and diagnosis documentation.

form childfrm_chld

The subordinate or dependent form record linked to a parent form in a hierarchical healthcare data structure. Used in EHR and claims systems to represent detail-level line items, secondary diagnoses, or nested form submissions associated with a primary parent form record within a transaction set.

form cityfrm_city

The name of the city associated with the address captured on a clinical or administrative form, such as a patient's residence or a facility location. Used in member enrollment, claims processing, and care coordination systems for geographic routing, eligibility verification, and population health reporting.

form classfrm_cls

The classification tier assigned to a standardized healthcare form, indicating its functional level such as institutional, professional, or pharmacy. Used in claims processing and EHR systems to determine applicable data validation rules, processing workflows, and reimbursement logic by form classification type.

form codefrm_cd

The standardized classification value assigned to identify a specific healthcare form type within data collection and processing systems. Used in EHR, claims, and payer platforms to categorize forms such as CMS-1500 or UB-04, enabling proper routing, adjudication, and regulatory compliance reporting workflows.

form coinsurance amountfrm_coins_amt

The dollar amount representing the patient's percentage-based cost-sharing responsibility for services documented on a specific clinical or administrative form. Calculated after deductibles are met and used in claims adjudication and patient billing workflows to determine the member's out-of-pocket liability.

form commentfrm_cmt

Free-text notation field captured on standardized healthcare data collection forms to provide supplemental clinical or administrative context. Used in EHR and claims systems to document exceptions, coordination of benefits notes, prior authorization rationale, or other unstructured information tied to a specific form record.

form completed datefrm_cmpl_dt

The calendar date on which all required fields of a clinical or administrative form were fully documented and finalized. Used in care management, compliance tracking, and reporting systems to measure documentation timeliness, closure rates, and adherence to clinical workflow standards.

form confidential indicatorfrm_conf_ind

A binary flag designating that a clinical or administrative form contains sensitive patient information subject to restricted access controls, such as behavioral health, substance use, or HIV-related data. Used in EHR security frameworks to enforce HIPAA and 42 CFR Part 2 privacy protections.

form contactfrm_cntct

The designated communication point, such as a person, phone number, or email, recorded on a standardized healthcare data collection form. Used in EHR, claims, and member enrollment systems to facilitate follow-up, appeals processing, or provider and member outreach associated with specific form submissions.

form countfrm_cnt

The numeric total of standardized healthcare form records submitted, processed, or associated within a given dataset or transaction batch. Used in claims analytics, EHR reporting, and PBM systems to measure form volume, identify processing gaps, and support operational monitoring of data pipeline throughput.

form countryfrm_ctry

The name or standard code of the country associated with the address recorded on a clinical or administrative form, such as a patient's residence or facility location. Used in member enrollment and claims systems to support international plan eligibility, cross-border care coordination, and regulatory reporting.

PreviousPage 113 of 325Next