g_cellreport.txt.bak

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

CREATE TABLE G_CellReport
(
MyType                                                  char(20),
MyDate                                                  datetime,
MyTime                                                  char(4),
Cell                                                    char(30),
Site                                                    char(50),
Bss                                                     char(20),
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,
o_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,
flow_cntrl_barred                                       float,
Offered_Erlang                                          float,
)