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

gastroenterology sexgi_sex

The patient's biological sex recorded in the context of gastroenterology care. Relevant to GI risk stratification as certain conditions such as colorectal cancer, autoimmune hepatitis, and irritable bowel syndrome demonstrate sex-based prevalence and treatment response differences.

gastroenterology sourcegi_src

The originating system, facility, or clinical encounter from which a gastroenterology record or finding was derived. Identifies whether GI data originated from an endoscopy unit, outpatient GI clinic, inpatient consult, pathology lab, or external referral source.

gastroenterology start dategi_start_dt

The date a gastrointestinal condition, treatment course, or clinical episode began. Used to calculate duration of GI disorders such as chronic hepatitis, IBD flares, or post-procedural recovery periods and to support longitudinal tracking of digestive system health events.

gastroenterology start timegi_start_tm

The precise time a gastroenterology procedure, treatment, or clinical event commenced. Captured for time-sensitive GI interventions such as endoscopy, colonoscopy, ERCP, or acute GI bleed management where procedure duration and timing impact clinical documentation and quality metrics.

gastroenterology stategi_st

The U.S. state or territory associated with a gastroenterology encounter, facility, or patient address. Used in GI population health reporting, regional disease surveillance for conditions like colorectal cancer screening rates, and geographic analysis of digestive disease burden.

gastroenterology statusgi_sts

The current clinical or administrative status of a gastroenterology condition, referral, or procedure. Indicates whether a GI episode is active, resolved, in remission, or pending, supporting care coordination and tracking of chronic GI conditions such as IBD or chronic liver disease.

gastroenterology strengthgi_str

The concentration or dosage strength of a medication prescribed or administered in gastroenterology care. Applies to GI-specific drugs such as mesalamine formulations, proton pump inhibitors, antifungals for esophageal candidiasis, or biologic agents used in inflammatory bowel disease treatment.

gastroenterology subtotalgi_subtot

A partial sum of charges, units, or findings within a gastroenterology encounter or billing record. Used in claims adjudication and clinical reporting to aggregate GI procedure costs, itemized service lines, or partial encounter data before applying adjustments or total calculations.

gastroenterology surgery dategi_surg_dt

The date a surgical procedure was performed for a gastrointestinal condition. Captures operative dates for GI surgeries such as colectomy, cholecystectomy, gastrectomy, bowel resection, or hepatic procedures, supporting post-operative care planning and surgical outcome tracking.

gastroenterology targetgi_tgt

The intended clinical target for a gastroenterology treatment, therapeutic intervention, or quality measure. Specifies goals such as mucosal healing in IBD, target lab values for liver disease management, or colonoscopy adenoma detection benchmarks used in GI quality improvement programs.

gastroenterology taxonomy codegi_tax_cd

The National Uniform Claim Committee taxonomy code identifying the specialty classification of a gastroenterology provider. Used in claims processing and provider directories to distinguish GI subspecialties such as general gastroenterology, hepatology, transplant hepatology, or pediatric gastroenterology.

gastroenterology temperaturegi_temp

Body temperature measurement recorded during a gastroenterology encounter, used to monitor fever or hypothermia in patients with GI conditions such as Crohn's disease, colitis, or post-procedural complications like infection following colonoscopy or endoscopy.

gastroenterology termination dategi_term_dt

Date on which a gastroenterology-related episode of care, treatment plan, or clinical program concludes. Used to define the end boundary of GI care episodes including post-procedural follow-up periods, chronic disease management plans, or specialist referral authorizations.

gastroenterology timegi_tm

Time of day associated with a gastroenterology clinical event, such as procedure start or end time for colonoscopy or endoscopy. Supports scheduling, resource utilization tracking, and procedural documentation within GI specialty workflows and clinical data systems.

gastroenterology timestampgi_ts

Combined date and time value marking when a specific gastroenterology event occurred, such as procedure completion, clinical note creation, or lab result entry. Ensures precise sequencing of GI clinical events for audit trails, care coordination, and outcomes analysis.

gastroenterology titlegi_ttl

Formal label or heading assigned to a gastroenterology record, document, or clinical protocol, such as a procedure report title or care plan designation. Used to standardize naming conventions for GI clinical documentation, referral letters, and endoscopy or colonoscopy reports.

gastroenterology totalgi_tot

Aggregate numeric value associated with a gastroenterology encounter or billing record, such as total charges, total units of service, or total procedure count. Used in financial reconciliation, claims adjudication, and GI specialty utilization reporting across clinical data warehouses.

gastroenterology total countgi_tot_cnt

Cumulative number of gastroenterology-related events, procedures, or encounters recorded for a patient or population, such as total colonoscopies performed or total GI clinic visits. Supports quality metrics, screening compliance tracking, and specialty utilization analysis.

gastroenterology typegi_typ

Classification category identifying the nature of a gastroenterology record or encounter, such as diagnostic endoscopy, therapeutic procedure, outpatient consultation, or inpatient GI consult. Used to route clinical data appropriately and support GI specialty reporting and analytics.

gastroenterology updated dategi_upd_dt

Date on which a gastroenterology record was most recently modified, such as updates to a procedure report, diagnosis coding correction, or care plan revision. Supports audit trail maintenance, data governance, and change tracking within GI clinical and administrative systems.

PreviousPage 274 of 806Next