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 expiration datefrm_exp_dt

The date after which a standardized healthcare data collection form is considered invalid or no longer actionable in EHR, payer, and member enrollment systems. Used to enforce submission deadlines for prior authorizations, enrollment applications, and clinical assessments.

form external identifierfrm_ext_id

Stores the unique identifier assigned to a form by an external system, such as a referring facility, health information exchange, or third-party platform. Used to cross-reference and reconcile form records across disparate healthcare systems during data integration, interoperability, and patient record matching workflows.

form faxfrm_fax

Records the facsimile number associated with a facility, provider, or contact entity as captured on a clinical or administrative form. Used to route clinical documents, prior authorization requests, referrals, and other healthcare communications to the appropriate receiving party via fax-based transmission workflows.

form feefrm_fee

Captures the monetary charge associated with a specific clinical service, administrative process, or medical form completion, such as record release or medical clearance fees. Used in revenue cycle management and billing workflows to track charges tied to form-related services outside of standard claims processing.

form first namefrm_first_nm

Records the given name of the patient, provider, or contact individual as entered on a clinical or administrative form. Used in patient identification, demographic matching, and display within healthcare systems to ensure accurate association of form data with the correct individual across care settings.

form flagfrm_flg

A binary status indicator applied to a standardized healthcare data collection form record in EHR, claims, or member enrollment systems to denote processing states such as incomplete submission, pending review, duplicate detection, or compliance hold requiring manual intervention.

form frequencyfrm_freq

Captures the prescribed administration frequency of a medication or treatment as documented on a clinical order or assessment form, such as twice daily or every eight hours. Used in medication management, care planning, and pharmacy dispensing workflows to ensure accurate scheduling and patient safety compliance.

form full namefrm_full_nm

Records the complete name, including first, middle, and last name components, of a patient, provider, or contact as entered on a clinical or administrative form. Used in identity verification, demographic record matching, and display across healthcare systems to ensure accurate attribution of form data to the correct individual.

form genderfrm_gndr

Captures the gender identity or administrative sex classification of a patient as recorded on a clinical or demographic form. Used in clinical decision support, demographic reporting, health equity analytics, and regulatory submissions to ensure appropriate care delivery and compliance with federal data collection standards.

form glucosefrm_gluc

Records the blood glucose measurement captured on a clinical assessment or monitoring form, reflecting a patient's blood sugar level at the time of collection. Used in diabetes management, inpatient glycemic control protocols, and chronic disease monitoring to inform treatment decisions and track metabolic health trends.

form group numberfrm_grp_nbr

Stores the insurance group number recorded on a clinical or administrative form, identifying the specific employer or plan group under which a member holds coverage. Used in eligibility verification, claims adjudication, and benefit coordination workflows to link patients to their correct insurance plan and coverage terms.

form hemoglobinfrm_hgb

The hemoglobin measurement value captured on a clinical assessment or intake form, typically recorded in g/dL. Used in chronic disease management, pre-operative screening, and dialysis monitoring workflows to track a patient's red blood cell oxygen-carrying capacity over time.

form identifierfrm_id

A unique alphanumeric value assigned to a specific standardized data collection form instance in EHR, payer, and member enrollment systems, such as a prior authorization ID or enrollment application number, enabling end-to-end tracking and cross-system record linkage.

form indexfrm_idx

A system-generated sequential integer used to reference a specific standardized healthcare data collection form within a database structure in EHR, claims, and enrollment systems. Facilitates efficient indexing, record retrieval, and relational joins in form processing pipelines.

form indicatorfrm_ind

A boolean or enumerated field in EHR, payer, and member enrollment systems that signals whether a standardized data collection form meets a specific classification criterion, such as completion status, regulatory compliance flag, or eligibility for downstream automated processing workflows.

form instructionfrm_instr

Descriptive or coded guidance text embedded within or associated with a standardized healthcare data collection form in EHR, payer, and enrollment systems, directing users or automated processes on required fields, submission protocols, or data entry validation rules.

form keyfrm_key

The unique lookup reference value assigned to a specific clinical or administrative form instance, enabling cross-system retrieval and linkage. Used in EHR and health information systems to associate submitted form data with related patient encounters, orders, or workflow events.

form languagefrm_lang

The preferred spoken or written language recorded on a patient-facing clinical or administrative form, used to ensure appropriate communication and translation services. Supports compliance with language access requirements and drives delivery of culturally competent care across health system encounters.

form last namefrm_last_nm

The patient's or respondent's family surname as recorded on a clinical or administrative form at the time of submission. Used for identity matching, record linkage, and verification against enrollment or registration data in EHR and health information systems.

form legal namefrm_legal_nm

The official full legal name of the patient or individual as recorded on a clinical or administrative form, used for identity verification and legal documentation purposes. Critical for accurate record matching in health plan enrollment, prior authorization, and clinical registration workflows.

PreviousPage 115 of 325Next