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 deleted dategi_del_dt

The date on which a gastroenterology record was marked as deleted or retired within the clinical or administrative system. Used in data governance and audit tracking to document when GI records were logically removed, supporting data lifecycle management and regulatory compliance.

gastroenterology deleted indicatorgi_del_ind

A flag indicating whether a gastroenterology record has been logically deleted or inactivated in the system. Used in data management workflows to filter out retired GI specialist profiles, procedure records, or referral entries without permanently removing them from the database.

gastroenterology descriptiongi_desc

A human-readable text field providing descriptive information about a gastroenterology record, procedure, or clinical finding. Used in clinical documentation to capture narrative details about digestive system conditions, endoscopic findings, diagnoses, or treatment plans in GI care workflows.

gastroenterology detailgi_dtl

Granular clinical or administrative information associated with a gastroenterology record. Captures procedure-level specifics, diagnostic findings, or encounter details related to digestive system care, supporting thorough clinical documentation and downstream reporting for GI service lines.

gastroenterology discharge dategi_dsch_dt

The date a patient was discharged from inpatient or outpatient care following a gastroenterology procedure or hospitalization. Used in GI care coordination and claims processing to mark the end of a digestive care episode, such as post-colonoscopy recovery or GI bleed management.

gastroenterology due dategi_due_dt

The date by which a gastroenterology-related action, payment, or follow-up is expected to occur. Used in GI care scheduling and revenue cycle management to track deadlines for procedure authorizations, follow-up appointments, or billing submissions tied to digestive system services.

gastroenterology durationgi_dur

The measured length of time associated with a gastroenterology procedure, treatment course, or clinical event. Used in GI procedure documentation and operational analytics to capture how long endoscopic procedures, sedation periods, or digestive disorder treatment regimens lasted.

gastroenterology emailgi_eml

The electronic mail address associated with a gastroenterology specialist, practice, or patient contact record. Used in care coordination and referral management to facilitate secure communication between GI providers, referring physicians, and patients regarding digestive care appointments and results.

gastroenterology emergency indicatorgi_emerg_ind

A flag identifying whether a gastroenterology encounter or procedure was performed on an emergency basis. Used in clinical documentation and claims processing to distinguish urgent GI interventions, such as emergency endoscopy for acute GI bleeding, from routine or elective digestive procedures.

gastroenterology end dategi_end_dt

The date marking the conclusion of a gastroenterology treatment episode, authorization period, or clinical record validity. Used in GI care management to close out procedure authorizations, treatment plans, or specialist referrals associated with digestive system conditions and care episodes.

gastroenterology end timegi_end_tm

The time at which a gastroenterology procedure or clinical event was completed. Used in GI procedure documentation and operational reporting to record when endoscopic procedures, sedation, or clinical encounters concluded, enabling accurate duration calculation and resource utilization analysis.

gastroenterology entered bygi_ent_by

Identifies the user who entered or last updated a gastroenterology record in the clinical system. Captures the username or user ID responsible for data entry in GI specialty workflows, supporting audit trails and data governance in EHR and clinical data warehouses.

gastroenterology ethnicitygi_ethn

Records the ethnic background of a patient receiving gastroenterology care. Used in GI specialty reporting to track demographic disparities in digestive disease prevalence, treatment outcomes, and care utilization across diverse patient populations in clinical and administrative systems.

gastroenterology expiration dategi_exp_dt

Captures the date on which a gastroenterology-related record, authorization, referral, or credential becomes invalid. Used to manage time-limited GI specialty authorizations, procedure approvals, and provider certifications within clinical and health plan administrative systems.

gastroenterology external identifiergi_ext_id

Stores a reference ID assigned by an external system to a gastroenterology record, enabling cross-system linkage for GI specialty data. Supports interoperability between EHR platforms, billing systems, and health information exchanges when reconciling digestive care records.

gastroenterology faxgi_fax

Records the facsimile number associated with a gastroenterology practice, department, or specialist. Used to route clinical communications such as referral requests, procedure results, and consultation reports within GI specialty care coordination and administrative workflows.

gastroenterology feegi_fee

Captures the charge amount associated with a gastroenterology service or procedure. Used in billing and revenue cycle management to record fees for GI specialty encounters such as colonoscopies, endoscopies, and consultations within healthcare financial systems.

gastroenterology first namegi_first_nm

Stores the given name of a patient, provider, or contact associated with a gastroenterology record. Used in GI specialty clinical and administrative workflows to display, search, and identify individuals within EHR and practice management systems.

gastroenterology flaggi_flg

A binary or coded marker applied to a gastroenterology record to indicate a specific condition, alert, or status requiring attention. Used in GI specialty workflows to highlight critical findings, care gaps, follow-up needs, or administrative exceptions in clinical data systems.

gastroenterology frequencygi_freq

Captures how often a gastroenterology-related service, procedure, or treatment is scheduled or administered. Used in GI care management to document follow-up colonoscopy intervals, surveillance endoscopy schedules, and medication dosing frequency for digestive conditions.

PreviousPage 270 of 806Next