Document toolboxDocument toolbox

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

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242