AASHTOWare Bridge Management Product Update

December 02, 2015

The following Task Force product update is provided to keep all AASHTOWare Bridge Management (BrM) Software users apprised of recent activity related to the development of the software. The Task Force is committed to providing these quarterly updates to help improve communication between the Task Force and those interested in the product.
AASHTOWare Bridge Management 5.2.2
AASHTOWare BrM 5.2.2 has been released to production. If you would like to request a copy, please email BrM@Bentley.com
The BrM 5.2.2 release will include a significant change to the way that your data is stored in the software database. This is being done to standardize and simplify the database structure. Agencies that have customized their software based off of keys in the database will need to modify their customizations to instead use GUIDs.
Depending on the amount of customizations made to your software installation, or dependencies from other systems that refer to the keys, migrating to support this change in BrM 5.2.2 may be a significant effort. Agencies have the ability to continue to use keys, however, legacy columns will no longer be officially supported.

  • GUID ‘White Paper’- The following link (GUID White Paper) provides a brief overview of the potential impacts of the 5.2.2 using an existing agency database as an example.
  • Legacy associated database columns (e.g. BRKEY in the INSPEVNT table) – If you are an agency that has existing external processes built reliant on the use of the legacy KEY columns in associated tables, the following links (SQL / Oracle) will provide you a skeleton trigger that will populate and update BRKEY automatically for the INSPEVNT column. If you need this trigger extended for other columns or tables, you will need to modify the trigger accordingly.

Multimedia TAG
It’s time to begin research on what multimedia capabilities we want BrM to have in the post 5.2.3 world.
This is your invitation to become a member of the AASHTOWare Bridge Management (BrM) Technical Advisory Group (TAG) for Multimedia
If your state uses the multimedia task,
you’ve created your own multimedia task,
or you have ideas on how you’d like to see BrM’s multimedia capabilities modernized,
Please Join.
We tentatively plan to meet monthly via web conference every 2nd Wednesday at 2:00 Eastern time.
Let me know if you want to join, but that time won’t work.
To join, please send your Name, State, Phone, Title and email to Mark Faulhaber (mark.faulhaber@ky.gov).
Once we have the membership list nailed down, a recurring meeting notice will be sent out.
Interested in Joining the Reporting TAG?
The Reporting TAG is being re-initiated to evaluate the default reports that currently exist within BrM and determine what reports should be included as part of future softare releases. These reports will be included as part of the BrM 5.2.3 release. Beckie Curtis (MDOT) has volunteered to lead this initiative.

Anyone interested in becoming a part of this group should email Beckie at CurtisR4@michigan.gov.

User Group Priorities
The following link (User Group Priorities) outlines the User Group priorities identified at the last User Group meeting. The Task Force has reviewed the list and provided the following status updates.

National Tunnel Inspection Standards
The Federal Highway Administration has released a final rule on the much anticipated National Tunnel Inspection Standards (NTIS). AASHTO and the Task Force believe that BrM is well-suited to record and track National Tunnel Inventory data and are working on a plan for the inclusion of tunnels, and other asset types, into the software. A solicitation has been request for agencies to assist in the funding of the NTIS inclusion into BrM. (Request for Funds)

In the meantime, an intermediate spreadsheet has been created to provide all agencies with a means of recording and submitting their inventory data. The intermediate spreadsheet is available and can be used to collect and report the preliminary inventory data that will be required to submit to FHWA by December 11, 2015. Spreadsheet data can later be conveniently uploaded to BrM assuming funding of the NTIS inclusion into BrM discussed above has been obtained. This spreadsheet can be requested by emailing Judy Skeen at JSkeen@aashto.org . It should be noted that the spreadsheet is intended for the preliminary inventory submittal, and will not be capable of creating the full submittal that will be necessary in 2018. The NTIS inclusion into BrM would have that capability.

AASHTOWare Bridge Management 5.2.3
Requirements for the various enhancements to the software are being gathered by the TRTs and Functional Design Specification documents are being crafted from those requirements. 5.2.3 will be continuing to build on the work done thus far in the BrM product. Significant enhancement include: enhancements to the deterioration modelling capabilities (notably LifeCycle Cost Analysis and the NBI Converter), enhancements to the project/programming capabilities (software analysis, scenario explorers, and project/program enhanced analysis), creating a new framework within the software to allow agencies to track and record information on any agency required asset types (e.g. Tunnels, Signs), a brand new user manual, and a refreshed User Interface for the product.

Bridge Management Webinars
The aashtowarebridge.com website is your online resource for information on the BrM software. There are currently 16 webinars that cover a wide-range of topics with more planned for the future. An overview webinar of the new Projects and Programs module in BrM 5.2.2 is currently being recorded and will be uploaded shortly. To submit your webinar requests please contact Bentley at BrM@Bentley.com.

Sincerely,
The AASHTOWare Bridge Task Force
Eric Christie, (Vice Chair – Bridge Management)
Assistant State Maintenance Engineer – Bridges
1409 Coliseum Boulevard
Montgomery, AL 36110
(334) 242-6281