Nokia NSS M13.5 VN Functional Specification

Data Export Date: 07 Sep 2008


1. Change History


IssueDateAuthorComments
TBD   


2. Document References


None.

3. Outstanding Issues


NumberDateDescriptionPlanned Resolution
TBD   


4. Network Model


4.1 Network Objects

This section describes the network objects (logical and physical) that are referenced in this technology pack's data model.

HLR

The Home Location Register is the main network database (may be distributed). The HLR records permanent subscriber information, and keeps track of each subscriber's status and location in the network.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the HLR.STRING 
NameA user friendly name preferably unique for the HLR.STRING 
RegionRegion associated with the HLR.STRINGRegion
NetworkNetwork associated with the HLR.STRINGNetwork
VendorManufacturer of the HLR.STRING 
HLR_VersionHardware/Software version of the HLR.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 


LAC

Location/Paging Area Code; a group of cells, managed by an MSC, that a mobile station's location may be recorded against.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the LAC.STRING 
NameA user friendly name preferably unique for the LAC.STRING 
MSCThe MSC which controls this Location Area Code.STRINGMSC
RegionRegion associated with the LAC.STRINGRegion
NetworkNetwork associated with the LAC.STRINGNetwork
VendorManufacturer of the LAC.STRING 


MSC

The Mobile Switching Centre has circuit/voice switching functions, as well as linking several BSCs to the core network and managing some of their functions (eg inter-BSC handover). It is also connected to an SS7 network for database queries.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the MSC.STRING 
NameA user friendly name preferably unique for the MSC.STRING 
RegionRegion associated with the MSC.STRINGRegion
NetworkNetwork associated with the MSC.STRINGNetwork
VendorManufacturer of the MSC.STRING 
MSC_VersionHardware/Software version of the MSC.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
MSC_TypeType of MSC.STRING 


Network

Network information.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Network.STRING 
NameA user friendly name preferably unique for the Network.STRING 
Network_TypeType of Network (e.g. GSM-900, GSM-1800 or GSM-1900).STRING 
Default_Link_SpeedThe default speed of SS7 Signalling Links in this network.FLOAT 


Processor

The Processor object represents a CPU inside another network element. Some elements have more than one Processor.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Processor.STRING 
NameA user friendly name preferably unique for the Processor.STRING 
RegionRegion associated with the Processor.STRINGRegion
NetworkNetwork associated with the Processor.STRINGNetwork
Processor_TypeType of Processor.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Node_IdThis is the identifier for the network element containing the Processor.STRING 
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_TypeThe type of the network element containing the Processor.STRING 
Processor_VersionHardware/Software version of the Processor.STRING 
VendorManufacturer of the Processor.STRING 


Region

A user defined grouping of network elements.

Attribute NameDescriptionTypeRelated Object
IDRegion associated with the network object.STRING 
NameA user friendly name preferably unique for the Region.STRING 
NetworkNetwork associated with the Region.STRINGNetwork


Route_IF

For each logical Route Interface, there will be 2 entries - 1 for the interface at each end, as it is the interfaces that report the data. Routes may connect switches and other nodes (including BSCs) in a circuit-switched network.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Route IF.STRING 
NameA user friendly name preferably unique for the Route IF.STRING 
RegionRegion associated with the Route IF.STRINGRegion
NetworkNetwork associated with the Route IF.STRINGNetwork
Source_IdA unique identifier for the Node (Switch) at this end of the connection.STRING 
Source_TypeType of Source.STRING 
Source_NameA user friendly name preferably unique for the Source.STRING 
Target_TypeType of Target.STRING 
Target_NameA user friendly name preferably unique for the Target.STRING 
Is_POIIs it a Point of Interconnection.BOOLEAN 
Is_TrunkIs it a Trunk Route?BOOLEAN 
Route_DirectionThere are three options - Incoming, Outgoing or BothWay.STRING 
Route_TypeThe type of route.STRING 
Target_IdA unique identifier for the Node at the other end of the connection.STRING 
Source_TechnologyTechnology of the Source (e.g. GSM, GPRS, UMTS).STRING 
Target_TechnologyTechnology of the Target (e.g. GSM, GPRS, UMTS).STRING 


Signalling_LinkSet

A set of Signalling Links between two points.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 LinkSet.STRING 
NameA user friendly name preferably unique for the SS7 LinkSet.STRING 
SS7_PointThe SS7 Point to which this SS7 LinkSet is connected to (at this end).STRINGSignalling_Point
NetworkNetwork associated with the SS7 LinkSet.STRINGNetwork
RegionRegion associated with the SS7 LinkSet.STRINGRegion
Node_IdThe Node (MSC or HLR) that this SS7 LinkSet is connected to (at this end).STRING 
Node_NameName of the node that this SS7 LinkSet is connected to (at this end).STRING 
Data_RateThe total of all the individual SS7 Link speeds (aggregated over all SS7 Links in the SS7 LinkSet) in bits per second (bit/s).FLOAT 
Designed_Link_FailuresThe number of SS7 Link failures permitted on the SS7 LinkSet while still keeping the SS7 LinkSet up to its designed capacity.INTEGER 
Node_TypeThe type of the network element that the SS7 LinkSet is connected to (at this end).STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdThe Adjacent Node that this SS7 LinkSet is connected from (at the other end).STRING 


Signalling_Link

The SS7 Signalling data link is a full-duplex, digital transmission channel, usually operating at 64 kbit/s.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 Link.STRING 
NameA user friendly name preferably unique for the SS7 Link.STRING 
SS7_LinkSetThe Node (MSC or HLR) that this SS7 Link is connected to (at this end).STRINGSignalling_LinkSet
SS7_PointA unique identifier for the SS7 Point.STRINGSignalling_Point
RegionRegion associated with the SS7 Link.STRINGRegion
NetworkNetwork associated with the SS7 Link.STRINGNetwork
Node_NameThe name for the network element that the SS7 Link is connected to (at this end).STRING 
Node_IdThe Node (MSC or HLR) that this SS7 Link is connected to (at this end).STRING 
Data_RateThe SS7 Link speed in bits per second (bit/s).FLOAT 
Node_TypeThe type of the network element that the SS7 Link is connected to at this end.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdThe Adjacent Node that this SS7 Link is connected from (at the other end).STRING 


Signalling_Point

Represents a signalling entity that is part of a Node.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 Point.STRING 
NameA user friendly name preferably unique for the SS7 Point.STRING 
RegionRegion associated with the SS7 Point. SS7_Point - the default value is derived via the Node.STRINGRegion
NetworkNetwork associated with the SS7 Point.STRINGNetwork
Node_IdA unique identifier for the Node.STRING 
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_TypeType of Node.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdA unique identifier for the Adjacent Node.STRING 


Signalling_RouteSet

A Signalling Route is a path from one point to another in the signalling network. It is implemented by a number of LinkSets, but the relationship between RouteSets and LinkSets is not available in the data supplied by most vendors.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the SS7 RouteSet.STRING 
NameA user friendly name preferably unique for the SS7 RouteSet.STRING 
SS7_PointThe SS7 Point to which this SS7 RouteSet is connected (at this end).STRINGSignalling_Point
RegionRegion associated with the SS7 RouteSet.STRINGRegion
NetworkNetwork associated with the SS7 RouteSet.STRINGNetwork
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_IdThe Node that this SS7 RouteSet is connected to (at this end).STRING 
Node_TypeType of Node.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
Adjacent_Node_IdThe Adjacent node that this SS7 RouteSet is connected from (at the other end).STRING 


VLR

The Visitor Location Register is distributed, and one VLR is usually associated with each MSC. It caches a subset of the information from the HLR, for subscribers that connected locally, plus some other temporary information.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the VLR.STRING 
NameA user friendly name preferably unique for the VLR.STRING 
MSCThe MSC to which the VLR belongs.STRINGMSC
NetworkNetwork associated with the VLR.STRINGNetwork
RegionRegion associated with the VLR.STRINGRegion
VLR_VersionHardware/Software version of the VLR.STRING 
VendorManufacturer of the VLR.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 


4.2 Reference Objects

This section describes the reference objects that are used only as lookups for compound-keyed raw data.

Completion_Code

Call completion codes for voice switches.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Completion Code.STRING 
NameA user friendly name preferably unique for the Completion Code.STRING 
Completion_Code_TypeType of Completion Code.STRING 
Completion_Code_DescriptionDescription of Completion Code.STRING 


Supplementary_Service

Supplementary Services supported by voice switches.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Supplementary Service.STRING 
NameA user friendly name preferably unique for the Supplementary Service.STRING 


Traffic_Type

Types of traffic carried by a voice switch.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Traffic Type.STRING 
NameA user friendly name preferably unique for the Traffic Type.STRING 
DirectionDirection of Traffic.STRING 
IS_SwitchedIs the traffic switched?STRING 


5. Busy Hours

This section lists the busy hours that are defined in this technology pack, grouped by the network object to which they relate, as follows:


HLR Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourhbhHLR.Neutral.GSM.access.auc_la_update_attempts


MSC Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourmbhMSC.Neutral.GSM.traffic.traffic
traffic_type_busy_hourmtbhMSC.Neutral.GSM.traffic.traffic


Processor Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourpbhProcessor.Neutral.GSM.cpu.load_pc


Route_IF Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourrbhRoute_IF.Neutral.GSM.transmission.bothway_traffic
incoming_busy_hourribhRoute_IF.Neutral.GSM.transmission.incoming_traffic
outgoing_busy_hourrobhRoute_IF.Neutral.GSM.transmission.outgoing_traffic


Signalling_Link Busy Hours

Busy Hour NameAcronymDefining KPI
received_busy_hourslrbhSignalling_Link.Neutral.GSM.link.incoming_utilisation
transmitted_busy_hoursltbhSignalling_Link.Neutral.GSM.link.outgoing_utilisation


Signalling_LinkSet Busy Hours

Busy Hour NameAcronymDefining KPI
received_busy_hourslsrbhSignalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_utilisation
transmitted_busy_hourslstbhSignalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_utilisation


VLR Busy Hours

Busy Hour NameAcronymDefining KPI
busy_hourvbhVLR.Neutral.GSM.mobility.vlr_subscribers


6. Constants


This section lists all constants that are defined in this technology pack, and which may be referenced in KPI expressions.

Constant NameDescriptionUnitsDefault Value
GTP_header_Size Byte16


7. Performance Indicators

This section lists the performance indicators (both one-to-one counter mappings, and complex KPIs) that are defined in this technology pack, grouped by the network object to which they relate, as follows:

Note that all KPIs will have total, average, minimum and maximum values calculated for daily, weekly, and monthly summaries. Individual groups of KPIs may have additional summary types (including busy hours) applied to them, and these are listed against the respective KPIs in the tables below.


HLR Performance Indicators

HLR.Neutral.GSM.access

Statistics on authentication procedures

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_auc_failurepercentfail({HLR.Neutral.GSM.access.auc_failures}, {HLR.Neutral.GSM.access.auc_attempts})FLOAT%Percentage of failed requests for authentication parameters to the Authentication Centre (HLR to AUC)hbh
%_auc_successpercentok({HLR.Neutral.GSM.access.auc_successes}, {HLR.Neutral.GSM.access.auc_attempts})FLOAT%Failed requests for authentication parameters to the Authentication Centre (HLR to AUC)hbh
%_auth_failurepercentfail({HLR.Neutral.GSM.access.auth_failures}, {HLR.Neutral.GSM.access.auth_attempts})FLOAT%Percentage of failed requests from a VLR for authentication parameters (VLR to HLR)hbh
%_auth_successpercentok({HLR.Neutral.GSM.access.auth_successes}, {HLR.Neutral.GSM.access.auth_attempts})FLOAT%Percentage of successful requests from a VLR for authentication parameters (VLR to HLR)hbh
%_data_coveragegetvalidity({auc_attempts})FLOAT%  
auc_attemptshlr_resource_access_raw.auc_attemptsINTEGER#Requests for authentication parameters to the Authentication Centre (HLR to AUC)hbh
auc_failureshlr_resource_access_raw.auc_failuresINTEGER#Successful requests for authentication parameters to the Authentication Centre (HLR to AUC)hbh
auc_la_update_attempts{HLR.Neutral.GSM.access.auc_attempts} + {HLR.Neutral.GSM.mobility.la_update_attempts}INTEGER#Total auc_attempts + la_update_attempts for HLR Busy Hour 
auc_successeshlr_resource_access_raw.auc_successesINTEGER#Successful requests for authentication parameters to the Authentication Centre (HLR to AUC)hbh
auth_attemptshlr_resource_access_raw.auth_attemptsINTEGER#Requests from a VLR for authentication parameters (VLR to HLR)hbh
auth_failureshlr_resource_access_raw.auth_failuresINTEGER#Failed requests from a VLR for authentication parameters (VLR to HLR)hbh
auth_reusedhlr_resource_access_raw.auth_reusedINTEGER#Number of times that authentication parameters have been re-usedhbh
auth_successeshlr_resource_access_raw.auth_successesINTEGER#Successful requests from a VLR for authentication parameters (VLR to HLR)hbh


HLR.Neutral.GSM.mobility

Statistics on the communication between VLRs and the HLR

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_active_subscriberspercentfail({HLR.Neutral.GSM.mobility.vlr_subscribers}, {HLR.Neutral.GSM.mobility.subscribers})FLOAT%Percentage of subscribers known to this HLR that are registered in a VLRhbh
%_data_coveragegetvalidity({la_update_attempts})FLOAT%  
%_inactive_subscriberspercentfail({HLR.Neutral.GSM.mobility.subscribers} - {HLR.Neutral.GSM.mobility.vlr_subscribers}, {HLR.Neutral.GSM.mobility.subscribers})FLOAT%Percentage of subscribers known to this HLR that are not registered in a VLRhbh
%_la_update_failurepercentfail({HLR.Neutral.GSM.mobility.la_update_failures}, {HLR.Neutral.GSM.mobility.la_update_attempts})FLOAT%Percentage of failed requests to update a subscriber?s Location Areahbh
%_la_update_successpercentok({HLR.Neutral.GSM.mobility.la_update_successes}, {HLR.Neutral.GSM.mobility.la_update_attempts})FLOAT%Percentage of successful requests to update a subscriber?s Location Areahbh
%_msrn_failurepercentfail({HLR.Neutral.GSM.mobility.msrn_failures}, {HLR.Neutral.GSM.mobility.msrn_attempts})FLOAT%Percentage of failed requests for MSRN by a VLRhbh
%_msrn_successpercentok({HLR.Neutral.GSM.mobility.msrn_successes}, {HLR.Neutral.GSM.mobility.msrn_attempts})FLOAT%Percentage of successful requests for MSRN by a VLRhbh
%_vlr_insert_failurepercentfail({HLR.Neutral.GSM.mobility.vlr_insert_failures}, {HLR.Neutral.GSM.mobility.vlr_insert_attempts})FLOAT%Percentage of failed attempts to insert subscriber data in a VLRhbh
%_vlr_insert_successpercentok({HLR.Neutral.GSM.mobility.vlr_insert_successes}, {HLR.Neutral.GSM.mobility.vlr_insert_attempts})FLOAT%Percentage of successful attempts to insert subscriber data in a VLRhbh
la_update_attemptshlr_resource_access_raw.la_update_attemptsINTEGER#Requests received to update a subscriber?s Location Areahbh
la_update_failureshlr_resource_access_raw.la_update_failuresINTEGER#Failed requests to update a subscriber?s Location Areahbh
la_update_successeshlr_resource_access_raw.la_update_successesINTEGER#Successful requests to update a subscriber?s Location Areahbh
msrn_attemptshlr_resource_access_raw.msrn_attemptsINTEGER#Requests for a Mobile Subscriber Roaming Number (MSRN) by a VLRhbh
msrn_failureshlr_resource_access_raw.msrn_failuresINTEGER#Failed requests for MSRN by a VLRhbh
msrn_successeshlr_resource_access_raw.msrn_successesINTEGER#Successful requests for MSRN by a VLRhbh
roamershlr_resource_access_raw.roamersINTEGER#Subscribers roaming outside this HLR?s area or outside this PLMN (network)hbh
subscribershlr_resource_access_raw.subscribersINTEGER#Subscribers registered in this HLRhbh
vlr_insert_attemptshlr_resource_access_raw.vlr_insert_attemptsINTEGER#Attempts to insert subscriber data in a VLRhbh
vlr_insert_failureshlr_resource_access_raw.vlr_insert_failuresINTEGER#Failed attempts to insert subscriber data in a VLRhbh
vlr_insert_successeshlr_resource_access_raw.vlr_insert_successesINTEGER#Successful attempts to insert subscriber data in a VLRhbh
vlr_subscribershlr_resource_access_raw.vlr_subscribersINTEGER#Subscribers known to this HLR that are registered in a VLRhbh


LAC Performance Indicators

LAC.Neutral.GSM.mobility

The results of updates from or within a Location Area (LA)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({attach_updates})FLOAT%  
%_vlr_update_failurepercentfail({LAC.Neutral.GSM.mobility.vlr_update_failures}, {LAC.Neutral.GSM.mobility.vlr_update_attempts})FLOAT%Percentage of failures to update the VLR with location information about MS?s in this LAmbh
%_vlr_update_successespercentok({LAC.Neutral.GSM.mobility.vlr_update_successes}, {LAC.Neutral.GSM.mobility.vlr_update_attempts})FLOAT%Percentage of successful attempts to update the VLR with location information about MS?s in this LAmbh
attach_updateslac_resource_access_raw.attach_updatesINTEGER#Updates from IMSI Attach actionsmbh
la_updateslac_resource_access_raw.la_updatesINTEGER#Updates from MS?s changing to this LACmbh
periodic_updateslac_resource_access_raw.periodic_updatesINTEGER%Periodic updatesmbh
vlr_update_attemptslac_resource_access_raw.vlr_update_attemptsINTEGER#Attempts to update the VLR with location information about MS?s in this LAmbh
vlr_update_failureslac_resource_access_raw.vlr_update_failuresINTEGER#Failures to update the VLR with location information about MS?s in this LAmbh
vlr_update_successeslac_resource_access_raw.vlr_update_successesINTEGER#Successful attempts to update the VLR with location information about MS?s in this LAmbh


LAC.Neutral.GSM.page

The results of paging activity within a Location Area

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({pages})FLOAT%  
%_responsepercentok({LAC.Neutral.GSM.page.responses}, {LAC.Neutral.GSM.page.total_pages})FLOAT%The percentage of pages (first + subsequent) that received a responsembh
%_successpercentok({LAC.Neutral.GSM.page.responses}, {LAC.Neutral.GSM.page.pages})FLOAT%The percentage of pages (not counting repeat attempts to send the same page) that eventually received a response (possibly after re-paging)mbh
%_unresponsepercentfail({LAC.Neutral.GSM.page.unresponses}, {LAC.Neutral.GSM.page.total_pages})FLOAT%The percentage of pages (first + subsequent) that didn?t receive a responsembh
pageslac_resource_access_raw.pagesINTEGER%First attempts to page an MS within this Location Areambh
repageslac_resource_access_raw.repagesINTEGER#Attempts to re-page (after the first page in this LAC received no response)mbh
responseslac_resource_access_raw.responsesINTEGER#Responses to pagesmbh
total_pageslac_resource_access_raw.total_pagesINTEGER#Total attempts to page an MS within this Location Areambh
unresponseslac_resource_access_raw.unresponsesINTEGER#The number of paging attempts that received no response the MSmbh


MSC Performance Indicators

MSC.Neutral.GSM.call_completion

How many of the calls controlled by this MSC terminated with each of the available Completion Codes (CCs)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({completed})FLOAT%  
completedmsc_call_completion_raw.completedINTEGER#Number of calls that completed with the Completion Codembh


MSC.Neutral.GSM.call_setup

The call setup performance for calls originating or terminating at an MS in the BSS controlled by this MSC

The performance data measurements for this KPI group are recorded against the combination of MSC and Completion_Code (cc_id)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({originate_attempts})FLOAT%  
%_originate_failurepercentfail({MSC.Neutral.GSM.call_setup.originate_failures}, {MSC.Neutral.GSM.call_setup.originate_attempts})FLOAT%% Failure to assign channels for originating callsmbh
%_originate_successpercentok({MSC.Neutral.GSM.call_setup.originate_successes}, {MSC.Neutral.GSM.call_setup.originate_attempts})FLOAT%% Success to assign channels for originating callsmbh
%_terminate_failurepercentfail({MSC.Neutral.GSM.call_setup.terminate_failures}, {MSC.Neutral.GSM.call_setup.terminate_attempts})FLOAT%% Failure to assign channels for terminating callsmbh
%_terminate_successpercentok({MSC.Neutral.GSM.call_setup.terminate_successes}, {MSC.Neutral.GSM.call_setup.terminate_attempts})FLOAT%% Success to assign channels for terminating callsmbh
originate_attemptsmsc_call_setup_raw.originate_attemptsINTEGER#Channel assignment attempts for originating callsmbh
originate_failuresmsc_call_setup_raw.originate_failuresINTEGER#Failures to assign channels for originating callsmbh
originate_successesmsc_call_setup_raw.originate_successesINTEGER#Successful attempts to assign channels for originating callsmbh
terminate_attemptsmsc_call_setup_raw.terminate_attemptsINTEGER#Channel assignment attempts for terminating callsmbh
terminate_failuresmsc_call_setup_raw.terminate_failuresINTEGER#Failures to assign channels for terminating callsmbh
terminate_successesmsc_call_setup_raw.terminate_successesINTEGER#Successful attempts to assign channels for terminating callsmbh


MSC.Neutral.GSM.destination

The calls managed by an MSC to a particular destination MSC

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_answered_callspercentok({MSC.Neutral.GSM.destination.answered_calls}, {MSC.Neutral.GSM.destination.total_calls})FLOAT%Percentage of calls to the destination that were answered (Answer-Seize percentage)mbh
%_data_coveragegetvalidity({MSC.Neutral.GSM.destination.total_calls})FLOAT%Data coverage 
%_data_coveragegetvalidity({answered_calls})FLOAT%  
answered_callsmsc_call_destinations_raw.answered_callsINTEGER#Number of calls to the destination that were answeredmbh
answered_mean_holding_time({MSC.Neutral.GSM.destination.answered_traffic} * {MSC.Neutral.GSM.destination.measurement_seconds}) / {MSC.Neutral.GSM.destination.answered_calls}FLOATSecondConversational mean holding time of circuits to the destination (i.e. only counting the part of the call after it has been answered)mbh
answered_trafficmsc_call_destinations_raw.answered_trafficFLOATErlangConversational traffic to the destination (i.e. only including the part of the call after it has been answered)mbh
mean_holding_time({MSC.Neutral.GSM.destination.traffic} * {MSC.Neutral.GSM.destination.measurement_seconds}) / {MSC.Neutral.GSM.destination.total_calls}FLOATSecondMean holding time of circuits to the destinationmbh
total_callsmsc_call_destinations_raw.total_callsINTEGER#Number of calls to the destinationmbh
trafficmsc_call_destinations_raw.trafficFLOATErlangTraffic to the destination (including calls that have not been answered)mbh


MSC.Neutral.GSM.handover

The results of handovers passing through this MSC, either (a) to or from a different MSC, or (b) between two BSCs controlled by this MSC

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({MSC.Neutral.GSM.handover.interbsc_attempts})FLOAT%Data coverage 
%_data_coveragegetvalidity({incoming_intermsc_attempts})FLOAT%  
%_incoming_intermsc_failurepercentfail({MSC.Neutral.GSM.handover.incoming_intermsc_failures}, {MSC.Neutral.GSM.handover.incoming_intermsc_attempts})FLOAT%Percentage of incoming nter-MSC handovers that failedmbh
%_incoming_intermsc_successpercentok({MSC.Neutral.GSM.handover.incoming_intermsc_successes}, {MSC.Neutral.GSM.handover.incoming_intermsc_attempts})FLOAT%Percentage of incoming inter-MSC handovers that succeededmbh
%_interbsc_failurepercentfail({MSC.Neutral.GSM.handover.interbsc_failures}, {MSC.Neutral.GSM.handover.interbsc_attempts})FLOAT%Percentage of inter-BSC handovers that failedmbh
%_interbsc_successpercentok({MSC.Neutral.GSM.handover.interbsc_successes}, {MSC.Neutral.GSM.handover.interbsc_attempts})FLOAT%Percentage of inter-BSC handovers that succeededmbh
%_outgoing_intermsc_failurepercentfail({MSC.Neutral.GSM.handover.outgoing_intermsc_failures}, {MSC.Neutral.GSM.handover.outgoing_intermsc_attempts})FLOAT%Percentage of outgoing inter-MSC handovers that failedmbh
%_outgoing_intermsc_successpercentok({MSC.Neutral.GSM.handover.outgoing_intermsc_successes}, {MSC.Neutral.GSM.handover.outgoing_intermsc_attempts})FLOAT%Percentage of outgoing inter-MSC handovers that succeededmbh
incoming_intermsc_attemptsmsc_handover_results_raw.incoming_intermsc_attemptsINTEGER#Handover attempts coming in from another MSC (i.e. inter-MSC)mbh
incoming_intermsc_failuresmsc_handover_results_raw.incoming_intermsc_failuresINTEGER#Failed incoming inter-MSC handover attempts (i.e. inter-MSC)mbh
incoming_intermsc_successesmsc_handover_results_raw.incoming_intermsc_successesINTEGER#Successful incoming inter-MSC handover attempts (i.e. inter-MSC)mbh
interbsc_attemptsmsc_handover_results_raw.interbsc_attemptsINTEGER#Attempted inter-BSC handovers controlled by this MSC (i.e. intra-MSC)mbh
interbsc_failuresmsc_handover_results_raw.interbsc_failuresINTEGER#Failed inter-BSC handovers controlled by this MSC (i.e. intra-MSC)mbh
interbsc_successesmsc_handover_results_raw.interbsc_successesINTEGER#Successful inter-BSC handovers controlled by this MSC (i.e. intra-MSC)mbh
outgoing_intermsc_attemptsmsc_handover_results_raw.outgoing_intermsc_attemptsINTEGER#Handover attempts to another MSC (i.e. inter-MSC)mbh
outgoing_intermsc_failuresmsc_handover_results_raw.outgoing_intermsc_failuresINTEGER#Failed outgoing inter-MSC handover attempts (i.e. inter-MSC)mbh
outgoing_intermsc_successesmsc_handover_results_raw.outgoing_intermsc_successesINTEGER#Successful outgoing inter-MSC handover attempts (i.e. inter-MSC)mbh


MSC.Neutral.GSM.page

The Paging activity to Mobiles in the BSS controlled by this MSC

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({global_pages})FLOAT%  
%_global_responsepercentok({MSC.Neutral.GSM.page.global_responses}, {MSC.Neutral.GSM.page.total_global_pages})FLOAT%Percentage of Global page responsesmbh
%_global_unresponsepercentfail({MSC.Neutral.GSM.page.global_unresponses}, {MSC.Neutral.GSM.page.total_global_pages})FLOAT%Percentage of Global pages with no responsembh
%_local_responsepercentok({MSC.Neutral.GSM.page.local_responses}, {MSC.Neutral.GSM.page.total_local_pages})FLOAT%Percentage of Local responsesmbh
%_local_unresponsepercentfail({MSC.Neutral.GSM.page.local_unresponses}, {MSC.Neutral.GSM.page.total_local_pages})FLOAT%Percentage of Local pages with no responsembh
global_pagesmsc_resource_pages_raw.global_pagesINTEGER#First Global paging messages sentmbh
global_repagesmsc_resource_pages_raw.global_repagesINTEGER#Subsequent (repeat) Global paging messages sentmbh
global_responsesmsc_resource_pages_raw.global_responsesINTEGER#Responses to Global paging messagesmbh
global_unresponsesmsc_resource_pages_raw.global_unresponsesINTEGER#Global paging messages that received no responsembh
local_pagesmsc_resource_pages_raw.local_pagesINTEGER#First Local paging messages sentmbh
local_repagesmsc_resource_pages_raw.local_repagesINTEGER#Subsequent (repeat) Local paging messages sentmbh
local_responsesmsc_resource_pages_raw.local_responsesINTEGER#Responses to Local paging messagesmbh
local_unresponsesmsc_resource_pages_raw.local_unresponsesINTEGER#Local paging messages that received no responsembh
total_global_pagesmsc_resource_pages_raw.total_global_pagesINTEGER#First and subsequent Global paging messagesmbh
total_local_pagesmsc_resource_pages_raw.total_local_pagesINTEGER#First and subsequent Local paging messagesmbh


MSC.Neutral.GSM.services

The usage of a Supplementary Service (SS) on an MSC. These are sometimes reported by the HLR, but are associated with an MSC in this data model

The performance data measurements for this KPI group are recorded against the combination of MSC and Supplementary_Service (service_id)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({activates})FLOAT%  
activatesmsc_supplementary_services_raw.activatesINTEGER#Activations of the SSmbh
deactivatesmsc_supplementary_services_raw.deactivatesINTEGER#Deactivations of the SSmbh
interrogationsmsc_supplementary_services_raw.interrogationsINTEGER#Number of times that the SS was interrogatedmbh
invocationsmsc_supplementary_services_raw.invocationsINTEGER#Invocations of the SSmbh


MSC.Neutral.GSM.traffic.total_switched_traffic

The call-switching performance of the MSC for a all switched traffic types

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_answered_callspercentok({MSC.Neutral.GSM.traffic.total_switched_traffic.answered_calls}, {MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts})FLOAT%Percentage of calls that were answeredmbh
%_call_failurepercentfail({MSC.Neutral.GSM.traffic.total_switched_traffic.call_failures}, {MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts})FLOAT%Percentage of calls that failed (all reasons)mbh
%_call_successpercentok({MSC.Neutral.GSM.traffic.total_switched_traffic.call_successes}, {MSC.Neutral.GSM.traffic.total_switched_traffic.call_attempts})FLOAT%Percentage of calls that were set upmbh
%_data_coveragegetvalidity({MSC.Neutral.GSM.traffic.total_switched_traffic.traffic})FLOAT%Data coverage 
answered_callsgroup({MSC.Neutral.GSM.traffic.answered_calls})INTEGER#Calls that were answeredmbh
call_attemptsgroup({MSC.Neutral.GSM.traffic.call_attempts})INTEGER#Call attempts for all switched Traffic Typesmbh
call_failuresgroup({MSC.Neutral.GSM.traffic.call_failures})INTEGER#Calls that failed (all reasons)mbh
call_successesgroup({MSC.Neutral.GSM.traffic.call_successes})INTEGER#Calls that were set upmbh
external_failed_callsgroup({MSC.Neutral.GSM.traffic.external_failed_calls})INTEGER#Calls that failed due to errors beyond this entity or networkmbh
internal_failed_callsgroup({MSC.Neutral.GSM.traffic.internal_failed_calls})INTEGER#Calls that failed due to errors in this entity or networkmbh
subscriber_error_callsgroup({MSC.Neutral.GSM.traffic.subscriber_error_calls})INTEGER#Failed calls due to subscriber errormbh
trafficgroup({MSC.Neutral.GSM.traffic.traffic})FLOATErlangCircuit occupancy for all switched Traffic Typesmbh


MSC.Neutral.GSM.traffic

The call-switching performance of the MSC for a particular traffic type

The performance data measurements for this KPI group are recorded against the combination of MSC and Traffic_Type (traffic_type_id)

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_answered_callspercentok({MSC.Neutral.GSM.traffic.answered_calls}, {MSC.Neutral.GSM.traffic.call_attempts})FLOAT%Percentage of calls that were answeredmbh, mtbh
%_call_failurepercentfail({MSC.Neutral.GSM.traffic.call_failures}, {MSC.Neutral.GSM.traffic.call_attempts})FLOAT%Percentage of calls that failed (all reasons)mbh, mtbh
%_call_successpercentok({MSC.Neutral.GSM.traffic.call_successes}, {MSC.Neutral.GSM.traffic.call_attempts})FLOAT%Percentage of calls that were set upmbh, mtbh
%_data_coveragegetvalidity({MSC.Neutral.GSM.traffic.call_attempts})FLOAT%Data coverage 
%_data_coveragegetvalidity({answered_calls})FLOAT%  
answered_callsmsc_traffic_raw.answered_callsINTEGER#Calls that were answeredmbh, mtbh
call_attemptsmsc_traffic_raw.call_attemptsINTEGER#Call attempts in this Traffic Typembh, mtbh
call_failuresmsc_traffic_raw.call_failuresINTEGER#Calls that failed (all reasons)mbh, mtbh
call_successesmsc_traffic_raw.call_successesINTEGER#Calls that were set upmbh, mtbh
external_failed_callsmsc_traffic_raw.external_failed_callsINTEGER#Calls that failed due to errors beyond this entity or networkmbh, mtbh
internal_failed_callsmsc_traffic_raw.internal_failed_callsINTEGER#Calls that failed due to errors in this entity or networkmbh, mtbh
subscriber_error_callsmsc_traffic_raw.subscriber_error_callsINTEGER#Failed calls due to subscriber errormbh, mtbh
trafficmsc_traffic_raw.trafficFLOATErlangCircuit occupancy for this Traffic Typembh, mtbh


Processor Performance Indicators

Processor.Neutral.GSM.cpu

The performance (load or utilisation) of the CPU

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({load_pc})FLOAT%  
load_pcprocessor_cpu_raw.load_pcFLOAT%Percentage load of the CPU from all non-idle activities (i.e. call processing, etc.)pbh


Route_IF Performance Indicators

Route_IF.Neutral.GSM.transmission.forecast

The forecast performance of the Route

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
capacitytp_gsm_route_capacity_collect(route_if_id, ml_subst(gStartdate), tp_gsm_route_bh_traffic_end_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gGOS)", ml_property(system.property.dgos))FLOATErlangForecast capacity or critical traffic level based upon a user supplied grade of service level 
extra_circuitsnc_route.tp_gsm_route_bh_extra_circuits_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), "ml_subst(gGOS)")INTEGER#Forecast extra circuits required 
linear_exhaustion_dateDECODE((tp_gsm_route_bh_traffic_exhaustion_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL)), NULL, "will not reach exhaustion in this period","will reach exhausion on "||(tp_gsm_route_bh_traffic_exhaustion_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL)))INTEGERUnixTimeForecast linear exhaustion date for the route 
linear_regression_coefficientnc_route.tp_gsm_route_bh_traffic_forecast_growth(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression coefficient 
linear_regression_errornc_route.tp_gsm_route_bh_traffic_regression_error(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression error 
linear_traffic_growthnc_route.tp_gsm_route_bh_traffic_forecast_growth(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear traffic growth 
required_circuitsnc_route.tp_gsm_route_bh_required_circuits_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), "ml_subst(gGOS)")INTEGER#Forecast number of circuits that can deliver the specified forecast grade of service for the offered traffic 
trafficnc_route.tp_gsm_route_bh_traffic_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL)FLOATErlangForecast traffic on the route 
utilisationnc_route.tp_gsm_route_bh_utilisation_forecast_value(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL)FLOAT%Forecast utilisation 


Route_IF.Neutral.GSM.transmission

The performance of the Route as seen from this end (Interface), reported by an MSC

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_blocked_circuitspercentfail({Route_IF.Neutral.GSM.transmission.blocked_circuits}, {Route_IF.Neutral.GSM.transmission.circuits})FLOAT%Percentage of circuits that are blocked or otherwise out of servicerbh
%_bothway_answeredpercentok({Route_IF.Neutral.GSM.transmission.bothway_answered_calls}, {Route_IF.Neutral.GSM.transmission.bothway_calls})FLOAT%Percentage of calls (incoming+outgoing) that were answered (Answer-Seize percentage)rbh
%_data_coveragegetvalidity({available_circuits})FLOAT%  
%_incoming_answeredpercentok({Route_IF.Neutral.GSM.transmission.incoming_answered_calls}, {Route_IF.Neutral.GSM.transmission.incoming_calls})FLOAT%Percentage of incoming calls that were answered (Answer-Seize percentage)rbh, ribh
%_outgoing_answeredpercentok({Route_IF.Neutral.GSM.transmission.outgoing_answered_calls}, {Route_IF.Neutral.GSM.transmission.outgoing_calls})FLOAT%Percentage of outgoing calls that were answered (Answer-Seize percentage)rbh, robh
%_outgoing_congestionspercentfail({Route_IF.Neutral.GSM.transmission.outgoing_congestions}, {Route_IF.Neutral.GSM.transmission.bids})FLOAT%Percentage of outgoing calls that found all circuits busyrbh, robh
available_circuitsroute_interface_transmission_raw.available_circuitsFLOAT#Number of unblocked, in-service circuitsrbh
bidsroute_interface_transmission_raw.bidsINTEGER#The number of attempts to seize a circuit (from this end)rbh, robh
blocked_circuitsroute_interface_transmission_raw.blocked_circuitsFLOAT#Number of circuits that are blocked or otherwise out of servicerbh
bothway_answered_calls{Route_IF.Neutral.GSM.transmission.incoming_answered_calls} + {Route_IF.Neutral.GSM.transmission.outgoing_answered_calls}INTEGER#Number of incoming+outgoing calls that were answeredrbh
bothway_calls{Route_IF.Neutral.GSM.transmission.incoming_calls} + {Route_IF.Neutral.GSM.transmission.outgoing_calls}INTEGER#The number of incoming calls plus the number of outgoing callsrbh
bothway_traffic{Route_IF.Neutral.GSM.transmission.incoming_traffic} + {Route_IF.Neutral.GSM.transmission.outgoing_traffic}FLOATErlangIncoming+Outgoing traffic on the Routerbh
busy_time_pcroute_interface_transmission_raw.busy_time_pcFLOAT%The percentage of time that all circuits were busy (i.e. couldn?t accept outgoing bids)rbh
capacitycriticaltraffic({Route_IF.Neutral.GSM.transmission.circuits},ml_property(system.property.dgos))FLOATErlangThe capacity or critical traffic level based upon a user supplied grade of service levelrbh
circuitsroute_interface_transmission_raw.circuitsINTEGER#Number of circuits provisioned on the Route for incoming and or outgoing trafficrbh
extra_capacity_requiredDECODE("ml_subst(gUser)","true","true",(DECODE((tp_gsm_route_bh_required_circuits_end_value(route_if_id, tp_gsm_route_bh_traffic_end_date(route_if_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage)), "ml_subst(gGOS)", ml_property(system.property.dgos))-tp_gsm_route_bh_circuits_end_value(route_if_id, tp_gsm_route_bh_traffic_end_date(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), NULL, NULL)),0,"false","true")))INTEGERErlangForecast extra capacity required 
grade_of_servicegos({Route_IF.Neutral.GSM.transmission.available_circuits}, {Route_IF.Neutral.GSM.transmission.offered_traffic})FLOAT%The estimated Grade of Service (GoS)rbh
incoming_answered_callsroute_interface_transmission_raw.incoming_answered_callsINTEGER#Number of incoming calls that were answeredrbh, ribh
incoming_callsroute_interface_transmission_raw.incoming_callsINTEGER#The number of incoming calls started (i.e. circuit seizures from the other end)rbh, ribh
incoming_mean_holding_time({Route_IF.Neutral.GSM.transmission.incoming_traffic} * {Route_IF.Neutral.GSM.transmission.measurement_seconds}) / {Route_IF.Neutral.GSM.transmission.incoming_calls}FLOATSecondMean holding time for incoming callsrbh, ribh
incoming_trafficroute_interface_transmission_raw.incoming_trafficFLOATErlangIncoming traffic on the Routerbh, ribh
is_exhaustedDECODE(tp_gsm_route_bh_traffic_exhaustion_date(route_if_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage), "ml_subst(gGOS)", ml_property(system.property.dgos),NULL),NULL,"YES","NO")INTEGERStatusForecasting flag indicating if route is exhausted 
lost_traffic{Route_IF.Neutral.GSM.transmission.offered_traffic} - {Route_IF.Neutral.GSM.transmission.bothway_traffic}FLOATErlangThe estimated traffic lost to the routerbh
number_of_samplesnc_route.tp_gsm_route_bh_traffic_num_samples(route_if_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))INTEGER#Forecasting number of data samples 
offered_trafficofferedtraffic({Route_IF.Neutral.GSM.transmission.available_circuits}, ({Route_IF.Neutral.GSM.transmission.bothway_traffic}))FLOATErlangThe estimated traffic offered to the Routerbh
offered_utilisationpercentok({Route_IF.Neutral.GSM.transmission.offered_traffic}, {Route_IF.Neutral.GSM.transmission.circuits})FLOAT%The estimated traffic lost to the routerbh
outgoing_answered_callsroute_interface_transmission_raw.outgoing_answered_callsINTEGER#Number of outgoing calls that were answeredrbh, robh
outgoing_callsroute_interface_transmission_raw.outgoing_callsINTEGER#The number of successful bids (seizures) of a circuitrbh, robh
outgoing_congestion_timeroute_interface_transmission_raw.outgoing_congestion_timeINTEGERSecondThe total time during the measurement period that all circuits on the Route were busy (i.e. couldn?t accept outgoing bids)rbh, robh
outgoing_congestionsroute_interface_transmission_raw.outgoing_congestionsINTEGER#The number of bids that find that all circuits are busy. Such bids may either fail or overflow onto another Circuit Grouprbh, robh
outgoing_mean_holding_time({Route_IF.Neutral.GSM.transmission.outgoing_traffic} * {Route_IF.Neutral.GSM.transmission.measurement_seconds}) / {Route_IF.Neutral.GSM.transmission.outgoing_calls}FLOATSecondMean holding time for outgoing callsrbh, robh
outgoing_trafficroute_interface_transmission_raw.outgoing_trafficFLOATErlangOutgoing traffic on the Routerbh, robh
required_circuitsrequiredcircuits({Route_IF.Neutral.GSM.transmission.offered_traffic}, ml_property(system.property.dgos))INTEGER#The smallest integer number of circuits that can deliver the specified design grade of service for the offered trafficrbh
required_extra_circuits{Route_IF.Neutral.GSM.transmission.required_circuits} - {Route_IF.Neutral.GSM.transmission.circuits}INTEGER#The smallest integer number of extra circuits required that can deliver the specified design grade of service for the offered trafficrbh
traffic(route_interface_transmission_week.rbh_incoming_traffic + rbh_incoming_traffic)FLOATErlangForecasting traffic value based on weekly summary datarbh


Signalling_Link Performance Indicators

Signalling_Link.Neutral.GSM.link

The performance of an individual Signalling Link

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availablepercentok({Signalling_Link.Neutral.GSM.link.available_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the Link was availableslrbh, sltbh
%_data_coveragegetvalidity({available_time})FLOAT%  
%_local_inhibition_timepercentfail({Signalling_Link.Neutral.GSM.link.local_inhibition_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the link was inhibited due to local management actionsslrbh, sltbh
%_remote_inhibition_timepercentfail({Signalling_Link.Neutral.GSM.link.remote_inhibition_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the link was inhibited due to remote management actionsslrbh, sltbh
%_unavailablepercentfail({Signalling_Link.Neutral.GSM.link.unavailable_time}, ({Signalling_Link.Neutral.GSM.link.available_time} + {Signalling_Link.Neutral.GSM.link.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the Link was unavailableslrbh, sltbh
available_timess7_link_availability_raw.available_timeINTEGERSecondAmount of time the Link was available during the measurement periodslrbh, sltbh
changebacksss7_link_performance_raw.changebacksINTEGER#Local automatic changebacksslrbh, sltbh
changeoversss7_link_performance_raw.changeoversFLOAT#Local automatic changeoversslrbh, sltbh
congestion_lossesss7_link_utilisation_raw.congestion_lossesINTEGER#Number of congestion events that resulted in lost MSUsslrbh, sltbh
congestion_timess7_link_utilisation_raw.congestion_timeINTEGERSecondAmount of time during which the Link was congestedslrbh, sltbh
congestionsss7_link_utilisation_raw.congestionsINTEGER#Number of Link congestion indicationsslrbh, sltbh
discarded_msusss7_link_utilisation_raw.discarded_msusINTEGER#Number of MSUs that were discarded because of Link congestionslrbh, sltbh
failures_abrss7_link_performance_raw.failures_abrINTEGER#Link failures due to receipt of an abnormal FIBR or BSNRslrbh, sltbh
failures_alignmentss7_link_performance_raw.failures_alignmentINTEGER#Link failures due to alignment or proving failureslrbh, sltbh
failures_congestionss7_link_performance_raw.failures_congestionINTEGER#Link failures due to the link being congested for too longslrbh, sltbh
failures_delayss7_link_performance_raw.failures_delayINTEGER#Link failures due to excessive delay on ACKslrbh, sltbh
failures_error_ratess7_link_performance_raw.failures_error_rateINTEGER#Link failures due to an excessive error rateslrbh, sltbh
failuresss7_link_performance_raw.failuresINTEGER#Link failures (any reason)slrbh, sltbh
in_service_timess7_link_performance_raw.in_service_timeFLOATSecondThe total time the Link has been up (since last reset)slrbh, sltbh
incoming_trafficss7_link_utilisation_raw.incoming_trafficINTEGER#Incoming traffic receivedslrbh
incoming_utilisationpercentok((8 * {Signalling_Link.Neutral.GSM.link.incoming_traffic}), {Signalling_Link.Neutral.GSM.measurement_seconds} * (decode(nc_ss7_link.data_rate, null, 0, "NULL", 0, nc_ss7_link.data_rate)))FLOAT%Incoming traffic utilisation ? percentage of available incoming capacity usedslrbh
link_failure_timess7_link_availability_raw.link_failure_timeINTEGERSecondAmount of time the Link was unavailable because it had failedslrbh, sltbh
local_busy_timess7_link_availability_raw.local_busy_timeINTEGERSecondAmount of local busy timeslrbh, sltbh
local_inhibition_timess7_link_availability_raw.local_inhibition_timeINTEGERSecondAmount of time the link was inhibited due to local management actionsslrbh, sltbh
outgoing_trafficss7_link_utilisation_raw.outgoing_trafficINTEGER#Outgoing traffic sentsltbh
outgoing_utilisationpercentok((8 * {Signalling_Link.Neutral.GSM.link.outgoing_traffic}), {Signalling_Link.Neutral.GSM.measurement_seconds} * (decode(nc_ss7_link.data_rate, null, 0, "NULL", 0, nc_ss7_link.data_rate)))FLOAT%Outgoing traffic utilisation ? percentage of available outgoing capacity usedsltbh
received_msusss7_link_utilisation_raw.received_msusINTEGER#Number of Message Signal Units (MSUs) receivedslrbh
received_neg_ackss7_link_performance_raw.received_neg_ackINTEGER#Number of negative acknowledgements (ACK) receivedslrbh
received_sif_siosss7_link_utilisation_raw.received_sif_siosINTEGER#Number of SIF and SIO octets receivedslrbh
received_su_errorsss7_link_performance_raw.received_su_errorsINTEGER#Number of Signalling Units (Sus) received with errorsslrbh
remote_inhibition_timess7_link_availability_raw.remote_inhibition_timeINTEGERSecondAmount of time the link was inhibited due to remote management actionsslrbh, sltbh
remote_outage_timess7_link_availability_raw.remote_outage_timeINTEGERSecondAmount of time the Link was unavailable because of a remote Processor outageslrbh, sltbh
remote_outagesss7_link_availability_raw.remote_outagesINTEGER#Number of remote Processor outagesslrbh, sltbh
restoresss7_link_performance_raw.restoresINTEGER#Number of times the link was restoredslrbh, sltbh
retransmitted_sif_siosss7_link_utilisation_raw.retransmitted_sif_siosINTEGER#Number of SIF and SIO octets re-transmittedsltbh
transmitted_msusss7_link_utilisation_raw.transmitted_msusINTEGER#Number of Message Signal Units (MSUs) transmittedsltbh
transmitted_sif_siosss7_link_utilisation_raw.transmitted_sif_siosINTEGER#Number of SIF and SIO octets transmittedsltbh
unavailable_timess7_link_availability_raw.unavailable_timeINTEGERSecondAmount of time the Link was unavailable (for any reason)slrbh, sltbh


Signalling_LinkSet Performance Indicators

Signalling_LinkSet.Neutral.GSM.forecast

The forecast performance of a set of Signalling Links

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
capacitytp_gsm_linkset_capacity_collect(ss7_linkset_id, ml_subst(gStartdate), tp_gsm_linkset_bh_incoming_traffic_end_date(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gNMT)", ml_property(system.property.dnmt))FLOATErlangForecast maximum nominal Erlangs per linkset 
in_failure_capacitytp_gsm_linkset_in_failure_capacity_collect(ss7_linkset_id, ml_subst(gStartdate), tp_gsm_linkset_bh_incoming_traffic_end_date(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage)), ml_subst(gNumdays), "ml_subst(gNMT)", ml_property(system.property.dnmt))FLOATErlangForecast capacity for the entire linkset during design link failures 
linear_exhaustion_datenc_ss7_linkset.DECODE((tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gNMT)" ,ml_subst(gMIT),ml_subst(gLIF))), NULL, "will not reach exhaustion in this period","will reach exhausion on "||(tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage), "ml_subst(gNMT)",ml_subst(gMIT),ml_subst(gLIF))))INTEGERUnixTimeForecast linear exhaustion date 
linear_regression_coefficientnc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_forecast_growth(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression coefficient 
linear_regression_errornc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_regression_error(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Forecast linear regression error 
linear_traffic_growthnc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_forecast_growth(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))FLOAT#Froecast linear traffic growth 
trafficnc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_forecast_value(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gNumdays), ml_subst(gDataCoverage), NULL)FLOAT#Forecast traffic value 


Signalling_LinkSet.Neutral.GSM.signalling_linkset

The performance of a set of Signalling Links

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availablepercentok({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the LinkSet was availableslsrbh, slstbh
%_data_coveragegetvalidity({Signalling_LinkSet.Neutral.GSM.signalling_linkset.failures})FLOAT%Data Coverage 
%_data_coveragegetvalidity({available_time})FLOAT%  
%_unavailablepercentfail({Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the LinkSet was unavailableslsrbh, slstbh
available_timess7_linkset_raw.available_timeINTEGERSecondTime for which the LinkSet was availableslsrbh, slstbh
capacitycriticaltraffic({Signalling_LinkSet.Neutral.GSM.signalling_linkset.links}, ml_property(system.property.dnmt))FLOATErlangMaximum nominal Erlangs per linksetslsrbh, slstbh
failuresss7_linkset_raw.failuresINTEGER#Number of LinkSet failuresslsrbh, slstbh
in_failure_capacityss7_linkset_week.criticaltraffic(count_links, "ml_subst(gMIT)")FLOATErlangCapacity for the entire linkset during design link failures 
incoming_trafficgroup({Signalling_Link.Neutral.GSM.link.incoming_traffic})INTEGER#Total Incoming traffic receivedslsrbh
incoming_utilisationpercentok((8 * {Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic}), {Signalling_LinkSet.Neutral.GSM.signalling_linkset.measurement_seconds} * avg(decode(nc_ss7_linkset.data_rate, null, 0, "NULL", 0, nc_ss7_linkset.data_rate)))FLOAT%Incoming traffic utilisation ? percentage of available incoming capacity usedslsrbh
is_exhaustednc_ss7_linkset.DECODE(tp_gsm_linkset_bh_incoming_traffic_exhaustion_date(ss7_linkset_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage), "ml_subst(gNMT)",ml_subst(gMIT),ml_subst(gLIF)),NULL,"YES","NO")INTEGERStatusForecast flag indicating if linkset capacity is exhausted 
linkscount({Signalling_Link.Neutral.GSM.link.ss7_link_id})INTEGER#Number of Links in the LinkSetslsrbh, slstbh
mean_%_availablepercentok({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_available_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time}))FLOAT%Average percentage Availability of the Links in the LinkSetslsrbh, slstbh
mean_%_unavailablepercentfail({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time}, ({Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_available_time} + {Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time}))FLOAT%Average percentage Unavailability of the Links in the LinkSetslsrbh, slstbh
mean_available_timegroup({Signalling_LinkSet.Neutral.GSM.signalling_linkset.available_time})FLOATSecondAverage Link available time for all the Links in the Linksetslsrbh, slstbh
mean_incoming_traffic{Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic}/count(*)FLOAT#Average Incoming traffic received per linkslsrbh
mean_outgoing_traffic{Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic}/count(*)FLOAT#Average Outgoing traffic sent per linkslstbh
mean_unavailable_timegroup({Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time})FLOATSecondAverage Link available time for all the Links in the Linksetslsrbh, slstbh
msustp_gsm_linkset_bh_received_msus_end_value(ss7_linkset_id, tp_gsm_linkset_bh_incoming_traffic_end_date(ss7_linkset_id,ml_subst(gStartdate),ml_subst(gEnddate),ml_subst(gDataCoverage)), "ml_subst(gNMT)", ml_property(system.property.dnmt))INTEGER#Forecast number of Message Signal Units (MSUs) 
number_of_samplesnc_ss7_linkset.tp_gsm_linkset_bh_incoming_traffic_num_samples(ss7_linkset_id, ml_subst(gStartdate), ml_subst(gEnddate), ml_subst(gDataCoverage))INTEGER#Forecast number of samples 
outgoing_trafficgroup({Signalling_Link.Neutral.GSM.link.outgoing_traffic})INTEGER#Total Outgoing traffic sentslstbh
outgoing_utilisationpercentok((8 * {Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic}), {Signalling_LinkSet.Neutral.GSM.signalling_linkset.measurement_seconds} * avg(decode(nc_ss7_linkset.data_rate, null, 0, "NULL", 0, nc_ss7_linkset.data_rate)))FLOAT%Outgoing traffic utilisation ? percentage of available outgoing capacity usedslstbh
received_msusss7_link_utilisation_raw.received_msusINTEGER#Number of Message Signal Units (MSUs) receivedslsrbh
received_sif_siosss7_link_utilisation_raw.received_sif_siosINTEGER#Number of SIF and SIO octets receivedslsrbh
total_failuresgroup({Signalling_Link.Neutral.GSM.link.failures})INTEGER#Total Failures of all Links in the LinkSetslsrbh, slstbh
traffic INTEGER#Forecast total trafficslsrbh, slstbh
transmitted_msusss7_link_utilisation_raw.transmitted_msusINTEGER#Number of Message Signal Units (MSUs) transmittedslstbh
transmitted_sif_siosss7_link_utilisation_raw.transmitted_sif_siosINTEGER#Number of SIF and SIO octets transmittedslstbh
unavailable_timess7_linkset_raw.unavailable_timeINTEGERSecondTime for which the LinkSet was unavailableslsrbh, slstbh


Signalling_Point Performance Indicators

Signalling_Point.Neutral.GSM.signalling_point

The signalling network?s performance, as seen from a Signalling Point

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({adjacent_sp_inaccessible})FLOAT%  
adjacent_sp_inaccessible_timess7_point_raw.adjacent_sp_inaccessible_timeINTEGERSecondTime for which an adjacent Signalling Point was inaccessible 
adjacent_sp_inaccessibless7_point_raw.adjacent_sp_inaccessibleINTEGER#Number of times an adjacent Signalling Point became inaccessible 
discarded_msusss7_point_raw.discarded_msusINTEGER#Number of Message Signal Units (MSUs) discarded due to routing errors 
received_tfcsss7_point_raw.received_tfcsINTEGER#Number of Transfer-Control (TFC) signals received, indicating RouteSet congestion 


Signalling_RouteSet Performance Indicators

Signalling_RouteSet.Neutral.GSM.routeset

The performance of a set of Signalling Routes

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_availablepercentok({Signalling_RouteSet.Neutral.GSM.routeset.available_time}, ({Signalling_RouteSet.Neutral.GSM.routeset.available_time} + {Signalling_RouteSet.Neutral.GSM.routeset.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the RouteSet was available 
%_data_coveragegetvalidity({available_time})FLOAT%  
%_unavailablepercentfail({Signalling_RouteSet.Neutral.GSM.routeset.available_time}, ({Signalling_RouteSet.Neutral.GSM.routeset.available_time} + {Signalling_RouteSet.Neutral.GSM.routeset.unavailable_time}))FLOAT%Percentage of time (during the measurement period) that the RouteSet was unavailable 
available_timess7_routeset_raw.available_timeINTEGERSecondTime for which the RouteSet was available 
failuresss7_routeset_raw.failuresINTEGER#Number of RouteSet failures 
unavailable_timess7_routeset_raw.unavailable_timeINTEGERSecondTime for which the RouteSet was unavailable 


VLR Performance Indicators

VLR.Neutral.GSM.mobility

The Mobility management activity (e.g. Location Area updates) in the BSS controlled by this VLR

KPI NameExpressionData TypeUnitsDescriptionAdditional Summaries
%_data_coveragegetvalidity({id_request_attempts})FLOAT%  
%_id_request_failurepercentfail({VLR.Neutral.GSM.mobility.id_request_failures}, {VLR.Neutral.GSM.mobility.id_request_attempts})FLOAT%Percentage of failed identification requests to PVLRmbh, vbh
%_id_request_successpercentok({VLR.Neutral.GSM.mobility.id_request_successes}, {VLR.Neutral.GSM.mobility.id_request_attempts})FLOAT%Percentage of successful identification requests to PVLRmbh, vbh
%_imsi_attach_failurepercentfail({VLR.Neutral.GSM.mobility.imsi_attach_failures}, {VLR.Neutral.GSM.mobility.imsi_attach_attempts})FLOAT%Percentage of failed IMSI attach attemptsmbh, vbh
%_imsi_attach_successpercentok({VLR.Neutral.GSM.mobility.imsi_attach_successes}, {VLR.Neutral.GSM.mobility.imsi_attach_attempts})FLOAT%Percentage of successful IMSI attach attemptsmbh, vbh
%_lac_update_failurepercentfail({VLR.Neutral.GSM.mobility.lac_update_failures}, {VLR.Neutral.GSM.mobility.lac_update_attempts})FLOAT%Percentage of failed Location Area updatesmbh, vbh
%_lac_update_successpercentok({VLR.Neutral.GSM.mobility.lac_update_successes}, {VLR.Neutral.GSM.mobility.lac_update_attempts})FLOAT%Percentage of successful Location Area updatesmbh, vbh
%_vlr_update_failurepercentfail({VLR.Neutral.GSM.mobility.vlr_update_failures}, {VLR.Neutral.GSM.mobility.vlr_update_attempts})FLOAT%Percentage of Intra-VLR Location Area update failuresmbh, vbh
%_vlr_update_successpercentok({VLR.Neutral.GSM.mobility.vlr_update_successes}, {VLR.Neutral.GSM.mobility.vlr_update_attempts})FLOAT%Percentage of Intra-VLR Location Area update successesmbh, vbh
id_request_attemptsvlr_resource_mobility_raw.id_request_attemptsINTEGER#Identification requests to PVLRmbh, vbh
id_request_failuresvlr_resource_mobility_raw.id_request_failuresINTEGER#Failed identification requests to PVLRmbh, vbh
id_request_successesvlr_resource_mobility_raw.id_request_successesINTEGER#Successful identification requests to PVLRmbh, vbh
imsi_attach_attemptsvlr_resource_mobility_raw.imsi_attach_attemptsINTEGER#IMSI attach attemptsmbh, vbh
imsi_attach_failuresvlr_resource_mobility_raw.imsi_attach_failuresINTEGER#Failed IMSI attach attemptsmbh, vbh
imsi_attach_successesvlr_resource_mobility_raw.imsi_attach_successesINTEGER#Successful IMSI attach attemptsmbh, vbh
imsi_attach_updatesvlr_resource_mobility_raw.imsi_attach_updatesINTEGER#Updates due to IMSI attachmbh, vbh
imsi_detachesvlr_resource_mobility_raw.imsi_detachesINTEGER#IMSI detach eventsmbh, vbh
lac_update_attemptsvlr_resource_mobility_raw.lac_update_attemptsINTEGER#Location Area update attemptsmbh, vbh
lac_update_failuresvlr_resource_mobility_raw.lac_update_failuresINTEGER#Failed Location Area updatesmbh, vbh
lac_update_successesvlr_resource_mobility_raw.lac_update_successesINTEGER#Successful Location Area updatesmbh, vbh
new_la_updatesvlr_resource_mobility_raw.new_la_updatesINTEGER#Updates for a new Location Areambh, vbh
periodic_updatesvlr_resource_mobility_raw.periodic_updatesINTEGER#Periodic updatesmbh, vbh
vlr_subscribersvlr_resource_mobility_raw.vlr_subscribersINTEGER#Subscribers in this VLRmbh, vbh
vlr_update_attemptsvlr_resource_mobility_raw.vlr_update_attemptsINTEGER#Intra-VLR Location Area update attemptsmbh, vbh
vlr_update_failuresvlr_resource_mobility_raw.vlr_update_failuresINTEGER#Intra-VLR Location Area update failuresmbh, vbh
vlr_update_successesvlr_resource_mobility_raw.vlr_update_successesINTEGER#Intra-VLR Location Area update successesmbh, vbh
vlr_visitorsvlr_resource_mobility_raw.vlr_visitorsINTEGER#Visitors from other PLMNs in this VLRmbh, vbh



8. Database Schema


8.1 Hierarchy Tables

This section lists the hierarchy ("NC") tables that are included in this technology pack's database schema.

nc_hlr

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
hlr_idVARCHAR(50) [HLR] NODEID
[USHM] EXCH_ID
[ACHLR] hlr_id
region_idVARCHAR(50) [HLR] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[ACHLR] region_id
network_idVARCHAR(50) [HLR] "PLMN"
[USHM] "PLMN"
[ACHLR] network_id
timestampINTEGER 
endstampINTEGER 
vendor_idVARCHAR(50) [HLR] "Alcatel"
[USHM] "Siemens"
[ACHLR] "Nokia"
hlr_nameVARCHAR(255) [HLR] NODEID
[USHM] EXCH_ID
[ACHLR] hlr_id
hlr_versionVARCHAR(50) [ACHLR] "M13.5"
technologyVARCHAR(50) [USHM] "GSM"
[ACHLR] "GSM"


nc_lac

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
lac_idVARCHAR(50) [NLAC] Obj2 & "-" & Obj3
[TRZ] locationAreaCode
[VLR_LAC] rank
[USLM] LACID
[VLRLAC] msc_id&"-"&lac_id
msc_idVARCHAR(50) [NLAC] Obj2
[TRZ] lookup("nc_cell","msc_id",utime(START_DATE & TIME,"%d %b %Y %R"), cellIdentity)
[VLR_LAC] NODEID
[USLM] EXCH_ID
[VLRLAC] msc_id
region_idVARCHAR(50) [NLAC] "Provided by customer"
[TRZ] lookup("nc_cell","region_id",utime(START_DATE & TIME,"%d %b %Y %R"), cellIdentity)
[VLR_LAC] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[USLM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[VLRLAC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
network_idVARCHAR(50) [NLAC] "Provided by customer"
[TRZ] lookup("nc_cell","network_id",utime(START_DATE & TIME,"%d %b %Y %R"), cellIdentity)
[VLR_LAC] "PLMN"
[USLM] "PLMN"
[VLRLAC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
timestampINTEGER 
endstampINTEGER 
vendor_idVARCHAR(50) [NLAC] "Alcatel"
[TRZ] "Nortel"
[VLR_LAC] "Alcatel"
[USLM] "Siemens"
[VLRLAC] "Nokia"
lac_nameVARCHAR(255) [NLAC] Obj2 & "-" & Obj3
[TRZ] locationAreaCode
[VLR_LAC] rank
[USLM] LACID
[VLRLAC] msc_id&"-"&lac_id


nc_msc

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
msc_idVARCHAR(50) [CML_GS_GLOBAL] "MSC"&MSCID
[VLR] NODEID
[RCF_SS] NODEID
[msc_traf] NODEID
[DEST] NODEID
[DEST] EXCH_ID
[USSM] EXCH_ID
[USMM] EXCH_ID
[TC] msc_id
region_idVARCHAR(50) [CML_GS_GLOBAL] "Provided by customer"
[VLR] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[msc_traf] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[DEST] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[USSM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[USMM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[TC] region_id
network_idVARCHAR(50) [CML_GS_GLOBAL] "Provided by customer"
[VLR] "PLMN"
[msc_traf] "PLMN"
[DEST] "PLMN"
[DEST] "PLMN"
[USMM] "PLMN"
[TC] network_id
timestampINTEGER 
endstampINTEGER 
vendor_idVARCHAR(50) [CML_GS_GLOBAL] "Alcatel"
[VLR] "Alcatel"
[msc_traf] "Alcatel"
[DEST] "Alcatel"
[DEST] "Siemens"
[USMM] "Siemens"
[TC] "Nokia"
msc_versionVARCHAR(50) [CML_GS_GLOBAL] "Provided by customer"
[VLR] "R6"
[msc_traf] "R6"
[DEST] "R6"
[DEST] "SR11"
[USMM] "SR11"
[TC] "M13.5"
msc_nameVARCHAR(255) [CML_GS_GLOBAL] "Provided by customer"
[VLR] NODEID
[msc_traf] NODEID
[DEST] NODEID
[DEST] EXCH_ID
[USMM] EXCH_ID
[TC] msc_id
msc_typeVARCHAR(50) [CML_GS_GLOBAL] "Provided by customer"
[TC] "MSC"
technologyVARCHAR(50) [CML_GS_GLOBAL] "GSM"
[USMM] "GSM"
[TC] "GSM"


nc_network

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
network_idVARCHAR(50) [msc_traf] "PLMN"
[TC] network_id
timestampINTEGER 
endstampINTEGER 
network_typeVARCHAR(50) [TC] "MSC"
default_link_speedVARCHAR(50) [TC] "Populated by the customer"
network_nameVARCHAR(255) [msc_traf] "PLMN"
[TC] network_id


nc_processor

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
processor_idVARCHAR(50) [BSC] BSC &"/"& CPUTYPE &"-"& ID
[CPUE] BSC &"/"& CPUTYPE &"-"& ID
[dproc_statistics] nodeid&"/"&procid
[gproc_statistics] sitename&"/"&procid
[PROC] NODEID&"/"&rank
[P_NBSC_LOAD] NODEID & "/" & OBJ_NAME & "-" & OBJ_INDEX
[PROC] if MEASURE_ID="CPXX" then EXCH_ID&"-"&NODEID else if MEASURE_ID="GPXX" then EXCH_ID&"-"&LTG else EXCH_ID
[CLOM] msc_id &"-"& unit_id
[CLOH] hlr_id &"-"& unit_id
node_idVARCHAR(50) [CPUE] BSC
[dproc_statistics] nodeid
[PROC] NODEID
[P_NBSC_LOAD] NODEID
[PROC] EXCH_ID
[CLOM] msc_id
[CLOH] hlr_id
region_idVARCHAR(50) [CPUE] lookup("nc_bsc","region_id",utime(START_DATE & TIME,"%d %b %Y %R"), BSC)
[dproc_statistics] lookup("nc_bsc","region_id",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid)
[PROC] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[P_NBSC_LOAD] REGION
[PROC] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[CLOM] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
[CLOH] lookup("nc_hlr","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),hlr_id)
network_idVARCHAR(50) [CPUE] lookup("nc_bsc","network_id",utime(START_DATE & TIME,"%d %b %Y %R"), BSC)
[dproc_statistics] lookup("nc_bsc","network_id",utime(STRINGYMD0_0 & start ,"%d %b %Y %R"), nodeid)
[PROC] "PLMN"
[P_NBSC_LOAD] NETWORK
[PROC] "PLMN"
[CLOM] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
[CLOH] lookup("nc_hlr","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),hlr_id)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [CPUE] bscName
[dproc_statistics] lookup("nc_bsc","bsc_name",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid)
[PROC] NODEID
[P_NBSC_LOAD] NODEID
[PROC] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[CLOM] msc_id
[CLOH] hlr_id
node_typeVARCHAR(50) [CPUE] "BSC"
[dproc_statistics] "DataPrc"
[gproc_statistics] "GenericPrc"
[PROC] "HLR"
[P_NBSC_LOAD] "BSC"
[PROC] "MSC"
[CLOM] "MSC"
[CLOH] "HLR"
processor_nameVARCHAR(255) [CPUE] BSC &"/"& CPUTYPE &"-"& ID
[dproc_statistics] nodeid&"/"&procid
[PROC] NODEID&"/"&rank
[P_NBSC_LOAD] NODEID & "/" & OBJ_NAME & "-" & OBJ_INDEX
[PROC] if MEASURE_ID="CPXX" then EXCH_ID&"-"&NODEID else if MEASURE_ID="GPXX" then EXCH_ID&"-"&LTG else EXCH_ID
[CLOM] msc_id &"-"& unit_id
[CLOH] hlr_id &"-"& unit_id
processor_typeVARCHAR(50) [CPUE] "CPUE"
[CLOM] "computer_unit"
[CLOH] "computer_unit"
technologyVARCHAR(50) [CPUE] "GSM"
[CLOM] "GSM"
[CLOH] "GSM"
vendorVARCHAR(50) [CPUE] "Nortel"
[CLOM] "Nokia"
[CLOH] "Nokia"
processor_versionVARCHAR(50) [CPUE] Manually populated by customer or "V15"
[CLOM] "M13.5"
[CLOH] "M13.5"


nc_region

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
region_idVARCHAR(50) [msc_traf] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[TC] region_id
network_idVARCHAR(50) [msc_traf] "PLMN"
[TC] network_id
timestampINTEGER 
endstampINTEGER 
region_nameVARCHAR(255) [msc_traf] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[TC] region_id


nc_route

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
route_if_idVARCHAR(50) [TRUNKGROUP] "MSC"&MSCID&"-"&OBJECTNAME
[class_f] NODEID&"/"&routeid
[TGRP] EXCH_ID & "-" & TGNO
[CGR] msc_id&"/"&cgr_id
source_idVARCHAR(50) [TRUNKGROUP] "MSC"&MSCID
[class_f] NODEID
[TGRP] EXCH_ID
[CGR] msc_id
target_idVARCHAR(50) [TRUNKGROUP] OBJECTNAME
[class_f] routeid
region_idVARCHAR(50) [TRUNKGROUP] lookup("nc_msc","region_id",utime(START_DATE & START_TIME,"%d %b %Y %R"),"MSC"&MSCID)
[class_f] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[TGRP] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[CGR] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
network_idVARCHAR(50) [TRUNKGROUP] "PLMN"
[class_f] "PLMN"
[TGRP] "PLMN"
[CGR] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
timestampINTEGER 
endstampINTEGER 
source_nameVARCHAR(255) [TRUNKGROUP] "MSC"&MSCID
[TGRP] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[CGR] msc_id
target_nameVARCHAR(255) [TRUNKGROUP] OBJECTNAME
source_typeVARCHAR(50) [TRUNKGROUP] "MSC"
[TGRP] "MSC"
[CGR] "MSC"
target_typeVARCHAR(50) [TRUNKGROUP] "Provided by customer"
route_typeVARCHAR(50) [TRUNKGROUP] "Provided by customer"
[class_f] routetype
route_directionVARCHAR(50) [TRUNKGROUP] "Provided by customer"
[class_f] if dir = "M" then "BothWay" else if dir = "A" then "Incoming" else "Outgoing"
[TGRP] if OPMODE = "OG" then "Outgoing" else if OPMODE = "IC" then "Incoming" else if OPMODE = "B" then "BothWay" else "None"
[CGR] if CGRDIR_ID = 2 then "Outgoing" else if CGRDIR_ID = 1 then "Incoming" else if CGRDIR_ID = 3 then "Bothway" else "Unknown"
is_trunkVARCHAR(50) [TRUNKGROUP] "True"
[class_f] "True"
[TGRP] "True"
[CGR] "TRUE"
is_poiVARCHAR(50) [TRUNKGROUP] "True"
[class_f] "True"
[TGRP] "True"
[CGR] "TRUE"
route_if_nameVARCHAR(255) [TRUNKGROUP] "MSC"&MSCID&"-"&OBJECTNAME
[class_f] NODEID&"/"&routeid
[TGRP] EXCH_ID&"-"&TGNO
[CGR] msc_id&"/"&cgr_id
source_technologyVARCHAR(50) [TRUNKGROUP] "Provided by customer"
[TGRP] "MSC"
[CGR] "GSM"
target_technologyVARCHAR(50) [TRUNKGROUP] "Provided by customer"
[CGR] "GSM"


nc_ss7_link

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_link_idVARCHAR(50) [SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer
[mtl_statistics] nodeid&"/"&linkid
[SIGN] NODEID&"/"&linksetid&"/"&linkcode
[sgnl_load] NODEID&"/"&linksetid&"/"&linkcode
[C7GOC7LL] moi & "-" & Linksetname
[MTPMSC] msc_id &"-"& sln_id
ss7_linkset_idVARCHAR(50) [mtl_statistics] "TBD"
[SIGN] NODEID&"/"&linksetid
[sgnl_load] NODEID&"/"&linksetid
[C7GOC7LL] moi0&"."&moi1&"."&moi2
[MTPMSC] msc_id &"-"& snet_id &"-"& spc_id &"-"& slsn_id
ss7_point_idVARCHAR(50) [SIGN] NODEID
[sgnl_load] NODEID
[C7GOC7LL] lookup("nc_ss7_routeset","ss7_point_id", utime(START_DATE & TIME,"%d %b %y %R"), EXCH_ID)
[MTPMSC] msc_id &"-"& snet_id &"-"& spc_id
node_idVARCHAR(50) [mtl_statistics] nodeid
[SIGN] NODEID
[sgnl_load] NODEID
[C7GOC7LL] EXCH_ID
[MTPMSC] msc_id
region_idVARCHAR(50) [mtl_statistics] lookup("nc_bsc","region_id",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid)
[SIGN] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[sgnl_load] lookup("nc_msc","region_id", utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[C7GOC7LL] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-duration, moi0)
[MTPMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
network_idVARCHAR(50) [mtl_statistics] lookup("nc_bsc","network_id",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid)
[SIGN] "PLMN"
[sgnl_load] "PLMN"
[MTPMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [mtl_statistics] lookup("nc_bsc","bsc_name",utime(STRINGYMD0_0 & start,"%d %b %Y %R"), nodeid)
[SIGN] NODEID
[sgnl_load] NODEID
[C7GOC7LL] EXCH_ID
[MTPMSC] msc_id
node_typeVARCHAR(50) [mtl_statistics] "BSC"
[SIGN] "HLR"
[sgnl_load] "MSC"
[MTPMSC] "MSC"
adjacent_node_idVARCHAR(50) 
data_rateVARCHAR(50) [mtl_statistics] "CUSTOMER_TO_DEFINE"
[sgnl_load] 65536
[MTPMSC] M210B1C2
ss7_link_nameVARCHAR(255) [mtl_statistics] nodeid&"/"&linkid
[SIGN] NODEID&"/"&linksetid&"/"&linkcode
[sgnl_load] NODEID&"/"&linksetid&"/"&linkcode
[C7GOC7LL] moi & "-" & Linksetname
[MTPMSC] msc_id &"-"& sln_id
technologyVARCHAR(50) [MTPMSC] "GSM"


nc_ss7_linkset

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_linkset_idVARCHAR(50) [C7LS] EXCH_ID & "-" & LSNAM
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id
ss7_point_idVARCHAR(50) [C7LS] lookup("nc_ss7_routeset","ss7_point_id", utime(START_DATE & TIME,"%d %b %y %R"), EXCH_ID)
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id
node_idVARCHAR(50) [C7LS] EXCH_ID
[AVANMSC] msc_id
region_idVARCHAR(50) [C7LS] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R"), EXCH_ID)
[AVANMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
network_idVARCHAR(50) [C7LS] "PLMN"
[AVANMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7LS] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[AVANMSC] msc_id
node_typeVARCHAR(50) [C7LS] "MSC"
[AVANMSC] "MSC"
adjacent_node_idVARCHAR(50) [AVANMSC] "Populated by the customer"
data_rateVARCHAR(50) [AVANMSC] "Populated by the customer"
designed_link_failuresVARCHAR(50) [AVANMSC] "Populated by the customer"
ss7_linkset_nameVARCHAR(255) [C7LS] EXCH_ID & "-" & LSNAM
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id
technologyVARCHAR(50) [C7LS] "GSM"
[AVANMSC] "GSM"


nc_ss7_point

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_point_idVARCHAR(50) [C7MU] MOI
[STAMSC] msc_id&"-"&snet_id&"-"&spc_id
node_idVARCHAR(50) [C7MU] MOI0
[STAMSC] msc_id
region_idVARCHAR(50) [C7MU] lookup("nc_msc","region_id",utime(START_DATE & TIME,"%d %b %y %R"), moi0)
[STAMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
network_idVARCHAR(50) [C7MU] "PLMN"
[STAMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7MU] lookup("nc_msc","msc_name",utime(START_DATE & TIME,"%d %b %y %R"), moi0)
[STAMSC] msc_id
node_typeVARCHAR(50) [C7MU] "MSC"
[STAMSC] "MSC"
ss7_point_nameVARCHAR(255) [C7MU] MOI
[STAMSC] msc_id&"-"&snet_id&"-"&spc_id
adjacent_node_idVARCHAR(50) 
technologyVARCHAR(50) [C7MU] "GSM"
[STAMSC] "GSM"


nc_ss7_routeset

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
ss7_routeset_idVARCHAR(50) [C7RS] MOI
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id
ss7_point_idVARCHAR(50) [C7RS] MOI0 & "." & MOI1
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id
node_idVARCHAR(50) [C7RS] MOI0
[AVANMSC] msc_id
region_idVARCHAR(50) [C7RS] lookup("nc_msc","region_id",utime(START_DATE & TIME,"%d %b %y %R"), moi0)
[AVANMSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"), msc_id)
network_idVARCHAR(50) [C7RS] "PLMN"
[AVANMSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"), msc_id)
timestampINTEGER 
endstampINTEGER 
node_nameVARCHAR(255) [C7RS] lookup("nc_msc","msc_name", utime(START_DATE & TIME,"%d %b %y %R")-duration, moi0)
[AVANMSC] lookup("nc_msc","msc_name",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"), msc_id)
node_typeVARCHAR(50) [C7RS] "MSC"
[AVANMSC] "MSC"
adjacent_node_idVARCHAR(50) 
ss7_routeset_nameVARCHAR(255) [C7RS] MOI
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id
technologyVARCHAR(50) [C7RS] "GSM"
[AVANMSC] "GSM"


nc_vlr

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
vlr_idVARCHAR(50) [GS_RESULT] "MSC"&MSCID
[VLR] NODEID
[VLR_GLOBAL] if RANK=NULL then RANK1&"/"&RANK2 else RANK
[USVM] EXCH_ID
[VLR1MSC] msc_id
msc_idVARCHAR(50) [GS_RESULT] "MSC"&MSCID
[VLR] NODEID
[USVM] EXCH_ID
[VLR1MSC] msc_id
region_idVARCHAR(50) [GS_RESULT] lookup("nc_msc","region_id",utime(START_DATE & START_TIME,"%d %b %Y %R"),"MSC"&MSCID)
[VLR] lookup("nc_msc","region_id",utime(EndDate & EndTime,"%d %b %y %R") - Duration, NODEID)
[USVM] lookup("nc_msc","region_id", utime(START_DATE & TIME,"%d %b %y %R")-(DURATION*60), EXCH_ID)
[VLR1MSC] lookup("nc_msc","region_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
network_idVARCHAR(50) [GS_RESULT] "PLMN"
[VLR] "PLMN"
[USVM] "PLMN"
[VLR1MSC] lookup("nc_msc","network_id",utime(StartDate & " " & StartTime,"%Y-%m-%d %R"),msc_id)
timestampINTEGER 
endstampINTEGER 
vendor_idVARCHAR(50) [GS_RESULT] "Alcatel"
[VLR] "Alcatel"
[VLR1MSC] "Nokia"
vlr_nameVARCHAR(255) [GS_RESULT] "Provided by customer"
[VLR] NODEID
[USVM] EXCH_ID
[VLR1MSC] msc_id
vlr_versionVARCHAR(50) [GS_RESULT] "Provided by customer"
[USVM] "SR11"
[VLR1MSC] "M13.5"
technologyVARCHAR(50) [GS_RESULT] "GSM"
[USVM] "GSM"
[VLR1MSC] "GSM"


nc_msc_completion_codes

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
completion_code_idVARCHAR(50) [CCMEA] cc_id
timestampINTEGER 
endstampINTEGER 
completion_code_nameVARCHAR(255) [CCMEA] cc_id
completion_code_typeVARCHAR(50) 
completion_code_descriptionVARCHAR(255) 


nc_msc_supplementary_services

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
supplementary_service_idVARCHAR(50) [UNKNOWN] "MSC"&MSCID&"-"&SSID
[RCF_SS] NODEID&"/"&rank
[SERVI] service_id
timestampINTEGER 
endstampINTEGER 
supplementary_service_nameVARCHAR(255) [UNKNOWN] "MSC"&MSCID&"-"&SSID
[RCF_SS] NODEID&"/"&rank
[SERVI] service_id


nc_msc_traffic_types

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
traffic_type_idVARCHAR(50) [MSC_TRAF] TRAFFTYPE
[ACCU_BSC] "TTYPE"
[msc_traf] ttype
[TRAFF] TY
[TC] TCAT_ID
timestampINTEGER 
endstampINTEGER 
directionVARCHAR(50) [MSC_TRAF] "Provided by customer"
[ACCU_BSC] if TTYPE = "ALORG" then "Originating" else if TTYPE = "ALTER" then "Terminating" else if TTYPE = "MTER" then "Terminating" else if TTYPE = "MGAT" then "Gateway" else TTYPE
[msc_traf] if ttype = "ALOUT" then "Outgoing" else if ttype = "ALINC" then "Incoming" else if ttype = "ALTRA" then "Transit" else if ttype = "ALMISC" then "Miscellaneous" else if ttype = "ALTOT" then "Total" else if ttype = "ALINCT" then "Incoming Terminating" else if ttype = "ALORGO" then "Originating Outgoing" else if ttype = "ALINT" then "Internal" else if ttype = "ALORG" then "Originating" else if ttype = "ALTER" then "Terminating" else ttype
[TRAFF] if TY = "MORTR" then "Originating" else if TY = "MICTR" then "Incoming" else if TY = "MTER" then "Terminating " else if TY = "MOUT_PLMN" then "Outgoing" else if TY = "MOUT_NOT_PLMN" then "Originating outgoing" else if TY = "MTRAN" then "Transit" else TY
is_switchedVARCHAR(50) [MSC_TRAF] "Provided by customer"
[ACCU_BSC] "false"
[msc_traf] if ttype = "ALTOT" then "true" else "false"
[TRAFF] if TY = "MICTR" then "TRUE" else if TY = "MORTR" then "TRUE" else "FALSE"
traffic_type_nameVARCHAR(255) [MSC_TRAF] TRAFFTYPE
[ACCU_BSC] "TTYPE"
[msc_traf] ttype
[TRAFF] if TY = "MTRAN" then "Transit" else if TY = "MOPLMN" then "Originating Outgoing" else if TY = "MTER" then "Terminating" else if TY = "MNPLMN" then "Terminating Incoming" else if TY = "MORTR" then "Originating" else if TY = "MICTR" then "Incoming" else TY
[TC] TCAT_ID


nc_hlr_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
hlr_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_lac_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
lac_idVARCHAR(50)n/a
msc_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_msc_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
msc_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_network_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
network_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_processor_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
processor_idVARCHAR(50)n/a
node_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_region_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
region_idVARCHAR(50)n/a
network_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_route_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
route_if_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_link_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_link_idVARCHAR(50)n/a
ss7_linkset_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_linkset_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_linkset_idVARCHAR(50)n/a
ss7_point_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_point_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_point_idVARCHAR(50)n/a
node_idVARCHAR(50)n/a
region_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_ss7_routeset_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
ss7_routeset_idVARCHAR(50)n/a
ss7_point_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_vlr_sec

Column NameData TypeLoader Block/Mapping
nc_idSERIALn/a
vlr_idVARCHAR(50)n/a
msc_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


8.2 Raw Performance Tables

This section lists the performance tables that are included in this technology pack's database schema, grouped by the network object to which they relate, as follows:


Raw HLR Tables

hlr_resource_access_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
hlr_idVARCHAR(50) [HLR] NODEID
[USHM] EXCH_ID
[ACHHLR] hlr_id
[HL1HLR] hlr_id
dayINTEGER 
subscribersVARCOUNTER [HLR] C18801
[USHM] SUB_REGISTERED_IN_HLR
vlr_subscribersVARCOUNTER [HL1HLR] M84B9C4
roamersVARCOUNTER [USHM] OWN_SUB_ROAM_IN_FOREIGN_PLMN
[HL1HLR] M83B5C1
la_update_attemptsVARCOUNTER [HLR] C10404
[USHM] RECVD_UPD_LOC_MSG_VLR_HPLMN+RECVD_UPD_LOC_MSG_VLR_VPLMN
[HL1HLR] M83B5C5 + M83B5C6
la_update_successesVARCOUNTER [HLR] C10405
[USHM] (RECVD_UPD_LOC_MSG_VLR_HPLMN+RECVD_UPD_LOC_MSG_VLR_VPLMN)-(UNS_UPLOCMSG_VLR_HPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_HPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_HPLMN_IRR_SYS+UNS_UPLOCMSG_VLR_VPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_VPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_VPLMN_IRR_SYS+UNS_LOC_UPD_OVL)
[HL1HLR] M83B5C5
la_update_failuresVARCOUNTER [HLR] C10404-C10405
[USHM] UNS_UPLOCMSG_VLR_HPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_HPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_HPLMN_IRR_SYS+UNS_UPLOCMSG_VLR_VPLMN_SUB_BEH+UNS_UPLOCMSG_VLR_VPLMN_IRR_VLR+UNS_UPLOCMSG_VLR_VPLMN_IRR_SYS+UNS_LOC_UPD_OVL
[HL1HLR] M83B5C6
msrn_attemptsVARCOUNTER [HLR] C10603
[USHM] SND_PROV_MSRN
msrn_successesVARCOUNTER [HLR] C10604
[USHM] RECVD_MSRN
msrn_failuresVARCOUNTER [HLR] C10603-C10604
[USHM] SND_PROV_MSRN-RECVD_MSRN
vlr_insert_attemptsVARCOUNTER [HLR] C10406
[USHM] SND_INS_SUBDT_MSG+SND_INS_SUBDT_MSG_SUB_ADMIN+SENT_INSERT_MS_DATA_AFTER_SCI
vlr_insert_successesVARCOUNTER [HLR] C10407
[USHM] (SND_INS_SUBDT_MSG+SND_INS_SUBDT_MSG_SUB_ADMIN+SENT_INSERT_MS_DATA_AFTER_SCI)-(UNS_INS_SUBDT_MSG+UNS_INS_SUBDT_MSG_SUB_ADMIN+UNS_RESP_INS_SUBDT_SS)
vlr_insert_failuresVARCOUNTER [HLR] C10406-C10407
[USHM] UNS_INS_SUBDT_MSG+UNS_INS_SUBDT_MSG_SUB_ADMIN+UNS_RESP_INS_SUBDT_SS
auc_attemptsVARCOUNTER [USHM] TRIPLES_REQUESTED_BY_HLR
auc_successesVARCOUNTER [USHM] TRIPLES_RETURNED_TO_HLR
auc_failuresVARCOUNTER [USHM] TRIPLES_REQUESTED_BY_HLR-TRIPLES_RETURNED_TO_HLR
auth_attemptsVARCOUNTER [HLR] C11001
[USHM] RECVD_SEND_PARAM_AR
[ACHHLR] M87B3C6
auth_successesVARCOUNTER [HLR] C11001-C11002
[USHM] RECVD_SEND_PARAM_AR-UNS_SND_PARAM_AR
[ACHHLR] M87B3C7
auth_failuresVARCOUNTER [HLR] C11002
[USHM] UNS_SND_PARAM_AR
[ACHHLR] M87B3C6 - M87B3C7
auth_reusedVARCOUNTER [HLR] C14001
[USHM] REUSED_TRIPLES


Raw LAC Tables

lac_resource_access_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
lac_idVARCHAR(50) [NLAC] Obj2 & "-" & Obj3
[VLR_LAC] rank
[USLM] LACID
dayINTEGER 
attach_updatesVARCOUNTER 
la_updatesVARCOUNTER [NLAC] LA_LUR_LA
pagesVARCOUNTER [NLAC] PA_MTER_LA
[USLM] PAG_PROC
periodic_updatesVARCOUNTER 
repagesVARCOUNTER [NLAC] PA_RETRY_LA
[USLM] RETRY_PAG
responsesVARCOUNTER [NLAC] PA_RESP_LA
[USLM] SUCC_PAG
total_pagesVARCOUNTER [NLAC] PA_MTER_LA + if (PA_RETRY_LA=NULL then 0 else PA_RETRY_LA)
[USLM] PAG_PROC+RETRY_PAG
unresponsesVARCOUNTER [USLM] (PAG_PROC+RETRY_PAG)-SUCC_PAG
vlr_update_attemptsVARCOUNTER [VLR_LAC] C20401 + C20403
[USLM] LOC_UPD
vlr_update_failuresVARCOUNTER [VLR_LAC] C20404
vlr_update_successesVARCOUNTER [VLR_LAC] C20401 + C20403 - C20404


Raw MSC Tables

msc_call_completion_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [CCMEA] msc_id
completion_code_idVARCHAR(50) [CCMEA] cc_id
dayINTEGER 
completedVARCOUNTER [CCMEA] M131B2C1 + M131B2C2 + M131B2C3


msc_call_destinations_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [NTDC] "MSC"&MSCID
[DEST] NODEID
[DEST] EXCH_ID
[NUMD] msc_id
destination_idVARCHAR(50) [NTDC] "MSC"&MSCID&"-"&DECO
[DEST] NODEID&"/"&deco
[DEST] EXCH_ID&"-"&DECO
[NUMD] dest_id &"-"&desttype_id&"-"&destdir_id
dayINTEGER 
answered_callsVARCOUNTER [NTDC] CS_OG_TDC
[DEST] round((calls \* effsub /100),0)
[DEST] CCS_WITH_ANSWER
[NUMD] M17B2C7
answered_trafficVARCOUNTER [DEST] if DURATION=0 then NULL else round(TV_WITH_ANSWER/(DURATION*60),2)
total_callsVARCOUNTER [NTDC] CC_OG_TDC
[DEST] calls
[DEST] CC
[NUMD] M17B2C5
trafficVARCOUNTER [NTDC] round(TV_OG_TDC,2)
[DEST] if DURATION=0 then NULL else round(TV/(DURATION*60*10),2)
[NUMD] M17B2C11


msc_call_setup_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [CML_GS_GLOBAL] "MSC"&MSCID
[VLR] NODEID
[USMM] EXCH_ID
dayINTEGER 
originate_attemptsVARCOUNTER [CML_GS_GLOBAL] CA_TCHRQ_MORTR
[VLR] C31505
[USMM] GEN_TRAFF_CHAN_REQ_MORTR
originate_failuresVARCOUNTER [CML_GS_GLOBAL] CA_TCHRQ_MORTR - CC_TCA_MORTR
[VLR] C31505 - C31506
[USMM] GEN_TRAFF_CHAN_REQ_MORTR-CALL_TCH_ALLOCATION_MORTR
originate_successesVARCOUNTER [CML_GS_GLOBAL] CC_TCA_MORTR
[VLR] C31506
[USMM] CALL_TCH_ALLOCATION_MORTR
terminate_attemptsVARCOUNTER [CML_GS_GLOBAL] CA_MTER
[VLR] C31507
[USMM] GEN_TRAFF_CHAN_REQ_MTER
terminate_failuresVARCOUNTER [CML_GS_GLOBAL] CA_MTER - CC_TCA_MTER
[VLR] C31507 - C31508
[USMM] GEN_TRAFF_CHAN_REQ_MTER-CALL_TCH_ALLOCATION_MTER
terminate_successesVARCOUNTER [CML_GS_GLOBAL] CC_TCA_MTER
[VLR] C31508
[USMM] CALL_TCH_ALLOCATION_MTER


msc_handover_results_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [HANDOVERS] "MSC"&MSCID
[VLR] NODEID
[USMM] EXCH_ID
[HO1] msc_id
dayINTEGER 
incoming_intermsc_attemptsVARCOUNTER [HANDOVERS] HA_REQ_INC_MSCB
[VLR] C30715 + C30718
[USMM] HANDOVER_MSC_MSC_IC_ATTEMPTS+SUBSEQ_MSC_MSC_HO_MSCB
[HO1] M81B3C15 + M81B3C16
incoming_intermsc_failuresVARCOUNTER [HANDOVERS] HL_RES_OWN
[VLR] C30715 + C30718 - C30719
[USMM] HANDOVER_MSC_MSC_IC_ATTEMPTS+SUBSEQ_MSC_MSC_HO_MSCB-SUCC_MSC_MSC_HO_MSCB-SUCC_SUBSEQ_MSC_MSC_HO_MSCB
[HO1] M81B3C16
incoming_intermsc_successesVARCOUNTER [HANDOVERS] HS_INC_MSCB
[VLR] C30719
[USMM] SUCC_MSC_MSC_HO_MSCB+SUCC_SUBSEQ_MSC_MSC_HO_MSCB
[HO1] M81B3C15
interbsc_attemptsVARCOUNTER [VLR] C30716 + TNORMAL_C30736 + TNOTNORMAL_C30736
[USMM] HANDOVER_ATTEMPTS-HANDOVER_MSC_MSC_OG_ATTEMPTS-SUBSEQ_MSC_MSC_HO_MSCB
[HO1] M81B3C6 + M81B3C5
interbsc_failuresVARCOUNTER [VLR] C30716 + TNOTNORMAL_C30736 - C30717
[USMM] HANDOVER_ATTEMPTS-HANDOVER_MSC_MSC_OG_ATTEMPTS-SUBSEQ_MSC_MSC_HO_MSCB-SUCC_COMPLETED_HO-SUCC_HO_SEC_MSC_MSC_HO_MSCB
[HO1] M81B3C6
interbsc_successesVARCOUNTER [HANDOVERS] HS_INTRA
[VLR] C30717 + TNORMAL_C30736
[USMM] SUCC_COMPLETED_HO+SUCC_HO_SEC_MSC_MSC_HO_MSCB
[HO1] M81B3C5
outgoing_intermsc_attemptsVARCOUNTER [HANDOVERS] HA_REQ_OG_MSCA
[VLR] C30713 + C30722
[USMM] HANDOVER_MSC_MSC_OG_ATTEMPTS+SUBSEQ_MSC_MSC_MSCA
[HO1] M81B3C23 + M81B3C24
outgoing_intermsc_failuresVARCOUNTER [HANDOVERS] HL_ERR_OTH
[VLR] C30713 + C30722 - C30714 - C30723
[USMM] HANDOVER_MSC_MSC_OG_ATTEMPTS+SUBSEQ_MSC_MSC_HO_MSCA-SUCC_MSC_MSC_HO_MSCA
[HO1] M81B3C24
outgoing_intermsc_successesVARCOUNTER [HANDOVERS] HS_OG_MSCA
[VLR] C30714 + C30723
[USMM] SUCC_MSC_MSC_HO_MSCA
[HO1] M81B3C23


msc_resource_pages_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [CML_GS_GLOBAL] "MSC"&MSCID
[VLR] NODEID
[USMM] EXCH_ID
[VLR1MSC] msc_id
dayINTEGER 
global_pagesVARCOUNTER [VLR] C20304
[VLR1MSC] M82B4C8
global_repagesVARCOUNTER 
global_responsesVARCOUNTER 
global_unresponsesVARCOUNTER 
local_pagesVARCOUNTER [CML_GS_GLOBAL] PA_START
[VLR] C20303
[USMM] STARTED_PAGING_PROC
[VLR1MSC] M82B4C7
local_repagesVARCOUNTER [CML_GS_GLOBAL] PA_RETRY
[VLR] C30301
[USMM] STARTED_PAGING_RETRY_PROC
[VLR1MSC] M82B4C7-M82B4C3
local_responsesVARCOUNTER [CML_GS_GLOBAL] PA_START+PA_RETRY-PL_TIMEOUT
[VLR] C20305
[USMM] RECEIVED_PAG_RESP
local_unresponsesVARCOUNTER [CML_GS_GLOBAL] PL_TIMEOUT
[VLR] C20303 + C30301 - C20305
[USMM] STARTED_PAGING_PROC+STARTED_PAGING_RETRY_PROC-RECEIVED_PAG_RESP
total_global_pagesVARCOUNTER 
total_local_pagesVARCOUNTER [CML_GS_GLOBAL] PA_START + PA_RETRY
[VLR] C20303 + C30301
[USMM] STARTED_PAGING_PROC+STARTED_PAGING_RETRY_PROC
[VLR1MSC] M82B4C7


msc_supplementary_services_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [CML_GS_GLOBAL] "MSC"&MSCID
[RCF_SS] NODEID
[USSM] EXCH_ID
[SERVI] msc_id
supplementary_service_idVARCHAR(50) [CML_GS_GLOBAL] "MSC"&MSCID
[RCF_SS] NODEID&"/"&rank
[USSM] EXCH_ID & "-" & SSID
[SERVI] service_id
dayINTEGER 
activatesVARCOUNTER [CML_GS_GLOBAL] MT_ASS_ALL
[SERVI] M128B2C3
deactivatesVARCOUNTER [CML_GS_GLOBAL] MT_DSS_ALL
[SERVI] M128B2C4
interrogationsVARCOUNTER [CML_GS_GLOBAL] SS_QA_VLR
[RCF_SS] if C23001 >= 0 then C23001 else NULL
[SERVI] M128B2C5
invocationsVARCOUNTER [CML_GS_GLOBAL] SA_CF_NREA_G+SA_CF_NREA_V+SS_INVOC_RHC
[RCF_SS] if C33002 >= 0 then C33002 else NULL
[USSM] if SSID="CFUN" then INV_SERV_CALL_FWD_UNCOND_CFUN else if SSID="CFBU" then INVOC_SERV_CALL_FWD_MSB_CFBU else if SSID="CFNR" then INVOC_SERV_CALL_FWD_NR_CFNR else if SSID="CFIN" then INVOC_SERV_CALL_FWD_MSNR_CFIN else if SSID="AOCC" then INVOC_SERV_AOC_CHARGE_AOCC else if SSID="AOCI" then INVOC_SERV_AOC_INFO_AOCI else if SSID="MULTIPARTY" then INVOC_SERV_AOC_MULTIPARTY else if SSID="CHOL" then INVOC_SERV_PUT_HOLD_CHOL else if SSID="CRETRIEVE" then INVOC_SERV_RTRV_HOLD_CRETRIEVE else if SSID="CLIP" then INVOC_SERV_CLIP else if SSID="CLIR" then INVOC_SERV_CLIR else if SSID="CALL_BACK" then INVOC_SERV_CALLBACK else if SSID="XFER" then INVOC_SERV_CALL_TRANSFER_XFER else if SSID="UUS" then INVOC_SERV_UUS else if SSID="SPLIT_MPTY" then INVOC_SERV_SPLIT_MPTY else if SSID="CCBS_MORTR" then INVOC_SERV_CCBS_MORTR else if SSID="CCBS_MTER" then INVOC_SERV_CCBS_MTER else leftstr("x",0)
[SERVI] M128B2C2


msc_traffic_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
msc_idVARCHAR(50) [MSC_TRAF] "MSC"&MSCID
[VLR] NODEID
[msc_traf] NODEID
[TRAFF] EXCH_ID
[TC] msc_id
traffic_type_idVARCHAR(50) [MSC_TRAF] "Provided by customer"
[VLR] "TTYPE"
[msc_traf] ttype
[TRAFF] TY
[TC] TCAT_ID
dayINTEGER 
answered_callsVARCOUNTER [MSC_TRAF] CS_NWTT
[VLR] if TTYPE="ALORG" then C30513 else if TTYPE="ALTER" then C30606 else NULL
[msc_traf] t01
[TRAFF] CALL_ATTEMPTS+DATACDA_ANA_ATTEMPTS+DATACDA_DIG_ATTEMPTS+ALTFAXSP_CALL_ATTEMPTS+FAX3_CALL_ATTEMPTS+DATACDS_ANA_ATTEMPTS+DATACDS_DIG_ATTEMPTS+ALT_SPCH_DATA_ATTEMPTS+IN_ATTEMPTS
[TC] M20B2C4
call_attemptsVARCOUNTER [MSC_TRAF] CA_NWTT
[VLR] if TTYPE="ALORG" then C30503 else if TTYPE="ALTER" then C30603 else if TTYPE = "ALGAT" then C31104 else NULL
[msc_traf] t05
[TRAFF] CALL_ATTEMPTS
[TC] M20B2C2
call_failuresVARCOUNTER [MSC_TRAF] CA_NWTT - CC_TCA_NWTT
[VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL
[msc_traf] (t05 - t04)
[TRAFF] if TY="MORTR" then UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_OVERLOAD+UNS_CONGESTION+UNS_BS_REASON+UNS_LACK_IWE+UNS_SECURITY_FAIL else if TY="MOPLMN" then UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_CONGESTION+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_NETW_MANAGEMENT+UNS_BS_REASON else if TY="MNPLMN" then UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_CONGESTION+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_NETW_MANAGEMENT+UNS_BS_REASON else if TY="MICTR" then UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_OVERLOAD else if TY="MTER" then UNS_PAGING+UNS_REQ_DEST_ERR+UNS_TECHN_FAULT+UNS_SERV_CHECK+UNS_CONGESTION+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_SECURITY_FAIL+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_OVERLOAD+UNS_BS_REASON else if TY="MTRAN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LINK_FAIL+UNS_PROTO_ERROR else leftstr("x",0)
[TC] M20B2C2 - M20B2C3
call_successesVARCOUNTER [MSC_TRAF] CC_TCA_NWTT
[VLR] if TTYPE="ALORG" then (C30509 + C30510 + C30512) else if TTYPE="ALTER" then C30605 else NULL
[msc_traf] t04
[TRAFF] if TY="MTRAN" then SN_THROUGH_CONNECTIONS else CALL_TCH_ALLOCATION
[TC] M20B2C4
external_failed_callsVARCOUNTER [VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL
[msc_traf] EXTFAILS
[TRAFF] if TY="MORTR" then UNS_REQ_DEST_ERR+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MOPLMN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MNPLMN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MICTR" then UNS_LINK_FAIL+UNS_PROTO_ERROR else if TY="MTER" then UNS_PAGING+UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LACK_IWE+UNS_LINK_FAIL+UNS_PROTO_ERROR+UNS_BS_REASON else if TY="MTRAN" then UNS_REQ_DEST_ERR+UNS_SN_CONGESTION+UNS_LINK_FAIL+UNS_PROTO_ERROR else leftstr("x",0)
[TC] M20B2C6
internal_failed_callsVARCOUNTER [MSC_TRAF] CL_CONG_N7_NWTT + CL_CONG_SSS_NWTT + CL_CONG_TKG_NWTT + CL_IWF_NWTT + CL_NC_NWTT + CL_NM_NWTT + CL_OTH_NWTT + CL_OVL_NWTT + CL_PE_NWTT + CL_PL_NWTT + CL_RRR_NWTT + CL_SBU_NWTT+ CL_TF_NWTT
[VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL
[msc_traf] INTFAILS
[TRAFF] if TY="MORTR" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_OVERLOAD else if TY="MOPLMN" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_NETW_MANAGEMENT else if TY="MNPLMN" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_NETW_MANAGEMENT else if TY="MICTR" then UNS_TECHN_FAULT+UNS_OVERLOAD else if TY="MTER" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_OVERLOAD else if TY="MTRAN" then UNS_TECHN_FAULT+UNS_CONGESTION+UNS_NETW_MANAGEMENT else leftstr("x",0)
[TC] M20B2C5
subscriber_error_callsVARCOUNTER [MSC_TRAF] CL_BL_NWTT
[VLR] if TTYPE="ALORG" then C30514 else if TTYPE="ALTER" then C30607 else NULL
[msc_traf] SUBFAILS
[TRAFF] if TY="MORTR" then UNS_SERV_CHECK+UNS_MS_BLOCKED+UNS_SECURITY_FAIL+UNS_MS_DETACH+UNS_CUG_REJECT else if TY="MOPLMN" then UNS_SERV_CHECK+UNS_MS_BUSY+UNS_BLACK_LIST+UNS_IMEI_UNKNOWN+UNS_CUG_REJECT else if TY="MNPLMN" then UNS_SERV_CHECK+UNS_MS_BUSY+UNS_BLACK_LIST+UNS_IMEI_UNKNOWN+UNS_CUG_REJECT else if TY="MICTR" then UNS_SERV_CHECK+UNS_MS_BLOCKED+UNS_MS_DETACH+UNS_CUG_REJECT else if TY="MTER" then UNS_SERV_CHECK+UNS_MS_BLOCKED+UNS_MS_BUSY+UNS_SECURITY_FAIL+UNS_BLACK_LIST+UNS_IMEI_UNKNOWN+UNS_MS_DETACH else leftstr("x",0)
[TC] M20B2C7
trafficVARCOUNTER [MSC_TRAF] round(TV_NWTT,2)
[msc_traf] round((traffic/10),2)
[TRAFF] if DURATION=0 then NULL else round(TRAFFIC_VOLUME/(DURATION*60),2)
[TC] M20B2C12/100


Raw Processor Tables

processor_cpu_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
processor_idVARCHAR(50) [BSC] BSC &"/"& CPUTYPE &"-"& ID
[dproc_statistics] nodeid&"/"&procid
[gproc_statistics] sitename&"/"&procid
[PROC] NODEID&"/"&rank
[P_NBSC_LOAD] NODEID & "/" & OBJ_NAME & "-" & OBJ_INDEX
[PROC] if MEASURE_ID="CPXX" then EXCH_ID&"-"&NODEID else if MEASURE_ID="GPXX" then EXCH_ID&"-"&LTG else EXCH_ID
[CLOM] msc_id &"-"& unit_id
[CLOH] hlr_id &"-"& unit_id
dayINTEGER 
load_pcVARCOUNTER [BSC] ((BSCB_0_1835_0_AVG + BSCB_1_1835_0_AVG + BSCB_2_1835_0_AVG + BSCB_3_1835_0_AVG + BSCB_4_1835_0_AVG + BSCB_5_1835_0_AVG + BSCB_6_1835_0_AVG + BSCB_7_1835_0_AVG + BSCB_8_1835_0_AVG + BSCB_9_1835_0_AVG) / 10) + ((CPUE_0_1835_0_AVG + CPUE_1_1835_0_AVG + CPUE_2_1835_0_AVG) / 3) + CPUM
[dproc_statistics] cpu_usage_mean
[gproc_statistics] cpu_usage_mean
[PROC] C101
[P_NBSC_LOAD] if ( LOAD_DENOM1 != 0 ) then round(LOAD_RATE/LOAD_DENOM1,0) else leftstr("x",0)
[PROC] if DURATION=0 then NULL else if INTEGRATION_FACTOR=0 then NULL else if MEASURE_ID="GPXX" then round((1000-((GP_IDR*GP_MEA)/(DURATION*60*1000)))/10,0) else if MEASURE_ID="CPXX" then round(TOTAL_INTENSITY/(INTEGRATION_FACTOR*10),0) else NULL
[CLOM] M119B2C2/10
[CLOH] M119B2C2/10


Raw Route_IF Tables

route_interface_transmission_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
route_if_idVARCHAR(50) [TRUNKGROUP] "MSC"&MSCID&"-"&OBJECTNAME
[class_f] NODEID&"/"&routeid
[TGRP] EXCH_ID & "-" & TGNO
[CGR] msc_id&"/"&alt_id
dayINTEGER 
available_circuitsVARCOUNTER [class_f] round((fs_i / 10),2)
[TGRP] CONNECTED_LINES-(SEMI_BLOCKED_LINES+TRANS_BLOCKED_LINES)
[CGR] M16B2C5 + M16B2C6
bidsVARCOUNTER [class_f] fpd_i + frd_i
[TGRP] CCU_SUM_OF_LOSS+CC_O
[CGR] M16B2C11 + M16B2C9
blocked_circuitsVARCOUNTER [class_f] round((fq_i - (fs_i / 10)),2)
[TGRP] SEMI_BLOCKED_LINES+TRANS_BLOCKED_LINES
[CGR] M16B2C23-(M16B2C5 + M16B2C6)
busy_time_pcVARCOUNTER [TGRP] if DURATION=0 then NULL else round((100.0*ATB_TIME)/(DURATION*60),2)
[CGR] (ROUND(M16B2C7/100,0))
circuitsVARCOUNTER [class_f] fq_i
[TGRP] CONNECTED_LINES
[CGR] M16B2C3
incoming_answered_callsVARCOUNTER [class_f] fea_i
[TGRP] CCS_WITH_ANSWER_I
[CGR] M16B2C16
incoming_callsVARCOUNTER [TRUNKGROUP] CC_OG_TK
[class_f] fpa_i
[TGRP] CC_I
[CGR] M16B2C12
incoming_trafficVARCOUNTER [TRUNKGROUP] round(TV_CS_MICTR_TK,2)
[class_f] round((foa_i / 10),2)
[TGRP] if DURATION=0 then NULL else round(TV_I/(DURATION*60),2)
[CGR] M16B2C24
outgoing_answered_callsVARCOUNTER [class_f] fed_i
[TGRP] CCS_WITH_ANSWER_O
[CGR] M16B2C17
outgoing_callsVARCOUNTER [TRUNKGROUP] CA_MICTR_TK
[class_f] fpd_i
[TGRP] CC_O
[CGR] M16B2C13
outgoing_congestion_timeVARCOUNTER [TGRP] ATB_TIME
[CGR] round (M16B2C7 / 100/(100 *(interval*60)),0)
outgoing_congestionsVARCOUNTER [class_f] frd_i
[TGRP] CCU_SUM_OF_LOSS
[CGR] M16B2C9
outgoing_trafficVARCOUNTER [TRUNKGROUP] round(TV_OG_TK,2)
[class_f] round((fod_i / 10),2)
[TGRP] if DURATION=0 then NULL else round(TV_O/(DURATION*60),2)
[CGR] M16B2C25


Raw Signalling_Link Tables

ss7_link_availability_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_link_idVARCHAR(50) [SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer
[mtl_statistics] nodeid&"/"&linkid
[C7GOC7LL] moi & "-" & Linksetname
[SLMSC] msc_id &"-"& sln_id
[SLPMSC] msc_id &"-"& sln_id
dayINTEGER 
available_timeVARCOUNTER [mtl_statistics] round((utime(STRINGYMD0_0 & end,"%d %b %Y %R") - utime(STRINGYMD0_0 & start,"%d %b %Y %R")) - (mtp_unavailable / 1000),0)
[C7GOC7LL] duration-slUnavailabilityDuration
[SLMSC] (interval*60 - M208B2C1)
unavailable_timeVARCOUNTER [mtl_statistics] round(mtp_unavailable / 1000,0)
[C7GOC7LL] slUnavailabilityDuration
[SLPMSC] M208B2C1
local_inhibition_timeVARCOUNTER [mtl_statistics] round(mtp_local_mgt / 1000,0)
[C7GOC7LL] inhLinkDurUnavail
[SLPMSC] M208B2C5
remote_inhibition_timeVARCOUNTER [mtl_statistics] round(mtp_remote_mgt / 1000,0)
[C7GOC7LL] slRemoteProcOutage
[SLPMSC] M208B2C6
link_failure_timeVARCOUNTER [mtl_statistics] round(mtp_linkfail / 1000,0)
[C7GOC7LL] slFailed
[SLPMSC] M208B2C2
remote_outage_timeVARCOUNTER [SLPMSC] M208B2C4
remote_outagesVARCOUNTER [mtl_statistics] mtp_start_rpo
[SLPMSC] M208B2C10
local_busy_timeVARCOUNTER [mtl_statistics] round(mtp_local_busy / 1000,0)
[SLPMSC] M208B2C7


ss7_link_performance_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_link_idVARCHAR(50) [SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer
[mtl_statistics] nodeid&"/"&linkid
[C7GOC7LL] moi & "-" & Linksetname
[SLMSC] msc_id &"-"& sln_id
[SLPMSC] msc_id &"-"& sln_id
dayINTEGER 
in_service_timeVARCOUNTER [mtl_statistics] round(mtp_link_ins / 1000,2)
[C7GOC7LL] lInServiceDuration
[SLMSC] M209B2C1
failuresVARCOUNTER [mtl_statistics] mtp_sl_fail
[SLMSC] M209B2C2
failures_abrVARCOUNTER [mtl_statistics] mtp_sl_fibr
[SLMSC] M209B2C3
failures_delayVARCOUNTER [SignallingLink] c5103_0_CUM
[mtl_statistics] mtp_sl_ack
[SLMSC] M209B2C4
failures_error_rateVARCOUNTER [SignallingLink] c5103_1_CUM
[mtl_statistics] mtp_sl_error_rate
[SLMSC] M209B2C5
failures_congestionVARCOUNTER [mtl_statistics] mtp_sl_congestion
[C7GOC7LL] slCongestedStarts
[SLMSC] M209B2C6
failures_alignmentVARCOUNTER [mtl_statistics] mtp_sl_alignment
[SLMSC] M209B2C7
received_su_errorsVARCOUNTER [mtl_statistics] mtp_su_error
[C7GOC7LL] signUnitsReceived
[SLPMSC] M209B3C1
received_neg_ackVARCOUNTER [SignallingLink] c5102_0_CUM
[mtl_statistics] mtp_neg_acks
[SLPMSC] M209B3C2
changeoversVARCOUNTER [mtl_statistics] round(mtp_changeover,2)
[SLMSC] M209B3C3
changebacksVARCOUNTER [mtl_statistics] mtp_changeback
[SLMSC] M209B3C4
restoresVARCOUNTER [SLPMSC] M209B3C5


ss7_link_utilisation_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_link_idVARCHAR(50) [SignallingLink] From vendor neutral loadmaps in vendor specific Tech Packs, or defined by the customer
[mtl_statistics] nodeid&"/"&linkid
[SIGN] NODEID&"/"&linksetid&"/"&linkcode
[sgnl_load] NODEID&"/"&linksetid&"/"&linkcode
[C7GOC7LL] moi & "-" & Linksetname
[MTPMSC] msc_id &"-"& sln_id
[SLMSC] msc_id &"-"& sln_id
[SLPMSC] msc_id &"-"& sln_id
dayINTEGER 
transmitted_sif_siosVARCOUNTER [mtl_statistics] mtp_sif_sio_tx
[SIGN] C1
[sgnl_load] nte_i
[C7GOC7LL] transmittedOctetsSIFSIO
[SLPMSC] M210B2C1
retransmitted_sif_siosVARCOUNTER [mtl_statistics] mtp_re_tx
[C7GOC7LL] retransmittedOctets
[SLPMSC] M210B2C5
received_sif_siosVARCOUNTER [mtl_statistics] mtp_sif_sio_rx
[SIGN] C2
[sgnl_load] ntr_i
[C7GOC7LL] receivedOctetsSIFSIO
[SLPMSC] M210B2C2
transmitted_msusVARCOUNTER [SignallingLink] c5101_0_CUM
[mtl_statistics] mtp_msu_tx
[SIGN] C3
[C7GOC7LL] transmittedMSUs
[SLPMSC] M210B2C3
received_msusVARCOUNTER [SignallingLink] c5100_0_CUM
[mtl_statistics] mtp_msu_rx
[SIGN] C4
[C7GOC7LL] receivedMSUs
[SLPMSC] M210B2C4
congestionsVARCOUNTER [mtl_statistics] round(sl_congestion / 1000,0)
[C7GOC7LL] slCongestedStarts
[SLMSC] M210B2C6 + M210B2C7 + M210B2C8
congestion_timeVARCOUNTER [mtl_statistics] mtp_congestion
[C7GOC7LL] slCongestedDuration
[SLMSC] M210B2C15 + M210B2C16 + M210B2C17
discarded_msusVARCOUNTER [SignallingLink] c5102_2_CUM
[mtl_statistics] msu_discarded
[C7GOC7LL] discardedMSUs
[SLMSC] M210B2C9 + M210B2C10 + M210B2C11
congestion_lossesVARCOUNTER [mtl_statistics] congestion_lost_m
[SLMSC] (M210B2C12 + M210B2C13 + M210B2C14)
outgoing_trafficVARCOUNTER [C7GOC7LL] transmittedOctetsSIFSIO + retransmittedOctets + (6* transmittedMSUs)
[MTPMSC] (M210B2C1 + (6 * M210B2C3))
incoming_trafficVARCOUNTER [C7GOC7LL] receivedOctetsSIFSIO + (6*receivedMSUs)
[SLPMSC] M210B2C2 + (6* M210B2C4)


Raw Signalling_LinkSet Tables

ss7_linkset_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_linkset_idVARCHAR(50) [C7LS] EXCH_ID & "-" & LSNAM
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id
dayINTEGER 
available_timeVARCOUNTER [C7LS] (DURATION*60)-slsUnavailable
[AVANMSC] (interval*60)-M212B2C3
unavailable_timeVARCOUNTER [C7LS] slsUnavailable
[AVANMSC] M212B2C3
failuresVARCOUNTER [C7LS] numLinkSetNotAvail
[AVANMSC] M212B2C1


Raw Signalling_Point Tables

ss7_point_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_point_idVARCHAR(50) [C7MU] MOI
[STAMSC] msc_id&"-"&snet_id&"-"&spc_id
dayINTEGER 
adjacent_sp_inaccessibleVARCOUNTER [C7MU] adjacentInaccessibleEvents
[STAMSC] M211B2C1
adjacent_sp_inaccessible_timeVARCOUNTER [C7MU] adjacentInaccessibleDuration
[STAMSC] M211B2C2
discarded_msusVARCOUNTER [C7MU] discardedMSUs
[STAMSC] M211B2C4
received_tfcsVARCOUNTER [STAMSC] M211B2C3


Raw Signalling_RouteSet Tables

ss7_routeset_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
ss7_routeset_idVARCHAR(50) [C7RS] MOI
[AVANMSC] msc_id&"-"&snet_id&"-"&spc_id&"-"&slsn_id
dayINTEGER 
available_timeVARCOUNTER [C7RS] duration-routeSetUnavailableDuration
[AVANMSC] (interval*60)-M212B2C9
unavailable_timeVARCOUNTER [C7RS] routeSetUnavailableDuration
[AVANMSC] M212B2C9
failuresVARCOUNTER [C7RS] routeSetUnavailable
[AVANMSC] M212B2C8


Raw VLR Tables

vlr_resource_mobility_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
vlr_idVARCHAR(50) [CML_GS_GLOBAL] "MSC"&MSCID
[VLR] NODEID
[USVM] EXCH_ID
[PLMNV] msc_id
[VLR1MSC] msc_id
dayINTEGER 
lac_update_attemptsVARCOUNTER [CML_GS_GLOBAL] LA_REQ
[VLR] C20416+C20415+C20414+C20413+C20411
[USVM] REQUESTS_LOCUPD
[VLR1MSC] M82B3C101+M82B3C118+M82B3C106+M82B3C110+M82B3C114+M82B3C105+M82B3C122+M82B5C101
lac_update_successesVARCOUNTER [CML_GS_GLOBAL] LS
[VLR] C20453
[USVM] SUCC_REQUESTS_LOCUPD+SUCC_LOCUPD_WITH_IMSI_ATTACH
[VLR1MSC] M82B3C102+M82B3C131+M82B3C107+M82B3C111+M82B3C115+M82B3C119+M82B3C123+M82B5C103
lac_update_failuresVARCOUNTER [CML_GS_GLOBAL] LA_REQ - LS
[VLR] (C20416+C20415+C20414+C20413+C20411) - C20453
[USVM] REQUEST_LOCUPD-(SUCC_REQUESTS_LOCUPD+SUCC_LOCUPD_WITH_IMSI_ATTACH)
[VLR1MSC] M82B3C101+M82B3C118+M82B3C106+M82B3C110+M82B3C114+M82B3C105-M82B3C102+M82B3C131+M82B3C107++M82B3C111+M82B3C115+M82B3C119 +M82B3C123+M82B5C103
vlr_update_attemptsVARCOUNTER [CML_GS_GLOBAL] LA_INTRA_VLR
[VLR] (C20403 - C20414)
[USVM] REQUESTS_LOCUPD_INTRA_VLR
[VLR1MSC] M82B3C14 + M82B3C1 + M82B3C10 + M82B3C5
vlr_update_successesVARCOUNTER [CML_GS_GLOBAL] LS_INTRA_VLR
[VLR1MSC] M82B3C15 + M82B3C11 + M82B3C2 + M82B3C31
vlr_update_failuresVARCOUNTER [CML_GS_GLOBAL] LA_INTRA_VLR - LS_INTRA_VLR
[VLR1MSC] M82B3C14 + M82B3C1 + M82B3C10 + M82B3C5 - M82B3C15 + M82B3C11 + M82B3C2 + M82B3C31
imsi_attach_attemptsVARCOUNTER [CML_GS_GLOBAL] LA_ATTACH
[VLR] C30402
[USVM] REQUESTS_LOCUPD_WITH_IMSI_ATT
[VLR1MSC] M82B5C101
imsi_attach_successesVARCOUNTER [USVM] SUCC_LOCUPD_WITH_IMSI_ATTACH
[VLR1MSC] M82B5C103
imsi_attach_failuresVARCOUNTER [USVM] REQUESTS_LOCUPD_WITH_IMSI_ATT-SUCC_LOCUPD_WITH_IMSI_ATTACH
[VLR1MSC] M82B5C101 - M82B5C103
imsi_detachesVARCOUNTER [VLR] C30403
[USVM] EXPLICIT_IMSI_DETACH+IMPLICIT_IMSI_DETACH
[VLR1MSC] M82B5C105
imsi_attach_updatesVARCOUNTER [USVM] SUCC_LOCUPD_WITH_IMSI_ATTACH
[VLR1MSC] M82B5C3
periodic_updatesVARCOUNTER [CML_GS_GLOBAL] LA_PER
[VLR] C30405
[USVM] REQUESTS_PERIODIC_LOCUPD
[VLR1MSC] M82B3C22
new_la_updatesVARCOUNTER [USVM] LA_CHANGES_OWN_PLMN+LA_CHANGES_FOREIGN_PLMN+VLR_AREA_LEAVES_FOREIGN_PLMN+VLR_AREA_LEAVES_OWN_PLMN
id_request_attemptsVARCOUNTER [VLR] C20408
[USVM] IDENTITY_REQUESTS
id_request_successesVARCOUNTER [CML_GS_GLOBAL] LS_RC_PVLR
id_request_failuresVARCOUNTER 
vlr_visitorsVARCOUNTER [USVM] ENTRY_USED_FOREIGN
[PLMNV] M340B2C3
vlr_subscribersVARCOUNTER [VLR] C20402
[USVM] ENTRY_USED_OWN+ENTRY_USED_FOREIGN
[VLR1MSC] M80B2C5


8.3 Views

This section lists the views that are included in this technology pack's database schema.

nc_processor_bsc_v

SELECT Statement
SELECT nc_id,
processor_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
processor_name,
processor_type,
technology,
vendor,
processor_version
FROM nc_processor
WHERE LOWER(node_type) = "bsc";
Column NameData Type
nc_idINTEGER
processor_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
processor_nameVARCHAR(255)
processor_typeVARCHAR(50)
technologyVARCHAR(50)
vendorVARCHAR(50)
processor_versionVARCHAR(50)


nc_processor_ggsn_v

SELECT Statement
SELECT nc_id,
processor_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
processor_name,
processor_type,
technology,
vendor,
processor_version
FROM nc_processor
WHERE LOWER(node_type) = "ggsn";
Column NameData Type
nc_idINTEGER
processor_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
processor_nameVARCHAR(255)
processor_typeVARCHAR(50)
technologyVARCHAR(50)
vendorVARCHAR(50)
processor_versionVARCHAR(50)


nc_processor_hlr_v

SELECT Statement
SELECT nc_id,
processor_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
processor_name,
processor_type,
technology,
vendor,
processor_version
FROM nc_processor
WHERE LOWER(node_type) = "hlr";
Column NameData Type
nc_idINTEGER
processor_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
processor_nameVARCHAR(255)
processor_typeVARCHAR(50)
technologyVARCHAR(50)
vendorVARCHAR(50)
processor_versionVARCHAR(50)


nc_processor_msc_v

SELECT Statement
SELECT nc_id,
processor_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
processor_name,
processor_type,
technology,
vendor,
processor_version
FROM nc_processor
WHERE LOWER(node_type) = "msc";
Column NameData Type
nc_idINTEGER
processor_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
processor_nameVARCHAR(255)
processor_typeVARCHAR(50)
technologyVARCHAR(50)
vendorVARCHAR(50)
processor_versionVARCHAR(50)


nc_processor_sgsn_v

SELECT Statement
SELECT nc_id,
processor_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
processor_name,
processor_type,
technology,
vendor,
processor_version
FROM nc_processor
WHERE LOWER(node_type) = "sgsn";
Column NameData Type
nc_idINTEGER
processor_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
processor_nameVARCHAR(255)
processor_typeVARCHAR(50)
technologyVARCHAR(50)
vendorVARCHAR(50)
processor_versionVARCHAR(50)


nc_ss7_link_bsc_v

SELECT Statement
SELECT nc_id,
ss7_link_id,
ss7_linkset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
data_rate,
ss7_link_name,
technology
FROM nc_ss7_link
WHERE LOWER(node_type) = "bsc";
Column NameData Type
nc_idINTEGER
ss7_link_idVARCHAR(50)
ss7_linkset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
data_rateVARCHAR(50)
ss7_link_nameVARCHAR(50)
technologyVARCHAR(50)


nc_ss7_link_mgw_v

SELECT Statement
SELECT nc_id,
ss7_link_id,
ss7_linkset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
data_rate,
ss7_link_name,
technology
FROM nc_ss7_link
WHERE LOWER(node_type) = "mgw";
Column NameData Type
nc_idINTEGER
ss7_link_idVARCHAR(50)
ss7_linkset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
data_rateVARCHAR(50)
ss7_link_nameVARCHAR(50)
technologyVARCHAR(50)


nc_ss7_link_msc_v

SELECT Statement
SELECT nc_id,
ss7_link_id,
ss7_linkset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
data_rate,
ss7_link_name,
technology
FROM nc_ss7_link
WHERE LOWER(node_type) = "msc";
Column NameData Type
nc_idINTEGER
ss7_link_idVARCHAR(50)
ss7_linkset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
data_rateVARCHAR(50)
ss7_link_nameVARCHAR(50)
technologyVARCHAR(50)


nc_ss7_linkset_bsc_v

SELECT Statement
SELECT nc_id,
ss7_linkset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
data_rate,
designed_link_failures,
ss7_linkset_name,
technology
FROM nc_ss7_linkset
WHERE LOWER(node_type) = "bsc";
Column NameData Type
nc_idINTEGER
ss7_linkset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
data_rateVARCHAR(50)
designed_link_failuresVARCHAR(50)
ss7_linkset_nameVARCHAR(255)
technologyVARCHAR(50)


nc_ss7_linkset_mgw_v

SELECT Statement
SELECT nc_id,
ss7_linkset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
data_rate,
designed_link_failures,
ss7_linkset_name,
technology
FROM nc_ss7_linkset
WHERE LOWER(node_type) = "mgw";
Column NameData Type
nc_idINTEGER
ss7_linkset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
data_rateVARCHAR(50)
designed_link_failuresVARCHAR(50)
ss7_linkset_nameVARCHAR(255)
technologyVARCHAR(50)


nc_ss7_linkset_msc_v

SELECT Statement
SELECT nc_id,
ss7_linkset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
data_rate,
designed_link_failures,
ss7_linkset_name,
technology
FROM nc_ss7_linkset
WHERE LOWER(node_type) = "msc";
Column NameData Type
nc_idINTEGER
ss7_linkset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
data_rateVARCHAR(50)
designed_link_failuresVARCHAR(50)
ss7_linkset_nameVARCHAR(255)
technologyVARCHAR(50)


nc_ss7_point_bsc_v

SELECT Statement
SELECT nc_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
ss7_point_name,
adjacent_node_id,
technology
FROM nc_ss7_point
WHERE LOWER(node_type) = "bsc";
Column NameData Type
nc_idINTEGER
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
ss7_point_nameVARCHAR(255)
adjacent_node_idVARCHAR(50)
technologyVARCHAR(50)


nc_ss7_point_mgw_v

SELECT Statement
SELECT nc_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
ss7_point_name,
adjacent_node_id,
technology
FROM nc_ss7_point
WHERE LOWER(node_type) = "mgw";
Column NameData Type
nc_idINTEGER
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
ss7_point_nameVARCHAR(255)
adjacent_node_idVARCHAR(50)
technologyVARCHAR(50)


nc_ss7_point_msc_v

SELECT Statement
SELECT nc_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
ss7_point_name,
adjacent_node_id,
technology
FROM nc_ss7_point
WHERE LOWER(node_type) = "msc";
Column NameData Type
nc_idINTEGER
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
ss7_point_nameVARCHAR(255)
adjacent_node_idVARCHAR(50)
technologyVARCHAR(50)


nc_ss7_routeset_bsc_v

SELECT Statement
SELECT nc_id,
ss7_routeset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
ss7_routeset_name,
technology
FROM nc_ss7_routeset
WHERE LOWER(node_type) = "bsc";
Column NameData Type
nc_idINTEGER
ss7_routeset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
ss7_routeset_nameVARCHAR(255)
technologyVARCHAR(50)


nc_ss7_routeset_mgw_v

SELECT Statement
SELECT nc_id,
ss7_routeset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
ss7_routeset_name,
technology
FROM nc_ss7_routeset
WHERE LOWER(node_type) = "mgw";
Column NameData Type
nc_idINTEGER
ss7_routeset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
ss7_routeset_nameVARCHAR(255)
technologyVARCHAR(50)


nc_ss7_routeset_msc_v

SELECT Statement
SELECT nc_id,
ss7_routeset_id,
ss7_point_id,
node_id,
region_id,
network_id,
timestamp,
node_name,
node_type,
adjacent_node_id,
ss7_routeset_name,
technology
FROM nc_ss7_routeset
WHERE LOWER(node_type) = "msc";
Column NameData Type
nc_idINTEGER
ss7_routeset_idVARCHAR(50)
ss7_point_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
node_nameVARCHAR(255)
node_typeVARCHAR(50)
adjacent_node_idVARCHAR(50)
ss7_routeset_nameVARCHAR(255)
technologyVARCHAR(50)


9. Performance Alarms

This section shows details of the performance alarms that are defined in this technology pack:

None.

10. Reports

This section shows details of the reports that are defined in this technology pack:

Historical Route Traffic Report

This report shows key route traffic statistics for a single route over all the weeks in the forecast base range. The report shows available & defined circuits, % congestion, carried traffic, offered traffic, lost traffic, critical traffic, 3-DAV and 5-DAV traffic, % utilisation and grade of service. The report is always generated with weekly busy hour values.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRoute_IF
Date RangingNo
Period SelectionWeekly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Historical Route Traffic Report (Table)
3-DAV Summarised Carried Traffic (E)Route_IF.Neutral.GSM.transmission.traffic3-day Average 
5-DAV Summarised Carried Traffic (E)Route_IF.Neutral.GSM.transmission.traffic5-day Average 
Available ChannelsRoute_IF.Neutral.GSM.transmission.available_circuitsbusy_hour 
Blocking (%)Route_IF.Neutral.GSM.transmission.%_outgoing_congestionsbusy_hour 
Busy Hourbusy_hourbusy_hour 
CapacityRoute_IF.Neutral.GSM.transmission.capacitybusy_hour 
Carried Traffic (E)Route_IF.Neutral.GSM.transmission.trafficbusy_hour 
Defined ChannelsRoute_IF.Neutral.GSM.transmission.circuitsbusy_hour 
GOSRoute_IF.Neutral.GSM.transmission.grade_of_servicebusy_hour 
Lost Traffic (E)Route_IF.Neutral.GSM.transmission.lost_trafficbusy_hour 
Offered Traffic (E)Route_IF.Neutral.GSM.transmission.offered_trafficbusy_hour 
Offered UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationbusy_hour 
RouteRoute_IF.nameUser-defined 
Week_of User-defined 

HLR Subscribers Graph

This graph shows the number of attached users and the % number of registered users attached.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.HLR
Primary ObjectHLR
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionHLR
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Subscribers in VLRs (Line Chart)
% Subscribers in VLRsHLR.Neutral.GSM.mobility.%_active_subscribersUser-defined 
Component 2: Subscribers (Line Chart)
In HLRHLR.Neutral.GSM.mobility.subscribersUser-defined 
In all VLRsHLR.Neutral.GSM.mobility.vlr_subscribersUser-defined 

Interconnect Traffic Graph

This graph shows the total traffic profile for all routes connecting an MSC to a POI (a POI route).

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object Selection 
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Interconnect Traffic Graph (Line Chart)
Traffic (E)Route_IF.Neutral.GSM.transmission.bothway_trafficUser-defined 

Inter-switch Traffic Graph

This graph shows the total traffic profile for all routes connecting an MSC to an MSC (a trunk route).

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object Selection 
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Inter-switch Traffic Graph (Line Chart)
Traffic (E)Route_IF.Neutral.GSM.transmission.bothway_trafficUser-defined 

LAC Paging Graph

This shows the performance of LAC paging attempts within a Location Area

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.LAC
Primary ObjectLAC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionLAC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Eventual Response (Line Chart)
% Eventual ResponseLAC.Neutral.GSM.page.%_successUser-defined 
Component 2: % Page/Repage Response (Line Chart)
% Page/Repage ResponseLAC.Neutral.GSM.page.%_responseUser-defined 
Component 3: Pages Without Response (Line Chart)
Pages Without ResponseLAC.Neutral.GSM.page.unresponsesUser-defined 
Component 4: Total Paging Attempts (Line Chart)
Total Paging AttemptsLAC.Neutral.GSM.page.total_pagesUser-defined 

Linkset Availability Report Link KPIs

This report shows the availability of a set of linksets and failures and unavailability on the constituent links.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, Signalling_LinkSet, Signalling_Point
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary SelectionTotal
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.total_failures (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_time (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Availability Report (Link KPIs) (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
Link FailuresSignalling_LinkSet.Neutral.GSM.signalling_linkset.total_failuresUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
Links Unavailable (s)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_unavailable_timeUser-defined 

Linkset Availability Report Linkset KPIs

This report shows the availability of a set of linksets and failures

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, Signalling_LinkSet, Signalling_Point
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary SelectionTotal
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_time (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Availability Report (Linkset KPIs) (Table)
% Linkset In-serviceSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_availableUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 
Linkset Unavailable (s)Signalling_LinkSet.Neutral.GSM.signalling_linkset.unavailable_timeUser-defined 

Linkset Utilisation Report

This report shows the utilisation of a set of linksets through the traffic carried on their constituent links.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, Signalling_LinkSet, Signalling_Point
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffic (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_traffic (min), Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Linkset Utilisation Report (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksTotal 
LinksetSignalling_LinkSet.nameUser-defined 
TX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_traffictransmitted_busy_hour 
TX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_sif_siostransmitted_busy_hour 
TX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msustransmitted_busy_hour 
TX Busy Hourtransmitted_busy_hourtransmitted_busy_hour 
TX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_outgoing_traffictransmitted_busy_hour 
RX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_trafficreceived_busy_hour 
RX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_sif_siosreceived_busy_hour 
RX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_msusreceived_busy_hour 
RX Busy Hourreceived_busy_hourreceived_busy_hour 
RX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_incoming_trafficreceived_busy_hour 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 

MSC Calls Graph

This graph shows network incoming and mobile originating call statistics for the specified MSC over the selected days.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionMSC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSC Calls Graph (Line Chart)
AttemptsMSC.Neutral.GSM.traffic.call_attemptsUser-defined 
FailuresMSC.Neutral.GSM.traffic.call_failuresUser-defined 

MSC Data Coverage Graph

This graph is a bar chart showing the percentage data coverage of a selected MSC over a selected number of days. The graph uses the MSC.Traffic table to select a single traffic type and determines the total time for which data was collected for that traffic type on the selected days. Traffic type data is reported per MSC so if data is available for one traffic type from a MSC it is available for all traffic type from the MSC.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionMSC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSC Data Coverage (Bar Chart)
% Data CoverageMSC.Neutral.GSM.traffic.%_data_coverageUser-defined 

MSC Handover Graph

This graph shows the handover performance of a MSC for inter-cell intra-MSC handover and incoming and outgoing inter-MSC handover.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionMSC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Incoming Inter-MSC (Line Chart)
AttemptsMSC.Neutral.GSM.handover.incoming_intermsc_attemptsUser-defined 
FailuresMSC.Neutral.GSM.handover.incoming_intermsc_failuresUser-defined 
Component 2: Inter-Cell Intra-MSC (Line Chart)
FailuresMSC.Neutral.GSM.handover.interbsc_failuresUser-defined 
SuccessesMSC.Neutral.GSM.handover.interbsc_successesUser-defined 
Component 3: Outgoing Inter-MSC (Line Chart)
AttemptsMSC.Neutral.GSM.handover.outgoing_intermsc_attemptsUser-defined 
FailuresMSC.Neutral.GSM.handover.outgoing_intermsc_failuresUser-defined 

MSC Handover Report

This report shows handover performance at the MSC level for either all MSCs in a region or all MSCs in the network during a selected time period. The report shows intra-MSC handover attempts and failures and incoming and outgoing inter-MSC handover attempts and failures.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringMSC.Neutral.GSM.handover.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSC Handover Report (Table)
Busy Hourbusy_hourbusy_hour 
Incoming Inter-MSC Handover % FailureMSC.Neutral.GSM.handover.%_incoming_intermsc_failureUser-defined 
Incoming Inter-MSC Handover AttemptsMSC.Neutral.GSM.handover.incoming_intermsc_attemptsUser-defined 
Incoming Inter-MSC Handover FailuresMSC.Neutral.GSM.handover.incoming_intermsc_failuresUser-defined 
Inter-Cell Handover % FailureMSC.Neutral.GSM.handover.%_interbsc_failureUser-defined 
Inter-Cell Handover AttemptsMSC.Neutral.GSM.handover.interbsc_attemptsUser-defined 
Inter-Cell Handover FailuresMSC.Neutral.GSM.handover.interbsc_failuresUser-defined 
MSCMSC.nameUser-defined 
Not displayed (for filtering only)MSC.Neutral.GSM.handover.%_data_coverageUser-defined 
Outgoing Inter-MSC Handover % FailureMSC.Neutral.GSM.handover.%_outgoing_intermsc_failureUser-defined 
Outgoing Inter-MSC Handover AttemptsMSC.Neutral.GSM.handover.outgoing_intermsc_attemptsUser-defined 
Outgoing Inter-MSC Handover FailuresMSC.Neutral.GSM.handover.outgoing_intermsc_failuresUser-defined 

MSC Paging Graph

This graph shows the performance of the paging function for the MSC

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionMSC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Global Paging (Line Chart)
Failed to RespondMSC.Neutral.GSM.page.global_unresponsesUser-defined 
Pages and RepagesMSC.Neutral.GSM.page.total_global_pagesUser-defined 
Component 2: Location Area Paging (Line Chart)
Failed to RespondMSC.Neutral.GSM.page.local_unresponsesUser-defined 
Pages and RepagesMSC.Neutral.GSM.page.total_local_pagesUser-defined 

MSC Switched Traffic Graph

This graph shows the key traffic performance statistics for an MSC specifically the total switched traffic and total failed calls. Total switched traffic must be calculated by summing traffic from the appropriate traffic categories.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionMSC
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Failed Calls (Line Chart)
% Failed CallsMSC.Neutral.GSM.traffic.total_switched_traffic.%_call_failureUser-defined 
Component 2: Total Switched Traffic (Line Chart)
Total Switched TrafficMSC.Neutral.GSM.traffic.total_switched_traffic.trafficUser-defined 

MSC Switched Traffic Report Individual TT

This report shows key switched traffic statistics for a single MSC or all MSCs in a region or all MSCs in the network during a selected time period. The report shows attempts, calls, failures, %failures, answered, % answered and traffic for all traffic types.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectiontraffic_type_busy_hour, Total
FilteringMSC.Neutral.GSM.traffic.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: [ Traffic Type ] (Table)
% Answered CallsMSC.Neutral.GSM.traffic.%_answered_callsUser-defined 
% Failed CallsMSC.Neutral.GSM.traffic.%_call_failureUser-defined 
Answered CallsMSC.Neutral.GSM.traffic.answered_callsUser-defined 
AttemptsMSC.Neutral.GSM.traffic.call_attemptsUser-defined 
CallsMSC.Neutral.GSM.traffic.call_successesUser-defined 
Failed CallsMSC.Neutral.GSM.traffic.call_failuresUser-defined 
MSCMSC.nameUser-defined 
MSC Busy Hourtraffic_type_busy_hourtraffic_type_busy_hour 
Not displayed (for filtering only)MSC.Neutral.GSM.traffic.%_data_coverageUser-defined 
TrafficMSC.Neutral.GSM.traffic.trafficUser-defined 

MSC Switched Traffic Report Total Switched

This report shows key switched traffic statistics for a single MSC or all MSCs in a region or all MSCs in the network during a selected time period. The report shows the total switched traffic calls, failures % failures, answered, %answered and traffic.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringMSC.Neutral.GSM.traffic.total_switched_traffic.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSC Switched Traffic Report (Total Switched Traffic Type) (Table)
% Answered Switched CallsMSC.Neutral.GSM.traffic.total_switched_traffic.%_answered_callsUser-defined 
% Failed Switched CallsMSC.Neutral.GSM.traffic.total_switched_traffic.%_call_failureUser-defined 
Switched TrafficMSC.Neutral.GSM.traffic.total_switched_traffic.trafficUser-defined 
Switched CallsMSC.Neutral.GSM.traffic.total_switched_traffic.call_successesUser-defined 
Switched AttemptsMSC.Neutral.GSM.traffic.total_switched_traffic.call_attemptsUser-defined 
Not displayed (for filtering only)MSC.Neutral.GSM.traffic.total_switched_traffic.%_data_coverageUser-defined 
MSC Busy Hourbusy_hourbusy_hour 
MSCMSC.nameUser-defined 
Failed Switched CallsMSC.Neutral.GSM.traffic.total_switched_traffic.call_failuresUser-defined 
Answered Switched CallsMSC.Neutral.GSM.traffic.total_switched_traffic.answered_callsUser-defined 

MSC Traffic Dispersion Report

For each MSC this report shows calls, answered calls and traffic to each destination recorded by the MSC.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.MSC
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
FilteringMSC.Neutral.GSM.destination.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSC Traffic Dispersion Report (Table)
% AnswersMSC.Neutral.GSM.destination.%_answered_callsUser-defined 
AnswersMSC.Neutral.GSM.destination.answered_callsUser-defined 
TrafficMSC.Neutral.GSM.destination.trafficUser-defined 
Not displayed (for filtering only)MSC.Neutral.GSM.destination.%_data_coverageUser-defined 
MSCMSC.nameUser-defined 
Destination User-defined 
CallsMSC.Neutral.GSM.destination.total_callsUser-defined 
Busy Hourbusy_hourbusy_hour 

Processor Load Graph

This graph shows the performance of a support processor associated with a node against time

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Processor
Primary ObjectProcessor
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionProcessor
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Processor Load (Line Chart)
% LoadProcessor.Neutral.GSM.cpu.load_pcUser-defined 

Route Congestion Graph

This graph shows the congestion on a selected route

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRoute_IF
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Congestion (Line Chart)
% CongestionRoute_IF.Neutral.GSM.transmission.%_outgoing_congestionsUser-defined 
Component 2: Congestions (Line Chart)
CongestionsRoute_IF.Neutral.GSM.transmission.outgoing_congestionsUser-defined 
Component 3: Defined and Available Circuits (Line Chart)
Available CircuitsRoute_IF.Neutral.GSM.transmission.available_circuitsUser-defined 
Defined CircuitsRoute_IF.Neutral.GSM.transmission.circuitsUser-defined 
Component 4: Outgoing Bids (Line Chart)
Outgoing BidsRoute_IF.Neutral.GSM.transmission.bidsUser-defined 

Route Exhaustion Report

This report shows all routes that will reach exhaustion in the specified forecast. The report shows carried traffic, % congestion, % utilisation, grade of service and lost traffic in the most recent actual busy hour and then the selected dimensioning parameter, the critical traffic, the sample size, correlation coefficient, traffic growth and exhaustion date. The report is always generated with weekly busy hour values. The user defines the length of forecast in days and the design GOS as runtime parameters, and has the option to include or exclude exhausted routes.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC, Route_IF
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Route Exhaustion Report (Table)
End Date % BlockingRoute_IF.Neutral.GSM.transmission.%_outgoing_congestionsbusy_hour 
End Date % UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationbusy_hour 
End Date CapacityRoute_IF.Neutral.GSM.transmission.capacityUser-defined 
End Date Grade Of ServiceRoute_IF.Neutral.GSM.transmission.grade_of_servicebusy_hour 
End Date Lost Traffic (E)Route_IF.Neutral.GSM.transmission.lost_trafficbusy_hour 
End Date Traffic (E)Route_IF.Neutral.GSM.transmission.trafficbusy_hour 
Exhaustion DateRoute_IF.Neutral.GSM.transmission.forecast.linear_exhaustion_dateUser-defined 
Is ExhaustedRoute_IF.Neutral.GSM.transmission.is_exhaustedUser-defined 
RouteRoute_IF.nameUser-defined 
SamplesRoute_IF.Neutral.GSM.transmission.number_of_samplesUser-defined 
Traffic (E)Route_IF.Neutral.GSM.transmission.trafficUser-defined 
Traffic Growth (Erlangs/week)Route_IF.Neutral.GSM.transmission.forecast.linear_traffic_growthUser-defined 

Route Interface Offered Traffic Graph

This chart shows the trend in the principal route interface parameters: busy hour traffic, 3-DAV and 5-DAV traffic

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRoute_IF
Date RangingYes
Period SelectionWeekly
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Route Interface Offered Traffic Graph (Line Chart)
CapacityRoute_IF.Neutral.GSM.transmission.capacityUser-defined 
Weekly 3-DAV ValueRoute_IF.Neutral.GSM.transmission.traffic3-day Average 
Weekly 5-DAV ValueRoute_IF.Neutral.GSM.transmission.traffic5-day Average 
Weekly Busy Hour ValueRoute_IF.Neutral.GSM.transmission.trafficbusy_hour 

Route Interface Traffic Forecast Graph

This chart allows the user to plot the weekly trend of either the carried or offered traffic for one of the three following dimensioning parameters: the busy hour traffic; 3-day average traffic; or, the 5-day average traffic. It also plots a regression of the selected dimensioning parameter extrapolated over a user-defined forecast period.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRoute_IF
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: [N]-Day Route Interface Traffic Forecast Graph (Line Chart)
Capacity GOS=[GOS1]Route_IF.Neutral.GSM.transmission.forecast.capacityUser-defined 
Coefficient of RegressionRoute_IF.Neutral.GSM.transmission.forecast.linear_regression_coefficientUser-defined 
Growth is [linear_traffic_growth] Erlangs/weekRoute_IF.Neutral.GSM.transmission.forecast.linear_traffic_growthUser-defined 
Route Interface [will reach exhaustion on date|will not reach exhaustion in this period]Route_IF.Neutral.GSM.transmission.forecast.linear_exhaustion_dateUser-defined 
Standard Error of RegressionRoute_IF.Neutral.GSM.transmission.forecast.linear_regression_errorUser-defined 
TrafficRoute_IF.Neutral.GSM.transmission.trafficUser-defined 
Traffic ForecastRoute_IF.Neutral.GSM.transmission.forecast.trafficUser-defined 

Route Low Utilisation Report

This report shows all routes that will remain consistently under utilised in the forecast period i.e. start off with low utilisation and finish with low utilisation. The report shows carried traffic, % congestion, % utilisation, grade of service and lost traffic in the most recent actual busy hour and then the selected dimensioning parameter, the critical traffic, the sample size, correlation coefficient and current and final utilisation. The report is always generated with weekly busy hour values. The report can be filtered on the maximum current utilisation and forecast utilisation; these parameters mandatory and default to 25%. The user defines the length of forecast in days and the design GOS as runtime parameters.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC, Route_IF
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
FilteringRoute_IF.Neutral.GSM.transmission.offered_utilisation (max), Route_IF.Neutral.GSM.transmission.forecast.utilisation (max)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Route Low Utilisation Report (Table)
CapacityRoute_IF.Neutral.GSM.transmission.capacityUser-defined 
End Date % CongestedRoute_IF.Neutral.GSM.transmission.%_outgoing_congestionsbusy_hour 
End Date % UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationbusy_hour 
End Date Grade of ServiceRoute_IF.Neutral.GSM.transmission.grade_of_servicebusy_hour 
End Date Lost Traffic (E)Route_IF.Neutral.GSM.transmission.lost_trafficbusy_hour 
End Date Traffic (E)Route_IF.Neutral.GSM.transmission.trafficbusy_hour 
Forecast % UtilisationRoute_IF.Neutral.GSM.transmission.forecast.utilisationbusy_hour 
RouteRoute_IF.nameUser-defined 
SamplesRoute_IF.Neutral.GSM.transmission.number_of_samplesUser-defined 
Traffic (E)Route_IF.Neutral.GSM.transmission.trafficUser-defined 

Route Required Circuits Report

This report shows the forecast circuit requirements for a set of routes for three different forecast periods. The forecast can be dimensioned using Weekly BH, 3-DAV or 5-DAV values of carried or offered traffic. For all selected routes, the report shows the sample size, the correlation coefficient of the forecast, the actual and required number of circuits and the selected dimensioning parameter in the latest busy hour and then the required circuits and forecast traffic at periods of N1, N2 and N3 days ahead where N1, N2 and N3 are configurable but default to 60, 90 and 120. The report is always generated with weekly busy hour values.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC, Route_IF
Date RangingYes
Period SelectionWeekly
Summary Selectionbusy_hour, 3-day Average, 5-day Average
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Route Required Circuits Report (Table)
End Date Defined CircuitsRoute_IF.Neutral.GSM.transmission.circuitsbusy_hour 
End Date Grade Of ServiceRoute_IF.Neutral.GSM.transmission.grade_of_servicebusy_hour 
[N3] Days Forecast Extra CircuitsRoute_IF.Neutral.GSM.transmission.forecast.extra_circuitsUser-defined 
[N1] Days Forecast Required No. Of CircuitsRoute_IF.Neutral.GSM.transmission.forecast.required_circuitsUser-defined 
SamplesRoute_IF.Neutral.GSM.transmission.number_of_samplesUser-defined 
RouteRoute_IF.nameUser-defined 
Latest Actual Traffic (E)Route_IF.Neutral.GSM.transmission.trafficUser-defined 
Latest Actual Required No. Of CircuitsRoute_IF.Neutral.GSM.transmission.required_circuitsUser-defined 
End Date UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationbusy_hour 
End Date Lost Traffic (E)Route_IF.Neutral.GSM.transmission.lost_trafficbusy_hour 

Route Traffic Graph

This graph shows the traffic profile for a selected route.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRoute_IF
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Answer Seize Ratio (Line Chart)
% Answer Seize RatioRoute_IF.Neutral.GSM.transmission.%_outgoing_answeredUser-defined 
Component 2: Calls (Line Chart)
IncomingRoute_IF.Neutral.GSM.transmission.incoming_callsUser-defined 
OutgoingRoute_IF.Neutral.GSM.transmission.outgoing_callsUser-defined 
Component 3: Traffic (Line Chart)
IncomingRoute_IF.Neutral.GSM.transmission.incoming_trafficUser-defined 
OutgoingRoute_IF.Neutral.GSM.transmission.outgoing_trafficUser-defined 

Route Traffic Report

This report shows key route traffic statistics for either all routes or all routes in a specified region or all routes from a specified MSC or all routes of a certain type during a selected time period.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC, Route_IF
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionincoming_busy_hour, outgoing_busy_hour, busy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Bothway (Table)
% UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationUser-defined 
ASRRoute_IF.Neutral.GSM.transmission.%_bothway_answeredUser-defined 
Available CircuitsRoute_IF.Neutral.GSM.transmission.available_circuitsUser-defined 
Busy Hourbusy_hourbusy_hour 
CallsRoute_IF.Neutral.GSM.transmission.bothway_callsUser-defined 
CongestionRoute_IF.Neutral.GSM.transmission.%_outgoing_congestionsUser-defined 
Defined CircuitsRoute_IF.Neutral.GSM.transmission.circuitsUser-defined 
GOSRoute_IF.Neutral.GSM.transmission.grade_of_serviceUser-defined 
RouteRoute_IF.nameUser-defined 
TrafficRoute_IF.Neutral.GSM.transmission.bothway_trafficUser-defined 
Component 2: Incoming (Table)
ASRRoute_IF.Neutral.GSM.transmission.%_incoming_answeredUser-defined 
Busy Hourincoming_busy_hourincoming_busy_hour 
CallsRoute_IF.Neutral.GSM.transmission.incoming_callsUser-defined 
RouteRoute_IF.nameUser-defined 
TrafficRoute_IF.Neutral.GSM.transmission.incoming_trafficUser-defined 
Component 3: Outgoing (Table)
ASRRoute_IF.Neutral.GSM.transmission.%_outgoing_answeredUser-defined 
Busy Houroutgoing_busy_houroutgoing_busy_hour 
CallsRoute_IF.Neutral.GSM.transmission.outgoing_callsUser-defined 
CongestionsRoute_IF.Neutral.GSM.transmission.%_outgoing_congestionsUser-defined 
RouteRoute_IF.nameUser-defined 
TrafficRoute_IF.Neutral.GSM.transmission.outgoing_trafficUser-defined 

Route Utilisation Graph

This graph shows the trend in utilisation of a route: traffic (offered and carried), % utilisation and calculated GOS.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRoute_IF
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Utilisation (Line Chart)
Graph Overlay Value: User-defined
100% overlay
% UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationUser-defined 
Component 2: Carried Traffic (E) (Line Chart)
Critical Traffic (overlay)Route_IF.Neutral.GSM.transmission.capacityUser-defined 
Traffic (E)Route_IF.Neutral.GSM.transmission.bothway_trafficUser-defined 
Component 3: GoS (Line Chart)
Graph Overlay Value: User-defined
Desgin GOS overlay
Grade Of ServiceRoute_IF.Neutral.GSM.transmission.grade_of_serviceUser-defined 
Component 4: Offered Traffic (E) (Line Chart)
Critical Traffic (overlay)Route_IF.Neutral.GSM.transmission.capacityUser-defined 
Traffic (E)Route_IF.Neutral.GSM.transmission.offered_trafficUser-defined 

Signalling Linkset Exhaustion Report

This report shows all linksets that will reach exhaustion in the specified forecast. The report is always generated with weekly busy hour values. The user has the option to set the following run-time parameters: Nominal Maximum Traffic - Default value 0.4, Maximum In-Failure Traffic - Default value 0.8, Default Links In-Failure - Default value 1.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, Signalling_LinkSet, Signalling_Point
Date RangingYes
Period SelectionWeekly
Summary Selectionreceived_busy_hour, transmitted_busy_hour
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Exhaustion Report (Table)
CapacitySignalling_LinkSet.Neutral.GSM.signalling_linkset.capacityUser-defined 
Designed Link FailuresSignalling_LinkSet.Designed_Link_FailuresUser-defined 
Exhaustion DateSignalling_LinkSet.Neutral.GSM.forecast.linear_exhaustion_dateUser-defined 
In-Failure CapacitySignalling_LinkSet.Neutral.GSM.signalling_linkset.in_failure_capacityUser-defined 
Is ExhaustedSignalling_LinkSet.Neutral.GSM.signalling_linkset.is_exhaustedUser-defined 
LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
Linkset NameSignalling_LinkSet.nameUser-defined 
MSUsSignalling_LinkSet.Neutral.GSM.signalling_linkset.msusUser-defined 
SamplesSignalling_LinkSet.Neutral.GSM.signalling_linkset.number_of_samplesUser-defined 
TrafficSignalling_LinkSet.Neutral.GSM.signalling_linkset.trafficUser-defined 
Traffic ForecastSignalling_LinkSet.Neutral.GSM.forecast.trafficUser-defined 
Traffic GrowthSignalling_LinkSet.Neutral.GSM.forecast.linear_traffic_growthUser-defined 

SS7 Link Availability Graph

This graph shows the link availability for a selected SS7 link

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Link
Primary ObjectSignalling_Link
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_Link
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Total % Link Availability (Line Chart)
% Link AvailabilitySignalling_Link.Neutral.GSM.link.%_availableTotal 
Component 2: Total % Local Busy (Line Chart)
% Local BusySignalling_Link.Neutral.GSM.link.%_local_inhibition_timeTotal 
Component 3: Total Link Failures (Line Chart)
Link FailuresSignalling_Link.Neutral.GSM.link.failuresTotal 

SS7 Linkset Availability Graph Link KPIs

This graph shows the linkset availability of the constituent links for a selected SS7 linkset.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Total % Link Availability (Line Chart)
% Link AvailabilitySignalling_LinkSet.Neutral.GSM.signalling_linkset.mean_%_availableTotal 
Component 2: Total Link Failures (Line Chart)
Link FailuresSignalling_LinkSet.Neutral.GSM.signalling_linkset.total_failuresTotal 

SS7 Linkset Availability Graph Linkset KPIs

This graph shows the linkset availability for a selected SS7 linkset.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Total % Linkset Availability (Line Chart)
% Linkset AvailabilitySignalling_LinkSet.Neutral.GSM.signalling_linkset.%_availableTotal 
Component 2: Total Linkset Failures (Line Chart)
Linkset FailuresSignalling_LinkSet.Neutral.GSM.signalling_linkset.failuresTotal 

SS7 Linkset Utilisation Graph

This graph shows the linkset transmission and reception utilisation for a selected SS7 link.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionreceived_busy_hour, transmitted_busy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Signalling Linkset MSUs on Linkset (Line Chart)
RXSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_msusUser-defined 
TXSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msusUser-defined 
Component 2: Signalling Linkset Traffic (Octets) (Line Chart)
IncomingSignalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_trafficUser-defined 
OutgoingSignalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_trafficUser-defined 

SS7 Linkset Utilisation Report RX

This report shows the utilisation of a set of linksets through the traffic received on their constituent links.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, Signalling_LinkSet, Signalling_Point
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectionreceived_busy_hour, Total
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Utilisation Report (RX) (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 
RX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_incoming_trafficUser-defined 
RX Busy Hourreceived_busy_hourreceived_busy_hour 
RX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_msusUser-defined 
RX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.received_sif_siosUser-defined 
RX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.incoming_trafficUser-defined 

SS7 Linkset Utilisation Report TX

This report shows the utilisation of a set of linksets through the traffic transmitted on their constituent links.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, Signalling_LinkSet, Signalling_Point
Date RangingNo
Period SelectionDaily (Raw), Daily, Weekly, Monthly
Summary Selectiontransmitted_busy_hour, Total
FilteringSignalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverage (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: SS7 Linkset Utilisation Report (TX) (Table)
# LinksSignalling_LinkSet.Neutral.GSM.signalling_linkset.linksUser-defined 
LinksetSignalling_LinkSet.nameUser-defined 
TX Usage (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.outgoing_trafficUser-defined 
TX SIF/SIO OctetsSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_sif_siosUser-defined 
TX MSUSSignalling_LinkSet.Neutral.GSM.signalling_linkset.transmitted_msusUser-defined 
TX Busy Hourtransmitted_busy_hourtransmitted_busy_hour 
TX Average Link (Octets)Signalling_LinkSet.Neutral.GSM.signalling_linkset.mean_outgoing_trafficUser-defined 
Not displayed (for filtering only)Signalling_LinkSet.Neutral.GSM.signalling_linkset.%_data_coverageUser-defined 

SS7 Link Utilisation Graph

This graph shows the link utilisation for a selected SS7 link.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Link
Primary ObjectSignalling_Link
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_Link
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionreceived_busy_hour, transmitted_busy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: MSUs (Line Chart)
ReceivedSignalling_Link.Neutral.GSM.link.received_msusUser-defined 
TransmittedSignalling_Link.Neutral.GSM.link.transmitted_msusUser-defined 
Component 2: SIF and SIO Octets (Line Chart)
ReceivedSignalling_Link.Neutral.GSM.link.received_sif_siosUser-defined 
TransmittedSignalling_Link.Neutral.GSM.link.transmitted_sif_siosUser-defined 
Component 3: Traffic (Line Chart)
IncomingSignalling_Link.Neutral.GSM.link.incoming_trafficUser-defined 
OutgoingSignalling_Link.Neutral.GSM.link.outgoing_trafficUser-defined 

SS7 Routeset Availability Graph

This graph shows the routeset availability for a selected SS7 routeset

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Routeset
Primary ObjectSignalling_RouteSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_RouteSet
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary SelectionTotal
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: % Routeset Availability (Line Chart)
% AvailabilitySignalling_RouteSet.Neutral.GSM.routeset.%_availableUser-defined 
Component 2: Total Routeset Failures (Line Chart)
Total FailuresSignalling_RouteSet.Neutral.GSM.routeset.failuresUser-defined 

SS7 Signalling Linkset Traffic Forecast Graph

This chart allows the user to plot the weekly trend of either the busy hour received or transmitted traffic. It also plots a regression of the selected parameter extrapolated over a user-defined forecast period. The report is always generated with weekly busy hour values. The user has the option to set the following run-time parameters: Nominal Maximum Traffic - Default value 0.4, Maximum In-Failure Traffic - Default value 0.8, Default Links In-Failure - Default value 1.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Linkset
Primary ObjectSignalling_LinkSet
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionSignalling_LinkSet
Date RangingYes
Period SelectionWeekly
Summary Selectionreceived_busy_hour, transmitted_busy_hour
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Heading (Line Chart)
Coefficient of RegressionSignalling_LinkSet.Neutral.GSM.forecast.linear_regression_coefficientUser-defined 
Growth is {linear_traffic_growth}Signalling_LinkSet.Neutral.GSM.forecast.linear_traffic_growthUser-defined 
Linkset [will reach exhaustion on {linear_exhaustion_date}|will not reach exhaustion in this period]Signalling_LinkSet.Neutral.GSM.forecast.linear_exhaustion_dateUser-defined 
Standard Error of RegressionSignalling_LinkSet.Neutral.GSM.forecast.linear_regression_errorUser-defined 
Component 2: SS7 Signalling Linkset Traffic Forecast Graph (Line Chart)
CapacitySignalling_LinkSet.Neutral.GSM.forecast.capacityUser-defined 
Forecast TrafficSignalling_LinkSet.Neutral.GSM.forecast.trafficUser-defined 
TrafficSignalling_LinkSet.Neutral.GSM.signalling_linkset.trafficUser-defined 
In-Failure CapacitySignalling_LinkSet.Neutral.GSM.forecast.in_failure_capacityUser-defined 

Summary Route Traffic Report

This report shows key route traffic statistics for a set of routes in a selected time period. The report shows available & defined circuits, % congestion, carried traffic, offered traffic, lost traffic, critical traffic, 3-DAV and 5-DAV traffic, % utilisation and grade of service. The report is always generated with weekly busy hour values.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.Route
Primary ObjectRoute_IF
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionRegion, MSC, Route_IF
Date RangingNo
Period SelectionWeekly
FilteringRoute_IF.Neutral.GSM.transmission.traffic (min), Route_IF.Neutral.GSM.transmission.grade_of_service (min), Route_IF.Neutral.GSM.transmission.lost_traffic (min), Route_IF.Neutral.GSM.transmission.offered_utilisation (min)

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: Summary Route Traffic Report (Table)
3-DAV Summarised Carried Traffic (E)Route_IF.Neutral.GSM.transmission.traffic3-day Average 
5-DAV Summarised Carried Traffic (E)Route_IF.Neutral.GSM.transmission.traffic5-day Average 
Available CircuitsRoute_IF.Neutral.GSM.transmission.available_circuitsbusy_hour 
Blocking (%)Route_IF.Neutral.GSM.transmission.%_outgoing_congestionsbusy_hour 
Busy Hourbusy_hourbusy_hour 
CapacityRoute_IF.Neutral.GSM.transmission.capacitybusy_hour 
Carried Traffic (E)Route_IF.Neutral.GSM.transmission.trafficUser-defined 
Defined CircuitsRoute_IF.Neutral.GSM.transmission.circuitsbusy_hour 
Grade of ServiceRoute_IF.Neutral.GSM.transmission.grade_of_servicebusy_hour 
Lost Traffic (E)Route_IF.Neutral.GSM.transmission.lost_trafficbusy_hour 
Offered Traffic (E)Route_IF.Neutral.GSM.transmission.offered_trafficbusy_hour 
Offered UtilisationRoute_IF.Neutral.GSM.transmission.offered_utilisationbusy_hour 
RouteRoute_IF.nameUser-defined 

System Traffic MSC Graph

This graph shows the total switch traffic for the appropriate traffic categories totalled for all MSCs in the network.

Overview

Report FeatureDetails
Report Tree BranchGSM.Engineering.Core Network.System
Primary ObjectMSC
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object Selection 
Date RangingYes
Period SelectionRaw, Daily, Weekly, Monthly
Summary Selectionbusy_hour, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: System Traffic (MSC) Graph (Line Chart)
Traffic (E)MSC.Neutral.GSM.traffic.total_switched_traffic.trafficUser-defined 


11. Data Availability

This section lists the data availability definitions for the network objects previously described.

Grouping ObjectKPI TypeReporting ObjectDefining KPI Group
HLRHLRs ReportingHLRHLR.Neutral.GSM.access
MSCMSCs ReportingMSCMSC.Neutral.GSM.page