Attachment J - Interfaces.xlsx

This is an Interface Inventory document that details the inbound and outbound data connections between a state's financial management system and numerous external entities across multiple state agencies, including the Department of Human Services (DHS), Department of Children and Family Services (DCFS), Department of Transportation (DOT), Healthcare and Family Services (HFS), and the Illinois Tollway, among others. The document catalogues mission-critical interfaces that facilitate the exchange of financial, human capital management, procurement, and asset management data across the enterprise system landscape.

The inventory identifies over 300 distinct interfaces organized by functional process area including Accounts Payable (AP), Accounts Receivable (AR), Asset Management (AM), Budget (BU), General Ledger (GL), Grant Management (GM), Procurement (PR), Payroll/Personnel (PS), and Human Capital Management (HCM). These interfaces operate through multiple technology protocols and connection methods, with the majority utilizing MoveIT flat file transfers (approximately 65 percent of interfaces), while others employ REST APIs, JDBC connections, SOAP protocols, HTTP, and manual uploads. The interfaces support critical business processes such as vendor master management, invoice processing, payment distribution, check deposits, cash receipts, payroll posting, purchase orders, contract management, and general ledger entries. Interface types include bi-directional, inbound, and outbound configurations, with specific interface identifiers (such as AP_I_1_237) cross-referenced to Data Analysis Report (DAR) system numbers to correlate with the inventory of state systems. The document indicates that interfaces have been implemented progressively across the enterprise, with some systems preferring dynamic connections while others rely on traditional flat file exchanges, reflecting the heterogeneous nature of the state's technology environment and the need for flexible integration approaches to support diverse agency requirements.