g_bssreport.sql.bak

移动通信网中摩托罗拉BSC话务统计分析软件,实现原始话统文件导入SQL SERVER2000数据库,极大方便后期分析.做摩托无线维护的同志必备.

CREATE TABLE G_BssReport
(
MyType                                           char(20), 
MyDate                                           datetime,
MyTime                                           char(4),
BSS                                              char(30),
SDCCH_Access_Success_Rate                        float,
Call_Setup_Success_Rate                          float,
Drop_Call_Rate                                   float,
TCH_RF_Lost_Rate                                 float,
SDCCH_RF_Lost_Rate                               float,
HO_Per_Call                                      float,
TCH_Blocking_Rate                                float,
TCH_Erlang                                       float,
TCH_Mean_Holding_Time                            float,
SDCCH_Blocking_Rate                              float,
SDCCH_Erlang                                     float,
SDCCH_Mean_Holding_Time                          float,
Total_Calls1                                     float,
Total_Lost                                       float,
TCH_RF_Lost                                      float,
HO_Lost                                          float,
Mean_Time_Between_Drops                          float,
Available_TCH_Mean                               float,
Available_SDCCH_Mean                             float,
HO_Lost_Call_Rate                                float,
HO_Failure_Rate                                  float,
HO_Failure                                       float,
Inter_Bss_HO_Drop_Call                           float,
Pages_Per_Second                                 float,
Page_Success_Rate                                float,
Assignment_Failure_Rate                          float,
Ratio_Intra_Cell_HO_To_HOs                       float,
Ratio_Intra_Bss_HO_To_HOs                        float,
Ratio_Inter_Bss_HO_To_HOs                        float,
Ratio_Intra_Cell_HO_Lost_To_HO_attempts          float,
Ratio_Intra_Bss_HO_Lost_To_HO_attempts           float,
Ratio_Inter_Bss_HO_Lost_To_HO_attempts           float,
Ratio_Intra_Cell_HO_Failure_To_HO_attempts       float,
Ratio_Intra_Bss_HO_Failure_To_HO_attempts        float,
Ratio_Inter_Bss_HO_Failure_To_HO_attempts        float,
Ratio_Ohoa_upqual_HO_Causes                      float,
Ratio_Ohoa_downqual_HO_Causes                    float,
Ratio_Ohoa_powerbdgt_HO_Causes                   float,
Mean_Time_Between_Handovers                      float,
Ratio_Ohoa_bandhandover_HO_Causes                float,
Call_Duration                                    float,
SMSs_Per_Call                                    float,
Handovers_Per_Call                               float,
Imsi_Detach_To_Calls                             float,
Ratio_Of_Sms_To_Calls                            float,
Location_Updates_To_Calls                        float,
Location_Update_Factor                           float,
rf_losses_sd                                     float,
ok_acc_proc                                      float,
rf_loss_tch_roll                                 float,
total_calls2                                     float,
i_inter_bs_ho_suc                                float,
i_intra_bs_ho_suc                                float,
intra_cell_ho_los                                float,
intra_cell_ho_atm                                float,
o_intra_bs_ho_los                                float,
o_inter_bs_ho_atm                                float,
o_intra_bs_ho_atm                                float,
o_inter_bs_ho_ret                                float,
o_intra_bs_ho_ret                                float,
o_inter_bs_ho_clr                                float,
alloc_sdcch                                      float,
alloc_sdcch_fail                                 float,
alloc_tch                                        float,
alloc_tch_fail                                   float,
cong_assn_ho_suc                                 float,
cm_serv_req_call                                 float,
cm_serv_req_emerg                                float,
cm_serv_req_sms                                  float,
page_response                                    float,
sms_init_on_sdcch                                float,
page_req_from_msc                                float,
access_per_pch                                   float,
pch_page_q_discrd                                float,
ok_acc_proc_suc_r                                float,
avail_sdcch_mean                                 float,
busy_sdcch_max                                   float,
busy_sdcch_mean                                  float,
sdcch_congestion                                 float,
chan_req_caus_atm                                float,
chan_req_fail_rol                                float,
cm_serv_req_supp1                                float,
cm_reestablish                                   float,
location_update                                  float,
imsi_detach                                      float,
busy_tch_mean                                    float,
busy_tch_max                                     float,
idl_tch_bnd0_mean                                float,
idl_tch_bnd1_mean                                float,
idl_tch_bnd2_mean                                float,
idl_tch_bnd3_mean                                float,
cong_exist_ho_atm                                float,
cong_stand_ho_atm                                float,
ma_cmd_to_ms_blkd                                float,
calls_queued                                     float,
intra_bss                                        float,
inter_bss                                        float,
intra_cell                                       float,
mat_pgsm_only                                    float,
mat_dcs1800_only                                 float,
mat_dcs2000_only                                 float,
mat_pgsm_egsm                                    float,
mat_pgsm_dcs1800                                 float,
mat_pegsm_dcs1800                                float,
mat_pgsm_dcs2000                                 float,
mat_pegsm_dcs2000                                float,
mtu_pgsm_only                                    float,
mtu_dcs1800_only                                 float,
mtu_dcs2000_only                                 float,
mtu_pgsm_egsm                                    float,
mtu_pgsm_dcs1800                                 float,
mtu_pegsm_dcs1800                                float,
mtu_pgsm_dcs2000                                 float,
mtu_pegsm_dcs2000                                float,
ia_pgsm_ho_atm                                   float,
ia_egsm_ho_atm                                   float,
ia_dcs1800_atm                                   float,
ia_dcs2000_atm                                   float,
ia_pgsm_ho_fail                                  float,
ia_egsm_ho_fail                                  float,
ia_dcs1800_fail                                  float,
ia_dcs2000_fail                                  float,
ia_invld_frq_as                                  float,
ia_invld_frq_ho                                  float,
inv_est_cause_rach                               float,
cipher_mode_fail                                 float,
conn_req_to_msc                                  float,
ma_req_from_msc                                  float,
conn_refused                                     float,
ma_fail_from_ms                                  float,
sec_assign_atmpt                                 float,
sec_assign_suc                                   float,
ma_complet_to_msc                                float,
bad_ho_refnum_ms                                 float,
intra_cell_ho_req                                float,
intra_cell_ho_suc                                float,
intra_cell_ho_ret                                float,
o_intra_bs_ho_req                                float,
o_intra_bs_ho_pri                                float,
o_intra_bs_ho_suc                                float,
_intra_bs_ho_clr                                 float,
o_inter_bs_rq_msc                                float,
o_inter_bs_ho_suc                                float,
i_intra_bs_ho_ret                                float,
i_intra_bs_eq_fa                                 float,
i_intra_bs_ho_los                                float,
i_intra_bs_ho_clr                                float,
i_inter_bs_eq_fa                                 float,
i_inter_bs_ms_ns                                 float,
i_inter_bs_ho_clr                                float,
ho_req_msc_ok                                    float,
ho_req_msc_fail                                  float,
ohoa_upqual                                      float,
ohoa_uplevel                                     float,
ohoa_downqual                                    float,
ohoa_downlevel                                   float,
ohoa_distance                                    float,
ohoa_upinterf                                    float,
ohoa_downinterf                                  float,
ohoa_powerbdgt                                   float,
ohoa_congestion                                  float,
ohoa_adj_chn_intf                                float,
ohoa_band_reasign                                float,
ohoa_bandhandover                                float,
tch_congestion                                   float,
ma_cmd_to_ms                                     float,
out_ho_caus_atmpt                                float,
cm_lcs_request                                   float,
mb_reassgn_ho                                    float,
loc_flw_req_sms                                  float,
sms_init_sdcch_ho                                float,
cm_serv_req_supp2                                float,
chan_req_ms_blk                                  float,
dr_retry_ho                                      float,
assgn_ho                                         float,
mt_lcs_on_sdcch                                  float,
rf_los_tch_hr_amr                                float,
assgn_res_req                                    float,
ho_req                                           float,
bsy_tch_h_amr_mean                               float,
paging_reqs_tot                                  float,
paging_reqs_cs                                   float,
assgn_redirect                                   float,
sms_init_on_tch                                  float,
sms_no_bcast_msg                                 float,
avail_tch_mean                                   float,
)