.Reporting on Cabling v2.1.4.7

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

Field	Usage	Populated Based On The
Cable Name	Name of the Cable.	Cable Record
From Equipment	Name of the Equipment the Cable comes from.	Equipment Record
To Equipment	Name of the Equipment the Cable goes to.	Equipment Record
From Equipment (Location)	Location of the Equipment the Cable comes from.	Equipment Record
To Equipment (Location)	Location of the Equipment the Cable goes to.	Equipment Record
Count	Number of Pair/Strands assosiated to the Cable.	Cable Record
Low	Minimum number of Pair/Strands applied to the Cable.	Cable Record
High	Maximum number of Pair/Strands applied to the Cable.	Cable Record
% Left In	Percent of Pair/Strands that are currently connected to something but not providing active Service.	Calculation of related Pair/Strands Records
% Spare	Percent of Pair/Strands that are not in use.	Calculation of related Pair/Strands Records
% Assigned	Percent of Pair/Strands that are currently assigned to a Service.	Calculation of related Pair/Strands Records
% Reserved	Percent of Pair/Strands that are Reserved.	Calculation of related Pair/Strands Records
% PDPC	Percent of Pair/Strands that are on a Service that is being disconnected via Service Order and has also been assigned on a Service Order.	Calculation of related Pair/Strands Records
% Pending Disconnect	Percent of Pair/Strands that are on a Service that is being disconnected via Service Order.	Calculation of related Pair/Strands Records
% Pending Connect	Percent of Pair/Strands that has been assigned to a Service on a Service Order.	Calculation of related Pair/Strands Records
% Bad	Percent of Pair/Strands that has been marked as Bad.	Calculation of related Pair/Strands Records
% Unknown	Percent of Pair/Strands that are Unknown.	Calculation of related Pair/Strands Records
Length of the Cable	Length of the Cable.	Cable Record
Signal Loss	Decibels of lost signal.	Cable Record

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 ;  
}