{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,0,0,4],[6,0,8,0],[9,0,11,0],[32,0,34,0],[39,0,44,0],[45,0,66,0],[74,0,78,0],[82,0,85,0],[86,0,89,0],[6,1,8,1],[9,1,11,1],[32,1,34,1],[39,1,44,1],[45,1,66,1],[74,1,78,1],[82,1,85,1],[86,1,89,1],[6,2,8,2],[9,2,11,2],[32,2,34,2],[39,2,44,2],[45,2,66,2],[74,2,78,2],[82,2,85,2],[86,2,89,2],[6,3,8,3],[9,3,11,3],[32,3,34,3],[39,3,44,3],[45,3,66,3],[74,3,78,3],[82,3,85,3],[86,3,89,3],[6,5,8,5],[9,5,11,5],[32,5,34,5],[39,5,44,5],[45,5,66,5],[74,5,78,5],[86,5,89,5]]}
["支持的自定义返回列字段",{"$nulls":4},"入库字段"]
["消息字段","字段名称","是否必填","字段类型","字段说明","sdate",null,"sdate"]
["uniqueId","告警唯一标识","否","String","系统唯一的告警标识","uniqueid",null,"uniqueid"]
["uniqueClearId","告警清除标识","否","String","清除告警和活动告警匹配的标识","uniqueclearid",null,"uniqueclearid"]
["eventTime","告警发生时间","否","String","yyyy-mm-dd 24hh:mm:ss","eventtime",null,"eventtime"]
["cancelTime","告警清除时间","否","String","yyyy-mm-dd 24hh:mm:ss","canceltime",null,"canceltime"]
["status","告警清除状态","否","integer","枚举值：","status",null,"status"]
[{"$nulls":4},"1：活动告警"]
[{"$nulls":4},"2：清除告警"]
["projectStatus","告警工程状态","否","integer","枚举值：","projectstatus"]
[{"$nulls":4},"1：在网运行"]
[{"$nulls":4},"2：工程状态",null,null,"projectstatus"]
["vendorAlarmSerial","厂家告警流水号","否","String","厂家告警流水号","vendoralarmserial",null,"vendoralarmserial"]
["alarmTitle","告警标题","否","String","告警含义的简要概括","alarmtitle",null,"alarmtitle"]
["vendorSeverity","厂家告警级别","否","String","厂家原始告警级别","vendorseverity",null,"vendorseverity"]
["vendorAlarmType","厂家告警类型","否","String","厂家原始告警类型","vendoralarmtype",null,"vendoralarmtype"]
["specificProblem","厂家告警原因","否","String","详细说明此告警的具体含义，产生原因等。","specificproblem",null,"specificproblem"]
["specificProblemID","厂家告警原因ID","否","String","告警原因ID","specificproblemid",null,"specificproblemid"]
["equipmentClass","设备类型","否","String","厂家告警设备类型","equipmentclass",null,"equipmentclass"]
["equipmentName","设备名称","否","String",null,"equipmentname",null,"equipmentname"]
["locateNeClass","对象类型","否","String","厂家告警对象类型","locateneclass",null,"locateneclass"]
["locateNeName","对象名称","否","String",null,"locatenename",null,"locatenename"]
["province","省份名称","否","String","省份全称","province",null,"province"]
["region","地市名称","否","String","地市全称","region",null,"region"]
["city","区县名称","否","String","区县全称","city",null,"city"]
["grid","网格名称","否","String","网格全称","grid",null,"grid"]
["area","区域名称","否","String","区域全称","area",null,"area"]
["vendor","厂家名称","否","String","厂家名称","vendor",null,"vendor"]
["specialty","一级专业分类","否","Integer","告警所属一级专业","specialty",null,"specialty"]
["siteId","局站名称","否","String",null,"siteid",null,"siteid"]
["roomId","机房名称","否","String",null,"roomid",null,"roomid"]
["towerSiteNo","铁塔站址编码","否","String",null,"towersiteno",null,"towersiteno"]
["proEquipmentStatus","设备工程状态","否","Integer","枚举值：","proequipmentstatus"]
[{"$nulls":4},"1：在网运行"]
[{"$nulls":4},"2：工程状态",null,null,"proequipmentstatus"]
["projectName","工程名称","否","String",null,"projectname",null,"projectname"]
["projectNo","工程号","否","String",null,"projectno",null,"projectno"]
["projectStartTime","工程开始时间","否","String","yyyy-mm-dd 24hh:mm:ss","projectstarttime",null,"projectstarttime"]
["projectEndTime","工程结束时间","否","String","yyyy-mm-dd 24hh:mm:ss","projectendtime",null,"projectendtime"]
["workSendStatus","派单类型","否","Integer","枚举值：","worksendstatus"]
[{"$nulls":4},"1：无需派单"]
[{"$nulls":4},"2：等待派单"]
[{"$nulls":4},"3：派单抑制"]
[{"$nulls":4},"5：派单成功"]
[{"$nulls":4},"6：派单失败",null,null,"worksendstatus"]
["workStatus","工单状态","否","Integer","枚举值：","workstatus"]
[{"$nulls":4},"0 无工单"]
[{"$nulls":4},"1 草稿"]
[{"$nulls":4},"2 待受理"]
[{"$nulls":4},"3 处理中"]
[{"$nulls":4},"4 处理完成"]
[{"$nulls":4},"5 已归档"]
[{"$nulls":4},"6 作废"]
[{"$nulls":4},"7 待审批"]
[{"$nulls":4},"8 处理超时"]
[{"$nulls":4},"9 待确认"]
[{"$nulls":4},"10 已销单"]
[{"$nulls":4},"12 待处理"]
[{"$nulls":4},"13 待定性"]
[{"$nulls":4},"14 待终止审核"]
[{"$nulls":4},"15 异常归档"]
[{"$nulls":4},"16 待处理完成"]
[{"$nulls":4},"17 待业务恢复"]
[{"$nulls":4},"18 已删除"]
[{"$nulls":4},"19 上传故障报告"]
[{"$nulls":4},"20 故障报告审核"]
[{"$nulls":4},"21 待归档",null,null,"workstatus"]
["workNo","工单号","否","String","BJ-2020120101-0001","workno",null,"workno"]
["workArchivedTime","派单时间","否","String","yyyy-mm-dd 24hh:mm:ss","workarchivedtime",null,"workarchivedtime"]
["workDutyDep","工单处理部门","否","String","运维部","workdutydep",null,"workdutydep"]
["workSendPerson","工单派发人","否","String","张三","worksendperson",null,"worksendperson"]
["alarmLogicClass","告警逻辑分类","否","String",null,"alarmlogicclass",null,"alarmlogicclass"]
["alarmLogicSubClass","告警逻辑子类","否","String",null,"alarmlogicsubclass",null,"alarmlogicsubclass"]
["standardAlarmName","告警标准名","否","String",null,"standardalarmname",null,"standardalarmname"]
["alarmSeverity","标准化告警级别","否","Integer","枚举值：","alarmseverity"]
[{"$nulls":4},"1：一级告警"]
[{"$nulls":4},"2：二级告警"]
[{"$nulls":4},"3：三级告警"]
[{"$nulls":4},"4：四级告警",null,null,"alarmseverity"]
["standardAlarmId","标准化网管告警 ID","否","String",null,"standardalarmid",null,"standardalarmid"]
["effectOnEquipment","该事件对设备的影响","否","String",null,"effectonequipment",null,"effectonequipment"]
["effectOnBusiness","该事件对业务的影响","否","String",null,"effectonbusiness",null,"effectonbusiness"]
["standardFlag","告警标准化标识","否","Integer","枚举值：",null,null,"standardflag"]
[{"$nulls":4},"1：未标准化"]
[{"$nulls":4},"2：已匹配"]
[{"$nulls":4},"3：未匹配"]
["networkType","网络类型","否","Integer","102: 2G"]
[{"$nulls":4},"103: 3G"]
[{"$nulls":4},"104: 4G"]
[{"$nulls":4},"105: 5G",null,null,"networktype"]
["equipmentDN","设备rdn","否","String",null,null,null,"equipmentdn"]
["locateNEDN","告警定位对象rdn","否","String",null,null,null,"locatenedn"]
["tacCode","基站ID","否","String",null,"taccode",null,"taccode"]
["tacId","小区ID","否","String",null,"tacid",null,"tacid"]
["alarmText","告警正文","否","String",null,"alarmtext",null,"alarmtext"]