Appendix 10 - Required Reports.pdf

STATE OF ILLINOIS

SCOPE OF SERVICES APPENDICES

APPENDIX 10 – REQUIRED REPORTS

State of Illinois IFB Appendix 10

Quality Assurance Reports

1) Repair Waiver Report This report shall compile a list of all repair waivers – pass or fail – that have been issued by Contractor personnel.

This report shall include the following report output data for each waiver and be searchable as follows:

Report Output Data o Application ID;

o Test ID;

o License plate;

o Hyperlink to waiver decision or waiver decision letter;

o Lane position number (if applicable);

o Inspection Facility ID;

o Waiver date and time;

o Waiver Result (PASS/DENIED);

o Total passing and total applications by program areas;

o Waiver Decision issued by (Name and ID);

o Hyperlink to archive documents used to determine waiver eligibility (e.g., receipts for repairs, repair waiver application including all documentation submitted in the application);

o Waiver Information Panel: Hyperlink to Details on Motorist Application Process by

Contractor; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o License plate;

o VIN;

o Air Team ID with hyperlink to the vehicle/test history information;

o Test ID;

o User Name;

o Application ID;

o Inspection Facility with Check Box to include Inactive Facility;

o Waiver Date Range Start Date (dropdown calendar)*; and, o Waiver Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month, this year, last year)

2) OBD VIN/Vehicle Mismatch Report This report shall compile a list of emissions inspections where the OBD fingerprint (i.e., OBD VIN, OBD Calibration ID, Calibration Verification Number (CVN), Supported Readiness Monitors, etc.) are retrieved from the vehicle tested.

This report shall include the following report output data for each OBD VIN/Vehicle Mismatch and be searchable as follows:

Report Output Data o Test ID;

o License Plate;

o VIR number with hyperlink to the vehicle/test history information;

o Test Date and Time;

o VIN entered (obtained from the vehicle record retrieved from the VID);

o OBD VIN (VIN obtained from the vehicle’s OBD system);

o Fraud Trigger;

o OBD Test Equipment ID (i.e. location identifier where test was performed);

o Lane ID and position number (if applicable);

o Inspector ID (if applicable);

o A hyperlink which sends a request for a copy of the image/video clip of the test performed

(if available); and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o OBD Test Equipment ID;

o Test ID;

o License plate;

o VIN;

o Air Team ID with hyperlink to the vehicle/test history information;

o Overall Test Result (dropdown menu: Pass/Fail/Reject/Abort/Audit);

o Inspector ID;

o Fraud Trigger (dropdown menu: Mismatch Fingerprint from Previous Test, Known Vehicle

Fingerprint Mismatch, Same Fingerprint of Previous Test, OBD VIN Mismatch, CAT and O2 Sensors Not Supported);

o Start Date (dropdown calendar)*; and, o End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month, this year, last year)

In addition, when any test exhibits one of the four OBD fingerprint mismatch scenarios listed above, a real-time (within 2 minutes) notification shall be sent to appropriate Agency staff through desktop alarms (e.g., OBD VIN does not match VIN entered) or alternate means as allowed by the Agency.

3) OBD Exception Table

This exception table will be utilized to address known readiness, OBD testability issues, and vehicle specific test procedures. This report shall include the following report output data for each vehicle and be searchable as follows:

Report Output Data o Low Model Year;

o High Model Year;

o Make;

o Model;

o VIN Mask; and, o Exception Info: Misfire, Fuel System, Comprehensive, Catalyst, Heated Catalyst, Evaporative

System, Secondary Air System, System AC, O2 Sensor, Heated O2 Sensor, EGR System, Readiness Count, NonComm, Ignore RPM, NonComm To MIL, Display, and Instructions/ Description.

Search/Query Options o Low Model Year;

o High Model Year;

o Make (dropdown menu);

o Model (dropdown menu); and, o VIN Mask.

This report shall contain an option button to add new exceptions to the report.

4) Motorist Complaints Report

This report shall provide a list of motorist complaints. This report shall include the following report output data for each complaint and be searchable as follows:

Report Output Data o Complaint ID w/ Hyperlink to Complaint;

o Complaint type (i.e. wait time for test, wait time for waiver application, rude inspector, etc.);

o Type of response;

o Implementation measure to address complaint;

o Complaint Received Date;

o Complaint Responded Date;

o Status (Open/ Closed, Duplicate);

o Motorist Name;

o Assignee;

o License plate;

o VIR number with hyperlink to the vehicle/test history information;

o Test ID;

o Test Date;

o Associated OBD Equipment ID;

o Associated lane ID and position number (if applicable);

o Associated Inspector ID (if applicable); and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o OBD Test Equipment ID (with click box to include inactive);

o VIN;

o License Plate;

o Air Team ID; and, o VIN Mask.

Customer Information o First Name;

o Last Name;

o Phone;

o Email; and, o City.

Complaint Information o Comment Type (dropdown menu);

o Implementation Measure (dropdown menu: Referred to management, No action necessary, request website change, request software change, implemented an operational change;

o Start Date (dropdown calendar)*; and, o End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

5) Voided Test Report

This report shall compile a list of all voided emissions inspections conducted. This report shall include the following report output data for each voided test and be searchable as follows:

Report Output Data o Test ID;

o VIN;

o License Plate;

o OBD Test Equipment ID;

o OBD Test Equipment Name/Location;

o Inspector ID (if applicable);

o Test Date and Time;

o VIR;

o Test (hyperlink to Official Test Report, Inspection Details); and, o Option to Print or Export Information in Report output (Excel/PDF).

o OBD Test Equipment ID (with click box to include inactive);

o Test Type (dropdown Menu: OBD II Test, Waiver, Training, Exempt, Audit);

o Start Date (dropdown calendar)*; and, o End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month)

6) Voluntary Test Voucher Report

This report shall compile the number of voluntary test vouchers that are sold at each inspection facility. This report shall include the following report output data for each voluntary test and be searchable as follows:

Report Output Data o OBD Test Equipment ID;

o OBD Test Equipment Name/Location;

o Not Used (Counts);

o Used (Counts);

o Void (Counts);

o Total (Counts);

o Test Date and Time;

o VIR;

o Test (hyperlink to Official Test Report, Inspection Details); and, o Start Date (dropdown calendar)*; and, o End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month)

7) Customer Relationship Management Report (recording and tracking of correspondences)

This report shall record, track, and monitor each communication matter with a motorist and repair technician via the motorist/repair assistance website, fax, US mail, e-mail, hotline, and any other method. This report shall include the following report output data and be searchable as follows:

o Ticket ID with hyperlink to CRM ticket;

o CSR creating CRM;

o OBD equipment ID (if applicable);

o Ticket source;

o Customer type;

o Comment type;

o Comment subtype(s);

o Motorist/Repair Technician name;

o Motorist/Repair Technician contact information;

o Create date;

o Incident date;

o Resolve date;

o Ticket status;

o CSR or contractor employee assigned to;

o CRM ticket closed by; and, o Option to Print or Export information in Report output (Excel/PDF).

Ticket Information o Ticket ID;

o Application ID;

o Status:

• Assigned;

• Closed;

• Duplicate;

• Received; and,

• Work in progress.

o Assigned To:

• Dropdown with a list of CSRs and contractor employees.

o OBD equipment ID (i.e. location identifier where test was performed):

• Select from dropdown.

o Source:

• Website;

• US mail;

• Email;

• Fax;

• Hotline; and,

• Other.

o Customer Type:

• Motorist; and,

• Repair technician.

o Group (reason for the call):

• Complaint;

• Compliment;

• Monitor reject;

• Repair waiver, extension, exemptions; and,

• Test location.

o Comment Type:

• Generated by selection from group.

o Comment Subtype(s):

• Generated by selection from Comment Type.

Search by Date o Create Start Date and Create End Date;

o Resolved Start Date and Resolved End Date; and, o Incident Start Date and Incident End Date.

(Each searchable date by a dropdown calendar)

Motorist information o First Name;

o Last Name;

o Phone;

o Email; and, o City.

Vehicle information o License Plate;

o VIN; and, o Air Team ID.

This report shall be generated by the user through the selection listed above and create a ticket which can be retrieved (for each CRM no matter the source).

8) Damage Claim Report

This report will be utilized to search all damage claims submitted by motorists. This report shall include the following report output data for each damage claim and be searchable as follows:

Report Output Data o Test ID;

o Motorist Name;

o Receive Date;

o Status;

o Feedback Type;

o Response;

o Letter Date;

o Resolved Date;

o Incident Date;

o Paid;

o Paid Amount;

o VIN;

o License Plate;

o VIR;

o Test ID;

o Test Date;

o OBD Equipment ID;

o Lane (if Applicable);

o Inspector ID; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options

Vehicle Information o VIN; and, o License Plate.

Application information o Application ID;

o Application Status (Active, Approved, Awaiting Motorist Notification, Awaiting OBD SME

Review, Awaiting Visual Inspection, Cancelled, Closed, Demo Test, Denied, Expired, IEPA Review, Incomplete Information, New, Received, Received Customer Documents, Recertification, Reinstate, Revoke, Suspend, Suspended, Termination, Under Review, Undone, Visual Inspection Complete;

o Start Receive Date (dropdown calendar*); and, o End Receive Date (dropdown calendar*).

Test Method Information o OBD Test Equipment ID (dropdown, list of Inspection Facilities, Self-Service Kiosk, MTU, Remote OBD);

o OBD Test Equipment ID (dropdown, by group type of OBD Test Equipment); and, o Lane Number (if Applicable).

Test Information o Test ID;

o Inspector ID;

o Start Test Date (dropdown calendar); and, o End Test Date (dropdown calendar).

Applicant Information o First Name;

o Last Name;

o Phone; and, o Email.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

9) OBD Fallback Report

This report will be utilized to search vehicles that have been given a fallback test. This report shall include the following report output data for each fallback test and be searchable as follows:

Report Output Data

OBD Fallback Report o Test ID;

o VIN number w/ hyperlink to Vehicle record;

o VIR number w/hyperlink to VIR;

o License Plate;

o Test Date;

o Test Type (OBD II, etc.);

o Result of Test;

o Inspection Facility or MTU ID;

o Inspection Facility or MTU Name/Location;

o Lane (if applicable);

o Make;

o Model;

o Model Year;

o Inspector ID;

o Reason/Procedure (i.e. Bulb check Performed, Bulb Check Failed KOEO, etc.); and, Test Method Information o Test Location with “Show Inactive” option box (Name of Inspection Facility, MTU); and, o Test Method Type (Centralized, Decentralized, MTU).

Test Information o Air Team ID;

o License Plate;

o Overall Test Result (Pass, Fail, Reject, Abort, Void, Audit);

o Inspector ID;

o Start Date (dropdown calendar*); and, o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

10) Fraud Check Report

This report shall compile a list of emissions inspections that exhibit potential fraud by looking for Agency and Contractor designed triggers (e.g., detects OBD defeat devices such as Malfunction Indicator Lamp (MIL) eliminators or O2 simulators, detects OBD simulators, etc.). This report shall include the following report output data for each fraud trigger and be searchable as follows:

Report Output Data o Test ID;

o VIN number w/hyperlink to Vehicle record;

o VIR number w/hyperlink to VIR;

o Test ID w/hyperlink to Official Test Report;

o License Plate w/hyperlink to vehicle lookup/test history;

o VIR w/hyperlink to VIR (pop-up pdf);

o VIN number;

o OBD VIN number;

o Fraud Trigger Description;

o OBD Equipment ID;

o OBD Equipment Name/Location;

o Lane/Test Position (if applicable);

o Inspector ID w/hyperlink to Inspector information (if applicable);

o Images/Video hyperlink of test to view and download (if applicable); and, o Option to Print or Export Information in Report output (Excel/PDF).

Note: Certain fraud triggers, as specified by the Agency, must result in immediate notification to appropriate Agency staff through desktop alarms (e.g., MIL eliminator detected) or alternate means as allowed by the Agency.

Search/Query Options

OBD Equipment Name/Location Information o OBD Equipment ID “Show Inactive” option box; and, o OBD Equipment Type Group (Centralized, Decentralized, MTU, Self-Service Kiosk, Remote

OBD).

Test Information o Test ID;

o Air Team ID;

o License Plate;

o Overall Result (Pass, Fail, Reject, Abort, Void, Audit);

o Inspector;

o Fraud Trigger (dropdown menu: Mismatch Fingerprint from Previous Test, Known Vehicle Fingerprint Mismatch, Same Fingerprint of Previous Test, OBD VIN Mismatch, CAT and O2 Sensors Not Supported);

o Start Date (dropdown calendar*); and, o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

11) OBD No Communication Report

This report shall compile a list of vehicles where the OBD scan tool and remote OBD device (if possible to know) fails to communicate with a vehicle. This report shall include the following report output data for each OBD No Communication and be searchable as follows:

Report Output Data o Test ID;

o VIN number w/hyperlink to Vehicle record;

o VIR number w/hyperlink to VIR;

o License Plate;

o Test Date;

o Test Type (OBD II, etc.);

o OBD Equipment ID;

o OBD Equipment Name/Location;

o Lane (if applicable);

o Make;

o Model;

o Model Year;

o Inspector ID; and, OBD Equipment Name/Location Information o OBD Equipment ID “Show Inactive” option box; and, o OBD Equipment Type Group (Centralized, Decentralized, MTU, Self-Service Kiosk, Remote

OBD (if applicable)).

Test Information o Test ID;

o Air Team ID;

o License Plate;

o Inspector ID (if applicable);

o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, Operations Reports

1) Official Test Report

This report is a summary of all vehicle emissions tests regardless of test result, test type, or test method. This report shall include the following report output data for each test and be searchable as follows:

Official Test Report Output Data o Test ID (hyperlink to inspection test details);

o VIN;

o Plate;

o Test Date Time;

o Test Type;

o Test Eligibility Date;

o Test Result;

o OBD Equipment ID (i.e. location identifier where test was performed);

o Lane position (if applicable);

o Image/Video (hyperlink to still image and/or test video – if applicable);

o Vehicle lookup (hyperlink to vehicle record);

o VIR (hyperlink to Vehicle Inspection report); and, Vehicle Information o License Plate;

o VIN;

o VIR; and, o Air Team ID.

Test Method Information o Test Method (dropdown list of all centralized, decentralized, self-serve kiosks, MTU and remote OBD;

o Test Method Type (dropdown with option);

• Centralized;

• Decentralized;

• Self-Serve Kiosk;

• MTU; and,

• Remote OBD.

o Test Position (as applicable).

Test Information o Test Type (dropdown with OBD and Training options);

o Overall Result (dropdown with pass, fail, reject, void, abort options);

o Date Range Start Date (dropdown calendar)*; and, o Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month, this year and last year)

2) Throughput Reporting

This report is a summary of a test method type (inspection facility, MTUs, self-service kiosks, remote OBD devices) throughput over a specified period of time. This report shall include the following throughput report output data and be searchable as follows:

Throughput Report Output Data o OBD Equipment ID;

o Name of Inspection Facility, MTU, self-service kiosk, remote OBD device; and, o Vehicle Test Count.

Search/Query Options o Inspection Facility, MTU, self-service kiosk, remote OBD device (dropdown to select a facility);

o Time (selection by operation hours on the hour or a selection of all day);

o Date Range Start Date (dropdown calendar)*;

o Date Range End Date (dropdown calendar)*; and o OBD Equipment ID (dropdown with option).

• Centralized;

• Decentralized;

• MTU;

• Self-Service Kiosk; and,

• Remote OBD.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month, this year and last year)

3) Inspector Throughput Reporting

This report is a summary of certified inspector average test per hour at an Inspection Facility and MTU using the following criteria:

Inspector Report Output Data o Inspector ID;

o Average Test per Hour; and, o Inspector ID ;

o Date Range Start Date (dropdown calendar)*;

o Date Range End Date (dropdown calendar)*; and, o Inspection Facility, MTU, self-service kiosk, remote OBD device (dropdown of all centralized, decentralize and MTU).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

4) Certified Inspector Report

This report is a summary of all certified inspector employment status, certification status (module scores, certification score, certification attempts, etc.) and peak staff per centralized, decentralized and MTU. This report shall include the following inspector report output data and be searchable as follows:

Inspector Report Output Data o Inspection Facility Type, MTU with dropdown to select or sort by each;

o Inspection Last Name;

o Inspector First Name;

o Inspector ID;

o Inspector Status;

• Active;

• Cancelled;

• Expired;

• Suspended; and,

• Revoked.

o Certificate Date;

o Certificate Expiration Date;

o Certification Status -hyperlink to:

• Module scores;

• Certification score(s); and,

• Certification attempt(s).

o Peak staff calculation;

o Searchable by each output data; and,

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

5) Calibration Report

This report is a summary of all OBD calibrations and OBD no comm self-tests performed. This report shall include the following calibration report output data and be searchable as follows:

o OBD equipment ID with a dropdown to select a specific centralized, decentralized, self-service kiosk, MTU, or remote OBD device (where feasible) for all report output data;

o Position identifier when multiple equipment is utilized at a location o Type (OBD check);

o Start date and time and seconds;

o User ID or name;

o VIR;

o Overall results; and, o OBD equipment ID with a dropdown to select a specific centralized, decentralized, self-service kiosk, MTU, or remote OBD device (where feasible);

o Position identifier when multiple equipment is at each centralized facility;

o Type

• OBD check; and,

• No communication self-test.

o Date Range Start Date (dropdown calendar)*; and, o Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

6) Transaction Report This report is a summary of Agency specified transaction types generated by the contractor and the Agency. This report shall include the following transaction report output data and be searchable as follows:

Report Output Data o Transaction ID;

o VIN;

o License plate;

o Vehicle Make;

o Vehicle Model;

o Vehicle Year;

o Voided;

o Transaction date;

o Issued by (contractor employee name and ID-if available);

o Hyperlink to vehicle owner record;

o Option to Print or Export Information in Report output (Excel/PDF); and, o Searchable by each output data.

o License plate;

o VIN;

o Air Team ID with hyperlink to the vehicle/test history information;

o Test ID;

o Transaction type;

o Application ID;

o Waiver Date Range Start Date (dropdown calendar)*;

o Waiver Date Range End Date (dropdown calendar)*; and, o SOS Compliance Transaction check box.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, Wait Time Reports

1) Current Average Wait Time This report shall provide the current average wait time for centralized and decentralized inspection facilities. This report shall include the following report output data and be searchable as follows:

Report Output Data:

o Inspection Facility ID;

o Inspection Facility Name;

o Date;

o Current Average Wait Time; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options:

o Inspection Facility (one or all)

2) Daily Average Wait Time Report This report shall provide the daily average wait time for centralized and decentralized inspection facilities. This report shall include the following report output data and be searchable as follows:

Report Output Data:

o Inspection Facility ID;

o Inspection Facility Name;

o Date;

o Today’s Average Wait Time (min);

o Today’s Total Number of Tests;

o Last 15 Minutes Average Wait Time (min);

o Last 15 Minutes Number of Tests; and, o Inspection Facility (one or all); and, o Date (today, yesterday, specific date).

3) Monthly Wait Time Report

This report shall provide the monthly wait time for centralized and decentralized inspection facilities. This report shall include the following report output data and be searchable as follows:

Report Output Data:

o Inspection Facility ID;

o Inspection Facility Name;

o Month/Year;

o Inspection Facility daily and monthly average wait time; and, o Month (dropdown calendar); and, o Year (dropdown calendar).

4) Weekly Wait Time Report This report shall provide the weekly wait time for centralized and decentralized inspection facilities. This report shall include the following report output data and be searchable as follows:

Report Output Data:

o Inspection Facility ID;

o Inspection Facility Name;

o Weekly Dates;

o Inspection Facility daily and weekly average wait time; and, o Week (52-week range); and o Year (dropdown calendar).

5) Wait Time Source Report This report shall provide wait time source statistics. This report shall include the following report output data and be searchable as follows.

Report Output Data:

o Inspection Facility ID;

o Inspection Facility Name;

o Weekly Dates;

o License Plate Recognition (LPR) Automatic (number and percentage);

o LPR Manual (number and percentage);

o Decentralized Check-In (number and percentage);

o Previous Test (number and percentage);

o Current Average Wait Time (number and percentage);

o Visual (number and percentage);

o All Sources (number);

o Summary Totals (number and percentage) of all of the above sources for the selected time period; and, o Start Date (dropdown calendar); and o End Date (dropdown calendar).

Statistical Reports

1) Test Summary Report

This report shall post test result totals and percentages for a specified centralized, decentralized, self-serve kiosk, MTU, or remote OBD device ID. This report shall include the following report output data for each test and be searchable as follows:

Separate Reports based on Group: Model Year/Region/OBD Equipment ID, Vehicle Type o Group Category;

o Fail Count;

o Fail Percentage;

o Pass Count o Pass Percentage;

o Reject Count;

o Reject Percentage;

o Total Tests;

o Percent Total; and, o Option to Print or Export Information in Report output (Excel/PDF).

Test Failure Rates (Data Separated out by Initial Test, First Retest, 2nd or Subsequent Test o Model Year;

o Total Tests;

o Pass Count;

o Pass Percentage;

o Fail Count; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options

Test Summary Report (Duration & Events) o Group (Select by: Model year, Region, OBD Test Equipment group, Vehicle type) with Check

Box to include Inactive;

o Start Date (dropdown calendar*); and, o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

2) Test Search by Result Reason

This report shall provide test results by specified result reason by OBD Equipment ID or by user selected groups of OBD Equipment ID over a user specified date range. This report shall include the following report output data for each result reason and be searchable as follows:

Separate Reports based on Group: Model Year/Region/OBD Equipment ID, Vehicle Type o Test ID w/hyperlink to Official Test Report;

o VIN w/hyper link to vehicle record;

o License Plate w/hyper link to vehicle record;

o Test Date and Time;

o Test Result;

o Make;

o Model;

o Year;

o OBD Equipment ID;

o OBD Equipment Name/Location;

o Lane (if Applicable);

o Inspector ID;

o Images/Video hyperlink of test to view and download (if available);

o VIR number w/hyperlink to VIR; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options

OBD Equipment Name/Location Information o OBD Equipment ID “Show Inactive” option box; and, o OBD Equipment Type Group (Centralized, Decentralized, MTU, Self-Service Kiosk, Remote

OBD).

Test Information o Test ID;

o Air Team ID;

o VIN;

o License Plate;

o Result Reasons a ;

o Test Type;

o Overall Test Result;

o Start Date (dropdown calendar*); and, o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month, this year, last year) a Result Reason to Select; Trouble codes (DTCs) reported, Damaged connector, Hybrid vehicle failed KOER DCL INACC, Inoperable connector, Hybrid vehicle failed KOER, MIL Illumination failure, Missing connector, Did not fail, Failed MIL check and for codes, Vehicle Not Found On VID, VIN Error Exceeded Non Full Service, VIN Error Fraud Check, Vehicle Fuel Type Not Required, Facility Idle Test Required, OBD Obstructed OEM, OBD Obstructed Aftermarket, OBD Readiness Reject, Reinspection Limit Exceeded, Vehicle rejected - no repair information, OBD Catalyst Monitor Not Ready, Vehicle Locked, Vehicle Not Assigned, Apparent Leaks, Engine Too Hot, User Aborted No Reason, Emissions Fraud Detected, Emissions Fraud Detected, Bulb Check Performed, Bulb Check Failed KOEO, Bulb Check Failed KOER, Simulator Detected, Interrogation fingerprint results did not match the previous transaction in test history, Interrogation results match previous inspection performed in that lane, Interrogation results returned OBD VIN that does not match the record, HDV exemption, OBD Cat And O2 Not Supported, OBD PCM Code out of rang, Vehicle not Checked In, Inspector Abort, Station Manager Abort, Vehicle stalled, Test aborted for an unspecified reason, VIN Mismatch, Hardware Failure Abort, Unable to locate VIN on vehicle, OBD Comm Failure, BAIID Device Installed, Handicap Modifications Installed

3) Daily/Monthly Facility Report

This report shall track the entire I/M Program Network or selected subgroups of OBD Equipment ID’s testing statistics*. This report shall include the following report output data and be searchable as follows:

o Inspection Facility, Self-Service Kiosk, MTU, Remote OBD device ID;

o Inspection Facility Self-Service Kiosk, MTU, Remote OBD device Name/Location;

o Test Facility Type (Centralized/Decentralized/Kiosk/MTU/Remote OBD);

o Pass Count;

o Pass Percentage;

o Fail Count;

o Fail Percentage;

o Reject Count;;

o Reject Percentage o HDV Exemption Count;

o HDV Exemption Percentage;

o Total Tests; and, o Option to Print or Export Information in Report output (Excel/PDF).

* Initial tests, all retests included.

* Rates are calculated relative to the total that includes pass, fail, reject and HDV exemptions.

* Aborts, voids, trainings, appeals, waivers, voluntary tests and audit tests are excluded.

* Reject count includes all rejects except ‘Vehicle Not Assigned’ rejects (Result Reason 27)

OBD Equipment Name/Location Information o OBD Equipment ID “Show Inactive” option box;

o OBD Equipment Type Group (Centralized, Decentralized, MTU, Self-Service Kiosk, Remote

OBD);

o Start Date (dropdown calendar*); and, o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

4) Daily Activity Report

This report shall provide daily activity statistics and utilization rates for Inspection Facilities, Self-Service Kiosks, MTUs, and Remote OBD. This report shall include the following report output data for each method of testing and be searchable as follows:

o Inspection Facility/Self-Service Kiosk/MTU/Remote OBD Device Name;

o Date;

o Total and Percent Tests Performed by hour;

o Total and Percent Tests Passed by hour;

o Total and Percent Tests Failed by hour;

o Total and Percent Tests Rejected by hour;

o Average Wait Time by hour (as applicable);

o Utilization Rate by hour;

o Daily Totals (number and percentage) for Output Data Above; and, o Inspection Facility/Self-Service Kiosk/MTU/Remote OBD Device Name with Check Box to include Inactive; and, o Date (dropdown calendar)*.

5) Network Activity Report

This report shall provide weekly, monthly, and annual network activity statistics and utilization rates for all Inspection Facilities, Self-Service Kiosks, MTUs, and Remote OBD devices. This report shall include the following report output data for each method of testing and be searchable as follows:

Report Output Data o Name of Each Inspection Facility, Self-Service Kiosk, MTU, Remote OBD Device;

o ID of Each Inspection Facility, Self-Service Kiosk, MTU, Remote OBD Device;

o Selected Date Range;

o Total and Percent Tests Performed for Each Inspection Facility, Self-Service Kiosk, MTU, Remote OBD Device by selected date range;

o Total and Percent Tests Passed for Each Inspection Facility, Self-Service Kiosk, MTU, Remote

OBD Device by selected date range;

o Total and Percent Tests Failed for Each Inspection Facility, Self-Service Kiosk, MTU, Remote

OBD Device by selected date range;

o Total and Percent Tests Rejected for Each Inspection Facility, Self-Service Kiosk, MTU, Remote OBD Device by selected date range;

o Average Wait Time for Each Inspection Facility for selected date range (as applicable);

o Utilization Rates for Each Inspection Facility, Self-Service Kiosk, MTU, Remote OBD Device by selected date range;

o Totals (number and percentage) for Output Data Above; and, o Month/Year (dropdown calendar)*;

o Week/Year*;

o Date Range Start Date (dropdown calendar)*; and, o Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (this week, last week, this month, last month, this year, last year)

6) Workstation Downtime Report This report displays all OBD test Equipment downtime for the entire network daily or over a user-selected period, in 10-minute increments by determining and reporting the OBD test equipment as Open or Closed. This report shall include the following report output data and be searchable as follows:

Report Output Data o OBD Equipment ID;

o OBD Equipment Location/Name;

o Lane (if Applicable);

o Designation as ‘O’ (Open) or ‘C’ (Closed) in six 10-minute periods per hour;

o Total percentage open and closed during selected time interval; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o Downtime Date (s);

o Inspection Facility or OBD Equipment ID “Show Inactive” option box;

o Start Date (dropdown calendar); and, o End Date (dropdown calendar).

7) Monthly and Annual Test Summary

This report shall display pass and fail tests grouped by selected criteria (model year, region, test type, vehicle type) for a monthly or annual period, and by total test volumes or only pass/fail. This report shall include the following report output data and be searchable as follows:

Report Output Data o Group Category (model year, region, vehicle type);

o By Category: Initial Tests Total Tests, Pass, Pass Rate, Fail, Fail Rate;

o By Category: First Retests Total Tests, Pass, Pass Rate, Fail, Fail Rate;

o By Category: 2nd or Subsequent Total Tests, Pass, Pass Rate, Fail, Fail Rate; and, o Option to Print or Export Information in Report output (Excel/PDF).

Note: Separate reports based on Group: Model Year/Region/Vehicle Type o Select by Group (model year, region, test type, vehicle type);

o Select by Period (monthly, annual);

o Year (dropdown);

o Month (dropdown);

o Inspection Facility or OBD Equipment ID “Show Inactive” option box; and, o Option box to include/exclude all types of Rejects from the summary counts.

8) Monthly and Annual Test Method Test Summary

This report shall display pass and fail tests or total test volumes grouped by test method category (total, centralized, decentralized, self-service kiosk, MTU, remote OBD) for a monthly or annual period. This report shall include the following report output data and be searchable as follows:

Report Output Data o Group Category (model year, region, vehicle type);

o By Category: Initial Tests Total Tests, Pass, Pass Rate, Fail, Fail Rate;

o By Category: First Retests Total Tests, Pass, Pass Rate, Fail, Fail Rate;

o By Category: 2nd or Subsequent Total Tests, Pass, Pass Rate, Fail, Fail Rate; and, o Option to Print or Export Information in Report output (Excel/PDF).

Note: Separate reports based on Group: Model Year/Region/Vehicle Type

Search/Query Options o Select by Test Facility Group (Total, Centralized, Decentralized, Self-Service Kiosk, MTU Remote OBD);

o Select by Period (monthly, annual);

o Year (dropdown);

o Month (dropdown);

o Inspection Facility or OBD Equipment ID “Show Inactive” option box; and, o Option box to include/exclude all types of Rejects from the summary counts.

9) Data Item Description Report

This report shall provide a list of test parameters by vehicle class over a specified date range. This report shall include the following report output data and be searchable as follows:

Report Output Data o Test Parameters Specified by the Agency;

o Number and Rate of Each Test Parameter Occurring by selected vehicle class over selected date range;

o Date range; and, o Option to Print or Export Information in Report Output (Excel/PDF).

o Vehicle Class (LDV, Light Duty, Heavy Duty, All);

o Start Date (dropdown calendar);

o End Date (dropdown calendar); and, o Inspection Facility, Self-Service Kiosk, MTU, Remote OBD “Show Inactive” option box only.

10) Call Center Source (Motorist/Repair Technician Statistic Report)

This report shall compile statistics for all inquiries to the call center by motorists and repair technicians. This report will also compile statistics for all applications in the CRM processed by the contractor. These reports shall include the following report output data for report and be searchable as follows:

Call Center Source Statistics Output Data o Customer type;

• Motorist; and,

• Repair technician.

o Total number of inquiries received from;

• Phone;

• Emails received;

• US mail received;

• Faxes received; and,

• Website inquiries from the comment tab.

Compliments;

Complaints;

Suggestions; and, Questions.

o Total for each source for motorist and repair technician and total for each source; and, Call Center Source Statistics Search Options o Call Center Source Statistic Date Range Start Date (dropdown calendar)*; and, o Call Center Source Statistic Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, CRM Application Statistics Output Data o Application type;

o Repair Waivers;

o Economic Hardship;

o Out of Area;

o Out of State;

o Sporting Activity;

o Ceremonial;

o Total number of applications received from;

• Website;

• Emails received;

• US mail received;

• Faxes received; and,

• Other sources.

o Total for each application and source; and, CRM Application Source Statistics Search Options o Application Source Statistic Date Range Start Date (dropdown calendar)*; and, o Application Source Statistic Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

11) Notification Selection File Report

This report shall provide a summary of both the preliminary (draft for Agency review) and final monthly selection (notification) file and report selections by model year (MY), total vehicle counts, and percent of the total for each MY. It shall also provide counts and percentages by motorist notification delivery option selected (i.e. US mail, email, text). This report shall include the following report output data and be searchable as follows:

o Model Year;

o Count Selected by Model Year;

o Percentage of total selected by Model Year;

o Counts and percentage of notification delivery option chosen;

o Delivery Schedule for Notices (planned and actual); and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o Select Month-Year via dropdown calendar based on test-by-date; and, o Select Full Year via dropdown calendar based on test-by-Date.

12) Notification Selection Zip Code Report

This report shall provide a summary of both the preliminary (draft for Agency review) and final monthly selection (notification) file and report number of selections by Zip Code with total vehicle counts and percent of the total for each Zip Code. This report shall include the following report output data and be searchable as follows:

o Zip Code;

o County of Zip Code;

o Program Area of Zip Code (i.e. Chicagoland or Metro-East);

o Count selected by Zip Code;

o Percentage of total selected by Zip Code; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o Select Month-Year via dropdown calendar based on test-by-date; and, o Select Full Year via dropdown calendar based on test-by-date.

13) Monthly Compliance Report

This report will track current and historical monthly compliance of vehicles assigned for testing and report the count of vehicles by complying “reason” and calculate a monthly compliance rate for each month dating from current TBD month to 4 years prior. This report shall include the following report output data and be searchable as follows:

o Test Eligibility Month;

o Test-By-Date Month;

o Total Notified;

o Total complied by Passing;

o Total complied by Waiver;

o Total complied by Out-of-State Exemption;

o Total complied by Hardship;

o Total complied by Exempted by SOS;

o Total complied by being Deleted;

o Total complied due to Owner change;

o Total complied due to Out of Area;

o Total complied by ‘Other’;

o Total Outstanding to enter into compliance;

o Compliance Rate for Selected Period; and, o Select Month-Year or multiple Month-Year period (dropdown calendar) based on test-by-date; and o Select Full Year (dropdown calendar) based on test-by-date.

14) Odometer Report

This report will provide vehicle Odometer readings and other pertinent information for each official vehicle test over a selected period of time. This report shall include the following report output data and be searchable as follows:

o VIN;

o Make;

o Model Year;

o Odometer;

o Test Date (yyyy:mm:dd);

o Test Site Zip Code;

o Overall Test Result (P/F); and, o End Date (dropdown calendar*).

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month)

Self-Service Kiosk Reports

1) Self-Service Kiosk Status Report

This report shall track self-service kiosk availability. This report shall include the following report output data for each self-service kiosk and grouping of self-service kiosks and be searchable as follows:

Report Output Data o Self-Service Kiosk Equipment ID;

o Self-Service Kiosk Equipment Location Identifier (i.e. City or Property Name);

o Status Counts in 10 minute increments (Standby);

o Status Counts in 10 minute increments (Testing);

o Status Counts in 10 minute increments (Down);

o Self-service Kiosk percent individual availability (i.e. Up%);

o Date Range for Self-Service Kiosk Availability Calculation;

o Self-service kiosk percent availability by user selected grouping; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o Self-Service Kiosk Equipment ID (individual or grouping or all), with Check Box to include Inactive Kiosks;

o Self-Service Kiosk Availability Date Range Start Date (dropdown calendar)*; and, o Self-Service Kiosk Availability Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

2) Self-Service Kiosk Repair Action Report

This report shall track and document self-service kiosk repair action taken. This report shall include the following report output data for each self-service kiosk and grouping of self-service kiosks and be searchable as follows:

Report Output Data o Self-Service Kiosk Equipment ID;

o Self-Service Kiosk Equipment Location Identifier (i.e. City or Property Name);

o Repair Action Taken Counts in 10 minute increments (Remote);

o Repair Action Taken in 10 minute increments (Visit Required);

o Repair Action Taken in 10 minute increments (No Action Needed);

o Downtime in 10 minute Increments during inspection facility emissions inspection services hours;

o Downtime in 10 minute Increments outside inspection facility emissions inspection services hours;

o Date Range for Self-Service Kiosk Repair Action counts;

o Self-service Kiosk Repair Action type count by user selected self-service kiosk grouping; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o Self-Service Kiosk Equipment ID (individual or grouping or all), with Check Box to include Inactive Kiosks;

o Self-Service Kiosk Repair Action Date Range Start Date (dropdown calendar)*; and, o Self-Service Kiosk Repair Action Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month)

3) Self-Service Kiosk Repair Support Performance Standard Report

This report shall track and document self-service kiosk repair support response time. This report shall include the following report output data for each incident that repair action is required in self-service kiosk network and be searchable as follows:

Report Output Data o Self-Service Kiosk Equipment ID;

o Self-Service Kiosk Equipment Location Identifier (i.e. City or Property Name);

o Repair Action Type (Remote/Visit);

o During IFEISHa (Y/N);

o Repair Issue Start Time;

o Repair Issue End Time;

o Resolution time;

o On-site arrival time;

o Met Applicable Performance Standard (Y/N);

o Amount of resolution time exceeding Performance Standard(s);

o Date Range for Self-Service Kiosk Repair Action; and, o Option to Print or Export Information in Report output (Excel/PDF).

a Inspection Facility Emissions Inspection Services Hours

Search/Query Options o Self-Service Kiosk Equipment ID (individual or grouping or all), with Check Box to include Inactive Kiosks;

o Self-Service Kiosk Repair Action Date Range Start Date (dropdown calendar)*; and, o Self-Service Kiosk Repair Action Date Range End Date (dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today, yesterday, this week, last week, this month, last month, this year, last year)

4) Self-Service Kiosk Downtime and Corrective Action Report

This report shall track and document self-service kiosk downtime repair reasons and corrective action taken. This report shall include the following report output data for each downtime incident that repair action is required in the self-service kiosk network and be searchable as follows:

o Date of Self-Service Kiosk Downtime Event;

o Self-Service Kiosk Equipment ID;

o Self-Service Kiosk Equipment Location Identifier (i.e. City or Property Name);

o Reason for Downtime;

o Description of Corrective Action;

o Date Range Selected for Self-Service Kiosk Downtime and Correction Action; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o Self-Service Kiosk Equipment ID (individual or grouping or all), with Check Box to include inactive Kiosks;

o Self-Service Kiosk Downtime Event Date Range Start Date (dropdown calendar)*;

o Self-Service Kiosk Downtime Event Date Range End Date (dropdown calendar)*; and, o Downtime Reason.

* This report shall be generated by the user through the selection of a date range as well as a selected duration

5) Kiosk Post-Test Touch Screen Survey Report

This report shall provide self-service kiosk survey results and statistical data to evaluate motorist feedback and satisfaction regarding the use of self-service kiosks. This report shall include the following report output data and be searchable as follows:

Report Output Data o Date of Self-Service Kiosk Survey;

o Self-Service Kiosk Equipment ID;

o Self-Service Kiosk Equipment Location Identifier (i.e. City, Zip code, and Property Name);;

o Response for Each Survey Question;

o Summary Statistics of Responses for all Surveys (e.g. numbers, percentages) o Option to Print or Export Information in Report output (Excel/PDF); and, o Air Team ID with hyperlink to the vehicle/test history information.

Search/Query Options o Self-Service Kiosk Equipment ID (individual or grouping or all), with Check Box to include Inactive Kiosks;

o Self-Service Kiosk Survey Date Range Start Date (dropdown calendar)*;

o Self-Service Kiosk Survey Date Range End Date (dropdown calendar)*;

o By Survey Question;

o By Survey Answer; and, o By Air Team ID.

* This report shall be generated by the user through the selection of a date range as well as a selected duration

MTU Reports

1) MTU Location and Throughput Report

This report shall track MTU test location and throughput. This report shall include the following report output data for each MTU event and be searchable as follows:

Report Output Data o Date;

o Day of Week;

o Start Time;

o End Time;

o MTU Equipment ID;

o MTU Name;

o MTU Test Location (City, Zip Code and Property Name);

o Total Throughput;

o Inspector ID; and, o Option to Print or Export Information in Report output (Excel/PDF).

Search/Query Options o MTU Equipment ID (individual);

o MTU Date Range Start Date (dropdown calendar)*;

o MTU Date Range End Date (dropdown calendar)*;

o Zip Code; and, o Day of the Week.

* This report shall be generated by the user through the selection of a date range as well as a selected duration (today,

2) MTU Weekly Operating Hours Performance Standard Report

This report shall track and document MTU operating hours to ensure the performance standard is met. This report shall include the following report output data for individual MTU and be searchable as follows:

Report Output Data o Calendar Week(s);

o MTU Equipment ID;

o MTU Name;

o Hours of Testing;

o Met Applicable Performance Standard (Y/N); and, o Calendar Week;

o MTU Equipment ID (individual);

o MTU Date Range Start Date (Weekly dropdown calendar)*; and, o MTU Date Range End Date (Weekly dropdown calendar)*.

* This report shall be generated by the user through the selection of a date range as well as a selected duration

3) MTU Survey Report

This report shall provide MTU survey results and statistical data to evaluate motorist feedback and satisfaction regarding the use of MTUs. This report shall include the following report output data and be searchable as follows:

Report Output Data o Date of MTU Survey;

o MTU Equipment ID;

o MTU Name;

o MTU Location Identifier (City, Zip code and Property Name) for Each Survey;

o Response to each Survey Question;

o Summary Statistics of Responses for all Surveys (e.g. numbers, percentages);

o Option to Print or Export Information in Report output (Excel/PDF); and, o Air Team ID with hyperlink to the vehicle/test history information.

Search/Query Options o MTU Equipment ID (individual or both), with Check Box to include Inactive MTUs;

o MTU Survey Date Range Start Date (dropdown calendar)*;

o MTU Survey Date Range End Date (dropdown calendar)*;

o By Survey Question;

o By Survey Answer; and, o By Air Team ID.

* This report shall be generated by the user through the selection of a date range as well as a selected duration

4) MTU Testability Performance Report

This report shall track and document MTU testability performance and repair reasons and corrective action taken if MTU wasn’t testable during scheduled times. This report shall include the following report output data for each lack of testability incident that repair action is required in the MTU network and be searchable as follows:

o Date of MTU Testability Event ;

o MTU Equipment ID;

o MTU Equipment Location Identifier (i.e. City or Property Name);

o Reason for Lack of Testability;

o Description of Corrective Action;

o Date Range Selected for MTU Performance Report; and, o Option to Print or Export Information in Report output (Excel/PDF).

S…