AGCO Data Inventory

Under Ontario’s Open Data Directive, provincial agencies are required to post a public Data Inventory of all the data sets they create, collect and/or manage. Publishing public Data Inventories is part of Ontario’s commitment to improving transparency, accountability and openness.

The Alcohol and Gaming Commission of Ontario’s Data Inventory lists all of the agency’s data sets and identifies whether a data set is currently open, in the process of being opened or exempt from being released as open data due to legal, security, privacy, confidentiality or commercially-sensitive reasons. For datasets marked “Will be Made Open/ Public”, some data elements may be removed prior to being made open if they fall under applicable exemptions.

Alcohol and Gaming Commission of Ontario Data Inventory 

Rules, laws and directives for provincial agencies

# Public Title Long Description Access Level
1 HRIS and Online Attendance The data contained in this database is used to track employee and attendance information, which is transferred via export files to the payroll system (Insync). Restricted
2 Payroll and Benefits System The data contained in this database is used to process employee payroll. Restricted
3 Job Evaluation Manager This is a tool used to conduct job evaluations and stores historical job data. Restricted
4 Data for Quarterly and Annual  Workforce Report Metrics related to workforce and human resources related activities. These include organizational metrics and demographic information for the Alcohol and Gaming Commission of Ontario (AGCO), such as workforce size, completed recruitments, job postings, training hours, information related to labour relations and complaints, etc. Certain data, including secondment and promotion data, reported to the public in the AGCO Annual Report. Staff numbers are made available to the public in the AGCO Business Plan. Will be made open/public
5 Travel and Hospitality Disclosure - Board & Chair, Executive & Directors, and Top Five Claimants Semi-Annually This dataset shows the person’s name and title, purpose of the trip(s), date and destination of the trip(s), names of government/ agency attendees, if applicable, plus a summary of expenses for relevant airfare, other transportation, accomodation, meals, hospitality and incidentals. Under review
6 Board Report Monthly reports to the Alcohol and Gaming Commission of Ontario Board including revenue financial statements (compares current and prior year revenue with variance commentary), expense reports (of the year to-date expenditure position by standard groups of accounts), and consulting service and other contracts reports (shows all consulting and other contracts and their details).  Restricted
7 Break Open Ticket Volumes This dataset is based on reports from break open ticket (BOT) manufacturers on the number and types of BOT boxes sold. It assesses, for internal purposes, total volume, the percent by each manufacturer, and variances from previous years, etc. Restricted
8  Alcohol and Gaming Commission of Ontario (AGCO) Performance Measures  The purpose of this Performance Measurement Framework is to act as an addendum to the Strategic Plan and outline an approach to gauge the AGCO’s performance against the agency’s Strategic Goals and Planning Themes. It includes regulatory compliance data (e.g., data related to infractions), service-related data (e.g., average application turnaround time, response to service quality surveys), data on strategic engagement (e.g., percent increase in participation in national and international working groups), and Human Resources assessments (e.g., increase in training hours). Under review
9 Liquor Licence Applications Processed The data in this report provides details on application type, status, and the licence’s risk level. Restricted
10 Liquor and Gaming information Monthly Liquor and Gaming KPI information for each of the last 12 months, including number of casino registrations and processing times, fees collected for commercial and charitable gaming, compliance inspections, and gaming equipment submissions and inspections, etc. (Gaming Dashboard) as well as the number of liquor-related applications received, processing time, infractions statistics, Special Occasion Permits received and reviewed, number of liquor complaints, and infractions, as well as media calls related to liquor, etc. (Liquor Dashboard). Will be made open/public
11 Performed Inspections Count The report includes calendar year, week of the year and count of weekly inspections performed for the last fifty-three weeks. Will be made open/public
12 Infraction Count The report includes the calendar year, week of the year and count of weekly infractions for the last fifty-three weeks. Will be made open/public
13 Big 5 Infraction Count The report includes the calendar year, week of the year and count of weekly Big 5 infractions for the last fifty-three weeks. Will be made open/public
14 Big 5 Infraction Rate The report includes the calendar year, week of the year and the weekly Big 5 infraction rate for the last fifty-three weeks. Will be made open/public
15 Weekly Inspection  The report includes establishment and  inspection data and the risk level of the establishment. Restricted
16 Weekly Infraction  The report includes establishment and infraction data and the risk level of the establishment. Restricted
17 Weekly  Big 5 Infraction The report includes establishment data, its risk level and Big 5 infraction rate. Restricted
18 Inspection and Infraction report The report includes establishment weekly inspection and infraction data. Restricted
19 Infraction detail report The report includes establishment data and details on the type and number of infractions. Restricted
20 Monthly media calls The media log details the date of the call, the name of the media outlet, as well as the description of the questions asked. Number of media inquiries related to liquor and type are included in the Corporate Dashboard for Liquor.  Will be made open/public
21 Alcohol and Gaming Commission of Ontario (AGCO) horse racing offices  This dataset lists the AGCO standardbred, thoroughbred, and quarterhorse offices located at racetracks and their hours of operation. Available on the AGCO website. Under review
22 Alcohol and Gaming Commission of Ontario (AGCO) Offices List of all Alcohol and Gaming Commission regional service locations that provide services to our stakeholders and the public, as well as the operating hours. Available on the AGCO Contact Us webpage. Under review
23 Horse Racing Appeal Panel statistics This dataset tracks metrics such the number of notices of appeal received, number of hearings, number of stay motions heard, number of stays granted, number of Type A and Type B hearings heard, etc., since the Horse Racing Appeal Panel was constituted on April 1, 2016. Will be made open/public
24 Police Reports Tracking Sheet This is the master tracking sheet for all reports received from Alcohol and Gaming Commision of Ontario partners in law enforcement. It includes charges laid by local police and internal workflows (e.g. reports forwarded to the Deputy Registrar Review process). Restricted
25 Deputy Registrar Review Reports Submitted by Region This log summarizes the inspection reports that are forwarded to the Deputy Registrar Review process.  Restricted
26 Charitable Gaming Inspection Statistics This document summarizes the number of OLG and charitable gaming inspections completed by AGCO inspectors.  Will be made open/public
27 Monthly Enforcement Activity Statistics This spreadsheet communicates monthly tallies of  all inspections completed by Alcohol and Gaming Commission of Ontario Inspectors, sorted by category (e.g. liquor, lottery, Break Open Ticket), compares tallies to other periods, and communicates year-to -date figures.    Will be made open/public
28 Investigations and Enforcement Internal Tracking Sheet This spreadsheet tracks reports through the Deputy Registrar Review Process. Restricted
29 Master Investigative Spreadsheet This excel spreadsheet tracks all liquor and gaming investigations.  Restricted
30 Ontario Lottery and Gaming  Corporation (OLG) Triage Statistics This Word document tracks all Ontario Lottery Gaming investigations forwarded to Investigations and Enforcement Branch (IEB) for disussion and/or IEB investigation Restricted
31 Ontario Provincial Police Last Drink and Police (LDP) Tracking Report This spreadsheet tabulates Last Drink and Police Reports received by the Bureau, sorted by Ontario Provincial Police region. Restricted
32 Investigations - Category 1 & 2 Gaming Assistant - Bingos & Casinos - 2016  This spreadsheet summarizes regulatory reviews for Cat 1 & 2 Gaming Assistants regarding present and prospective Bingo and  Casino employees. Restricted
33 Investigations – Seller & Lottery Retail Manager - 2016 This spreadsheet logs regulatory reviews of current and prospective OLG product sellers and lottery retail managers. Restricted
34 Investigations – Regular Corporate - 2016 This spreadsheet summarizes regulatory reviews into current and prospective corporate entities (gaming/nongaming, trade union, and gaming operators). Restricted
35 Assist Other Agency  This report summarizes requests for regulatory information from provincial and international Memorandum of Understanding  holders. Restricted
36 Ontario Provincial Police / Alcohol and Gaming Commission Parking Passes This spreadsheet summarizes all parking passes for AGCO inspectors and OPP officers at 90 Sheppard Ave. in Toronto. Restricted
37 Ontario Provincial Police / Alcohol and Gaming Commission Fleet This spreadsheet lists all vehicles assigned to OPP and AGCO personnel, including pool vehicles. Restricted
38 Ontario Provincial Police Budget Report This table lists all Ontario Provincial Police employees within Investigations and Enforcement Branch, locations they are posted to, badge numbers, WIN, rank. Restricted
39 Quarterly Racing Inspection Statistics This table summarizes totals of racing inspections and investigations initiated during the previous quarter.  Will be made open/public
40 Daily Activity Report This dataset contains information related to daily logs of inspections and infractions by Alcohol and Gaming Commission of Ontario Liquor Inspectors.  Information includes liquor licensee information such as licence numbers, addresses, inspection logs and infraction details.  Restricted
41 Lotteries System This database is used to store information related to lottery licensing entered by AGCO Gaming Registration Officers (GRO) and contains  an eligible charitable or religious organization’s licensing information including the licence type, address of licensee, where event is being held and details of the event such as revenue generated and use of proceeds.   Restricted
42 Slot History System This database contains information related to infractions entered by Alcohol and Gaming Commission of Ontario  Electronic Gaming Inspectors and contains data taken from electronic gaming machines operated in Ontario casinos, slot facilities and E-Bingo sites.   Information includes infraction details such as site employee names and postions, compliance issues and remedial action.   Restricted
43 Gaming Registation Module This database contains information related to Gaming registrations for individuals and organizations who are employed at Ontario gaming sites including casinos, slot facilities and bingo sites. It includes information such as personal information of individuals (incl. risk scores and whether or not the individual passed the background check) and contact information of organizations.  Restricted
44 Liquor Licensing Module This dataset contains information related to Liquor Licensing for individuals and organizations that are engaged in selling liquor in Ontario.  Information includes liquor licensee names, addresses, security checks and licence details.   Restricted
45 Compliance Module This dataset contains information related to inspections and infractions of liquor licencees, including infraction type, date, inspection locations, etc. Restricted
46 Liquor Special Occasion Permit (SOP) Module This dataset contains information related to Special Occasion Permits (SOP) issued by the Liquor Control Board of Ontario (LCBO).  Information includes the Refuse to Issue (RTI) list that flags any issues with permit holders and locations that flags LCBO to forward the SOP application to AGCO for review.  Restricted
47 Liquor Hearing Module This dataset contains information related to Notices of Proposed Orders (NOPO), Order of Monetary Penalties (OMPs), warnings and other sanctions imposed on liquor licences.   Restricted
48 Approval System This database contains information related to testing of electronic gaming equipment that is entered by the Technical and Laboratory Services, including approval status and conditions on gaming equipment tested.  Will be made open/public
49 Gaming Compliance Management System (Checkpoint) This database contains information related to inspections and infractions entered by Alcohol and Gaming Commission of ONtario Gaming Compliance Inspectors.  Inspectors enter data from Ontario casinos, slot facilities and Bingo Halls.  Information includes inspection checklists, infraction details such as employee names and positions, compliance issues and remedial action.   Restricted
50 Lotteries - Event Reports Break Open Tickets Tracks Bingo, Loonie progressive, Media bingo, Bingo progressive, Monster (Special) bingo, super jackpot, Break Open Tickets, Nevada tickets, raffle, social gaming event financial information as submitted by the licensees. Restricted
51 Ministry of Health - Compliance List received from the Ministry of Health tracking assessments and penalties against licensees under the Smoke-free Ontario Act. Under review
52 Compliance re: Education / Complaints Tracks complaints from licensee/bingo players including the nature of the complaint and possible personally identifiable information. Restricted
53 Ontario Lottery and Gaming Corporation Active / Pending Suspended Retailers List This dataset is obtained weekly from the OLG and includes location, expiry date, and establishment information and status of the registration. Restricted
54 Charitable Gaming Summary Reports Tracks Bingo Hall financial information, performance (wins, sales), fees, etc. Restricted
55 Raffles Issued Monthly Summary Type of raffle, dates of the events, applicant information, terms and conditions.  Restricted
56 50/  50 Special Draw Raffles - Pilot Project Dataset includes financial information such as total wagers, revenues, etc. Restricted
57 Retail Store Database This database is used to generate reports for the number and location of on-site/off-site liquor retail stores for both internal and external stakeholders.  Will be made open/public
58 Farmer’s Market Authorization Tracker  Tracks the number and locations of wineries/farmers’ markets participating in the VQA Wine Sales at Farmers’ Market pilot program. Under review
59 Master Request for Proposal Spreadsheet Details pertaining to applicants and Ontario Lottery and Gaming Corporation bundles for land-based casino modernization.  This includes sensitive proponent information. Restricted
60 Customer Service Complaints Tracker This dataset includes the content of the complaint,  date of incident and receipt of complaint,  type of complaint (e.g., liquor or gaming), and full contact information (if provided). Restricted
61 Accessibility for Ontarians with Disabilities (AODA) Feedback Tracking Log AODA Feedback Tracking Log used to track accessibility comments and to ensure compliance with the Accessibility for Ontarians with Disabilities and all contacts are properly tracked. Restricted
62 List of Liquor Sales License Applications - Notice Web Posting List (English/French) All liquor sales licence applications currently filed with the Alcohol and Gaming Commission of Ontario for which a public notification is required, and includes the establishment name and address, submission deadline date, file number, type of application and area(s) applied for. Under review
63 Daily / Weekly Monthly Call Centre Reports  Data produced directly from the system and includes data related to call centre activity, including how long a call took, volume of calls, etc. Will be made open/public
64 Certified Copies Processed Logs (Liquor Licenses only) Tracks all certified copies requests (liquor licenses only) that have been processed through Customer Service. Restricted
65 Complaints Tracker Monthly Tracks the number of complaints, nature of complaints, complainant information, and nature of complaints follow-up and handling, etc. Will be made open/public
66 Miscellaneous Customer Tracking Log Tracks influx of calls (by nature of contact) for a particular business initiative such as events/media in Ontario (i.e World Cup, media announcement). Will be made open/public
67 Customer service voice tree data Dataset includes where in the voice tree that customers request a customer service representative, and how they are able to navigate the telephone customer voice tree. Will be made open/public
68 Current active liquor sales licences Data includes business name, address of establishment, licence number, etc. Will be made open/public
69 Liquor Sales Licences issued for the month Data includes business name, address, license date, expiry date, etc. Will be made open/public
70 Liquor Sales Applications received for the month Data includes business name, address, license date, expiry date, etc. Restricted
71 Ontario Licensed Distilleries Data includes business name, address, license date, expiry date, etc. Will be made open/public
72 Ontario Licensed Representatives Data includes business name or individual name, address, license date, expiry date, etc. Will be made open/public
73 Ontario Liquor Delivery Service Licensees Data includes business name, address, license date, expiry date, etc. Will be made open/public
74 Ontario Licensed Breweries Data includes business name, address, license date, expiry date, etc. Will be made open/public
75 Ontario Licensed Establishments with Catering endorsements Data includes business name, address, license date, expiry date, etc. Will be made open/public
76 Ontario Licensed Wineries Data includes business name, address, license date, expiry date, etc. Will be made open/public
77 Ontario Brew-on-Premise Licensees Data includes business name, address, license date, expiry date, etc. Will be made open/public
78 Bring Your Own Wine Endorsements Data includes business name, address, license date, expiry date, etc. Will be made open/public
79 Applications requiring advertising or requesting that a condition be removed List of applications requiring advertising or requesting that a condition be removed, received in the preceding month, and includes the type of condition requested to be removed.  Restricted
80 New Liquor Applications, Ontario, Received in the Last Two Months Dataset includes name of the establishment and confirmation of receipt of application. Restricted
81 New Liquor Licences Issued List of new liquor sales licenses issued in the last two weeks and provided to Canadian Restaurant & Food services. Will be made open/public
82 New Liquor Transfer Licences Issued List of new liquor sales license transferred issued in the last two weeks and provided to Canadian Restaurant & Food services. Will be made open/public
83 New Liquor Applications  List of new applications received in the last two weeks in selected areas. Restricted
84 New Liquor Applications in designated areas List of new applications received in previous month in Mississauga, Brampton, Woodbridge, Maple, and Etobicoke Restricted
85 Current Liquor Licences in designated areas List of current licensees in Mississauga,Brampton, Woodbridge, Maple, and Etobicoke.  Will be made open/public
86 Monthly Liquor Applications by Type Number of applications received in previous month, by type, submitted to the  Ministry of Finance. Will be made open/public
87 Licence Type Counts Number of licences issued by AGCO by type. This data is available on an annual basis in the AGCO annual report.  Under review
88 New Liquor Licence Applications Received, Liquor Licence Transfers, Additional Facilities Applications, and Licenses issued in the Last Two Weeks New liquor licence applications received, liquor licene transfers, additional facilities applications, and licenses issued in the last two weeks. Includes data such as business name, location, licence/transfer date, expiry, etc. Restricted
89 Active Liquor Delivery Licences in Ontario List of all active liquor delivery licensees in Ontario, including licence number. Will be made open/public
90 Ministry of Finance - Compliance Violation information is used in relation to lottery retailer licensing. Under review
91 Horse Racing Complaints tracker This data includes complaints with respect to horse-racing, including the nature of the complaint.  Restricted
92 Supplier notification system Dataset related to defects in software / hardware identified by supplier of equipment and/or identified by the AGCO upon review. Restricted
93 Electronic Gaming Branch Statistic- fiscal This spreadsheet details billings performed by T&LS against targets. Restricted
94 Game issues log Defects in software / hardware of games not approved or approved with terms and conditions by the AGCO. Restricted
95 Lab review form tracker Quality assurance tracker of testing performed including type of tests, quality concerns with testing or reporting identified, etc. used as a performance measure for staff. Restricted
96 Testing quality assurance review form Supplemental and independent quality assurance of testing performed including type of tests, quality concerns with testing or reporting identified, etc. used as a performance measure for staff. Restricted
97 Gaming Equipment Issue tracker This is summary and tracking information for issues identified in the field after the gaming equiment is in service. This database is similar to supplier notification system, but holds different information. Restricted
98 Paytable information This dataset relates to Ontario Lottey Gaming Sites only and will be decommissioned September 8, 2016. Will be made open/public
99 Seal tracker List of seal numbers used to ensure no one tampers with the gaming equipment once it’s installed. Restricted
100 Quarterly meter analysis Performance of electronic games as compared to the theoretical holdout percentage.  This is being decommissioned September 8, 2016 Restricted
101 New supplier registration applications tracking sheet This set includes both suppliers that continue through the registration process, as well as those who erroneously applied for things they didn’t need to. Restricted
102 Complaints database This set includes customer complaints submitted to Electronic Gaming Compliance Inspectors, Gaming Compliance Inspectors, and their management teams in cGaming and casino environments. Restricted
103 Rules of play submissions tracking Primarily received from the Ontario Lottery and Gaming Corporation, tracks the proposed changes to rules of play for table games. Restricted
104 Internal Control Manual database for casinos Tracks the proposed changes to sites’ internal control manuals submitted for review. Restricted
105 Internal Control Manual database for lotteries Tracks the proposed changes to the Ontario Lottery and Gaming Corporation’s internal control manual submitted for review.  Includes internal control manual changes and games approvals submitted to Technical & Laboratory Services. Restricted
106 Compliance Scorecards and Snapshots Includes attendance, revenue, year to date visits by Gaming Compliance staff, as well as a number of statistical pieces derived from the Checkpoint and Slot History System databases, including analysis on risk. Restricted
107 Test equipment inventory and preventative maintenance log List of types of all technical equipment in the AGCO laboratory, including controllers, servers, and maintenance information.  Restricted
108 Equipment qualification records Record of all equipment received by the AGCO. This log ensures equipment is capable of performing at the desired level.  Updated once a piece of equipment arrives at the lab and is qualified.  Restricted
109 Safety, housekeeping and sensitive information log Logs include date and time of inspections, deficiency information, etc. Restricted
110 Corrective action, preventive action, non-conformance report log This log tracks corrective actions, preventive actions, and non-conformances to the lab’s quality management system. Restricted
111 Annual Gaming Compliance Audit/Inspection Tracking  This assessment includes risk assesssments and likelihood of non-compliance, as well as areas of inspection and frequency of inspection. Restricted
112 Annual Gaming Compliance Liquor/Drop Inspection Tracking Tracks the inspections performed and to be performed in liquor and drop (collection of monies from the gaming floor) for gaming sites. Restricted
113 Approved Table Games by Site  List of the types of tables games (ex. craps, Omaha) approved for use at gaming sites. Will be made open/public
114 Regulatory Assurance Activity Database – Security & Surveillance Pilot  This dataset contains information on areas inspected, inspectors, findings, and other sensitive information.  It is expected to be decommissioned on November 30, 2016. Restricted
115 Compliance Issues Database for Letter of Incident Consideration  This dataset contains details on the incidents themselves including in some cases personally identifiable information on patrons, gaming site staff, and Alcohol and Gaming Commision of Ontario employees. Restricted
116 Gaming Risk Assessments Assessments of the perceived risk at gaming sites by Registrar’s Standard, including the impact of such risks materializing as well as their perceived likelihood. Restricted
117 Periodic site reports This dataset is sent to the Alcohol and Gaming Commsision by gaming sites and includes information on breaches, failures to comply with controls, as well as general performance data. Restricted
118 iGaming Notifications database This dataset contains notification details as described in the iGaming Notifications Matrix (issues, breaches, senior management changes, etc.).  These notifications may in some cases contain personally identifiable information. Restricted
119 Table hold analysis This dataset contains individual table game identifiers as well as the amount of money bet on the games and the amount of money paid out reported by each site. Restricted
120 Lottery notifications database This dataset includes the nature of incident, game integrity and notifications breaches, incident details, corrective actions, preventive measures, residual risk, etc. Restricted
121 iGaming monthly data report This data set includes approximately 150 data elements including player account information, registration numbers, and fraudulent activity, etc. Restricted
122 Ontario Lottery and Gaming Corporation Call centre reports This dataset is a Salesforce report that includes FAQ breakdown, average resolving time, speed to answer, calls abandoned, etc. It is reported to the AGCO by the OLG and relates to iGaming operations Under review
123 Duplicate account report This dataset includes account numbers and names. This dataset is reported to the Alcohol and Gaming Commission of Ontario by the Ontario Lottery and Gaming Commission and relates to iGaming operations and contains personally identifiable information Restricted
124 OnePay alerts This dataset includes monetary amounts, limits set, and account information that can be used to identify players. This dataset is reported to the AGCO by the OLG and relates to iGaming operations and contains personally identifiable information Restricted
125 Withdrawal report This data set contains lists of requests from players to withdraw from an account. This dataset is reported to the AGCO by the Ontario Lottery and Gaming Corporation and relates to iGaming operations and contains personally identifiable information Restricted
126 Deposit transaction report This dataset includes data on all deposit transactions, including account identifiers, timestamps, and amounts. It is reported to the Alcohol and Gaming Commision of Ontario by the Ontario Lottery and Gaming Corporation. It relates to iGaming operations and contains personally identifiable information Restricted
127 Equifax report This dataset is reported to the AGCO by the Ontario Lottery and Gaming Corporation and relates to iGaming operations. Under review
128 Locaid report This dataset includes geolocation information, i.e. where players logged in from. This dataset is reported to the Alcohol and Gaming Commission of Ontario by the Ontario Lottery and Gaming Corporation and relates to iGaming operations Under review
129 Audit Summary Tracker This dataset includes statistics on audits conducted in all sectors including audit period, findings and recommendations. Restricted
130 Commission Racing Information System (CRIS) This database includes a horse’s attributes (colour, age), past performance, as well as licensing information (including personally identifiable information) for trainers and jockeys. Restricted
Line of Business: