Application Modifications and Enhancements

HiCAMS and DOH Vendor Versions 8.0 were released Friday, 21 August 2009.

OVERVIEW OF THE RELEASE

Enhancements have been made to Project Certification/Audit Materials functionality. Key enhancements in 8.0 include:
- Tracking/reporting material quantities by Line Item as well as by Material
- Adding an Incidental Materials indicator to the Master Bill of Materials and Contract Bill of Materials to allow designation of materials such as CRS-2 which are incidental to an item. This designation will be used in tracking material quantities in Project Certification/Audit Materials.
- Allowing users to re-generate their data based on either the MSG Versions associated with the various source records or using the MSG Versions associated with each material on the Contract Bill of Materials.
Modified the Density Other Conventional and Nuclear windows to track test results by Category/Subcategory on a Contract rather than by Line Item/Material combination. Existing Density records are being converted from the previous Line Item/Material combinations to the new Category/Subcategory designations.
Created new PAR Types for failing soils Density Tests. These PARs will need to be resolved in Final Estimates processing just as other PARs are.
Modified Field Inspection Reports that have Alternate ID information to allow access/update to the Alt ID tab data after report Authorization. The system will control assignment of the "In Use" status and FIRs having Alt IDs marked as In Use cannot be unauthorized.
Modified the Asphalt Mix Design module to allow users to designate the AMD Year in response to the 2010 specification changes for lower gyration levels.
Modified the Asphalt Mix Design and Job Mix Formula reports to display the Asphalt Design Engineer title, name and signature.
Expanded Federal Aid Number field across the system from 18 characters to 30 characters to match SPECS & BSIP.
NOTE: No changes were made to the DOH Vendor system in the 8.0 release. This release maintains synchronization of the Release Numbering.

CONTRACT MAINTENANCE - Review Contract BOM

Added an Incidental Materials indicator to allow designation of materials that are to be tracked for Received and Accepted quantities but where payment of the material is not directly made. These materials will no longer show as payment discrepancies in Project Certification/Audit Materials.

CONTRACT TRACKING - Review Material Receipts

Modified the Alt ID dropdown list to display expired types as grayed-out and at the bottom of the list.

CONTRACT TRACKING - Review Pay Adjustments

Created new PAR Types for failing soils density tests. PARs of these new types will be created from the Review Density Other Conventional and Review Density Other Nuclear windows.

CONTRACT TRACKING - Audit Materials

Added a Line Item Quantities tab to display Project Certification data for a selected Material by Line Item. The Project Certification module now allows review of data quantities by Material across all Line Items on the Contract and broken down by Line Item. When double-click navigating from the main Contract Material Quantities tab to the Line Item Quantities tab, a small blue arrow indicator displays next to the Material selected to distinguish it from other Materials listed for the selected Line Item.
Materials marked as Incidental on the Contract Bill of Materials will now have payment quantities calculated from estimate data. This allows the normal comparison against received and accepted quantities. On the Detail tab in Review Project Certification, these records will be marked as Source Type I records, with a Source ID of the estimate number.
Adjusted the Review Project Certification window to allow users who can update Project Certification to also have the ability to regenerate the data using either the MSG Version for each material on CBOM or the MSG Version associated with each Source record.
On the main Contract Material Quantities tab, rearranged the column order to display the most pertinent information towards the left side of the window. Additionally, a Material Type filter field was added to enhance analysis and review of a Contract's data.
Improved the window security to ensure updates for a contract can only be made by authorized M&T users and users assigned to that contract's office location.
On the Display Options pop-up window, the Discrepancies (at LI Level) Type choice previously labeled as None has been renamed to All.
KNOWN BUG: Users can no longer Print from the Detail Tab. This will be corrected in the next release.

CONTRACT ESTIMATES - Review Estimates

On the Open Issues tab, PARs resulting from any failing Density Tests (Conventional or Nuclear) will now be tracked with any other outstanding PARs.
On the printed estimate versions where Federal Aid Number is displayed, the reports have been modified to display the newly expanded 30 character field.

WBS MAINTENANCE - Add WBS

Expanded the Federal Aid Number field size from 18 characters to 30 characters to match SPECS & BSIP.

DENSITY - General

Modified the window and system to allow Density test information to be recorded at the Contract level rather then by Material and Line Item. Soils Density tests will now be associated to a Soils Density Category/Sub-Category rather then to a Material/Line Item combination. The new Category/Sub-Category values are:

Material Category

Material Subcategory

Base Untreated Base (ABC)

Base Cement Treated Base (CTBC)

Embankment Embankment

Embankment Fill

Embankment Flooring Lift

Embankment Pipe X-line

Embankment Rock Lift

Subgrade Aggregate Stabilized

Subgrade Cement Treated

Subgrade Cement Treated & Aggregate Stabilized

Subgrade Lime Treated

Subgrade Lime Treated & Aggregate Stabilized

Subgrade Raw Subgrade

DENSITY - Review Density Other Conventional

Modified the window and system to allow Density test information to be recorded at the Contract level rather then by Material and Line Item. Soils Density tests will now be associated to a Soils Density Category/Sub-Category rather then to a Material/Line Item combination. Existing data will be converted to the new Category/Sub-Category values as part of the 8.0 release implementation.
The window has been enhanced to allow creation of a PAR for failing Density test results.

DENSITY - Review Density Other Nuclear

Modified the window and system to allow Density test information to be recorded at the Contract level rather then by Material and Line Item. Soils Density tests will now be associated to a Soils Density Category/Sub-Category rather then to a Material/Line Item combination. Existing data will be converted to the new Category/Sub-Category values as part of the 8.0 release implementation.
The window has been enhanced to allow creation of a PAR for failing Density test results.

FIELD INSPECTION REPORTS (FIR) - General

Modified the windows to prevent Unauthorization of the FIR if any Alt ID on the FIR is marked as In Use.
The Alt ID Status of In Use is now system controlled based on linking to MRR's and the Alt ID Status will be protected whenever the system marks an Alt ID as "In Use".
Modified the windows to allow access/update to the data on the Alt ID tab even if the FIR has been Authorized. Changes to any of the data will still be subject to the usual edits the system performs and will only be accepted if all edits pass.
Added the Alt ID Quantity and Alt ID Available Quantity fields to the Report tab and to the printed report.

FIELD INSPECTION REPORTS (FIR) - Review Field Inspection Reports

CONCRETE PIPE, CORRUGATED METAL PIPE, GUARDRAIL, PRECAST CONCRETE and PRESTRESSED CONCRETE:
- Modified the windows to prevent Unauthorization of the FIR if any Alt ID on the FIR is marked as In Use.
- The Alt ID Status of In Use is now system controlled based on linking to MRR's and the Alt ID Status will be protected whenever the system marks an Alt ID as "In Use".
- Modified the windows to allow access/update to the data on the Alt ID tab even if the FIR has been Authorized. Changes to any of the data will still be subject to the usual edits the system performs and will only be accepted if all edits pass.
- Added the Alt ID Quantity and Alt ID Available Quantity fields to the Report tab and to the printed report.
GUARDRAIL: Corrected a problem with the Word Wrap function that caused the application to crash.
PRESTRESSED CONCRETE: Modified the window to restrict Load Live End and Load Dead End fields to a maximum of 6 digits.

SAMPLING - Enter Sample Details

Expanded the Represented Quantity field on the Line Item tab to accept quantities up to the maximum Represented Quantity value that can be entered on the Sample (99,999,999.99).

PROJECT CERTIFICATION - Review Project Certification

Added a Line Item Quantities tab to display Project Certification data for a selected Material by Line Item. The Project Certification module now allows review of data quantities by Material across all Line Items on the Contract and broken down by Line Item. When double-click navigating from the main Contract Material Quantities tab to the Line Item Quantities tab, a small blue arrow indicator displays next to the Material selected to distinguish it from other Materials listed for the selected Line Item.
Materials marked as Incidental on the Contract Bill of Materials will now have payment quantities calculated from estimate data. This allows the normal comparison against received and accepted quantities. On the Detail tab in Review Project Certification, these records will be marked as Source Type I records, with a Source ID of the estimate number.
Adjusted the Review Project Certification window to allow users who can update Project Certification to also have the ability to regenerate the data using either the MSG Version for each material on CBOM or the MSG Version associated with each Source record.
On the main Contract Material Quantities tab, rearranged the column order to display the most pertinent information towards the left side of the window. Additionally, a Material Type filter field was added to enhance analysis and review of a Contract's data.
Improved the window security to ensure updates for a contract can only be made by authorized M&T users and users assigned to that contract's office location.
On the Display Options pop-up window, the Discrepancies (at LI Level) Type choice previously labeled as None has been renamed to All.
KNOWN BUG: Users can no longer Print from the Detail Tab. This will be corrected in the next release.

QUERY TOOL

CONTRACT BILL OF MATERIALS: Added the Incidental Material field.
MASTER BILL OF MATERIALS: Added the Incidental Material field.
MATERIAL RECEIPTS: Corrected a problem with the query tool to allow retrieval of data with Alternate ID Type of GRDR.

STANDARD REPORTS - Contract BOM Report

Added the Incidental Material field to the report.

STANDARD REPORTS - Contract Materials Discrepancy Report

This report has been removed from the system as all of its information can be displayed/retrieved within the Audit Materials or Project Certification modules.

STANDARD REPORTS - Contract Materials w/Line Items Report

This report has been removed from the system as all of its information can be displayed/retrieved within the Audit Materials or Project Certification modules.

STANDARD REPORTS - Contract Quantities Statistics Report

This report has been removed from the system as all of its information can be displayed/retrieved within the Audit Materials or Project Certification modules.

STANDARD REPORTS - Density Other Summary

Modified the Material filter to be Category/Subcategory. The report itself has also been modified to display the Material Category/Subcategory.

REFERENCES - Asphalt Mix Designs

Modified the window to allow the user to designate the AMD Year value. Previously, the system auto-generated the year based on the current date, but the Asphalt Lab and Pavement Construction Section requested control of the year designation. Mixes beginning with the year 10 (for 2010) will fall under the new lower gyrations specifications levels. The system will continue to assign the 3-digit sequential number within the chosen AMD Year.
The printed Asphalt Mix Design report has been adjusted to display the Asphalt Design Engineer title, staff name and signature.

REFERENCES - Job Mix Formulas

The printed Asphalt Mix Design report has been adjusted to display the Asphalt Design Engineer title, staff name and signature.

REFERENCES - Master Bill of Materials

Added an Incidental Materials indicator to allow designation of materials that are to be tracked for Received and Accepted quantities but where payment of the material is not directly made via Ticket or Pay Record. These materials will no longer show as payment discrepancies in Project Certification/Audit Materials.

REFERENCES - Minimum Sampling Guide

Added notifications to the Contract's Resident Engineer, Assistant Resident Engineer, and the M&T Records Section Specialist when corrected versions of an MSG Material Type have been applied to their contracts.

ADMIN - Codes Table

AMD/JMF YEARS: NEW for Version 8.0. The code table was created to support the new functionality that allows authorized users to select the year designation on an Asphalt Mix Design.

ADMIN - Notification Setup

A new Incidental Material Changed notification has been created to alert the M&T Records Section Specialist anytime one of the contracts assigned to them has the Incidental Material checkbox adjusted on a Contract Bill of Materials record.
Two new Pay Adjustment Forward notifications have been created for the new Other Density Conventional and Other Density Nuclear PARs.

TOOLS - Notifications

Corrected the notifications for Failing Materials (e.g., Samples, Densities) to be displayed in red envelopes to provide additional visual hint that action is required.
KNOWN BUG: Go To navigation has reverted to the General Tab instead of the Line Items tab. This will be corrected in the next release.

Page last updated 26 August 2009

Material Category	Material Subcategory
Base	Untreated Base (ABC)
Base	Cement Treated Base (CTBC)
Embankment	Embankment
Embankment	Fill
Embankment	Flooring Lift
Embankment	Pipe X-line
Embankment	Rock Lift
Subgrade	Aggregate Stabilized
Subgrade	Cement Treated
Subgrade	Cement Treated & Aggregate Stabilized
Subgrade	Lime Treated
Subgrade	Lime Treated & Aggregate Stabilized
Subgrade	Raw Subgrade