BIP3203 - Attachment C - Mandatory Reports Matrix - CMMS Modernization RFP.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
CMMS RFP
Solicitation number
27-494DOT-FINAD-B-53247
Issued by
Illinois

About this file

This is a Mandatory Reports Matrix attachment for the Illinois Department of Transportation's (IDOT) Construction and Materials Management System (CMMS) Modernization Request for Proposal, detailing the comprehensive reporting requirements for the replacement SaaS solution. The document specifies over 40 mandatory reports organized across eight functional categories, including Construction Diary, Pay Item Quantities, Material Assignments and Inventory Management, Pay Estimates, Change Process Control, Funding and Appropriations, Materials Testing, Materials Plant Inspections, and Materials Mix Designs. Each report entry defines the report name, system section, description and usage, key data elements to be captured, frequency of generation (all listed as "On Demand"), end-users (primarily Field Residents, Contract Support personnel, District Engineers, and Accounting departments), and specific notes or questions from stakeholders. The reports support critical construction contract management functions such as material tracking, quantity verification, pay estimate processing, authorization approvals, and final contract closeout documentation, with specialized letters for HMA plant inspections encompassing various plant types and approval conditions.

The matrix includes internal stakeholder feedback and approval notations, with several entries marked as concurred by key personnel such as J Mann (dated 07/14/25) and Trey Summers (dated 070125). Notable observations from reviewers include questions regarding additional HMA Plant 916 Form requirements and requests for clarification on report functionality. The document serves as a specification baseline for the vendor's system design and configuration, ensuring the modernized CMMS can generate all required reports with specified data elements and maintain accessibility across multiple user roles and departments involved in construction and materials management operations.

View the file

Other files

Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Reports Matrix

CMMS Modernization - Reporting Matrix
Report InformationReport Usage
Report/View NameSystem Section/CategoryDescription and UsageKey Data/InfoFrequencyPurposeConsumer(s)Notes/QuestionsBusiness Feedback
Materials to Contract ReportMaterial Assignments and Inventory Mgmt (1.4)Engineer selects a contract, report displays a summary of all assigned materials and quantity used.Contract number, contractor, district, resident engineer, material, description, producer, supplier, tests, unit of measure, transaction qty and date.On DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers)
Contract Material Inspection ReportMaterial Assignments and Inventory Mgmt (1.4)Engineer selects a contract, report displays a list of materials and their associated pay items, including the quantities placed, required, tested and remaining balance.Contract number, project, job number, route, section, district, county, material, unit of measure, description, pay item, adjusted pay item quantity, quantity placed to date, conversion, quantity required, tested/EOI qty, balance.On DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers)
Construction Diary Weekly ReportConstruction Diary (1.1)User selects from Reports list in the construction diary. Report displays weekly diary summary details.Contractor, contract completion days, contract working days, resident engineer, contract, district, route, adjusted contract value, daily weather details, daily controlling item detailsOn DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers - Mkessler)Concur; this report is needed. J Mann 07/14/25
Working/Workable Days ReportConstruction Diary (1.1)User selects from Reports list in the construction diary. Shows controlling item details within a specified date range.Contractor, contract completion days, contract working days, resident engineer, contract, district, route, report begin date, report end date, diary entry date, controlling item detailsOn DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers - Mkessler)Concur; this report is needed. J Mann 07/14/25
Ledger ReportPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows quantity placement details on all contract pay items within a specified date range. The report is broken down by pay item and includes full pay item details.Contract, contract name, contractor, report run date, report date range, district, resident engineer, pay item sequence #, pay item description, pay item #, pay item awarded quantity, pay item adjusted quantity, pay item unit price, quantity placement details (date placed, fund, quantity, price, contractor, comments, posted indicator, pay estimate #, creator name)On DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers - Mkessler)Concur; this report is needed. J Mann 07/14/25
Daily Quantity by DatePay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows a list of pay item quantity placement details within a specified date range.Contract, contract name, contractor, report run date, report date range, quantity placement details (placement date, pay item, fund, pay item description, quantity, unit price, location, posted indicator)On DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers - Mkessler)Concur; this report is needed. J Mann 07/14/25
Pay Item Key SummaryPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows all pay item summary details.Contract, contract name, report run date, pay item number, pay item fund, pay item description, pay item UOM, awarded quantity, added quantity, deducted quantity, total adjusted quantity, placed quantity, posted quantityOn DemandEnd-userEngineers (Field Residents, Contract Support personnel and District Engineers - Mkessler)Concur; this report is needed. J Mann 07/14/25
Item Status ReportPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows all pay item quantities, including over runs and under runs. Report is helpful to see Pay Item totals Paid to date. This report can be used to see what has and has not been paid and balanced.Contract name, contractor, report run date, district, contract awarded amount, pay item sequence #, pay item #, pay item description, total adjusted quantity, pay item UOM, pay item unit price, quantity placed, dollar amount placed, price adjustments, pay item over run, pay item under run (?), % over/underOn DemandEnd-userEngineers (Field Residents, Prime Contractor, Contract Support personnel and District Engineers - Mkessler)
Overage ReportPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows all placed quantity overages.Contractor, contract completion date, contract working date, resident engineer, adjusted contract value, route, district, contract #, pay item #, pay item description, fund, awarded quantity, added qty, deducted qty, adjusted qty, qty placed, overage qty, overage priceOn DemandEnd-userEngineers (Field Residents, Prime Contractor, Contract Support personnel and District Engineers - Mkessler)
Quantities to be CompletedPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows remaining quantities available to place. Helpful with conducting final contract paperwork and reviews. Shows pay items not paid todate, indicating either needed balancing authorization or to be included in new or final pay estimate.Contractor, contract completion date, contract working date, resident engineer, adjusted contract value, route, district, contract #, pay item #, pay item description, fund, qty placed, adjusted qty, remaining qty, unit price, dollar amount placedOn DemandEnd-userEngineers (Field Residents, Prime Contractor, Contract Support personnel and District Engineers - Mkessler)
Contractor Price SummaryPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows total dollar amount placed per contractor within a specified date range.Contract, report date range, contractor name, total dollar amount placedOn DemandEnd-userEngineers (Field Residents, Prime Contractor, EEO-Labor, Contract Support personnel and District Engineers - Mkessler)
Contractor Pay ItemPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows pay item placement details by contractor within a specified date range. Report when ran show total quantities and payments for each pay item per contractor (example ran on 76L46). This report is helpful when needing to know Pay items and totals paid to contractor(s) from start of contract to End or between specificContract, report date range, contractor name, total dollar amount placedOn DemandEnd-userEngineers (Field Residents, Prime Contractor, EEO-Labor, Contract Support personnel and District Engineers - Mkessler)
Pay Items By UOMPay Item Quantities (1.3)User selects from Reports list in the construction quantity book. Shows pay item details organized by unit of measure. Tells which pay items will need Independent Weight Checks (Paid by weight) or additional documentation based on UOM.Contract #, contract awarded value, contract adjusted value, UOM, pay item #, pay item description, unit price, adjusted qty, adjusted qty $ amount, posted qty, posted qty $ amount, % adjusted value, posted % adjusted valueOn DemandEnd-userField Residents and Contract Support personnel for Contract reviews. - Mkessler
Export Quantity BookPay Item Quantities (1.3)Exports the quantity book pay items to ExcelPay item #, pay item description, UOMOn DemandEnd-user
Items Paid this Estimate (Short Form)Pay Estimates (1.6)User selects from Report list on a pay estimate in either the construction module or accounting module. Shows quantity book details of the placements included on a particular pay estimate.Contract #, contract name, pay estimate #, contractor name/address, route, section, job #, pay estimate to date, report date, district, county, project #, pay item #, fund key, pay item description, placement type, quantity placed, pay item UOM, dollar amount placedOn DemandEnd-userEngineers (Field Residents, Prime Contractor, Contract Support personnel and District Engineers - Mkessler)

Accounting Department access via Accounting tab.

All Items (Submittal Form) Pay Estimates (1.6) User selects from Report list on a pay estimate in either the construction module or accounting module. Shows quantity book details of the placements included on a particular pay estimate sorted by fund key. Contract #, contract name, pay estimate #, contractor name/address, route, section, job #, pay estimate to date, report date, district, county, project #, pay item #, fund key, pay item description, placement indicator, quantity placed, pay item UOM, dollar amount placed, quantity placed to date, dollar amount placed to date, adjusted quantity, pay item unit price On Demand End-user Engineers (Field Residents, Prime Contractor, Contract Support personnel and District Engineers - Mkessler) Accounting Department access via Accounting tab.

InvoicePay Estimates (1.6)User selects from Report list on a pay estimate in the accounting module. Shows all accounting pay estimate details broken down by FAS ID.Report date/time, route, section, project #, state job #, aeronautics project #, airport project #, contract description, contract #, pay estimate from date, pay estimate to date, district, county, payee name/address, contractor name/address, pay estimate #, % complete, FAS ID, contract awarded amount, contract adjusted amount, total amount due to date, total completed amount, Other Direct Pay Participant(s) Share, Total Amount Due before retainage, liens, and other deductions, Retainage % held, Total Retained, Trust % held, total retained by trust, liens, other deductions, Total Amount Due after retainage, liens, and other deductions, previous amount paid, pay estimate total, appropriation, invoice amount, invoice schedule #On DemandEnd-userAccounting
Pay Estimate Detail SummaryPay Estimates (1.6)User selects from Report list on a pay estimate in the accounting module. Shows entire contract quantity book with placements for a specified pay estimate broken down by FAS ID.Contract #, contract name, pay estimate #, contractor name/address, route, section, job #, pay estimate to date, report date, district, county, project #, FAS ID, county code, cnst/sfty code, pay item #, pay item description, placed indicator, quantity placed, pay item UOM, dollar amount placed, quantity placed to date, dollar amount placed to date, adjusted quantity, pay item unit price, pay item adjusted quantity priceOn DemandEnd-userAccounting
Authorization ReportChange Process Control (1.5)User selects from Report list on an authorization. Generates an authorization approval form for the changes proposed to the contract.Authorization #, contract adjustment or change order, PoDI or PoCI, Consultant or In House, Major or Minor, authorization date, county, section, route, district, contract #, job #, project #, consultant name, contractor name/address, project location, authorization reason, authorization determination, DOT secretary signature line, DOT CFO signature line, DOT Chief Counsel signature line, regional engineer signature line, engineer of construction signature line, director of highways signature line, supervisor signature line, resident engineer signature line, FHWA participation indicatorOn DemandEnd-userEngineers (Field Residents, Prime Contractor, Contract Support personnel and District Engineers - Mkessler)

Accounting Department access via Accounting tab.

Pay Participant ReportFunding & Appropriations (1.8)User selects from Report list on the Accounting Funding tab. Shows pay participant details for each fund assigned to a contract.Contract #, fund key, participant name, participant awarded amount, participant not to exceed amount, participant adjusted amount, participant vouchered amountOn DemandEnd-userAccounting
Sample LabelMaterials Test Sample Creation (2.6)User selects one or multiple samples and initiates sample label generation through a menu option. Each generated label includes key sample attributes, suitable for affixing to the sample prior to lab submission.Test ID, sample date, producer, supplier, material, item descriptions, special identifier, inspected quantity, inspector, and contract number.On DemandEnd-userEngineers, Material Inspectors, District Materials
Pass/Fail LetterMaterials Test Sample Creation (2.6)User selects one or multiple samples and initiates Pass/Fail Letter generation through a menu option. Each generated letter includes department-defined content suitable for communication with vendors.Contract number, supplier number, supplier name, supplier address, laboratory, test ID, material number, material description, special identifier, inspected quantity, sample status, sample completed date, test data (values and results).On DemandEnd-userEngineers, Vendors, District Materials
Test Results ReportMaterials Distribution and Testing (2.7)User selects one or multiple samples and initiates Test Results Report generation through a menu option. Each report includes department-defined content for external communication and presents a summary of key test data, enabling efficient review and evaluation of the material.Material number, material description, test ID, completed date, producer, supplier, item descriptions, sample status, contract number, sample date, special identifier, inspected quantity, approved by, test name, version, test date, tested by, test questions and results, unit of measure, comments, test validated by, validated date.On DemandEnd-userEngineers, Material Inspectors, District Materials
HMA Letter - Permissive Use Drum ShellMaterials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Permissive Use Drum Shell letter. Each letter includes department-defined content outlining conditional approval for the use of a specific drum shell in HMA production.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, IDOT Policy Memorandum version number, IDOT Policy Memorandum publication date, CBM HMA plant technician , CBM HMA plant technician phone number, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisorOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District MaterialsLines 29 to 40 are for the existing HMA letters in the system. Mapped to old RFP requirements 2.8.13.

I remember Trey mentioned that there are a few letters we need to add. Should we add those in the new RFP?

HMA Letter - Plant Survey DeficienciesMaterials Plant Inspections (2.8)User selects a HMA Drum or Batch plant inspection and initiates the generation of Plant Survey Deficiencies letter. Each letter includes department-defined content notifying HMA plant operators of inspection findings that do not meet standards with required corrective actions.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), deficiencies and location of specification, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District MaterialsResponse to Line 29, Column H - I have added the HMA Plant 916 Form in Row 41. This should be the only one that needs to be added. Please see notes/questions for Row 41. - Trey Summers 070125
HMA Letter - Reapproval Batch (No Surge Bin)Materials Plant Inspections (2.8)User selects a HMA Batch plant inspection and initiates the generation of Reapproval Batch (No Surge Bin) letter. Each letter includes department-defined content outlining conditional acceptance of batch-produced HMA without surge bin storage.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Reapproval Batch (Surge Bin)Materials Plant Inspections (2.8)User selects a HMA Batch plant inspection and initiates the generation of Reapproval Batch (Surge Bin) letter. Each letter includes department-defined content outlining conditional acceptance of batch-produced HMA using a surge bin.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Reapproval Batch (Surface Mix & No Surge Bins)Materials Plant Inspections (2.8)User selects a HMA Batch plant inspection and initiates the generation of Reapproval Batch (Surface Mix & No Surge Bins) letter. Each letter includes department-defined content outlining conditional acceptance of surface mix asphalt produced without surge bin storage.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Reapproval Batch (Surface Mix & Surge Bins)Materials Plant Inspections (2.8)User selects a HMA Batch plant inspection and initiates the generation of Reapproval Batch (Surface Mix & Surge Bin) letter. Each letter includes department-defined content outlining conditional acceptance of surface mix asphalt produced using a surge bin.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Reapproval Drum (No Surge Bin)Materials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Reapproval Drum (No Surge Bin) letter. Each letter includes department-defined content outlining conditional acceptance of drum-mixed HMA produced without surge bin storage.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Reapproval Drum (Surge Bin)Materials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Reapproval Drum (Surge Bin) letter. Each letter includes department-defined content outlining conditional acceptance of drum-mixed HMA produced using a surge bin.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Reapproval Drum (Surface Mix & Surge Bins)Materials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Reapproval Drum (Surface Mix & Surge Bin) letter. Each letter includes department-defined content outlining conditional acceptance of surface mix asphalt produced in a drum plant using a surge bin.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technicianOn DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Type 1 or 2 Approval with LimitsMaterials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Type 1 or 2 Approval with Limits letter. Each letter includes department-defined content outlining conditional approval of HMA production under specific limitations or conditions.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), approval tonnage, plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technician, 1/2 inch control limit #, No. 4 control limit #, No. 8 control limit #, No. 30 control limit #, No. 200 control limit #, asphalt binder control limit #, 12.mm sieve mix formula #, 4.75 mm sieve mix formula #, 2.36mm sieve mix formula #, 600µm sieve mix formula #, 75µm sieve mix formula #, binder sieve mix formula #On DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Type 1 or 2 Approval with Limits (Additional 2000)Materials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Type 1 or 2 Approval with Limits (Additional 2000) letter. Each letter includes department-defined content outlining conditional approval for producing an additional 2,000 tons of HMA under specific limitations.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), approval tonnage, plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technician, 1/2 inch control limit #, No. 4 control limit #, No. 8 control limit #, No. 30 control limit #, No. 200 control limit #, asphalt binder control limit #, 12.mm sieve mix formula #, 4.75 mm sieve mix formula #, 2.36mm sieve mix formula #, 600µm sieve mix formula #, 75µm sieve mix formula #, binder sieve mix formula #On DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
HMA Letter - Type 1 or 2 Approval with Limits (Surface Only)Materials Plant Inspections (2.8)User selects a HMA Drum plant inspection and initiates the generation of Type 1 or 2 Approval with Limits (Surface Only) letter. Each letter includes department-defined content outlining conditional approval of producing surface mix asphalt under specific limitations.Date letter is generated, vendor name, vendor mailing address, plant make, plant model, number of surge bins, surge bin brand, plant location, producer/supplier number, date of publication (standard specifications for road and bridge construction), approval tonnage, plant rating number, date survey was completed, year of next construction season, CBM engr of materials, CBM HMA and Agg engr, District Materials engineer name, District number, CBC Prequal engr, CBM HMA lab supervisor, CBM HMA plant technician, 1/2 inch control limit #, No. 4 control limit #, No. 8 control limit #, No. 30 control limit #, No. 200 control limit #, asphalt binder control limit #, 12.mm sieve mix formula #, 4.75 mm sieve mix formula #, 2.36mm sieve mix formula #, 600µm sieve mix formula #, 75µm sieve mix formula #, binder sieve mix formula #On DemandEnd-userEngineers, Plant Inspectors, Vendors, District Materials
PCC Mix Design ReportMaterials Mix Designs (2.10)User selects a PCC mix design and initiates the generation of Mix Design Report. Each report includes department-defined content outlining the evaluation of proportions and performance characteristics of PCC mixtures.IDOT mix number, Producer mix number, material code, class(es), cement factor, mortar factor, CA voids, % air, W/C ratio, responsible district, reviewed by, producer number, producer name, effective date, aggregate, cementitious, Specific gravity, % blend, weight (SSD), theoretical water (lbs./cu yd), total batch wt., latex code, latex dosage, theoretical water (gal/cu yd), remarks, designer, phone, emailOn DemandEnd-userEngineers
HMA Mix Design ReportMaterials Mix Designs (2.10)User selects a HMA mix design and initiates the generation of Mix Design Report. Each report includes department-defined content outlining the evaluation the composition and performance characteristics of HMA mixtures.IDOT lab verification number, date, producer number and name, plant location, IDOT mix number, material code and name, plant bin 1 to 7 information ( #, size, source, name, location, add. info, agg blend %, mix blend %, 1 in., 3/4 in., 1/2 in., 3/8 in., no. 4, no. 8, no. 16, no. 30, no. 50, no. 100, no. 200, <Year> Gsb, Design Gsb, absorption %), plant bin MF information ( #, size, source, name, location, add. info, agg blend %, mix blend %, 1 in., 3/4 in., 1/2 in., 3/8 in., no. 4, no. 8, no. 16, no. 30, no. 50, no. 100, no. 200, <Year> Gsb, Design Gsb, absorption %), RCY1 to 4 type, plant bin RCY 1 to 4 information (#, size, source, name, location, add. info, agg blend %, mix blend %, 1 in., 3/4 in., 1/2 in., 3/8 in., no. 4, no. 8, no. 16, no. 30, no. 50, no. 100, no. 200, <Year> Gsb, Design Gsb, absorption %), AB material code, AB material design grade, AB plan grade, combined aggregate information (1 in., 3/4 in. 1/2 in., 3/8 in., no. 4, no. 8, no. 16, no. 30, no. 50, no. 100, no. 200), mixture spec range information (1 in., 3/4 in. 1/2 in., 3/8 in., no. 4, no. 8, no. 16, no. 30, no. 50, no. 100, no. 200), <Year> combined aggregate Gsb, design combined aggregate Gsb, combined aggregate absorption %, asphalt binder specific gravity, dust/AB ratio, change in combined aggregate Gsb, N initial, mix 1 to 4 N ini information (AB % mix, Gmb, Gmm, air voids (Pa), VMA, VFA, Vbe, Pbe, Pba), N design, mix 1 to 4 N des information (AB % mix, Gmb, Gmm, air voids (Pa), VMA, VFA, Vbe, Pbe, Pba), optimum N des information (AB, Gmb, Gmm, % voids (Pa), VMA, VFA, Gse, Gsb, TSR, RCY AB, Virgin AB, ABR, RCY AB), Hamburg no. passes, Hamburg wheel depth, unaged flexibility index, LTA FI, TSR, CA strip rating, FA strip rating, additive prod #, additive product name, additive %, lab preparing design, designing lab mix #, designing lab name, tested by, reviewed by, verified by, final approval, remarks line 1, remarks line 2, HMA aging time, HMA aging temperature, IDOT mix design verification GmmOn DemandEnd-userEngineers
Final Payment Status ReportThis is used as part of the final contract closeout processOn DemandAccounting
Bc-107 FormThis is used as part of the final contract closeout processOn DemandAccounting
Overpayment LetterThis is used as part of the final contract closeout processOn DemandAccounting

Drop Down Values

Frequency Options
Daily
Weekly
Monthly
Quarterly
Annually
Multiple
On Demand
Other

File details come from the government source that posted it. Updated .