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 procedure dategi_proc_dt

The date on which a gastroenterology procedure was performed, such as a colonoscopy, upper endoscopy, or ERCP. Used in claims processing, clinical documentation, and quality reporting to establish the service date for GI treatments and associate them with the correct billing period.

gastroenterology pulsegi_pulse

The recorded pulse rate for a patient at the time of a gastroenterology encounter or procedure. Used as a clinical vital sign in pre-procedure assessments for GI interventions, helping clinicians evaluate patient stability before and after procedures such as sedated endoscopy.

gastroenterology quantitygi_qty

The count or volume associated with a gastroenterology service, such as the number of units billed, medication doses dispensed, or procedures performed. Used in claims adjudication and pharmacy management to validate service quantities against contracted rates and authorization limits.

gastroenterology racegi_race

The self-reported or recorded racial classification of a patient receiving gastroenterology services. Used in population health analytics and quality reporting to identify disparities in GI disease prevalence, screening rates, and treatment outcomes across racial demographic groups.

gastroenterology rangegi_rng

The minimum and maximum boundary values for a gastroenterology clinical measurement or financial metric, such as lab reference ranges for GI biomarkers or cost thresholds. Used in clinical decision support and analytics to flag abnormal results or out-of-range claim values.

gastroenterology rategi_rt

The reimbursement or utilization rate associated with gastroenterology services, such as per-unit pricing on a fee schedule or the frequency of GI procedure performance within a population. Used in financial modeling and contract management for digestive system specialty services.

gastroenterology ratinggi_rtg

An assigned assessment score for a gastroenterology provider, service, or outcome, such as a quality rating, patient satisfaction score, or risk tier. Used in network management, value-based care programs, and quality improvement initiatives for GI specialty services.

gastroenterology ratiogi_ratio

A proportional value comparing two gastroenterology metrics, such as the ratio of GI specialist visits to primary care referrals or the cost ratio between inpatient and outpatient GI procedures. Used in utilization management and financial analytics to benchmark digestive care efficiency.

gastroenterology reasongi_rsn

The documented explanation or justification associated with a gastroenterology event, such as the reason for a GI referral, claim denial, prior authorization decision, or procedure indication. Used in clinical and administrative workflows to support audit trails and care coordination.

gastroenterology received dategi_rcvd_dt

The date on which a gastroenterology claim, referral, authorization request, or clinical document was received by the processing entity. Used in claims management and care coordination to track turnaround times and ensure timely adjudication of GI specialty service requests.

gastroenterology referencegi_ref

An external identifier or pointer linking a gastroenterology record to a related entity, such as a referring encounter, authorization number, or external clinical guideline. Used in data integration workflows to maintain traceability between GI claims, orders, and associated clinical events.

gastroenterology resolution dategi_resol_dt

The date a gastrointestinal condition, episode, or finding was considered resolved or inactive. Used in clinical documentation to track the duration of GI disorders such as Crohn's disease, colitis, or peptic ulcer disease and measure treatment effectiveness.

gastroenterology respirationgi_resp

The recorded respiratory rate for a patient receiving gastroenterology care, captured as part of vital sign assessment. Respiratory changes can indicate complications from GI conditions such as peritonitis, bowel perforation, or severe gastrointestinal bleeding requiring clinical escalation.

gastroenterology resultgi_rslt

The outcome or finding from a gastroenterology procedure, diagnostic test, or clinical evaluation. Captures results from colonoscopies, endoscopies, biopsy pathology, or GI lab panels such as H. pylori testing, stool cultures, or liver function assessments.

gastroenterology revisiongi_rev

The version or iteration number of a gastroenterology clinical record, treatment plan, or procedure report that has been updated. Tracks amendments to GI procedure findings, diagnostic interpretations, or care plans following additional review or new clinical information.

gastroenterology riskgi_rsk

The assessed risk level associated with a gastroenterology patient's condition, procedure, or treatment. Captures stratified risk scores for GI procedures such as endoscopy complications, bleeding risk in ulcer disease, or malignancy likelihood in polyp or lesion findings.

gastroenterology routegi_rte

The administration pathway for medications or therapeutic agents prescribed in gastroenterology care. Specifies delivery methods such as oral, rectal suppository, intravenous, or nasogastric tube, which are commonly used in managing GI conditions including IBD, GERD, and hepatic disorders.

gastroenterology scoregi_scr

A standardized numerical rating used in gastroenterology clinical assessment, such as the Mayo Score for ulcerative colitis, Harvey-Bradshaw Index for Crohn's disease, MELD score for liver disease severity, or AIMS65 score for upper GI bleeding risk stratification.

gastroenterology sequencegi_seq

The positional order of a gastroenterology record, diagnosis, procedure, or finding within a patient encounter or clinical workflow. Used to rank multiple GI diagnoses by clinical priority or to sequence steps within a multi-stage GI procedure or treatment protocol.

gastroenterology severitygi_sev

The clinical severity classification of a gastrointestinal condition or episode, such as mild, moderate, or severe. Used to stratify GI disorders including inflammatory bowel disease flares, hepatic encephalopathy grades, or acute pancreatitis severity using validated scoring systems.

PreviousPage 273 of 806Next