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

frequency procedure datefreq_proc_dt

Records the date on which a clinical procedure associated with a recurring treatment frequency was performed. Used in procedure-linked order management to anchor interval-based follow-up treatments or assessments to the original procedural event, ensuring accurate scheduling within clinical and surgical workflows.

frequency rangefreq_rng

Defines the minimum and maximum permissible interval bounds for a medication or treatment administration frequency, such as every 4 to 6 hours as needed. Used in clinical decision support and pharmacy systems to enforce safe dosing boundaries and allow clinician or patient discretion within prescribed therapeutic limits.

frequency resultfreq_rslt

Captures the clinical outcome or measurement recorded in association with a specific administration frequency event, such as a post-dose lab value or vital sign. Used to evaluate therapeutic response relative to dosing intervals, supporting dose titration decisions and frequency adjustments in medication management workflows.

frequency routefreq_rte

Specifies the anatomical or physiological pathway by which a medication or treatment is delivered at each scheduled frequency interval, such as oral, intravenous, or subcutaneous. Integral to medication order validation in pharmacy systems, ensuring that the prescribed route is clinically appropriate and consistent with the dosage form dispensed.

frequency strengthfreq_str

Defines the concentration or potency of a medication associated with a specific administration frequency schedule, expressed as the amount of active ingredient per dose unit. Used in pharmacy dispensing and clinical documentation to ensure each interval-based administration delivers the precise therapeutic dose intended by the prescriber.

frequency surgery datefreq_surg_dt

Records the operative procedure date linked to a medication or treatment administration frequency schedule. Used to anchor perioperative dosing regimens, such as prophylactic antibiotics or post-surgical analgesics, ensuring interval-based orders are correctly timed relative to the surgical event within clinical order management systems.

gastroenterology active indicatorgi_actv_ind

A binary flag indicating whether a gastroenterology-related record, order, diagnosis, or encounter is currently active within clinical or administrative systems. Used to filter and surface relevant GI conditions and treatment plans during patient care workflows, ensuring clinicians act on current rather than resolved or historical digestive health data.

gastroenterology active statusgi_actv_sts

Represents the current lifecycle state of a gastroenterology-related clinical record, such as an active GI diagnosis, ongoing endoscopic treatment plan, or open referral. Distinct from a binary indicator, this field may carry coded status values supporting nuanced workflow routing in digestive disease management programs.

gastroenterology admission dategi_admn_dt

Records the date a patient was admitted to an inpatient or observation unit for a gastroenterology-related condition such as gastrointestinal bleeding, inflammatory bowel disease, or acute pancreatitis. Used to establish episode timelines, calculate length of stay, and support GI-specific quality reporting and outcomes analysis.

gastroenterology agegi_age

Records the patient's age at the time of a gastroenterology-related encounter, procedure, or diagnosis. Used in GI clinical analytics to stratify colorectal cancer screening eligibility, inflammatory bowel disease onset patterns, and age-adjusted prevalence metrics across digestive disease populations in registry and outcomes reporting systems.

gastroenterology allowed amountgi_alwd_amt

The maximum dollar amount a payer has approved for reimbursement of a gastroenterology service, such as a colonoscopy or endoscopic procedure, based on contracted rates or fee schedules. Used in claims adjudication to calculate patient cost-sharing obligations and provider payment for GI-related services rendered.

gastroenterology amountgi_amt

The monetary value associated with a gastroenterology encounter or procedure, such as colonoscopy, endoscopy, or GI consultation. Used in billing and financial reconciliation workflows to record charges tied to digestive system specialty services.

gastroenterology approved bygi_appr_by

The identifier of the clinician or administrator who authorized a gastroenterology-related order, referral, or procedure such as an endoscopic examination or GI treatment plan. Supports audit trails and clinical accountability in digestive disease care workflows.

gastroenterology arrival timegi_arrv_tm

The recorded time a patient arrived for a scheduled gastroenterology appointment or procedure, such as a colonoscopy prep or endoscopy suite visit. Used in operational reporting to measure patient flow efficiency and wait times in GI specialty units.

gastroenterology arrived dategi_arrv_dt

The calendar date on which a patient arrived for a gastroenterology visit or procedure, such as an endoscopy, liver biopsy, or GI consultation. Used in scheduling systems and clinical data warehouses to track appointment adherence and care timelines.

gastroenterology assessmentgi_asmt

The structured or free-text clinical evaluation documented by a gastroenterologist following examination of a patient with digestive system conditions such as Crohn's disease, GERD, or colorectal disorders. Captures diagnostic impressions and clinical reasoning in the patient record.

gastroenterology balancegi_bal

The remaining unpaid amount owed on a gastroenterology account after insurance adjudication and patient payments have been applied. Used in revenue cycle management to track outstanding patient financial responsibility for digestive specialty services.

gastroenterology billed amountgi_bill_amt

The total charges submitted to a payer or patient for gastroenterology services rendered, including procedures such as colonoscopy, flexible sigmoidoscopy, or GI consultation visits. Represents the gross invoice value before adjustments or insurance payments.

gastroenterology birth dategi_birth_dt

The date of birth of a patient receiving gastroenterology care, used to calculate age-related screening eligibility such as colorectal cancer screening at age 45, pediatric GI assessments, and age-stratified digestive disease risk analysis.

gastroenterology blood pressuregi_bp

The systolic and diastolic arterial pressure measurement recorded during a gastroenterology encounter. Clinically relevant for monitoring patients with conditions such as portal hypertension, liver cirrhosis, or GI bleeding where hemodynamic status affects treatment decisions.

PreviousPage 268 of 806Next