{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["河北_CEM高品质2日统计_HE_D_HIGH_QUALITY","河北_CEM移网质量投诉明细_HE_D_MOBILE_COMP","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"河北_CEM高品质2日统计_HE_D_HIGH_QUALITY","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["序号","中文名称","英文名称","数据类型","字段长度","敏感级别"]
[0,"账期月","MONTH_ID","字符串",6,"非敏感","month_id","?"]
[1,"账期日","DAY_ID","字符串",2,"非敏感","day_id","?"]
[2,"日期","ACCT_DATE","字符串",30,"非敏感","acct_date","?"]
[3,"工单归属地市","BUSINOAREANAME","字符串",15,"非敏感","businoareaname","?"]
[4,"专业线","PROFES_DEP","字符串",15,"非敏感","profes_dep","?"]
[5,"大类问题","BIG_TYPE_NAME","字符串",60,"非敏感","big_type_name","?"]
[6,"小类问题","SMALL_TYPE_NAME","字符串",120,"非敏感","small_type_name","?"]
[7,"总投诉量（办结量）","TOTAL_COMPLAINTS","字符串",30,"非敏感","total_complaints","?"]
[8,"10010热线投诉量（办结量）","HOTLINE_COMPLAINTS","字符串",30,"非敏感","hotline_complaints","?"]
[9,"营业厅、在线等其他投诉渠道（办结量）","OTHER_COMPLAINT","字符串",30,"非敏感","other_complaint","?"]
[10,"10015升诉量（办结量）","LITIGATION_VOLUME","字符串",30,"非敏感","litigation_volume","?"]
[11,"总满意率","SATISFACTION_RATE","字符串",30,"非敏感","satisfaction_rate","?"]
[12,"总满意参评量","SATISFACTION_COUNT","字符串",30,"非敏感","satisfaction_count","?"]
[13,"总参评量","TOTAL_EVALUATION","字符串",30,"非敏感","total_evaluation","?"]
[14,"投诉满意率","COMPLAINT_SATISFIED","字符串",30,"非敏感","complaint_satisfied","?"]
[15,"投诉满意量","COMPLAINT_SATISFIED_LIST","字符串",30,"非敏感","complaint_satisfied_list","?"]
[16,"投诉满意参评量","COMPLAINT_SATISFIED_COUNT","字符串",30,"非敏感","complaint_satisfied_count","?"]
[17,"投诉解决率","COMPLAINT_RESOLUTION","字符串",30,"非敏感","complaint_resolution","?"]
[18,"投诉解决量","COMPLAINT_RESOLUTION_LIST","字符串",30,"非敏感","complaint_resolution_list","?"]
[19,"投诉解决参评量","COMPLAINT_RESOLUTION_COUNT","字符串",30,"非敏感","complaint_resolution_count","?"]
[20,"投诉响应率","COMPLAINT_RESPONSE","字符串",30,"非敏感","complaint_response","?"]
[21,"投诉响应量","COMPLAINT_RESPONSE_LIST","字符串",30,"非敏感","complaint_response_list","?"]
[22,"投诉响应参评量","COMPLAINT_RESPONSE_COUNT","字符串",30,"非敏感","complaint_response_count","?"]
[23,"投诉未邀请评价量","COMPLAINT","字符串",30,"非敏感","complaint","?"]
[24,"故障满意率","FAULT_SATISFACTION_RATE","字符串",30,"非敏感","fault_satisfaction_rate","?"]
[25,"故障满意量","FAULT_SATISFACTION_LIST","字符串",30,"非敏感","fault_satisfaction_list","?"]
[26,"故障满意参评量","FAULT_SATISFACTION_COUNT","字符串",30,"非敏感","fault_satisfaction_count","?"]
[27,"故障解决率","FAULT_RESOLUTION_RATE","字符串",30,"非敏感","fault_resolution_rate","?"]
[28,"故障解决量","FAULT_RESOLUTION_LIST","字符串",30,"非敏感","fault_resolution_list","?"]
[29,"故障解决参评量","FAULT_RESOLUTION_COUNT","字符串",30,"非敏感","fault_resolution_count","?"]
[30,"故障响应率","FAULT_RESPONSE_RATE","字符串",30,"非敏感","fault_response_rate","?"]
[31,"故障响应量","FAULT_RESPONSE_LIST","字符串",30,"非敏感","fault_response_list","?"]
[32,"故障响应参评量","FAULT_RESPONSE_COUNT","字符串",30,"非敏感","fault_response_count","?"]

{"sheet":"河北_CEM移网质量投诉明细_HE_D_MOBILE_COMP","index":1,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["序号","中文名称","英文名称","数据类型","字段长度","敏感级别"]
[0,"账期月","MONTH_ID","字符串",6,"非敏感",null,"month_id"]
[1,"账期日","DAY_ID","字符串",2,"非敏感",null,"day_id"]
[2,"日期","ACCT_DATE","字符串",300,"非敏感",null,"acct_date"]
[3,"工单流水","SHEET_NO","字符串",150,"非敏感",null,"sheet_no",null,null,null,"区县",null,"地市和区县规范表","4月区县投诉率月统计-移网万投比"]
[4,"是否在线办结","IS_ONLINE_COMPLETE","字符串",300,"非敏感",null,"is_online_complete"]
[5,"来电号码","CONTACT_NO","字符串",300,"一般敏感",null,"contact_no",null,null,4,"投诉分析主因"]
[6,"业务号码","BUSI_NO","字符串",300,"非敏感",null,"busi_no",null,null,3,"工单里面携带"]
[7,"受理内容","SERV_CONTENT","字符串",4136,"非敏感",null,"serv_content",null,null,1,"工单系统"]
[8,"最后一次处理结果","LAST_DEAL_CONTENT","字符串",4136,"非敏感",null,"last_deal_content",null,null,2,"工单归属县分字段","搞一个对应表"]
[9,"处理部门","DEAL_DEPART_NAME","字符串",300,"非敏感",null,"deal_depart_name"]
[10,"处理意见","DEAL_OPINION","字符串",4136,"非敏感",null,"deal_opinion",null,null,"业务号码","短号问题--一号双机"]
[11,"客户端投诉问题分类","SERV_TYPE","字符串",600,"非敏感",null,"serv_type"]
[12,"业务类别","BUS_TYPE","字符串",300,"非敏感",null,"bus_type",null,null,null,"短号问题对当前系统是否有影响"]
[13,"投诉问题定位","DUTY_REASON","字符串",600,"非敏感",null,"duty_reason"]
[14,"投诉受理渠道","ACCEPT_CHANNEL","字符串",300,"非敏感",null,"accept_channel"]
[15,"提交渠道","SUBMIT_CHANNEL","字符串",300,"非敏感",null,"submit_channel"]
[16,"投诉归属地","COMPL_AREA_LOCAL","字符串",300,"非敏感",null,"compl_area_local"]
[17,"责任归属专业","DUTY_MAJOR","字符串",300,"非敏感",null,"duty_major"]
[18,"套餐名称","PRODUCT_NAME","字符串",600,"一般敏感",null,"product_name"]
[19,"sp产品编码","SP_PRODUCT_CODE","字符串",600,"非敏感",null,"sp_product_code"]
[20,"执行的服务补救名称","PRE_REPAIR_NAME","字符串",300,"非敏感",null,"pre_repair_name"]
[21,"执行的服务补救费用","PRE_REPAIR_CHARGES","双精度",24,"非敏感",null,"pre_repair_charges"]
[22,"通信质量问题位置信息","FAULT_LOCATION","字符串",300,"非敏感",null,"fault_location"]
[23,"投诉客户类别","CUST_LEVEL","字符串",300,"非敏感",null,"cust_level"]
[24,"答复环节满意度","SATISFACTION_IN_REPLY","字符串",300,"非敏感",null,"satisfaction_in_reply"]
[25,"答复环节问题是否解决","IS_OK_IN_REPLY","字符串",300,"非敏感",null,"is_ok_in_reply"]
[26,"受理时间","ACCEPT_TIME","日期",8,"非敏感",null,"accept_time"]
[27,"归档时间","END_TIME","日期",8,"非敏感",null,"end_time"]
[28,"审核时间","PROCE_TIME","日期",8,"非敏感",null,"proce_time"]
[29,"号码归属地","CUST_AREA","字符串",300,"非敏感",null,"cust_area"]
[30,"是否客服办结","IS_CUST_SERV_COMPLETE","字符串",300,"非敏感",null,"is_cust_serv_complete"]
[31,"是否派单办结","IS_SEND_SHEET_COMPLETE","字符串",300,"非敏感",null,"is_send_sheet_complete"]
[32,"是否重复投诉","IS_REPEAT","字符串",300,"非敏感",null,"is_repeat"]
[33,"是否升级","IS_UPGRADE","字符串",300,"非敏感",null,"is_upgrade"]
[34,"是否超时办结","IS_TIMEOUT","字符串",300,"非敏感",null,"is_timeout"]
[35,"打点区县","GIS_CITY","字符串",300,"非敏感",null,"gis_city"]
[36,"处理步长","PROCESS_NUMS","双精度",24,"非敏感",null,"process_nums"]
[37,"一次处理完成部门","DEAL_DEPART_NAME_1","字符串",300,"非敏感",null,"deal_depart_name_1"]
[38,"二次处理完成部门","DEAL_DEPART_NAME_2","字符串",300,"非敏感",null,"deal_depart_name_2"]
[39,"三次处理完成部门","DEAL_DEPART_NAME_3","字符串",300,"非敏感",null,"deal_depart_name_3"]
[40,"人工首次联系用户时间","FIRST_CALL_BACK_TIME","日期",8,"非敏感",null,"first_call_back_time"]
[41,"审核结果","PROCE_REMARK","字符串",4136,"非敏感",null,"proce_remark"]
[42,"日定责问题分类","DUTY_MAJOR_DAY","字符串",300,"非敏感",null,"duty_major_day"]
[43,"日定责专业","DUTY_REASON_ID_DAY","字符串",300,"非敏感",null,"duty_reason_id_day"]
[44,"月定责问题分类","DUTY_MAJOR_MONTH","字符串",300,"非敏感",null,"duty_major_month"]
[45,"月定责专业","DUTY_REASON_ID_MONTH","字符串",300,"非敏感",null,"duty_reason_id_month"]
[46,"语音转文本","VOICE_TEXT","字符串",4136,"非敏感",null,"voice_text"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}