Examples of SiteManager Data Report Utilities - 5/19/2008

All of Oklahoma DOT Materials SiteManager data report utilities are Microsoft Access .mdb database sessions, dynamically linked to SiteManager production tables by read-only Oracle ODBC data table connections/links.  User report utilities typically start-up to a beginning option selection Form (pick list).  Some have progressive filter options.  User Report Utilities:

·         Are made accessible by a single official URL link in SiteManager System Attachments

·         Use a single .mdb database file in a shared network folder

·         Function both on our network clients with standard software installs and via Terminal Services

 

All of the data lists and reports in the Approved Lists section of OKDOT Materials e-Guide are:

·         Automatically queried by .mdb database files from live production SiteManager data and automatically refreshed on the website every 24 hours.  How current is the web list data?

 

OKDOT Training Center maintains Certified Technician data in SiteManager.  Materials Division defines data set-up procedures, produces and hosts the Certified Technician data lists seen on the OHCMTCB website in a similar manner, refreshing their lists at the same frequency.

 

Examples:

Description

Initial Form View

Example Output

Pre-Construction Outstanding Items List Tool (Materials Admin)

Form

Output

Contractor’s Proposed Sources of Materials

Form

Output

Contract Sampling and Testing Checklist

Form

Output 1

Output 2

Sample Information (Cover) Sheets

Form

Output

Contract Asphalt Mix Design Data

Form

Output

Asphalt Mix Design Lists

Form

Output

IAS Contract Summary

Form

Output

Contract Materials Audit/Certification Process

(PowerPoint Presentation Links)

(About OKDOT’s Tracking of Contract S/T Modifications)

Form 1

Form 2

Form 3

 

Output 2

Output 3

Output 4

Sampling & Testing Frequency Report (Materials Admin)

none

Output

Contract Producer/Suppliers of Materials

Form 1

Form 2

 

Output 2

Quality Monitored (QM) Materials Usage

Form

Output 1

Output 2

Test Template Specifications (Materials Admin)

Form

Output

Division and Residency Technician Information

Form

Output

Certified Technician Setup Instructions

Form

Output

Welder Operator Certification Card (Materials Admin)

Form

Output

Address Labels

Form 1

Form 2

 

Output  2

Materials Status Report

none

Output

 

Please email questions etc. about these utilities to:

dconaway@odot.org

vsmith@odot.org