Attachment J - Reporting~1.docx

Attachment J - Reporting

STATE OF ILLINOIS

Illinois Gaming Board Attachment J — Reporting Central Communications System Procurement BidBuy Reference Number B45047

State of Illinois RFP V.24.3 2 This document is an attachment to the Request for Proposal (RFP) for the Illinois Gaming Board (IGB), for the procurement of a Central Communications System (CCS). This Attachment J provides the detailed Reporting requirements for the IGB CCS RFP. The Offeror shall read and understand the goals and objectives and all reporting requirements found in the RFP, as well as in this attachment.

To ensure the Illinois Gaming Board (IGB) can effectively oversee and regulate Video Gaming activities within the state, the Offerors solution shall be capable of generating detailed reports. These reports are crucial for the IGB to monitor compliance, assess financial health, and optimize the overall management of Video Gaming operations.

A. Data and Reporting Compliance and Governance

a. The proposed Central Communication System (CCS) shall provide data and reporting capabilities sufficient to meet requirements in the Video Gaming Act (230 ILCS 40), Illinois Administrative Rules (Title 11 (D) (I) 1800), Technical Standards for Video Gaming Terminals v. 1.4 dated August 2019, and Video Gaming Terminal Operator Account Sweep Schedule (Procedures) per the IGB public website.

b. The proposed Central Communication System (CCS) shall provide data and reporting compliance of rules, statutory and references to the following current or future Acts and Rules in the Video Gaming Act (230 ILCS 40), Illinois Administrative Rules (Title 11 (D) (I) 1800), Technical Standards for Video Gaming Terminals v. 1.4 dated August 2019, and Video Gaming Terminal Operator Account Sweep Schedule (Procedures) per the IGB public website.

c. The proposed Central Communication System (CCS) and Offeror shall comply with SOC reporting standards, transitioning from the previously required ISO certification to align with the Illinois Auditor General’s Office preferences needed for fulfilling the requirements of the resulting contract. (e.g., SOC 1 Type 2, and SOC 2)

B. Minimum Data and Reporting Requirements

a. Access: All reports shall be available for licensees and Board staff using role-based access.

b. Formatting: All reports shall be applicable and available in detail and summary form as necessary to support licensee and Board operations. Reports shall be exportable in the following formats XML, CSV, PDF, MHTML, Excel, TIFF, Word, and Common Database Formats.

c. Dates: All reports shall support data being searched, run, or scheduled by dates or a range of dates from the inception of the current CCS system to current.

d. Comprehensive Data Description: The Offeror shall provide an exhaustive catalog of the types of data the central communications system will capture. This should cover player data, game performance metrics, financial transactions, and any anomalies or security breaches. The description should detail not only the type of data but also how it will be stored, processed, and protected.

e. Detailed System Reporting Capabilities: The Offeror shall provide an outline of the reporting functions the system will offer, emphasizing customizability, real-time analytics, and automated reporting. For each report type, specify the data sources, the frequency of generation, and how these reports can be tailored to meet the IGB's specific monitoring needs.

f. Alignment with IGB's Strategic Objectives: The solution should explicitly link the system's capabilities with the IGB's strategic objectives for monitoring and regulating Video Gaming. This should include examples of how the system will improve compliance monitoring, enhance the detection of illegal activities, and support responsible gaming initiatives.

g. Efficiency Improvements: The Offeror shall provide details that streamline current processes for monitoring and administering Video Gaming activity. This should include reducing manual data entry, automating compliance checks, and providing dashboard views for quick assessments of gaming activities across the state.

h. Data Integrity and Security: The Offeror shall provide an in-depth measure that will ensure data integrity and security, including encryption methods, access controls, and audit trails. These features should help the IGB safeguard sensitive information and comply with relevant data protection laws.

i. Scalability and Futureproofing: The solution should scale and adapt to future changes in gaming regulations, technology advancements, or increases in gaming activity. Include considerations for integrating new types of games or gaming venues.

j. User Training and Support: The Offeror shall provide training and support to IGB staff to ensure they can effectively utilize the new system. Include information on documentation, help desk support, and ongoing training opportunities to keep staff updated on new features or best practices.

k. Real Time Data and Reports: The solution shall provide reports and dashboards of critical data identified by IGB staff. Data should include (e.g., tampering, outages, resources such as receipt paper or cash being full or empty) and provide such data in a way that is actionable. These reports and dashboards shall consume and present data immediately and not on a regular basis or scheduled data refresh.

l. Data and Reporting Integration: The solution shall provide integration methods and support of data and reports to Third Party and State systems, software, and solutions identified by the State for fulfilling the requirements of the resulting contract.

m. Machine and Game Level Information: The solution shall provide reliable and functional reporting required to manage the granularity of data required for comprehensive monitoring, including anti-money laundering efforts of machine and game level data.

C. Data and Reporting Standard Data Fields The system should, at a minimum, capture and organize data fields essential for fulfilling the requirements of the resulting contract. The following data fields are examples derived from the current solution's architecture and functionalities.

Table 1: Data Fields

D. Key Financial Metrics and Performance Indicators for Video Gaming Terminals (VGTs) The system should, at a minimum, capture and organize Financial Metrics and Performance Indicators essential for fulfilling the requirements of the resulting contract. The following are examples derived from the current solution's architecture and functionalities.

a. Net Terminal Income (NTI) defined as money put into a video gaming terminal minus credits paid out to players

b. Net Play — amount played less amount won by wagerer

c. Administrative Share — Central Communication System (CCS) vendor administrative fee as a percentage of net terminal income

d. State Share — tax imposed on Net Terminal Income (NTI) and collected by the Board

e. Total Bill — (by terminal operator) calculated as tax imposed on NTI plus central system administrative fee

f. Average NTI (Revenue) for Days Revenue posted by Establishments by Terminal Operator (for a range of days)

g. Total Days NTI Earned by Terminal Operator (for a range of days)

h. Average NTI by Establishment by Terminal Operator (for a range of days)

i. Total Days NTI posted for a Terminal Operator for all Establishments for a date range

j. Total number of Establishments posting NTI (for a range of days)

k. Total number of live gaming days for all Establishment by terminal operator (for a range of days)

l. NTI Per VGT Terminal Per Day by Terminal Operator (for a range of days)

m. Statewide Average NTI Per VGT Per Day (for a range of days)

n. Total Days NTI Earned by Each Establishment (for a range of days)

o. Total NTI revenue Earned for Each Establishment (for a range of days)

p. Average NTI per Establishment Per Day (for a range of days)

q. Average NTI per VGT per Day

r. Average Total Days of NTI revenue for each Establishment (for a range of days)

s. Average Establishment NTI Per Day (for a range of days)

t. Average Net Revenue per VGT per Day for each Establishment (for a range of days)

u. Summations/Counts

v. VGT Device

w. Establishment Count

x. Voucher Count

y. Total Days NTI Revenue Posted

z. Date First NTI Revenue Observed

aa. Total Days NTI revenue.

E. Data and Reporting Canned Reports The system should at a minimum provide any reports required to fulfill the resulting contract. The following reports are sample descriptions of existing reports provided in the current solution.

a. Accounting and Operational Reports provide appropriate calculations and reporting video gaming activity at the individual game, game set level, video gaming terminal, establishment, and terminal operator level. Example scenarios:

i. Video gaming accounting and transaction activity

ii. Game performance data and statistics

iii. VGT, meter and event activity and monitoring, including non-reporting terminals information

iv. All voucher activity, including Voucher Liability and Expired Vouchers reporting as outlined in 1800.110 and 1800.1410 (e) of the Administrative Rules

v. Meter adjustment reporting, including hard meter and soft meter adjustments

vi. Undue Economic Concentration reporting as required in 230 ILCS 40/25(i) of the Video Gaming Act and 1800.440 of the Administrative Rules

vii. Progressive Jackpot Reporting as outlined 230 ILCS 40/20 and 1800.2010-2160 of the Administrative Rules

b. Terminal Operator Billing Reports provide appropriate summary terminal operator billing information at the establishment and terminal operator level. Example scenarios:

i. Total net terminal income

ii. State share of tax imposed on net terminal income

iii. CCS vendor administrative fee

iv. Billing adjustments

v. Total terminal operator billing, including file of EFT activity

vi. Local government tax allocation and distribution reporting as required by 230 ILCS 40/60 and 230 ILCS 40/75 of the Video Gaming Act. Reporting should include both detail and summary reports and a file extract that can be used in file transmission

c. Auditing Reports provide appropriate summary reporting at the VGT, meter, game and game set level. Example scenarios:

i. User activity

ii. Inventory reporting, including hardware and software

d. Expired Vouchers Reporting The CCS should include capabilities to accurately track, report, and account for expired vouchers.

i. Rulemaking: The Offeror should amend existing rules to define and manage expired vouchers specifically for video gaming, given the current regulations primarily address casino gambling.

ii. Policy and Procedural Resolutions: The Offeror should address the handling and reconciliation of facility pay voucher issues, acknowledging the technological limitations of some redemption terminals (RTs).

e. Undue Economic Concentration Reporting

i. The Offeror should develop, implement, and maintain reporting capabilities for undue economic concentration, as stipulated by the Act and Rules.

ii. The Offeror should modify and maintaining current reporting to comply with ongoing requirements, considering potential staffing constraints and expertise availability.

f. Progressive Jackpots Functionality and Reporting

i. The RFP should specify the need for functionality and reporting support for progressive jackpots, reflecting updates to the Video Gaming Act and Rules F. Data and Reporting Ad Hoc Reports The system should at a minimum provide a tool to generate any reports for all data collected by the Offeror solution and required to fulfill the resulting contract.

END OF ATTACHMENT J — REPORTING