Appendix N - Example of Monthly Interface Volumes.docx

This document is Appendix N to the Idaho Department of Health and Welfare's System Integrator Builder procurement, providing a comprehensive reference table of monthly interface volumes for the Medicaid Management Information System (MMIS) integration project. The appendix details 67 distinct data interfaces and their transaction frequencies, establishing baseline metrics for system performance and capacity planning. Transaction volumes vary significantly across interfaces, ranging from minimal monthly volumes (such as the 10042_ICSES_Carrier interface with fewer than 10 transactions monthly) to exceptionally high-volume daily transfers (including the 10380_Eligib interface processing approximately 28.4 million transactions daily and the 10229_Financial_Trans interface handling roughly 28.2 million transactions weekly). The interfaces encompass diverse functional areas including eligibility management, claims processing, prior authorization, member data, provider information, and integration with external systems such as CMS, PBM vendors (Magellan), dental providers (MCNA), behavioral health (OPTUM), vision services (NVA), and other third-party administrators. Transaction frequencies range from daily to yearly intervals, with most interfaces operating on daily or monthly schedules.

The volume data presented serves as a critical specification component for the successful system integrator, establishing performance requirements and throughput expectations that the proposed MMIS integration solution must accommodate. This appendix provides potential contractors with essential technical parameters to assess system architecture scalability, database capacity, processing power, and network infrastructure requirements. The interface volumes demonstrate the complexity and mission-critical nature of the integration project, requiring bidders to design solutions capable of processing billions of transactions monthly while maintaining data integrity, system reliability, and compliance with healthcare information management standards. Contractors must leverage this volumetric information to develop robust integration architecture, implement appropriate load balancing, ensure adequate redundancy, and establish performance monitoring mechanisms that align with Idaho's healthcare information management objectives.