The gravity main defect codes table contains more options than the manhole or lateral defect codes tables simply because clients typically conduct survey analysis on gravity mains more often than manholes or laterals. 


Gravity Main Defect Code Table Options

 Add/Delete Record - You may add or delete defect code records with these options.  Normally, tables within the Dashboard window are not editable and cannot have records added or deleted.  Defect Code tables are an exception.

 Reset  - Even if you alter and save your defect tables in order to customize them to their own non-standard requirements, the tables can always return to the default InfoAsset Planner template options with Reset.

 Survey Standard - You can use this drop-down option to switch between a number of different CCTV standards. InfoAsset Planner contains eight different CCTV standards from around the world.  For the United States, NASSCO PACP/MACP/LACP is the most popular standard and is included in InfoAsset Planner with a number of different versions.

 Active Version Dropdown - NASSCO PACP standards have gone through multiple iterations.  InfoAsset Planner can update the Defect Codes table to match previous PACP standards dating back to NASSCO PACP 6.0.2.  InfoAsset Planner's default "Custom Defined" table is Innovyze's attempt to reconcile all these different NASSCO PACP versions into a single table.  Because of this, the "Custom Defined" table is NOT NASSCO standardized.  It contains defect codes from old and new standards.  You should carefully review any Defect Codes table, particularly this "Custom Defined" table, before running the CCTV Wizard.

The "Custom Defined" table option is also a good template for you if you want to customize your scoring analysis with your own preferences.  By using this table, you still have the readily available option to switch back and forth between your custom scoring and a recent NASSCO scoring standard.

Field Descriptions

In the Defect Codes table, every field has influence in terms of how each defect is evaluated.  Therefore, you should take care to not only to make sure the correct codes are in the table, but that they also have the correct field values as these can play a key role in how survey data is geocoded, scored on the pipe, and assigned to the Draft Rehab Plan.  It is not advisable to add/remove columns from any Defect Code table.

Defect Code - Contains all the readable defect codes.  It is the key to the table; when InfoAsset Planner runs the Survey Analysis Wizard it is essentially performing a VLOOKUP function based on this field and the Defect Code field in the Condtions table.  If (when running the Survey Analysis Wizard) defect codes are found within the survey import data that are not in the Defect Code's table, InfoAsset Planner will notify the user and then append the new defect codes to the bottom of the currently active table.

Some defect codes are automatically considered Connection Codes.  These codes include:

For NASSCO PACP: 

CN, CX, CI, TF, TFA, TFB, TFC, TFD, TFI, TB, TBA, TBB, TBC, TBD, TBI, TS, TSA, TSB, TSC, TSD, and TSI


For Los Angeles Pipe Inspection Standard:

L, CL, T, PL, PM


For ISYBAU Standards:

BCA


Default Score - The score which will be given to the defect code.  So in the example above, everytime a 'B' or Broken defect score is read, InfoAsset Planner will give it a score of 4 by default.  NASSCO PACP scores are normally on a 0-5 scale, but you can enter any numerical value in this field if desired.


Type - Different defect codes may be associated as different types of defects.  NASSCO scores differentiate between Operational and Structural defects for example.  InfoAsset Planner does this as well.  Instead of Operational as a type, however, InfoAsset Planner by default categorizes defects as 'Construction', 'Miscellaneous', or 'Service' defects.  All these defect types feed into the Operational NASSCO scores (Peak, Quick Scores, Ratings Index, etc.).  Only Structural type defects are aggregated into NASSCO Structural scores.


Description/Comments - Contain the default NASSCO description and any comments the user may want to add.  These do not change the survey analysis or scoring.


Rehab Method - Rehab Methods can be associated to the defect codes in this field.  This allows for a defect-by-defect rehab analysis which is stored in in the Draft Rehab Plan/Summary reports.  Step 4 of the CCTV Analysis Wizard is where the defect codes are assigned with their Rehab Methods as shown in the Defect Codes table.  So for example, in the screenshot above the 'B' Broken defect code is associated with a Rehab Method of POINT REPAIR.  Every time a 'B' defect appears on a pipe, the POINT REPAIR Rehab Method is assigned.  Also note that these Rehab Methods come from a set list of Rehab Methods; see the Rehab Actions and Costs window to add Rehab Methods.  Defect Codes do not need to be assigned a Rehab Method.


Clock Pos. Grade 1, 2, 3, 4 - These fields analyze the difference between the clock position data from the Conditions table in the CCTV.  For example, in the screenshot above, if a 'B' defect is read and it has a Clock From value of 11 and a Clock To value of 12, then the difference would be 1 (12-11).  This matches up with the 1 value in the Clock Pos. Grade 3 field.  Because it matches in the 'Grade 3' field, the new score for this particular defect will be 3 instead of the default score of 4.  Notice that there is no Clock Pos. Grade 5 field.  If the defect exceeds the value specified in the Clock Pos. Grad 4 field, 5 will be the assigned score.


Value % Grade 1, 2, 3, 4 - These fields are similar to the Clock Pos. Grade fields in that they modify the default score.  In this case, InfoAsset Planner is reading the Value Percent field from the Conditions table to modify the score.  So in the screenshot above, if a 'DNF' score is read and it has a Value Percent value of 30, then the score will be 4.  It is important to note that the Value Percent field should be in increments of 5 per NASSCO standards. So if the Value Percent field read 25, InfoAsset Planner would round up and adjust the defect score to 4, just as it did for a Value Percent value of 30.  If the Value Percent field is not in increments of 5, say if Value Percent value of 2 were read, the score would be 2 since the Value % Grade2 field is 10 and 2 is less than 10.  If the Value Percent read is above the value specified in Value % Grade4, then the defect score would be 5.


Alternative Method/Alter. Rehab Cutoff - These two fields are related to the Value Percent field in the conditions table.  If the Value Percent is greater than the Alter. Rehab Cutoff value indicated in the Defect Codes table, then the Alternative Method will be assigned to the defect instead of the Rehab Method.  So in the example above, if a 'DAE' defect code is read and the Value Percent field in the Conditions table is greater than 4, the Alternative Rehab Method of 'SERVICE' will be assigned.



Different CCTV Standards (MSCC, EN 13508-2, etc.) will have different fields, with different modifying fields which work similarly.  For more detailed information on these fields within different CCTV standards, contact Innovyze Support.