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 minimumgi_min

The lower threshold value applied to a gastroenterology-related measurement, authorization, or benefit limit, such as minimum age for screening colonoscopy eligibility, minimum required procedure intervals, or minimum clinical criteria for GI specialty referral authorization.

gastroenterology mobilegi_mob

The mobile phone number of a gastroenterologist or GI specialist, used for on-call communications, care coordination, urgent consultation callbacks, and secure messaging related to digestive system patient cases, endoscopy scheduling, and inpatient GI consult workflows.

gastroenterology modified bygi_mod_by

The user identifier of the individual who last updated a gastroenterology-related record, providing an audit trail for changes made to GI provider profiles, procedure documentation, referral records, or clinical data entries in healthcare information systems.

gastroenterology modified dategi_mod_dt

The calendar date on which a gastroenterology-related record was most recently updated, used for audit tracking, data governance, and change history reporting across GI provider profiles, procedure authorizations, clinical documentation, and specialty care management records.

gastroenterology modified timegi_mod_tm

The exact timestamp indicating when a gastroenterology-related record was last updated, used alongside the modified date to provide precise audit trail data for GI provider records, procedure documentation, referral updates, and clinical data changes in healthcare systems.

gastroenterology namegi_nm

The display name associated with a gastroenterologist, GI practice, or digestive system specialty service, used in provider directories, referral documentation, patient-facing scheduling systems, and claims records to identify the GI specialist or specialty unit in a readable format.

gastroenterology notegi_nt

A free-text annotation associated with a gastroenterology encounter, provider record, or procedure, capturing clinical observations, referral instructions, procedure findings, or administrative comments related to digestive system specialty care such as endoscopy results or IBD management notes.

gastroenterology numbergi_nbr

A numeric reference assigned to a gastroenterology record, encounter, or procedure, used as a tracking identifier in claims processing, referral management, endoscopy scheduling systems, and clinical data repositories for digestive system specialty services and provider records.

gastroenterology onset dategi_onset_dt

The date on which a patient's gastrointestinal symptom or digestive system condition first presented, recorded in clinical documentation to establish disease timeline, support diagnostic coding for conditions such as Crohn's disease or GI bleeding, and inform GI treatment planning.

gastroenterology oxygen saturationgi_o2sat

The peripheral blood oxygen saturation level recorded during a gastroenterology procedure, particularly monitored during sedated endoscopic procedures such as colonoscopy or upper endoscopy to ensure patient safety under conscious sedation or general anesthesia protocols.

gastroenterology paid amountgi_pd_amt

The dollar amount reimbursed by a payer for gastroenterology services rendered, such as colonoscopy, endoscopy, or GI consultation claims. Captured in claims adjudication records to reflect actual payment after contractual adjustments, deductibles, and co-insurance are applied.

gastroenterology paid dategi_pd_dt

The date on which payment was issued for a gastroenterology claim, including services related to the esophagus, stomach, intestines, liver, and colon. Used in claims adjudication to reconcile reimbursements for GI procedures such as colonoscopy or endoscopy.

gastroenterology parentgi_prnt

The hierarchical parent entity associated with a gastroenterology record, such as a parent encounter, claim, or organizational grouping. Used in data systems to link GI specialty records to their governing or originating entity for rollup reporting and structural hierarchy management.

gastroenterology percentagegi_pct

A calculated percentage value associated with a gastroenterology encounter or claim, such as coinsurance rate, cost-sharing percentage, or utilization metric. Used in financial and clinical analytics to measure GI service cost distribution or procedure outcome rates.

gastroenterology periodgi_prd

The defined time interval applicable to a gastroenterology record, such as a treatment period, authorization window, or reporting cycle for GI services. Used to establish start and end boundaries for episodes of care involving digestive system conditions and procedures.

gastroenterology phonegi_ph

The telephone contact number associated with a gastroenterology service location, practice, or clinical contact. Used in care coordination and scheduling workflows to facilitate direct communication for GI specialty appointments, referrals, and patient follow-up.

gastroenterology preferred namegi_pref_nm

The preferred display name used to identify a gastroenterology service, facility, or clinical entity within data systems. Used in patient-facing and administrative interfaces to present a standardized, human-readable label for GI specialty services and reporting outputs.

gastroenterology pricegi_prc

The billed or contracted price associated with a gastroenterology service or procedure, such as a colonoscopy, endoscopy, or GI consultation. Used in claims processing and reimbursement workflows to capture the cost before adjustments, discounts, or insurance payments are applied.

gastroenterology primary indicatorgi_prim_ind

A flag that designates whether a gastroenterology record, diagnosis, or provider is the primary designation within a given encounter or claim. Used in claims adjudication and care management to distinguish principal GI diagnoses or lead treating specialists from secondary entries.

gastroenterology prioritygi_prty

A ranking value that indicates the urgency or processing order of a gastroenterology service, referral, or authorization request. Used in care management workflows to triage GI conditions such as GI bleeding or inflammatory bowel disease based on clinical or administrative urgency.

PreviousPage 272 of 806Next