Reporting on Cabling

Summary

Navigate to the Reporting section by clicking on the 'Reporting' icon in the 'Main' tab. Click on the node labeled 'Cable' (see image above). Click on any listed node to see a query-only reporting grid for the corresponding Cable report.(See image below)

Reporting functionality for Cable entries is included in the Reporting section for the sake of convenience, as users will likely generate these queries/reports on a frequent basis. Accordingly, these grids – which also appear in the View/Report section of Cable section – cannot be modified.

However, all of the functionalities common to all other grids – in terms of reporting - apply equally to these reporting grids. For instance, users can filter items on the grid, sort by column, and print grid reports. For more information on grid functionality, see the Getting Started:Critical Interfaces section entitled 'The Grid'.

Cable Reports

Cable Locations: View locations for all cable items. This includes from and to different locations and also from and to different equipment.

What's in the Report

Other Service status can be custom defined to meet internal use, or new . These values also will be included with a percentage of the Pair/Strands within the Cable. Service status labels can also be updated to better align with organizational terminology.

How Calculations are Performed

All Pair/Strands status field values are stored internally within a list, so that the application can quickly iterate through the list when grabbing all values that need record totaling. The application looks up all records for the given value by the associated PAIR_STATUS_LISTS_RECID and calculates the total. It then averages it against the total number of all records for the Cable's Pair/Strands. Once the Average is calculated, it is converted into a percentage.

• Pseudo-Code-Calculation
  
  

  calcStatusPercent(CABLE_RECORD, PAIR_STATUS_LISTS_RECID) {
    SRC_RECID = PAIR_STATUS_LISTS_RECID; 
    PS_RECORDS = findRecords(CABLE_RECORD); 
    TOTAL_COUNT = getCount(PS_RECORDS); 
    SUB_COUNT = getCount(subSet(PS_RECIDS_FROM_CABLE, SRC_RECID )); 
    SRC_PERCENT_STATUS = (SUB_COUNT / TOTAL_COUNT) * 100; return SRC_PERCENT_STATUS ;  
  }