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 revisionfrm_rev

The version or iteration number of a clinical or administrative form, indicating how many times the document has been updated since its original creation. Used in document management to ensure staff reference current content, maintain audit trails, and support regulatory compliance for controlled forms.

form riskfrm_rsk

The risk level or score assigned to a patient or case as documented on a clinical or care management form. Used in population health management, utilization review, and care coordination to stratify members by clinical or financial risk and prioritize intervention outreach and resources.

form routefrm_rte

The administration route for a medication or treatment as documented on a clinical order or medication administration form, such as oral, intravenous, or topical. Supports pharmacy dispensing, nursing administration workflows, and medication reconciliation across inpatient and ambulatory care settings.

form scheduled datefrm_sched_dt

The calendar date on which a clinical service, procedure, or appointment associated with a form is planned to occur. Used in scheduling systems, prior authorization workflows, and care coordination to align clinical activities with coverage periods and operational capacity planning.

form scheduled timefrm_sched_tm

The specific time of day at which a clinical service, procedure, or appointment associated with a form is planned to occur. Used in scheduling and operational workflows to coordinate clinical staff, facility resources, and patient preparation for the documented encounter or service.

form scorefrm_scr

The calculated numeric or categorical rating derived from responses on a standardized clinical assessment form in EHR or care management platforms, such as PHQ-9 or AUDIT scores. Used by data engineers to support risk stratification, quality measures, and population health analytics.

form sequencefrm_seq

The numeric ordering value that determines the position of a form, form section, or form line item within a standardized data collection workflow in EHR or claims systems. Data engineers rely on this field to correctly reconstruct multi-part form submissions and maintain data integrity during ETL processing.

form severityfrm_sev

The coded or descriptive value indicating the seriousness or intensity of a clinical condition or finding as captured on a standardized form in EHR or care management systems. Data engineers use this field to support acuity scoring, risk adjustment models, and clinical decision support data pipelines.

form sexfrm_sex

The patient's biological sex as recorded on a clinical or enrollment form, typically coded as male, female, or unknown. Used in clinical documentation, eligibility verification, quality reporting, and actuarial analysis to support sex-specific care guidelines and population health stratification.

form sourcefrm_src

The origin identifier indicating which system, provider, facility, or workflow generated a standardized form record in EHR, claims, or member enrollment platforms. Used by data engineers to track data provenance, resolve duplicates, and apply source-specific transformation rules during ingestion.

form start datefrm_start_dt

The beginning date of a clinical episode, treatment period, or data collection window as documented on a standardized form in EHR or care management systems. Data engineers use this field to define temporal boundaries for longitudinal member records, authorization periods, and program enrollment spans.

form start timefrm_start_tm

The time at which a clinical procedure, service, or documented activity associated with a form began. Used in operative reports, therapy documentation, and billing workflows to calculate duration, establish anesthesia or procedure timing, and support accurate claim submission and audit review.

form statefrm_st

The U.S. state or territory recorded on a clinical or administrative form, typically as part of a patient, facility, or payer address. Used in eligibility verification, licensure validation, benefit plan assignment, and geographic analysis within health plan enrollment and claims processing systems.

form statusfrm_sts

The current workflow or processing state of a standardized form in EHR, claims, or member enrollment systems, such as draft, submitted, approved, or closed. Used by data engineers to filter active records, trigger downstream processing logic, and monitor form completion rates across operational data pipelines.

form street addressfrm_st_addr

The street-level mailing or physical address captured on a clinical or administrative form, including street number and name. Used in member enrollment, claims adjudication, coordination of benefits, and correspondence workflows to route communications and verify geographic eligibility for health plan coverage.

form strengthfrm_str

The concentration or potency of a drug as recorded on a pharmacy or medication form, expressed as a numeric value with unit of measure (e.g., 500mg, 10mg/mL). Used in pharmacy dispensing records, medication administration forms, and clinical documentation to ensure accurate dosing.

form subtotalfrm_subtot

The partial sum of charges, units, or line items calculated within a healthcare form prior to final totaling. Used in claims processing, billing forms, and encounter documentation to aggregate specific categories of charges or services before applying adjustments, taxes, or additional fees.

form system identifierfrm_sys_id

The unique system-generated key assigned to a specific healthcare form instance within a clinical or administrative data system. Used to track, retrieve, and link form records across EHR, claims, and reporting platforms, ensuring each form submission is distinctly identifiable throughout its lifecycle.

form targetfrm_tgt

The destination reference identifying the intended recipient system, provider, facility, or care goal associated with a standardized form in EHR or care coordination platforms. Used by data engineers to route form data to appropriate downstream systems and map referral or transition-of-care workflows.

form taxonomy codefrm_tax_cd

The standardized specialty classification code associated with a healthcare form, aligned with NUCC taxonomy standards. Used in claims and enrollment forms to identify the clinical specialty or service category under which a form was submitted, supporting proper routing and adjudication.

PreviousPage 118 of 325Next