This article reviews the changes in the Work Order Tracking application to support Linear Assets, but it does not include meters and meter readings.

Performing Work on Linear Assets

There are a few work order scenarios about linear assets that can be accommodated on both the Work Order Tracking and Quick Reporting applications. 

  • You can perform work on a single linear asset or a segment of it. Costs are attributed to the linear asset.
  • You can perform work on a single feature of a linear asset. Costs are attributed to the linear asset.
  • You can perform work on multiple linear assets or multiple segments of one or more linear assets, this uses the Multiple Assets, Locations and CIs table. Costs are attributed to the location, asset of GL Account on the work order header.
  • You can perform work on multiple point assets, locations or features along a linear asset, or along a segment of a linear asset. This uses the Multiple Assets, Locations and CIs table. Costs are attributed to the location, asset of GL Account on the work order header.

Linear Segment Details will be found on the work order header, and in the Multiple Assets, Locations and CIs table, but not on child or task work orders. There is no linear capability on the Activities and Tasks application.

Perform Work on a Linear Segment

For work order 1479 – Patching near MP 20, we have referenced I-95N as the asset, the feature and feature label remain blank, and Job Plan 401 was applied.

In the Linear Segment Details the Start Measure is from Reference Point MP 20, and the End Measure is from the same reference point but with a Reference Point Offset of 5,000 FEET. We are patching the road over a linear segment from 20.00 miles to 20.95 miles. 

The cost of this work is against asset I-95N.

Perform Work on a Linear Feature

For work order 1494 – Linear asset and feature, we have referenced I-95N as the asset and the GANTRY-SIGN asset feature that has the feature label of Road sign for MD 202.

In the Linear Segment Details the Start and End Measures have come from the selected asset feature, a point 5,280 FEET from the reference point where I-95N intersects with MD 202, this reference point is derived from the relationship between the two linear assets. 

The cost of this work is against asset I-95N.

Perform Work on Multiple Linear Segments

For work order 1487 – Potholes in I-95N between MP 30 and MP 40, we have referenced I-95N as the asset, the feature and feature label remain blank.

In the Linear Segment Details, it is a good idea to restrict the part of the linear asset where work is being performed as this will make it easier to find the work order when you use the action Filter by Linear Assets. The Start Measure and End Measure will otherwise be set to the start and end of the linear asset 0 and 109.70 miles in the case of linear asset I-95N.

In this example the Start Measure is using the Reference Point MP 30, and the End Measure is using Reference Point MP 40. We are only patching a small area between 30.00 and 30.10 miles whether you make this more precise or just use reference points will be something which the implementation will need to decide.

The Multiple Assets, Locations and CIs is being used to indicate where the spots are that need patching and I’ve used the Target Description field to provide an indication of where in the 10 mile stretch it will be, we will be looking at the detail of the first row with a Target Description of 25 Feet, that is 25 feet in from mile post MP 30. 

It is also a good idea to provide a Sequence so that as the team works down the road doing their pothole repairs they don’t miss one and need to go back.

In the details section of the Multiple Assets, Locations and CIs table window the Linear Segment Details defines exactly where the point or linear segment is. In this case it is a linear segment that needs to be repaired from 25.20 FEET from MP 30 to 50.00 FEET, a portion of road just under 25 feet in length and offset from the MIDLINE by 21.50 FEET to its left.

While this example shows that the costs will be attributed to the linear asset I-95N you could have other examples where no linear asset is referenced in the header, a location or GL account might be referenced to receive the costs. You are performing work on multiple linear or point assets, or locations in the Multiple Assets, Locations and CIs table, this is not dependent on you having referenced a linear asset on the work order header.

Perform Work on a Multiple Point Assets, Locations or Features

For work order 1498 – Guard Rail Painting, we have referenced I-95N as the asset, the feature and feature label remain blank.

In the Linear Segment Details, we have restricted the part of the linear asset to where work is being performed. The two Guard rails will be found be 12.00 MILES and 25.00 MILES

The Multiple Assets, Locations and CIs is being used to indicate the two linear GUARDRAIL features. The Sequence has been used to indicate the order of work. 

In the details section of the Multiple Assets, Locations and CIs table window in the Details area we have referenced the Linear Asset and a Feature, and the Linear Segment Details information is copied from the asset feature. We are looking at the second GUARDRAIL between 20.00 and 25.00 MILES. There is a total of 6 miles of guard rail to paint. 

The costs are being attributed to the I-95N asset referenced on the work order header.

Linear Progress on Work Orders

On the Multiple Assets, Locations and CIs table there is a checkbox for indicating progress, the field title is Mark Progress. The work for the asset or location is either completed or not.

For linear assets there is the ability to reference the progress of work along the linear asset. The Progress table window is displayed if any of the Multiple Asset, Location and CI records is a linear asset, it does not need to be the top record. It is also displayed if the work order header is a linear asset, there might not be any Multiple Asset, Location and CI records.

In the Progress table window, you use New Row button and then the Select Value on the Asset or Feature fields will display the assets whether they are on the header or the Multiple Asset, Location and CI table. These could be point assets or point features of a linear asset.

After a row is selected, it is transferred to the Progress table window. The GUARDRAIL selected is shown with its default measures from 12.00 MILES to 13.00 MILES. If you have completed the work on the whole of this linear feature, then the record can be saved.

The Progress record is linked to the Multiple Asset, Location and CI table record using the key field MULTIID. If there are no records displayed in the Multiple Asset, Location and CI table window then there is still a record in the table, it reflects the Asset, Location or CI that is on the header of the work order. 

For longer linear features you may be indicating the measures that had been completed during the progress reporting period. In the example, we had originally painted the GUARDRAIL from the mile post MP 20 for 1,500 FEET and we used the Reference Point MP 20 with an Offset of 1,500 and the exact measures were calculated as 20.00 MILES to 20.28 MILES. 

In the second record we have again used the MP 20 Reference Points with a Start Offset of 1,500 and an End Offset of 4,000 FEET, a total of 2,500 FEET, or 0.48 MILES.

Note. Maximo does not have validation to check that you are not overlapping your progress reporting records for the same work order. 

If you duplicate a work order with linear progress the Progress table window on the duplicated work order will be blank.

Note. If you create a follow-on work order for a linear asset that has a Feature or Linear Segment Details on the main work order, then these are not copied to the follow-on work order.

With regard to the action Move/Swap/Modify, the Modify tab allows you to see all the attributes of the specification but it does not show the linear measures, you may end-up with the attribute being shown multiple times, but without configuration you would not be able to understand where on the linear asset the attribute is being referenced. This is the same problem on the Assets application and the action Move/Modify Assets. If you need to make these changes then it needs to be done from the Assets application and Specifications tab.

Feature Specification Changes can only be made from the Assets application and Features tab.

Assets Application – Work Tab

Work Orders and Service Requests that reference linear assets can be viewed from the Assets application and Work tab. There are two sub-tabs for Work Orders and Tickets. The table window shows the Start Measure and End Measure and you can filter the rows by using the From and To fields in the header. You can navigate to the Work Order Tracking application from the Work Order column.

Similarly for Service Requests, you can see the Start/End Measures from the Tickets sub-tab and you can filter the rows by using the From and To fields in the header. You can navigate to the Service Requests application from the Ticket column.

You can see that below the set of related tickets there is the Linear Visual Control.

The Linear Visual Control has a section for Work that then splits between Work Orders and Tickets. Work Order bars are coloured green and there is both bar text and hover-over text. The hover-over text displays more data than we have seen for other hover-over dialogs.

You might notice at the bar ends two orange lines these represent the From and To measures in the header of the tab, 0 and 109.70 miles.

The work orders, 1146, 1167, 1168, etc., also have a Progress bar. For work order 1167 there are four turquoise bars and there were four work progress records with the Change Date being displayed. The data conveniently shows a progress of 10 miles on four consecutive days, 01-04 February 2011. 

For Tickets you get a similar display but orange bars. There are no progress bars for Tickets.­

Organizations – Asset Options 

We have seen previously that to change the bar text or the hover-over text we use the Linear Visual Control Message Configuration. There is a row for Tickets, Work Order Progress, and Work Orders.

To change the colour of the bars you use the Configure button in the Linear Visual Control Symbology, this is the button next to the text ‘Configure the appearance of Linear object symbols in the Linear Visual Control display.’.

A dialog opens and you look for the “objectName” property that you wish to change. In the object MULTIASSETLOCCI where the attribute RECORDCLASS = “WORKORDER” you will find that the colour cssClass = Green, and for RECORDCLASS = “SR” the cssClass = Orange.

A little further down for object MULTIASSETLOCCIPR, the work order progress, the cssClass is Aqua.