| Table of Contents | ||||
|---|---|---|---|---|
|
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.
...
| Code Block | ||
|---|---|---|
| ||
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 ;
} |