GPRS Siemens BSS BR8 Neutral Functional Specification

Data Export Date: 24 May 2007


1. Change History


IssueDateAuthorComments
1.027 April 2007IshakReleased


2. Document References


Document NameDateDocument ReferenceURL
Internal Documentation
Vallent Siemens BSS GPRS VN BR6Aug 2004 http://notesdoc/87256D28003200ED/0/18164BDA3C8562E987256EFC00354863/$file/VN_SIEMENS_GPRS_BSS_6_prs.html


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.

Bearer

Frame Relay bearers, used between a PCU and an SGSN in a GPRS network.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Bearer.STRING 
NameA user friendly name preferably unique for the Bearer.STRING 
PCUA unique identifier for the PCU.STRINGPCU
SGSNA unique identifier for the SGSN.STRINGSGSN
RegionRegion associated with the Bearer.STRINGRegion
NetworkNetwork associated with the Bearer.STRINGNetwork
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
CIRDesigned Committed Information Rate.STRING 
Node_IdA unique identifier for the Node.STRING 
Node_NameA user friendly name preferably unique for the Node.STRING 
Node_TypeType of Node.STRING 
VendorManufacturer of the Bearer.STRING 


Cell

The Cell handles the radio interface to the mobile station. The Cell is the radio equipment (transceivers and antennas) needed to service each cell in the network. A group of Cells is controlled by a BSC.

Attribute NameDescriptionTypeRelated Object
IDA unique identifier for the Cell.STRING 
NameA user friendly name preferably unique for the Cell.STRING 
BSA unique identifier for the BS at which the Cell is located. The BS at which the cell is located.STRINGBS
LACThe Location Area Code encompassing the Cell.STRINGLAC
PCUA unique identifier for the PCU.STRINGPCU
NSVCA unique identifier for the NSVC.STRINGNSVC
Routing_AreaA unique identifier for the Routing_Area.STRINGRouting_Area
Registration_AreaA unique identifier for the Registration_Area.STRINGRegistration_Area
BSCA unique identifier for the BSC.STRINGBSC
MSCA unique identifier for the MSC.STRINGMSC
SGSNA unique identifier for the SGSN.STRINGSGSN
RegionRegion associated with the Cell.STRINGRegion
NetworkNetwork associated with the Cell.STRINGNetwork
GPRS_CellA unique identifier for the Cell.STRINGCell
UMTS_CellA unique identifier for the Cell.STRINGCell
Cell_TypeIs the cell omni_directional, or a sector, or micro/pico/macro/umbrella cell, etc.STRING 
Defined_TRXNumber of defined TRX belonging to the cell.INTEGER 
Defined_TCHNumber of defined TCH channels of the Cell.INTEGER 
Defined_CCHNumber of defined CCH channels for the Cell.INTEGER 
Max_PowerThe bs_tx_pwr_max configuration attribute.FLOAT 
Segment_IdA unique identifier for the Segment.STRING 
Cell_VersionHardware/Software version of the Cell.STRING 
VendorManufacturer of the Cell.STRING 
TechnologyTechnology of the network/element (e.g. GSM, GPRS, UMTS).STRING 
NSVC_CN_IdA unique identifier for the NSVC CN.STRING 
BVC_IdA unique identifier for the BVC.STRING 
Defined_PDCHDesignated Packet Data Channel.INTEGER 
Dedicated_PDCHDedicated Packet Data Channel.INTEGER 
UTRAN_Absolute_Radio_Freq_ULUL UTRAN absolute Radio Frequency Channel number.STRING 
UTRAN_Absolute_Radio_Freq_DLDL UTRAN absolute Radio Frequency Channel number.STRING 
Primary_Scrambling_CodePrimary DL scrambling code.STRING 
Primary_Common_Pilot_Ch_PowerPrimary CPICH channel power.FLOAT 
Primary_Sync_Ch_PowerPrimary synchronisation channel power, DL.FLOAT 
Secondary_Sync_Ch_PowerSecondary synchronisation channel power, DL.STRING 
BCH_PowerBroadcast channel power.STRING 
Cell_DescriptionDescription of Cell.STRING 


4.2 Reference Objects

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

Not applicable to this tech pack.


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:


Cell Busy Hours

Busy Hour NameAcronymDefining KPI
RLC_Traffic_DL_Busy_HourcpdbhCell.Neutral.GPRS.RLC.RLC_DATA_BLOCKS_DL
Cell_max_RLC_Busy_HourcmrlcbhCell.Neutral.GPRS.RLC.RLC_max_UL_DL


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
RLC_Raw_Blocksize_CS1RLC_Raw_Blocksize_CS1bits181
RLC_Raw_Blocksize_CS2RLC_Raw_Blocksize_CS2bits268
RLC_Raw_Blocksize_CS3RLC_Raw_Blocksize_CS3bits312
RLC_Raw_Blocksize_CS4RLC_Raw_Blocksize_CS4bits428
RLC_Raw_Rate_CS1RLC_Raw_Rate_CS1kb/s9.05
RLC_Raw_Rate_CS2RLC_Raw_Rate_CS2kb/s13.4
RLC_Raw_Rate_CS3RLC_Raw_Rate_CS3kb/s15.6
RLC_Raw_Rate_CS4RLC_Raw_Rate_CS4kb/s21.4
RLC_User_Blocksize_CS1RLC_User_Blocksize_CS1bits160
RLC_User_Blocksize_CS2RLC_User_Blocksize_CS2bits240
RLC_User_Blocksize_CS3RLC_User_Blocksize_CS3bits288
RLC_User_Blocksize_CS4RLC_User_Blocksize_CS4bits400
RLC_User_Rate_CS1RLC_User_Rate_CS1kb/s8.0
RLC_User_Rate_CS2RLC_User_Rate_CS2kb/s12.0
RLC_User_Rate_CS3RLC_User_Rate_CS3kb/s14.40
RLC_User_Rate_CS4RLC_User_Rate_CS4kb/s20.0


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.


Cell Performance Indicators

Cell.Neutral.GPRS.PDCH

KPI NameDescriptionData TypeUnitsExpressionAdditional Summaries
%_data_coverage FLOAT%getvalidity({AVE_GPRS_TERRITORY}) 
AVE_GPRS_TERRITORYAverage number of radia time slots allocated for GPRS useFLOATTime Slotcell_pdch_raw.ave_gprs_territorycmrlcbh, cpdbh, cpubh, pmrlcbh
AVE_PDCH_CARRYING_TRAFFICAverage number of PDCHs carrying packetsFLOATTime Slotcell_pdch_raw.ave_traffic_pdchcmrlcbh, cpdbh, cpubh, pmrlcbh
AVAIL_DEDICATED_PDCHNumber of dedicated GPRS territoryFLOATTime Slotcell_pdch_raw.avail_dedicated_pdchcmrlcbh, cpdbh, cpubh, pmrlcbh
GPRS_TER_UG_REQUESTNumber of territory upgrade requests that have been attemptedINT8#cell_pdch_raw.gprs_ter_ug_requestcmrlcbh, cpdbh, cpubh, pmrlcbh
GPRS_TER_DG_REQUESTNumber of territory downgrade requests that have been attemptedINT8#cell_pdch_raw.gprs_ter_dg_requestcmrlcbh, cpdbh, cpubh, pmrlcbh
GPRS_TER_UG_REJECTNumber of territory upgrade requests that have been rejectedINT8#cell_pdch_raw.gprs_ter_ug_rejectcmrlcbh, cpdbh, cpubh, pmrlcbh
PDCH_REQUESTNumber of packet channel requestedINT8#cell_pdch_raw.pdch_requestcmrlcbh, cpdbh, cpubh, pmrlcbh
PDCH_REJECTNumber of packet channel rejectedINT8#cell_pdch_raw.pdch_rejectcmrlcbh, cpdbh, cpubh, pmrlcbh
DL_TBF_ATTEMPTNumber of downlink TBFs attemptINT8#no mapping available.cpdbh, cpubh
UL_TBF_ESTABLISHEDNumber of established uplink TBFsINT8#cell_pdch_raw.ul_tbf_establishedcmrlcbh, cpdbh, cpubh, pmrlcbh
DL_TBF_ESTABLISHEDNumber of esblished downlink TBFsINT8#cell_pdch_raw.dl_tbf_establishedcmrlcbh, cpdbh, cpubh, pmrlcbh
UL_TBF_REJECTNumber of rejected uplink TBF establishmentsINT8#cell_pdch_raw.ul_tbf_rejectcmrlcbh, cpdbh, cpubh, pmrlcbh
DL_TBF_REJECTNumber of rejected downlink TBF establishmentsINT8#cell_pdch_raw.dl_tbf_rejectcmrlcbh, cpdbh, cpubh, pmrlcbh
LLC_BLOCKS_DLNumber of LLC blocks in downlinkINT8#cell_pdch_raw.llc_blocks_dlcmrlcbh, cpdbh, cpubh, pmrlcbh
LLC_BLOCKS_INT_BKG_DLNumber of LLC blocks in Downlink for interactive and backgroundINT8#no mapping availablecpdbh, cpubh
LLC_BLOCKS_STRM_DLNumber of LLC blocks in Downlink for streamingINT8#no mapping availablecpdbh, cpubh
LLC_BLOCKS_ULNumber of LLC blocks in uplinkINT8#cell_pdch_raw.llc_blocks_ulcmrlcbh, cpdbh, cpubh, pmrlcbh
LLC_BLOCKS_INT_BKG_ULNumber of LLC blocks in uplink for interactive and backgroundINT8#no mapping available.cpdbh, cpubh
LLC_BLOCKS_STRM_ULNumber of LLC blocks in uplink for streamingINT8#no mapping available.cpdbh, cpubh
CS_PAGING_ATTEMPTSThis message is sent from BSC/PCU to BTS requests CS paging of a GPRS MSINT8#cell_pdch_raw.cs_paging_attemptscmrlcbh, cpdbh, cpubh, pmrlcbh
PS_PAGING_ATTEMPTSThis message is sent from BSC_PCU to BTS to request PS paging of a GPRS MSINT8#cell_pdch_raw.ps_paging_attemptscmrlcbh, cpdbh, cpubh, pmrlcbh
%_CS_PAGING_ATTEMPTS% request CS paging of a GPRS MS.FLOAT% cpdbh, cpubh
%_PS_PAGING_ATTEMPTS% request PS paging of a GPRS MS.FLOAT% cpdbh, cpubh
LLC_DATA_Throughput_DLEstimated rate of the user data transmitted on the LLC DL. This estimate counter is based on the size maximum of LLC block (cf. 1520)FLOATkbit/scell_pdch_raw.llc_data_throughput_dlcmrlcbh, cpdbh, cpubh, pmrlcbh
LLC_DATA_Throughput_ULEstimated rate of the user data transmitted on the LLC UL. This estimate counter is based on the size maximum of the LLC block (cf. 1520)FLOATkbit/scell_pdch_raw.llc_data_throughput_ulcmrlcbh, cpdbh, cpubh, pmrlcbh


Cell.Neutral.GPRS.RLC

KPI NameDescriptionData TypeUnitsExpressionAdditional Summaries
%_data_coverage FLOAT%getvalidity({RLC_DATA_BLOCKS_DL}) 
RLC_DATA_BLOCKS_DLNumber of transmitted RLC data blocks downlink for all CS (CS1 to CS4)INT8#cell_rlc_1_raw.rlc_data_blocks_dlcmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_ULNumber of transmitted RLC data blocks uplink for all CS (CS1 to CS4)INT8#cell_rlc_1_raw.rlc_data_blocks_ulcmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_DL_CS1Number of transmitted RLC data blocks downlink CS1INT8#cell_rlc_1_raw.rlc_data_blocks_dl_cs1cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_UL_CS1Number of transmitted RLC data blocks uplink CS1INT8#cell_rlc_1_raw.rlc_data_blocks_ul_cs1cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_DL_CS2Number of transmitted RLC data blocks downlink CS2INT8#cell_rlc_1_raw.rlc_data_blocks_dl_cs2cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_UL_CS2Number of transmitted RLC data blocks uplink CS2INT8#cell_rlc_1_raw.rlc_data_blocks_ul_cs2cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_DL_CS3Number of transmitted RLC data blocks downlink CS3INT8#cell_rlc_1_raw.rlc_data_blocks_dl_cs3cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_UL_CS3Number of transmitted RLC data blocks uplink CS3INT8#cell_rlc_1_raw.rlc_data_blocks_ul_cs3cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_DL_CS4Number of transmitted RLC data blocks downlink CS4INT8#cell_rlc_1_raw.rlc_data_blocks_dl_cs4cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_BLOCKS_UL_CS4Number of transmitted RLC data blocks uplink CS4INT8#cell_rlc_1_raw.rlc_data_blocks_ul_cs4cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_DLNumber of retransmitted RLC data blocks downlink for all CS (CS1 to CS4)INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_ULNumber of retransmitted RLC data blocks uplink for all CS (CS1 to CS4)INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_DL_CS1Number of re-transmitted RLC data blocks downlink for CS1INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_UL_CS1Number of re-transmitted RLC data blocks uplink for CS1INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_DL_CS2Number of re-transmitted RLC data blocks downlink for CS2INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_UL_CS2Number of re-transmitted RLC data blocks uplink for CS2INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_DL_CS3Number of re-transmitted RLC data blocks downlink for CS3INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_UL_CS3Number of re-transmitted RLC data blocks uplink for CS3INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_DL_CS4Number of re-transmitted RLC data blocks downlink for CS4INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RETRA_RLC_DATA_BLOCKS_UL_CS4Number of re-transmitted RLC data blocks uplink for CS4INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_CNTRL_BLOCKS_DLNumber of RLC control blocks in Downlink (including re-transmitted)INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_CNTRL_BLOCKS_ULNumber of RLC control blocks in uplink (including re-transmitted)INT8# cmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_Throughput_DLRate of the user data transmitted on the RLC DLFLOAT#cell_rlc_2_raw.rlc_data_throughput_dlcmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_DATA_Throughput_ULRate of the user data transmitted on the RLC ULFLOAT#cell_rlc_2_raw.rlc_data_throughput_ulcmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_cntrl_Throughput_DLRate of the Control data transmitted on the RLC DLFLOAT#cell_rlc_2_raw.rlc_cntrl_throughput_dlcmrlcbh, cpdbh, cpubh, pmrlcbh
RLC_cntrl_Throughput_ULRate of the Control data transmitted on the RLC ULFLOAT#cell_rlc_2_raw.rlc_cntrl_throughput_ulcmrlcbh, cpdbh, cpubh, pmrlcbh
%_RLC_CNTRL_BLOCK_DLPercentage of the Control data transmitted on the RLC DLFLOAT# cmrlcbh, cpdbh, cpubh, pmrlcbh
%_RLC_CNTRL_BLOCK_ULPercentage of the Control data transmitted on the RLC ULFLOAT# cmrlcbh, cpdbh, cpubh, pmrlcbh
%_RLC_Raw_DL_UtilisationActual percentage of achieved throughput compare to the raw maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT% cpdbh, cpubh
%_RLC_Raw_UL_UtilisationActual percentage of achieved throughput compare to the raw maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT% cpdbh, cpubh
%_RLC_DATA_DL_UtilisationActual percentage of achieved throughput compare to the user maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT% cpdbh, cpubh
%_RLC_DATA_UL_UtilisationActual percentage of achieved throughput compare to the user maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT% cpdbh, cpubh
RLC_Raw_Throughput_DLRate of the transmitted, re-transmitted and control data on the RLC DLFLOATKbit/s cpdbh, cpubh
RLC_Raw_Throughput_ULRate of the transmitted, re-transmitted and control data on the RLC ULFLOATKbit/s cpdbh, cpubh
RLC_max_UL_DLMaximum of transmitted RLC data blocks downlink or uplink for all CS (CS1 to CS4)FLOAT#cell_rlc_1_raw.rlc_max_ul_dlcmrlcbh, pmrlcbh
%_RLC_DATA_DL_UTILISATIONActual percentage of achieved throughput compare to the user maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT# cmrlcbh, pmrlcbh
%_RLC_RAW_DL_UTILISATIONActual percentage of achieved throughput compare to the raw maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT# cmrlcbh, pmrlcbh
%_RLC_DATA_UL_UTILISATIONActual percentage of achieved throughput compare to the user maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT# cmrlcbh, pmrlcbh
RLC_RAW_THROUGHPUT_DLRate of the transmitted, re-transmitted and control data on the RLC DLFLOAT# cmrlcbh, pmrlcbh
RLC_RAW_THROUGHPUT_ULRate of the transmitted, re-transmitted and control data on the RLC ULFLOAT# cmrlcbh, pmrlcbh
%_RLC_RAW_UL_UTILISATIONActual percentage of achieved throughput compare to the raw maximum throughput achievable given the number of Time slot available and the Coding Schemes usedFLOAT#  



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_bearer

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
bearer_idVARCHAR(50) [NSVC] NAMEBSC&"-"&NAMEPCU
pcu_idVARCHAR(50) [NSVC] NAMEBSC&"-"&NAMEPCU
sgsn_idVARCHAR(50) [NSVC] lookup("nc_bsc","sgsn_id",utime(ENDDATE & ENDTIME,"%d %b %Y %R") - (GRANULARITY*60), NAMEBSC)
node_idVARCHAR(50) [NSVC] BSS_ID
region_idVARCHAR(50) [NSVC] lookup("nc_bsc","region_id",utime(ENDDATE & ENDTIME,"%d %b %Y %R") - (GRANULARITY*60), BSS_ID)
network_idVARCHAR(50) [NSVC] "PLMN"
timestampINTEGER 
endstampINTEGER 
vendor_idVARCHAR(50) [NSVC] "Siemens"
bearer_nameVARCHAR(255) [NSVC] NAMEBSC&"-"&NAMEPCU
technologyVARCHAR(50) [NSVC] "GPRS"
cirVARCHAR(50) [NSVC] CIR
node_nameVARCHAR(255) [NSVC] BSS_ID
node_typeVARCHAR(50) [NSVC] "BSC"


nc_cell

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
cell_idVARCHAR(50) [SCANBTS] CEL_ID
gprs_cell_idVARCHAR(50) 
umts_cell_idVARCHAR(50) 
bs_idVARCHAR(50) [SCANBTS] BSS_ID&"-"&BTSM_ID
bsc_idVARCHAR(50) [SCANBTS] BSS_ID
pcu_idVARCHAR(50) [SCANBTS] NAMEBSC&"-"&PCUN
nsvc_idVARCHAR(50) [SCANBTS] NAMENSVC
lac_idVARCHAR(50) 
routing_area_idVARCHAR(50) 
msc_idVARCHAR(50) [SCANBTS] lookup("nc_bsc","msc_id",utime(ENDDATE & ENDTIME,"%d %b %Y %R") - (GRANULARITY*60),BSS_ID)
sgsn_idVARCHAR(50) [SCANBTS] lookup("nc_bsc","sgsn_id",utime(ENDDATE & ENDTIME,"%d %b %Y %R") - (GRANULARITY*60), BSS_ID)
region_idVARCHAR(50) [SCANBTS] lookup("nc_bsc","region_id",utime(ENDDATE & ENDTIME,"%d %b %Y %R") - (GRANULARITY*60), BSS_ID)
network_idVARCHAR(50) [SCANBTS] "PLMN"
timestampINTEGER 
endstampINTEGER 
cell_nameVARCHAR(255) [SCANBTS] CEL_ID
cell_typeVARCHAR(50) [SCANBTS] if (CELLTYPE=2) then "Extended" else if (CELLTYPE=1) then "Concentric" else "Standard"
cell_descriptionVARCHAR(255) 
registration_area_idVARCHAR(50) 
max_powerVARCHAR(50) [SCANBTS] power
defined_trxVARCHAR(50) [SCANBTS] Defined_TRX
defined_tchVARCHAR(50) [SCANBTS] C1_16_2
defined_cchVARCHAR(50) [SCANBTS] C1_15_2
segment_idVARCHAR(50) 
cell_versionVARCHAR(50) [SCANBTS] "BR8.0"
vendorVARCHAR(50) [SCANBTS] "Siemens"
technologyVARCHAR(50) 


nc_cell_gprs_ext

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
cell_idVARCHAR(50) 
timestampINTEGER 
endstampINTEGER 
nsvc_cn_idVARCHAR(50) 
bvc_idVARCHAR(50) 
defined_pdchVARCHAR(50) 
dedicated_pdchVARCHAR(50) 


nc_cell_umts_ext

Column NameData TypeLoader Block/Mapping
nc_idSERIAL 
cell_idVARCHAR(50) 
timestampINTEGER 
endstampINTEGER 
uarfcnulVARCHAR(50) 
uarfcndlVARCHAR(50) 
primscrmblcdVARCHAR(50) 
primcpichpwrVARCHAR(50) 
primschpwrVARCHAR(50) 
secschpwrVARCHAR(50) 
bchpowerVARCHAR(50) 


nc_bearer_sec

Column NameData TypeLoader Block/Mapping
bearer_idVARCHAR(50)n/a
pcu_idVARCHAR(50)n/a
sgsn_idVARCHAR(50)n/a
timestampINTEGERn/a
endstampINTEGERn/a


nc_cell_sec

Column NameData TypeLoader Block/Mapping
cell_idVARCHAR(50)n/a
bs_idVARCHAR(50)n/a
lac_idVARCHAR(50)n/a
routing_area_idVARCHAR(50)n/a
pcu_idVARCHAR(50)n/a
nsvc_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 Cell Tables

cell_pdch_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [SCANGPRS] CEL_ID
[BTSGPRSMEAS] CEL_ID
[SCANBTSE] CEL_ID
dayINTEGER 
ave_gprs_territoryVARCOUNTER [SCANGPRS] C9_0_3
ave_traffic_pdchVARCOUNTER [BTSGPRSMEAS] MEALPDCO
avail_dedicated_pdchVARCOUNTER 
gprs_ter_ug_requestVARCOUNTER [SCANGPRS] C9_21_1 + C9_21_3
gprs_ter_dg_requestVARCOUNTER [SCANGPRS] C9_21_2 + C9_21_4
gprs_ter_ug_rejectVARCOUNTER 
pdch_requestVARCOUNTER [SCANGPRS] C9_2_1 + C9_2_2
pdch_rejectVARCOUNTER [SCANGPRS] C9_2_1 + C9_2_2 - C9_3_1 + C9_3_2
ul_tbf_establishedVARCOUNTER [SCANGPRS] C9_13_1
dl_tbf_establishedVARCOUNTER [SCANGPRS] C9_13_3
ul_tbf_rejectVARCOUNTER [SCANGPRS] NTBFRJC_1
dl_tbf_rejectVARCOUNTER [SCANGPRS] NTBFRJC_2
llc_blocks_dlVARCOUNTER 
llc_blocks_ulVARCOUNTER 
cs_paging_attemptsVARCOUNTER [SCANBTSE] NTDPMAIN
ps_paging_attemptsVARCOUNTER [BTSGPRSMEAS] NATGPPAG_1 + NATGPPAG_2
llc_data_throughput_dlVARCOUNTER [SCANGPRS] ((C9_22_1*1520) / granularity*60) / 1024
llc_data_throughput_ulVARCOUNTER [SCANGPRS] ((C9_22_2*1520) / granularity*60) / 1024


cell_rlc_1_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [SCANGPRS] CEL_ID
[BTSGPRSMEAS] CEL_ID
dayINTEGER 
rlc_data_blocks_dlVARCOUNTER [SCANGPRS] C9_19_14 + C9_19_15 + C9_19_16 + C9_19_17
rlc_data_blocks_ulVARCOUNTER [SCANGPRS] C9_19_1 + C9_19_2 + C9_19_3 + C9_19_4
rlc_data_blocks_dl_cs1VARCOUNTER [SCANGPRS] C9_19_14
rlc_data_blocks_ul_cs1VARCOUNTER [SCANGPRS] C9_19_1
rlc_data_blocks_ul_cs2VARCOUNTER [SCANGPRS] C9_19_2
retra_rlc_data_blocks_dlVARCOUNTER 
retra_rlc_data_blocks_ulVARCOUNTER 
retra_rlc_data_blocks_dl_cs1VARCOUNTER 
retra_rlc_data_blocks_dl_cs2VARCOUNTER 
rlc_data_blocks_dl_cs2VARCOUNTER [SCANGPRS] C9_19_15
rlc_cntrl_blocks_dlVARCOUNTER 
rlc_cntrl_blocks_ulVARCOUNTER 
rlc_max_ul_dlVARCOUNTER [BTSGPRSMEAS] if (MSTHRF_1 > MSTHRF_2) then MSTHRF_1 else MSTHRF_2


cell_rlc_2_raw

Column NameData TypeLoader Block/Mapping
nc_idINTEGER 
cell_idVARCHAR(50) [SCANGPRS] CEL_ID
[BTSGPRSMEAS] CEL_ID
dayINTEGER 
retra_rlc_data_blocks_ul_cs2VARCOUNTER 
retra_rlc_data_blocks_dl_cs3VARCOUNTER 
retra_rlc_data_blocks_ul_cs3VARCOUNTER 
retra_rlc_data_blocks_dl_cs4VARCOUNTER 
retra_rlc_data_blocks_ul_cs4VARCOUNTER 
rlc_data_throughput_dlVARCOUNTER [BTSGPRSMEAS] MUTHRF_1 / 1024
rlc_data_throughput_ulVARCOUNTER [SCANGPRS] BTSGPRSMEASMUTHRF_2 / 1024
rlc_data_blocks_dl_cs3VARCOUNTER [SCANGPRS] C9_19_16
rlc_data_blocks_dl_cs4VARCOUNTER [SCANGPRS] C9_19_17
rlc_data_blocks_ul_cs4VARCOUNTER [SCANGPRS] C9_19_4
retra_rlc_data_blocks_ul_cs1VARCOUNTER 
rlc_cntrl_throughput_dlVARCOUNTER [BTSGPRSMEAS] MSTHRF_1 / 1024
rlc_cntrl_throughput_ulVARCOUNTER [BTSGPRSMEAS] MSTHRF_2 / 1024
rlc_data_blocks_ul_cs3VARCOUNTER [SCANGPRS] C9_19_3


8.3 Views

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

nc_bearer_bsc_v

SELECT Statement
SELECT nc_id,
bearer_id,
pcu_id,
sgsn_id,
node_id,
region_id,
network_id,
timestamp,
vendor_id,
bearer_name,
technology,
cir,
node_name,
node_type
FROM nc_bearer
WHERE LOWER(node_type) = "bsc";
Column NameData Type
nc_idINTEGER
bearer_idVARCHAR(50)
pcu_idVARCHAR(50)
sgsn_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
vendor_idVARCHAR(50)
bearer_nameVARCHAR(255)
technologyVARCHAR(50)
cirVARCHAR(50)
node_nameVARCHAR(255)
node_typeVARCHAR(50)


nc_bearer_pcu_v

SELECT Statement
SELECT nc_id,
bearer_id,
pcu_id,
sgsn_id,
node_id,
region_id,
network_id,
timestamp,
vendor_id,
bearer_name,
technology,
cir,
node_name,
node_type
FROM nc_bearer
WHERE LOWER(node_type) = "pcu";
Column NameData Type
nc_idINTEGER
bearer_idVARCHAR(50)
pcu_idVARCHAR(50)
sgsn_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
vendor_idVARCHAR(50)
bearer_nameVARCHAR(255)
technologyVARCHAR(50)
cirVARCHAR(50)
node_nameVARCHAR(255)
node_typeVARCHAR(50)


nc_bearer_sgsn_v

SELECT Statement
SELECT nc_id,
bearer_id,
pcu_id,
sgsn_id,
node_id,
region_id,
network_id,
timestamp,
vendor_id,
bearer_name,
technology,
cir,
node_name,
node_type
FROM nc_bearer
WHERE LOWER(node_type) = "sgsn";
Column NameData Type
nc_idINTEGER
bearer_idVARCHAR(50)
pcu_idVARCHAR(50)
sgsn_idVARCHAR(50)
node_idVARCHAR(50)
region_idVARCHAR(50)
network_idVARCHAR(50)
timestampINTEGER
vendor_idVARCHAR(50)
bearer_nameVARCHAR(50)
technologyVARCHAR(50)
cirVARCHAR(50)
node_nameVARCHAR(255)
node_typeVARCHAR(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:

Radio Voice & Packet Traffic Overview

This graph shows a glimpse of the key performance data for a single cell on selected days.

Overview

Report FeatureDetails
Report Tree BranchSystem.GPRS.Engineering.Radio.Neutral.Cell
Primary ObjectCell
Drill-down Behaviour 

Report Parameters

ParameterOptions
Object SelectionCell
Date RangingYes
Period SelectionRaw, Daily (Raw), Daily, Weekly, Monthly
Summary SelectionRLC_Traffic_DL_Busy_Hour, RLC_Traffic_UL_Busy_Hour, Average, Total
Filtering 

Report Components

LabelAttribute/KPISummary TypeOverlay
Component 1: BSS Information (Table)
Cell IdCell.idUser-defined 
Cell NameCell.nameUser-defined 
Defined CCHCell.Defined_CCHUser-defined 
Defined TCHCell.Defined_TCHUser-defined 
PCU IdCell.PCUUser-defined 
Dedicated PDCHCell.Dedicated_PDCHUser-defined 
Component 2: PDCH (Line Chart)
RequestCell.Neutral.GPRS.PDCH.PDCH_REQUESTUser-defined 
RejectCell.Neutral.GPRS.PDCH.PDCH_REJECTUser-defined 
Component 3: RLC Data Blocks (Line Chart)
DownlinkCell.Neutral.GPRS.RLC.RLC_DATA_BLOCKS_DLUser-defined 
UplinkCell.Neutral.GPRS.RLC.RLC_DATA_BLOCKS_ULUser-defined 
Component 4: TBF (Line Chart)
AttemptCell.Neutral.GPRS.PDCH.DL_TBF_ATTEMPTUser-defined 
EstablishedCell.Neutral.GPRS.PDCH.DL_TBF_ESTABLISHEDUser-defined 
RejectCell.Neutral.GPRS.PDCH.DL_TBF_REJECTUser-defined 


11. Data Availability

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

None.