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?
Examples:
Description |
Initial Form View |
Example Output |
Pre-Construction Outstanding Items List Tool (Materials Admin) |
||
Contractor’s Proposed Sources of Materials |
||
Contract Sampling and Testing Checklist |
||
Sample Information (Cover) Sheets |
||
Contract Asphalt Mix Design Data |
||
Asphalt Mix Design Lists |
||
IAS Contract Summary |
||
Contract Materials Audit/Certification Process |
|
|
Sampling & Testing Frequency Report (Materials Admin) |
none |
|
Contract Producer/Suppliers of Materials |
|
|
Quality Monitored (QM) Materials Usage |
||
Test Template Specifications (Materials Admin) |
||
Division and Residency Technician Information |
||
Certified Technician Setup Instructions |
||
Welder Operator Certification Card (Materials Admin) |
||
Address Labels |
|
|
Materials Status Report |
none |
Please email questions etc. about these utilities to: