This section outlines the bulk data update workflows featured in the Capital Budgets module of the Metrix Asset Management system. These workflows facilitate the handling of changes resulting from capital intervention works on related component records.
The topics discussed in this section include:
Following the completion of a project using a Budget Bucket in the Metrix Asset Management system, it is often necessary to update the intervention attributes of the underlying Asset Components to reflect the work that was completed throughout the project.
This section discusses the common attributes that you may consider updating as the result of a capital intervention project:
Condition: The condition of an Asset Component is often updated to reflect the current state of the Component following the completion of the project. In many cases, the condition of all Components can be set to the same value of ‘Excellent’, or equivalent.
Intervention Date: The date of the intervention is often updated to reflect the projects completion date as the most recent intervention date for the underlying Asset Components. Once again, this is often the same value for all Components in the Budget Bucket.
Treatment Useful Life: In the event that the project had an effect on the useful life of the Asset Component, it is important to update the Treatment Useful Life attribute to reflect the new useful life of each Component. Note; this is different to the Remaining/Residual Life of the Asset Component.
Residual Life: This attribute is relevant mostly in Renewal projects where the remaining useful life of the Asset
Component has been restored (typically to match the Treatment Useful Life). In this case, the Residual Life attribute
can typically be updated to match the Treatment Useful Life.
Cost Units: This attribute is relevant mostly in Upgrade projects where the size/scale of the underlying Asset Component may have changed. Such changes are NOT typically done in a bulk update, but rather, on a Component by Component basis.
Report Categories: Some users have implemented various Report Categories/Tags to track the Capital status of various Asset Components. If this pertains to you, don’t forget to update the Report Categories/Tags of the underlying Asset Component upon completion of the project.
It is important to note that Metrix will NOT automatically adjust any of the above attribute information. Whilst we do provide the ability to update many of these attributes in bulk, it is still up to the user to determine the correct values, and apply the changes to the underlying Asset Components.
In the data update tab, you will find a list of the unique Asset Classifications that pertain to the underlying Asset Components within the Budget Bucket. For each of the Asset Classifications, you will find the related Component Groups listed. Clicking on one of the Asset Classification tiles will show you Asset level attributes that you can edit. Clicking on one of the Component Group tiles will show you Component level attributes that you can edit.
As you might have presumed, when you edit attributes on a given tile, those changes will apply to the Asset/Component entities that are associated with that tile. For example, if you edit the ‘Condition’ attribute on the Component Group tile for ‘Sealed Road Surface’, the changes will apply to all the underlying Asset Components that are associated with that Component Group.
This form of grouping was chosen so that the bulk update process aligns with the classification configuration structure of Metrix. That is, each Asset Classification, and its child Component Groups, could potentially have a different set of Custom Attributes defined for them. Therefore, the Bulk Update tool is designed to allow you to edit the attributes for each Asset Classification and Component Group as independent groups.