...
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.
...
Pseudo-Code-Calculation
Code Block language php 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 ; }