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

gynecology total countgyn_tot_cnt

Represents the aggregate number of gynecological encounters, procedures, diagnoses, or records within a defined dataset or reporting period. Used in women's health population analytics, quality reporting, and operational dashboards to measure service volume and care utilization trends.

gynecology typegyn_typ

Classifies the category of a gynecological record, encounter, or service, such as preventive, diagnostic, surgical, or reproductive endocrinology. Used in women's health EHR and claims systems to differentiate service lines, support billing code selection, and enable specialty-specific reporting.

gynecology updated dategyn_upd_dt

Records the most recent date on which a gynecological clinical or administrative record was modified in the health information system. Used in women's health data warehouses and EHR audit logs to track record currency, support data governance, and identify changes to patient information.

gynecology urgencygyn_urg

Indicates the clinical time-sensitivity or priority level assigned to a gynecological encounter, referral, or procedure, such as routine, urgent, or emergent. Used in women's health scheduling and triage systems to ensure appropriate resource allocation and timely intervention for reproductive health conditions.

gynecology valuegyn_val

The discrete measured data point captured within a gynecological clinical encounter or assessment, such as a cervical measurement, hormone level, or pelvic finding. Used to record quantitative or qualitative results specific to female reproductive health evaluations and screenings.

gynecology versiongyn_ver

The sequential version number assigned to a gynecological clinical record, indicating how many times the record has been updated or revised. Used to track document history, support audit trails, and ensure clinicians are referencing the most current female reproductive health data on file.

gynecology zipgyn_zip

The postal ZIP code associated with a gynecological service location, patient residence, or referring facility within a female reproductive health record. Used to support geographic analysis, care access reporting, and population health studies related to gynecological services and outcomes.

hcpcs active indicatorhcpcs_actv_ind

A binary flag indicating whether a specific HCPCS procedure or supply code is currently active and eligible for use in claims submission. Inactive codes may have been deleted or replaced, and this indicator prevents billing errors by signaling whether the code is valid for the applicable service date.

hcpcs active statushcpcs_actv_sts

The current lifecycle status of an HCPCS code, indicating whether it is active, terminated, or pending within the CMS code set. This field supports claims adjudication by ensuring that only valid, currently recognized procedure and supply codes are accepted for reimbursement processing.

hcpcs admission datehcpcs_admn_dt

The date a patient was admitted to a facility in connection with a claim line containing an HCPCS-coded service. Used in institutional claim processing to establish the episode of care timeline and validate that the billed HCPCS code corresponds to services rendered during the inpatient stay.

hcpcs discharge datehcpcs_dsch_dt

The date a patient was discharged from a facility associated with an HCPCS-coded claim line. Used in institutional claims processing to define the end of the care episode, validate covered HCPCS services, and calculate length of stay for reimbursement and utilization reporting purposes.

hcpcs durationhcpcs_dur

The total time span associated with the delivery of an HCPCS-coded service, such as the number of minutes for an infusion or hours for durable medical equipment use. Used in claims processing to validate units billed and ensure reimbursement aligns with the documented length of service provided.

hcpcs emergency indicatorhcpcs_emerg_ind

A flag on an HCPCS-coded claim line identifying whether the associated service was delivered in an emergency context. Used during claims adjudication to apply appropriate reimbursement rules, override prior authorization requirements, and support reporting on emergency utilization patterns across procedure categories.

hcpcs history present illnesshcpcs_hpi

The clinical narrative documenting the patient's current condition and symptom history as it relates to an HCPCS-coded service on a claim. Supports medical necessity determinations during claims review by providing context for why a specific procedure, supply, or service was ordered and performed.

hcpcs instructionhcpcs_instr

The usage or billing guidance text associated with a specific HCPCS code, including coverage requirements, documentation expectations, or coding rules published by CMS. Used by billing staff and payers to ensure correct application of HCPCS codes in claims submission and adjudication workflows.

hcpcs labelhcpcs_lbl

The short descriptive display text assigned to an HCPCS code that identifies the procedure, supply, or service it represents. Used in claims processing systems, remittance displays, and reporting interfaces to provide human-readable identification of coded services without requiring lookup of full code descriptions.

hcpcs notehcpcs_nt

Free-text annotation associated with an HCPCS code or claim line, capturing supplemental information such as billing clarifications, payer-specific rules, or clinical documentation remarks. Used during claims review and audit processes to provide additional context beyond what the structured HCPCS code fields alone convey.

hcpcs procedure datehcpcs_proc_dt

The specific date on which an HCPCS-coded procedure or service was performed. Used in claims adjudication to validate that the billed HCPCS code was active on the date of service, confirm timely filing compliance, and align the service with applicable coverage periods and authorization windows.

hcpcs rangehcpcs_rng

The defined span of HCPCS codes within a specific category, such as A0000–A9999 for transport and medical supplies. Used in claims editing, benefit configuration, and coverage policy management to apply rules, exclusions, or reimbursement logic consistently across related groups of procedures and supplies.

hcpcs resulthcpcs_rslt

The clinical or procedural outcome recorded in association with an HCPCS-coded service, such as a lab test result or therapy response measurement. Used to support medical necessity validation, quality reporting, and outcomes analysis tied to specific procedure and supply codes billed on professional or outpatient claims.

PreviousPage 298 of 806Next