In InfoMaster, there are five special tables to help users go from defect codes to costs for completing rehab actions. These five tables can be found under the main InfoMaster dropdown:
So let’s start from the first table: Defect Codes. The Defect Codes table related the code given by each CCTV defect to a particular Rehab Method. So a pipe with a NASSCO PACP defect code of ‘CS’ will not only be assigned a default score of 2, but also the Rehab Method ‘LINING’ in the example screenshot below.
This ‘LINING’ Rehab Method can be found in the second table: Rehab Methods. The Rehab Methods table contains many fields which control how different Rehab Methods are be applied. Users can add or subtract as many custom Rehab Methods as they want. Rehab Methods can be assigned to work on the full pipe vs. only the defect area. Rehab Methods can be merged into one Rehab Method if they are within a certain buffer, can have connection costs (ie Lateral Reinstatements) associated with them, or be assigned an Added Life value to be used in InfoMaster’s LCCA extension.
The next table is the Rehab Actions table. Like Rehab Methods, Rehab Actions can be added or subtracted as desired. Rehab Actions are assigned to entire pipe, not individual defects, in rehabilitation flowchart. The Rehab Actions can be associated to either work orders or inspections from the InfoMaster Work Manager.
The fourth table, the Rehab Action-Method table, relates the Rehab Actions table to the Rehab Methods table. Only the Rehab Methods assigned to each Rehab Action will be assigned to particular pipes after running your final rehabilitation plan flowchart. So a pipe’s Draft Rehab plan may specify many different Rehab Methods, but the final rehab plan for that pipe will only include one Rehab Action which may not include those many different Rehab Methods. The final rehab plan will only include costs from Rehab Methods associated with the assigned Rehab Action.
The fifth table, the Rehab Costs table, assigns unit costs to the different Rehab Methods. Rehab Costs can be specified based on the diameter, material, and depth of the pipe. Costs can be assigned per linear foot or per Rehab Method assigned. Rows with no size, material, etc. assigned will be considered universal costs assigned to pipes which don’t meet any other criteria in the table.
So after you have all five of these tables set up and you run your rehab flowchart , you will get a rehab summary report with two cost columns: Draft Cost and Total Cost. The Draft Cost value comes from the Rehab Methods assigned to that particular pipe based on the CCTV data. If that pipe does not CCTV data, the column should read $0. Pipes without CCTV data can still have Total Costs, however, because they still could have Rehab Actions associated to Rehab Methods which are associated to Rehab Costs.
In InfoMaster Water, the relationship is simplified since there is no CCTV data. Rehab Costs are associated to Rehab Actions which can be assigned to pipes via a Rehabilitation Plan flowchart. There are no Draft Costs, CCTV data, or Rehab Action-Method tables to worry about. Whew!
The relationships between these five tables can sometimes feel complicated and tenuous, but it is key to comparing and evaluating costs and rehab actions within InfoMaster. If you ever have any questions, please feel free to reach out to our support team!