核心網(wǎng)網(wǎng)元話單數(shù)據(jù)字典

CG話單稽查系統(tǒng)數(shù)據(jù)字典說(shuō)明書(shū)第2頁(yè)共34頁(yè)CG話單稽查系統(tǒng)數(shù)據(jù)字典說(shuō)明書(shū)上海新炬網(wǎng)絡(luò)技術(shù)有限公司編寫(xiě)：.

審核：.

日期：.

更改記錄1流量增加地市和記錄數(shù)1.1李云根2014-12-312增加ServiceID1.2李云根2015-06-183語(yǔ)音增加isroaming,city,cdrfilename,cdrfilesize,sparea,frometl字段1.3李云根2015-06-284增加語(yǔ)音、智能網(wǎng)相關(guān)的表1.4李云根2015-07-28目錄TOC\o"1-4"\h\z\u1. CDR話單數(shù)據(jù)表 41.1. ERI_GGSN_YYYYMMDD(愛(ài)立信GGSN話單數(shù)據(jù)) 41.2. ERI_P_GW_YYYYMMDD(愛(ài)立信P-GW話單數(shù)據(jù)) 51.3. HW_GGSN_YYYYMMDD(華為GGSN話單數(shù)據(jù)) 61.4. HW_P_GW_YYYYMMDD(華為P-GW話單數(shù)據(jù)) 71.5. HW_SMS_YYYYMMDD(華為短信數(shù)據(jù)) 91.6. NSN_GGSN_YYYYMMDD(諾西GGSN話單數(shù)據(jù)) 101.7. ZTE_P_GW_YYYYMMDD(中興P-GW話單數(shù)據(jù)) 111.8. ZTE_SMS_YYYYMMDD(中興短信數(shù)據(jù)) 121.9. ERI_MOCall_YYYYMMDD(愛(ài)立信語(yǔ)音主叫數(shù)據(jù)) 131.10. ERI_MTCall_YYYYMMDD(愛(ài)立信語(yǔ)音被叫數(shù)據(jù)) 141.11. ERI_FWCall_YYYYMMDD(愛(ài)立信語(yǔ)音前轉(zhuǎn)數(shù)據(jù)) 151.12. HW_MOCall_YYYYMMDD(華為語(yǔ)音主叫數(shù)據(jù)) 161.13. HW_MTCall_YYYYMMDD(華為語(yǔ)音被叫數(shù)據(jù)) 171.14. HW_FWCall_YYYYMMDD(華為語(yǔ)音前轉(zhuǎn)數(shù)據(jù)) 181.15. ZTE_MOCall_YYYYMMDD(中興語(yǔ)音主叫數(shù)據(jù)) 181.16. ZTE_MTCall_YYYYMMDD(中興語(yǔ)音被叫數(shù)據(jù)) 191.17. ZTE_FWCall_YYYYMMDD(中興語(yǔ)音前轉(zhuǎn)數(shù)據(jù)) 201.18. HW_OCG_YYYYMMDD(華為智能網(wǎng)數(shù)據(jù)) 221.19. ERI_OMM_YYYYMMDD(愛(ài)立信智能網(wǎng)數(shù)據(jù)) 232. 接口匯總表 242.1. CGData(輸出接口數(shù)據(jù)匯總表) 242.2. NumberSegment(號(hào)段表) 252.3. HSC_Route_MobileNo(散號(hào)表) 252.4. HSC_Route_NoSect(號(hào)段表) 252.5. CGData_V2(輸出接口數(shù)據(jù)匯總表2) 252.6. MSC_CITY_MAP(網(wǎng)元地市對(duì)照表) 262.7. CGData_Voice(輸出接口語(yǔ)音數(shù)據(jù)匯總表) 262.8. CGData_SMS(輸出接口短信數(shù)據(jù)匯總表) 272.9. CGData_OCG(輸出接口智能網(wǎng)關(guān)數(shù)據(jù)匯總表) 273. 統(tǒng)計(jì)表 273.1. GGSN_WW(網(wǎng)管GGSN維度數(shù)據(jù)) 273.2. GGSN_YZ(業(yè)支GGSN維度數(shù)據(jù)) 283.3. GGSN_GI_ESB(ESB來(lái)的GI數(shù)據(jù)) 283.4. GGSN_GI(GI匯總數(shù)據(jù)) 293.5. CG_WW(網(wǎng)管CG維度數(shù)據(jù)) 293.6. CG_YZ(業(yè)支CG維度數(shù)據(jù)) 303.7. CITY_WW(網(wǎng)維地市維度數(shù)據(jù)) 303.8. CITY_YZ(業(yè)支地市維度數(shù)據(jù)) 313.9. vGgsnIPAdress(GGSN與IP對(duì)照表) 313.10. CGNodeMap(業(yè)支與網(wǎng)管CG名稱對(duì)照表) 313.11. CodeMap(地市代碼名稱對(duì)照表) 323.12. Service_WW(網(wǎng)管ServiceID維度數(shù)據(jù)) 323.13. Voice_WW(網(wǎng)管語(yǔ)音數(shù)據(jù)) 323.14. DX_WW(網(wǎng)管短信數(shù)據(jù)) 333.15. OCG_WW(網(wǎng)管智能網(wǎng)數(shù)據(jù)) 33CDR話單數(shù)據(jù)表ERI_GGSN_YYYYMMDD(愛(ài)立信GGSN話單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注servedIMSIIMSIvarchar(16)ggsnAddressGGSN的ip地址varchar(16)chargingID計(jì)費(fèi)標(biāo)識(shí)Numeric(32,0)sgsnAddressSGSN的ip地址varchar(16)accessPointNameNIAPNvarchar(32)recordOpeningTime記錄打開(kāi)的時(shí)間timestampduration會(huì)話時(shí)長(zhǎng)IntchangeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)causeForRecClosing話單關(guān)閉的原因varchar(32)nodeID網(wǎng)元名稱varchar(32)servedMSISDN原始用戶號(hào)varchar(16)msisdnMSIDNVarchar(16)chargingCharacteristics付費(fèi)類型varchar(10)rATType使用的無(wú)線技術(shù)IntservedIMEISVIMESVvarchar(16)durationC合并時(shí)長(zhǎng)IntdataVolumeGPRSUplink上行流量IntdataVolumeGPRSDownlink下行流量IntuserLocationInformation終端位置信息varchar(32)pSFurnishChargingInformation從OCS接收的FCIIntconsolidationResult合并結(jié)果狀態(tài)varchar(16)msisdnSeg86后7位數(shù)字varchar(32)IsRoamin是否漫入,1=是,0=否IntCity地市編號(hào)Varchar(8)ServiceDataCountServiceData中的記錄數(shù)IntServiceDataServiceIDTextcgIDCG網(wǎng)維名稱varchar(32)spName廠商名稱varchar(32)ERICSSONProgressTime入庫(kù)時(shí)間timestampcdrFileName話單解碼文件名Varchar(100)cdrFileSize話單解碼文件容量大小intfromETLETL來(lái)源Varchar(500)spArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ERI_P_GW_YYYYMMDD(愛(ài)立信P-GW話單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注servedIMSI用戶的IMSIvarchar(16)pGWAddress使用的P-GW的控制面IP地址varchar(16)chargingIDIPCAN承載標(biāo)識(shí)用來(lái)識(shí)別PCNs創(chuàng)建的不同IPCAN承載Numeric(32,0)servingNodeAddress在此記錄期間使用的SGSN、S-GW的控制面IP地址的列表varchar(16)accessPointNameNIAPN的網(wǎng)絡(luò)標(biāo)識(shí)部分varchar(32)recordOpeningTime記錄打開(kāi)時(shí)間timestampduration會(huì)話時(shí)長(zhǎng)IntchangeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)causeForRecClosing關(guān)閉原因varchar(32)nodeIDP-GW的名稱varchar(32)servedMSISDN原始用戶號(hào)varchar(16)MSISDNMSISDNVarchar(16)chargingCharacteristics此IPCAN承載應(yīng)用的計(jì)費(fèi)特性varchar(16)pSFurnishChargingInformation實(shí)時(shí)計(jì)費(fèi)會(huì)話特定的信息IntservedIMEISV記錄移動(dòng)設(shè)備的IMEISVvarchar(16)rATType該字段指示MS當(dāng)前使用的無(wú)線接入技術(shù)類型（RAT）IntuserLocationInformation用戶的位置信息varchar(32)IsRoamin是否漫入,1=是,0=否IntCity地市編號(hào)Varchar(8)ServiceDataCountServiceData中的記錄數(shù)IntServiceDataServiceIDTextdatavolumeFBCUplink上行流量IntdatavolumeFBCDownlink下行流量IntstartTime用戶IP-CAN會(huì)話開(kāi)始的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話第一個(gè)承載的話單中timestampstopTime用戶IP-CAN會(huì)話終止的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話最后一個(gè)承載的話單中timestampconsolidationResult合并結(jié)果狀態(tài)varchar(16)msisdnSeg號(hào)段varchar(8)cgIDCG網(wǎng)維名稱varchar(32)spName廠商名稱varchar(32)ERICSSONProgressTime行解析生成時(shí)間timestampcdrFileName話單解碼文件名Varchar(100)cdrFileSize話單解碼文件容量大小intfromETLETL來(lái)源Varchar(500)spArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_GGSN_YYYYMMDD(華為GGSN話單數(shù)據(jù))ID字段名具體描述數(shù)據(jù)類型備注servedIMSIIMSIvarchar(16)ggsnAddressGGSN的ip地址varchar(16)chargingID計(jì)費(fèi)標(biāo)識(shí)Numeric(32,0)sgsnAddressSGSN的ip地址varchar(16)accessPointNameNIAPNvarchar(32)dataVolumeGPRSUplink上行流量IntdataVolumeGPRSDownlink下行流量IntrecordOpeningTime記錄打開(kāi)的時(shí)間timestampduration會(huì)話時(shí)長(zhǎng)IntchangeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)causeForRecClosing關(guān)閉原因IntnodeID網(wǎng)元名稱varchar(32)servedMSISDN原始用戶號(hào)varchar(16)MSISDNMSISDNVarchar(16)chargingCharacteristics付費(fèi)類型varchar(10)sgsnPLMNIdentifier移動(dòng)國(guó)家代號(hào)和移動(dòng)網(wǎng)絡(luò)代號(hào)varchar(100)rATType使用的無(wú)線技術(shù)IntservedIMEISVIMESVvarchar(16)userLocationInformation用戶的位置信息varchar(200)pSFurnishChargingInformation從OCS接收的FCIIntconsolidationResult合并結(jié)果狀態(tài)varchar(200)msisdnSeg號(hào)段varchar(8)IsRoamin是否漫入,1=是,0=否IntCity地市編號(hào)Varchar(8)ServiceDataCountServiceData中的記錄數(shù)IntServiceDataServiceIDTextcgIDCG網(wǎng)維名稱varchar(32)spName廠商名稱varchar(20)HUAWEIprocesstime行解析生成時(shí)間timestampcdrFileName話單解碼文件名Varchar(100)cdrFileSize話單解碼文件容量大小intfromETLETL來(lái)源Varchar(500)spArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_P_GW_YYYYMMDD(華為P-GW話單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注servedIMSI用戶的IMSIvarchar(16)servedIMEISV記錄移動(dòng)設(shè)備的IMEISVvarchar(16)pGWAddress使用的P-GW的控制面IP地址varchar(16)chargingIDIPCAN承載標(biāo)識(shí)用來(lái)識(shí)別PCNs創(chuàng)建的不同IPCAN承載Numeric(32,0)servingNodeAddress在此記錄期間使用的SGSN、S-GW的控制面IP地址的列表varchar(16)accessPointNameNIAPN的網(wǎng)絡(luò)標(biāo)識(shí)部分varchar(32)datavolumeFBCUplink上行流量IntdatavolumeFBCDownlink下行流量IntrecordOpeningTime記錄打開(kāi)時(shí)間timestampduration本話單的持續(xù)時(shí)長(zhǎng)IntchangeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)causeForRecClosing關(guān)閉原因IntnodeIDP-GW的名稱varchar(32)servedMSISDN原始用戶號(hào)varchar(16)MSISDNMSISDNVarchar(16)userLocationInformation用戶的位置信息varchar(200)chargingCharacteristics此IPCAN承載應(yīng)用的計(jì)費(fèi)特性varchar(10)pSFurnishChargingInformation實(shí)時(shí)計(jì)費(fèi)會(huì)話特定的信息IntrATType該字段指示MS當(dāng)前使用的無(wú)線接入技術(shù)類型（RAT）IntStartTime用戶IP-CAN會(huì)話開(kāi)始的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話第一個(gè)承載的話單中timestampStopTime用戶IP-CAN會(huì)話終止的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話最后一個(gè)承載的話單中timestampconsolidationResult合并結(jié)果狀態(tài)varchar(16)msisdnSeg號(hào)段varchar(8)IsRoamin是否漫入,1=是,0=否IntCity地市編號(hào)Varchar(8)ServiceDataCountServiceData中的記錄數(shù)IntServiceDataServiceIDTextcgIDCG網(wǎng)維名稱varchar(32)spName廠商名稱：ERICSSON、NOKIASIERMENS、HUAWEI、ZTEvarchar(20)HUAWEIprocesstime行解析生成時(shí)間timestampcdrFileName話單解碼文件名Varchar(100)cdrFileSize話單解碼文件容量大小intfromETLETL來(lái)源Varchar(500)spArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_SMS_YYYYMMDD(華為短信數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1RecNo話單序號(hào)varchar(20)2MsgID短消息IDvarchar(16)3OAddress源地址varchar(32)4OAddressTON源地址TONvarchar(8)5OaddressNPI源地址NPIvarchar(6)6TAddress目的地址varchar(32)7TAddressTON目的地址號(hào)碼類型。varchar(8)8TAddressNPI目的地址NPIvarchar(6)9SendTime短信提交時(shí)間timestamp10LastTime最后時(shí)間timestamp11Priority優(yōu)先級(jí)Int12LastStatus最終狀態(tài)報(bào)告Int13PID短消息的協(xié)議類型。Int14LangType編碼方案Int15MsgLength消息長(zhǎng)度Int16MsgStatus短消息的狀態(tài)Int17MsgErrorCode短消息的錯(cuò)誤碼Int18MsgType短消息的類型Int19MsgServiceType服務(wù)類型Int20RSUdesc發(fā)收雙方PPS用戶描述varchar(16)21OrgAccount短消息發(fā)送帳號(hào)varchar(24)22DestAccount短消息接收帳號(hào)varchar(24)23MoMscAddrMOMSC地址varchar(32)24MtMscAddrMTMSC地址varchar(32)25ulServiceFlag被叫業(yè)務(wù)類型varchar(24)26szOrgAddress3源地址varchar(32)27OrgTON3原始主叫的TONvarchar(8)28OrgNPI3主叫的NPIvarchar(6)29szDestAddress3原始的目的地址varchar(32)30DestTON3被叫的TONvarchar(8)31DestNPI3被叫的NPIvarchar(6)32SMSNumber短信中心代碼varchar(18)33HostName話單主機(jī)名稱varchar(32)34SPName廠商名稱varchar(32)HUAWEI35ProgressTime入庫(kù)時(shí)間timestamp36distriblot分發(fā)批號(hào)varchar(200)NSN_GGSN_YYYYMMDD(諾西GGSN話單數(shù)據(jù))ID字段名具體描述數(shù)據(jù)類型備注servedIMSIIMSIvarchar(16)ggsnAddressGGSN的ip地址varchar(16)chargingID計(jì)費(fèi)標(biāo)識(shí)Numeric(32,0)sgsnAddressSGSN的ip地址varchar(16)accessPointNameNIAPNvarchar(32)dataVolumeGPRSUplink上行流量IntdataVolumeGPRSDownlink下行流量IntrecordOpeningTime記錄打開(kāi)的時(shí)間timestampduration會(huì)話時(shí)長(zhǎng)IntchangeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)causeForRecClosing關(guān)閉原因IntnodeID網(wǎng)元名稱varchar(32)servedMSISDN原始用戶號(hào)varchar(16)MSISDNMSISDNVarchar(16)chargingCharacteristics付費(fèi)類型varchar(10)sgsnPLMNIdentifier移動(dòng)國(guó)家代號(hào)和移動(dòng)網(wǎng)絡(luò)代號(hào)varchar(100)rATType使用的無(wú)線技術(shù)IntservedIMEISVIMESVvarchar(16)userLocationInformation用戶的位置信息varchar(200)pSFurnishChargingInformation從OCS接收的FCIIntconsolidationResult合并結(jié)果狀態(tài)varchar(200)msisdnSeg號(hào)段varchar(8)IsRoamin是否漫入,1=是,0=否IntCity地市編號(hào)Varchar(8)ServiceDataCountServiceData中的記錄數(shù)IntServiceDataServiceIDTextcgIDCG網(wǎng)維名稱varchar(32)spName廠商名稱varchar(20)NOKIASIERMENSprocesstime行解析生成時(shí)間timestampcdrFileName話單解碼文件名Varchar(100)cdrFileSize話單解碼文件容量大小intfromETLETL來(lái)源Varchar(500)spArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ZTE_P_GW_YYYYMMDD(中興P-GW話單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注servedIMSI用戶的IMSIvarchar(16)servedIMEISV記錄移動(dòng)設(shè)備的IMEISVvarchar(16)pGWAddress使用的P-GW的控制面IP地址varchar(16)chargingIDIPCAN承載標(biāo)識(shí)用來(lái)識(shí)別PCNs創(chuàng)建的不同IPCAN承載Numeric(32,0)servingNodeAddress在此記錄期間使用的SGSN、S-GW的控制面IP地址的列表varchar(16)accessPointNameNIAPN的網(wǎng)絡(luò)標(biāo)識(shí)部分varchar(32)datavolumeFBCUplink上行流量IntdatavolumeFBCDownlink下行流量IntrecordOpeningTime記錄打開(kāi)時(shí)間timestampduration本話單的持續(xù)時(shí)長(zhǎng)IntchangeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)causeForRecClosing關(guān)閉原因IntnodeIDP-GW的名稱varchar(32)servedMSISDN原始用戶號(hào)varchar(16)MSISDNMSISDNVarchar(16)userLocationInformation用戶的位置信息varchar(200)chargingCharacteristics此IPCAN承載應(yīng)用的計(jì)費(fèi)特性varchar(10)pSFurnishChargingInformation實(shí)時(shí)計(jì)費(fèi)會(huì)話特定的信息IntrATType該字段指示MS當(dāng)前使用的無(wú)線接入技術(shù)類型（RAT）IntStartTime用戶IP-CAN會(huì)話開(kāi)始的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話第一個(gè)承載的話單中timestampStopTime用戶IP-CAN會(huì)話終止的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話最后一個(gè)承載的話單中timestampconsolidationResult合并結(jié)果狀態(tài)varchar(16)msisdnSeg號(hào)段varchar(8)IsRoamin是否漫入,1=是,0=否IntCity地市編號(hào)Varchar(8)ServiceDataCountServiceData中的記錄數(shù)IntServiceDataServiceIDTextcgIDCG網(wǎng)維名稱varchar(32)spName廠商名稱：ERICSSON、NOKIASIERMENS、HUAWEI、ZTEvarchar(20)ZTEprocesstime行解析生成時(shí)間timestampcdrFileName話單解碼文件名Varchar(100)cdrFileSize話單解碼文件容量大小intfromETLETL來(lái)源Varchar(500)spArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ZTE_SMS_YYYYMMDD(中興短信數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1RecNo話單序號(hào)varchar(20)2CallType呼叫類別Int1:MO,2:MT3CallingNumber起呼方地址varchar(30)4CalledNumber終呼方地址varchar(30)5RegisterTime存檔記錄時(shí)間timestamp6SendTime最終狀態(tài)時(shí)間timestamp7TextLength信息量,記錄發(fā)送的字節(jié)數(shù)Int8LastStatus最終狀態(tài)報(bào)告Int0:成功,非0:失敗9ServiceType信息來(lái)源Int10STExtentionServiceTypeExtention信息類別Int11LangType編碼方式Int0:English,8:Chinese12Priority優(yōu)先標(biāo)準(zhǔn)Int0:普通,非零:優(yōu)先13SMSNumber短信中心代碼varchar(18)14HostName話單主機(jī)名稱varchar(32)15spName廠商名稱varchar(32)ZTE16processtime行解析生成時(shí)間timestamp17distriblot分發(fā)批號(hào)varchar(200)ERI_MOCall_YYYYMMDD(愛(ài)立信語(yǔ)音主叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注tACTRAFFICACTIVITYCODE(TAC)varchar(12)CINumbercallidentificationnumbervarchar(24)RSNumberRecordSequenceNumbervarchar(24)TypeCSTypeofCallingSubscriberINTEGERCallingNumberCallingPartyNumbervarchar(24)CallingSIMSICallingSubscriberIMSIvarchar(20)CallingSIMEICallingSubscriberIMEIvarchar(20)CalledNumberCalledPartyNumbervarchar(24)DisconnectPDisconnectingPartyvarchar(8)TimeForStartDatetimeforStartofChargeDatetimeTimeForStopDatetimeforStopofChargeDatetimeCdurationTheseconds(total)ofChargeableDurationINTEGER記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)MSCIdentvarchar(24)MSCaddressMSCAddressvarchar(16)chargeNumberChargeNumbervarchar(24)mMENamemMEName-NEWCALLDATAPARAMETERSvarchar(64)mMEIdentitymMEIdentity-NEWCALLDATAPARAMETERSvarchar(16)cgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)ERICSSONProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ERI_MTCall_YYYYMMDD(愛(ài)立信語(yǔ)音被叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注tACTRAFFICACTIVITYCODE(TAC)varchar(12)CINumbercallidentificationnumbervarchar(24)RSNumberRecordSequenceNumbervarchar(24)TypeCSTypeofCallingSubscriberINTEGERCallingNumberCallingPartyNumbervarchar(24)CalledNumberCallingSubscriberIMSIvarchar(20)CalledIMSICallingSubscriberIMEIvarchar(20)CalledIMEICalledPartyNumbervarchar(24)RoamingNumbervarchar(24)DisconnectPDisconnectingPartyvarchar(8)TimeForStartDatetimeforStartofChargeDatetimeTimeForStopDatetimeforStopofChargeDatetimeCdurationTheseconds(total)ofChargeableDurationINTEGER記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)MSCIdentvarchar(24)MSCaddressMSCAddressvarchar(16)mMENamemMEName-NEWCALLDATAPARAMETERSvarchar(64)cgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)ERICSSONProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ERI_FWCall_YYYYMMDD(愛(ài)立信語(yǔ)音前轉(zhuǎn)數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注tACTRAFFICACTIVITYCODE(TAC)varchar(12)CINumbercallidentificationnumbervarchar(24)RSNumberRecordSequenceNumbervarchar(24)TypeCSTypeofCallingSubscriberINTEGERCallingNumberCallingPartyNumbervarchar(24)CalledNumberCalledPartyNumbervarchar(20)OCalledNumbervarchar(20)RNumbervarchar(24)RcounterRIMSIvarchar(24)DisconnectPDisconnectingPartyvarchar(8)TimeForStartDatetimeforStartofChargeDatetimeTimeForStopDatetimeforStopofChargeDatetimeCdurationTheseconds(total)ofChargeableDurationINTEGER記錄打開(kāi)時(shí)間+會(huì)話時(shí)長(zhǎng)MSCIdentvarchar(24)MSCaddressMSCAddressvarchar(16)mMENamemMEName-NEWCALLDATAPARAMETERSvarchar(64)cgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)ERICSSONProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_MOCall_YYYYMMDD(華為語(yǔ)音主叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注recordType指明本話單是主叫話單。INTEGERservedIMSI主叫的IMSI號(hào)碼。varchar(24)servedIMEI主叫設(shè)備的IMEI號(hào)碼varchar(24)servedMSISDN主叫用戶的基本MSISDN號(hào)碼。varchar(24)callingNumber主叫用戶的MSISDN號(hào)碼。varchar(24)calledNumber被叫的目的號(hào)碼varchar(24)translatedNumber經(jīng)過(guò)號(hào)碼變換后的被叫號(hào)碼。varchar(24)connectedNumber最終連接的被叫號(hào)碼。varchar(24)roamingNumber被叫用戶的漫游號(hào)碼。varchar(24)seizureTime主叫側(cè)指配完成的時(shí)間戳。datetimeanswerTime成功通話中被叫方應(yīng)答的時(shí)間戳。datetimereleaseTime釋放話務(wù)信道的時(shí)間戳。datetimecallDurationINTEGER通話的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGERcalledIMSI被叫用戶的IMSIvarchar(24)callType指示呼叫類型INTEGERcalledIMEI被叫設(shè)備的IMEI號(hào)碼varchar(24)officeName計(jì)費(fèi)局名稱。varchar(32)csfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。INTEGERcgid網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)HUAWEIProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_MTCall_YYYYMMDD(華為語(yǔ)音被叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注recordType指明本話單是主叫話單。INTEGERservedIMSI主叫的IMSI號(hào)碼。varchar(24)servedIMEI主叫IMEIvarchar(24)servedMSISDN主叫用戶的基本MSISDN號(hào)碼。varchar(24)callingNumber主叫用戶的MSISDN號(hào)碼。varchar(24)connectedNumber最終連接的被叫號(hào)碼。varchar(24)recordingEntityE.164串號(hào)varchar(24)seizureTime主叫側(cè)指配完成的時(shí)間戳。datetimeanswerTime被叫方應(yīng)答的時(shí)間戳。datetimereleaseTime釋放話務(wù)信道的時(shí)間戳。datetimecallDurationINTEGER通話的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGERcallType指示呼叫類型INTEGERofficeName計(jì)費(fèi)局名稱。varchar(32)csfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。INTEGERcgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)HUAWEIProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_FWCall_YYYYMMDD(華為語(yǔ)音前轉(zhuǎn)數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注recordType指明本話單是主叫話單。INTEGERservedIMSI主叫的IMSI號(hào)碼。varchar(24)servedIMEI主叫移動(dòng)設(shè)備IMEI號(hào)碼varchar(24)servedMSISDN主叫用戶的基本MSISDN號(hào)碼。varchar(24)callingNumber主叫用戶的MSISDN號(hào)碼。varchar(24)connectedNumber最終連接的被叫號(hào)碼。varchar(24)recordingEntity話單E.164串號(hào)varchar(24)seizureTime主叫側(cè)指配完成的時(shí)間戳。datetimeanswerTime被叫方應(yīng)答的時(shí)間戳。datetimereleaseTime釋放話務(wù)信道的時(shí)間戳。datetimecallDurationINTEGER通話的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGERcallType指示呼叫類型INTEGERofficeName計(jì)費(fèi)局名稱。varchar(32)csfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。INTEGERcgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)HUAWEIProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ZTE_MOCall_YYYYMMDD(中興語(yǔ)音主叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注recordType指明本話單是主叫話單。INTEGERservedIMSI主叫的IMSI號(hào)碼。varchar(24)servedIMEI記錄主叫移動(dòng)設(shè)備的IMEI號(hào)碼，獲得IMEI時(shí)填寫(xiě)。varchar(24)servedMSISDN主叫用戶的基本MSISDN號(hào)碼。varchar(24)callingNumber主叫用戶的MSISDN號(hào)碼。varchar(24)calledNumber被叫的目的號(hào)碼，通常是主叫用戶撥打的號(hào)碼。varchar(24)translatedNumber經(jīng)過(guò)號(hào)碼變換后的被叫號(hào)碼。varchar(24)connectedNumber當(dāng)通話最終連接的被叫號(hào)碼與主叫撥打的原被叫號(hào)碼不同時(shí)，記錄最終連接的被叫號(hào)碼。varchar(24)roamingNumber被叫用戶的漫游號(hào)碼。varchar(24)mscIncomingROUTE主叫話務(wù)接入主叫MSCServer的入中繼群varchar(24)seizureTime主叫側(cè)指配完成的時(shí)間戳。datetimeanswerTime成功通話中被叫方應(yīng)答的時(shí)間戳。datetimereleaseTime主被叫任何一方釋放話務(wù)信道的時(shí)間戳。datetimecallDurationINTEGER通話的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGERadditionalChgInfo計(jì)費(fèi)/不計(jì)費(fèi)和附加計(jì)費(fèi)標(biāo)識(shí)varchar(32)calledIMSI被叫用戶的IMSIvarchar(24)callType指示呼叫類型INTEGERchargeLevel通話時(shí)長(zhǎng)精度。如果該字段不編碼，則通話時(shí)長(zhǎng)精度的默認(rèn)單位是秒。INTEGERcalledIMEI記錄被叫叫移動(dòng)設(shè)備的IMEI號(hào)碼，獲得IMEI時(shí)填寫(xiě)。varchar(24)officeName計(jì)費(fèi)局名稱。varchar(32)csfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。INTEGERcgid網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)HUAWEIProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ZTE_MTCall_YYYYMMDD(中興語(yǔ)音被叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注recordType指明本話單是主叫話單。INTEGERservedIMSI主叫的IMSI號(hào)碼。varchar(24)servedIMEI記錄主叫移動(dòng)設(shè)備的IMEI號(hào)碼，獲得IMEI時(shí)填寫(xiě)。varchar(24)servedMSISDN主叫用戶的基本MSISDN號(hào)碼。varchar(24)callingNumber主叫用戶的MSISDN號(hào)碼。varchar(24)connectedNumber當(dāng)通話最終連接的被叫號(hào)碼與主叫撥打的原被叫號(hào)碼不同時(shí)，記錄最終連接的被叫號(hào)碼。varchar(24)recordingEntity產(chǎn)生本話單的MSCServer的E.164串號(hào)（MSC/VLR的串號(hào)：TON+NPI+MSC識(shí)別號(hào)）。varchar(24)seizureTime主叫側(cè)指配完成的時(shí)間戳。datetimeanswerTime成功通話中被叫方應(yīng)答的時(shí)間戳。datetimereleaseTime主被叫任何一方釋放話務(wù)信道的時(shí)間戳。datetimecallDurationINTEGER通話的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGERcallType指示呼叫類型INTEGERchargeLevel通話時(shí)長(zhǎng)精度。如果該字段不編碼，則通話時(shí)長(zhǎng)精度的默認(rèn)單位是秒。varchar(32)officeName計(jì)費(fèi)局名稱。INTEGERcsfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。cgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)ZTEProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)varchar(4)distriblot分發(fā)批號(hào)varchar(200)ZTE_FWCall_YYYYMMDD(中興語(yǔ)音前轉(zhuǎn)數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注recordType指明本話單是主叫話單。INTEGERservedIMSI主叫的IMSI號(hào)碼。varchar(24)servedIMEI記錄主叫移動(dòng)設(shè)備的IMEI號(hào)碼，獲得IMEI時(shí)填寫(xiě)。varchar(24)servedMSISDN主叫用戶的基本MSISDN號(hào)碼。varchar(24)callingNumber主叫用戶的MSISDN號(hào)碼。varchar(24)calledNumber前轉(zhuǎn)目的用戶的號(hào)碼。varchar(24)translatedNumber經(jīng)過(guò)號(hào)碼變換后的被叫號(hào)碼。varchar(24)connectedNumber當(dāng)通話最終連接的被叫號(hào)碼與主叫撥打的原被叫號(hào)碼不同時(shí)，記錄最終連接的被叫號(hào)碼。varchar(24)roamingNumber被叫用戶的漫游號(hào)碼(前轉(zhuǎn)到的用戶的漫游號(hào)碼)。varchar(24)recordingEntity產(chǎn)生本話單的MSCServer的E.164串號(hào)（MSC/VLR的串號(hào)：TON+NPI+MSC識(shí)別號(hào)）。varchar(24)location前轉(zhuǎn)方用戶發(fā)起呼叫時(shí)所處的位置區(qū)小區(qū)信息。varchar(128)changeOfLocation如果呼叫過(guò)程中發(fā)生了位置區(qū)小區(qū)變化，記錄變化后的位置區(qū)小區(qū)以及發(fā)生變化的時(shí)間戳信息列表。varchar(128)seizureTime主叫側(cè)指配完成的時(shí)間戳。datetimeanswerTime成功通話中被叫方應(yīng)答的時(shí)間戳。datetimereleaseTime主被叫任何一方釋放話務(wù)信道的時(shí)間戳。datetimecallDurationINTEGER通話的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGERcalledIMSI前轉(zhuǎn)到的用戶的IMSI。varchar(24)callType指示呼叫類型INTEGERchargeLevel通話時(shí)長(zhǎng)精度。如果該字段不編碼，則通話時(shí)長(zhǎng)精度的默認(rèn)單位是秒。INTEGERcalledIMEI記錄被叫叫移動(dòng)設(shè)備的IMEI號(hào)碼，獲得IMEI時(shí)填寫(xiě)。varchar(24)officeName計(jì)費(fèi)局名稱。varchar(32)csfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。INTEGERcgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)ZTEProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)HW_OCG_YYYYMMDD(華為智能網(wǎng)數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注ServiceKey業(yè)務(wù)鍵INTEGERFlowType流程類型INTEGERCallBeginTime呼叫開(kāi)始時(shí)間DATETIMETimeStamp寫(xiě)話單時(shí)系統(tǒng)當(dāng)前時(shí)間DATETIMERecordResultType話單結(jié)果類型INTEGERCallDuration呼叫時(shí)長(zhǎng)INTEGERchargingtime結(jié)束時(shí)間DATETIMEFlowEndReason流程結(jié)束原因INTEGERCallingPartyNumber主叫號(hào)碼varchar(32)CalledPartyNumber被叫號(hào)碼varchar(32)RediretionPartyNumber前轉(zhuǎn)號(hào)碼varchar(32)CallingNumberIDP上報(bào)的主叫號(hào)碼varchar(32)CalledNumberIDP上報(bào)的被叫號(hào)碼varchar(32)MSCAddressIDP上報(bào)的MSC地址varchar(32)CallingVlrNumberIDP上報(bào)的主叫VLR號(hào)varchar(32)CalledVlrNumberIDP上報(bào)的被叫VLR號(hào)碼varchar(32)CallVPLMN漫游地區(qū)號(hào)INTEGERRedirectionReasonIDP上報(bào)的前轉(zhuǎn)原因varchar(256)ServiceMsgString產(chǎn)生交互的業(yè)務(wù)消息串varchar(256)PeerIDString對(duì)端網(wǎng)元標(biāo)識(shí)。varchar(256)ResultString網(wǎng)元交互結(jié)果。varchar(256)DCCResultStringDCC返回結(jié)果串varchar(256)VoiceString語(yǔ)音交互串varchar(256)cgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)HUAWEIProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)ERI_OMM_YYYYMMDD(愛(ài)立信智能網(wǎng)數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注OCEStatus通話與OCE連接狀態(tài)INTEGEROverTime實(shí)際產(chǎn)生時(shí)間DATETIMEServiceKey業(yè)務(wù)鍵。INTEGERCallType呼叫類型varchar(8)IMSI用戶的IMSIvarchar(32)CallingPartyNumber主叫號(hào)碼varchar(40)CalledPartyNumber被叫號(hào)碼varchar(40)ShortNumber對(duì)端號(hào)碼短號(hào)varchar(12)RedirectingPartyID改向用戶號(hào)碼varchar(16)CallForwardingCode前轉(zhuǎn)原因varchar(8)RoamAreaNumber漫游地區(qū)號(hào)varchar(32)MSCMSC地址varchar(16)VLR觸發(fā)智能業(yè)務(wù)的用戶的VLR號(hào)varchar(24)LAI位置區(qū)識(shí)別碼varchar(8)CellId小區(qū)標(biāo)識(shí)varchar(8)D_VLR對(duì)端手機(jī)用戶的VLR號(hào)varchar(24)D_LAI對(duì)端手機(jī)用戶的LACvarchar(8)D_CellId對(duì)端手機(jī)小區(qū)標(biāo)識(shí)varchar(8)CallBeginTime通話開(kāi)始時(shí)間DATETIMETotalDuration通話總時(shí)長(zhǎng),單位：秒INTEGERUDuration未確認(rèn)時(shí)長(zhǎng)INTEGERGUID集團(tuán)編號(hào)varchar(18)GUuID內(nèi)部編號(hào)varchar(8)FCIFCI標(biāo)志INTEGERConnectNumCONNECT主叫號(hào)碼特殊前綴INTEGERServiceFlag服務(wù)標(biāo)志ServiceFlagINTEGERVPNTypeVPN呼叫類別INTEGERVPNDisVPN呼叫優(yōu)惠INTEGERDCCIDDCC會(huì)話IDvarchar(64)OOTimespanOCE/OCS已確認(rèn)時(shí)長(zhǎng)INTEGERFACTimespan故障AC時(shí)長(zhǎng)INTEGERcgID網(wǎng)元名稱varchar(24)spName廠商名稱varchar(16)ERICSSONProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetimecdrFilename話單解碼文件名varchar(100)cdrFilesize話單解碼文件容量大小。INTEGER單位：KBFromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例：\\DN0002\GSDISK1#ftp://abc:abc@3/xxx/xxx.datspArea網(wǎng)元所在片區(qū)Varchar(20)distriblot分發(fā)批號(hào)varchar(200)接口匯總表CGData(輸出接口數(shù)據(jù)匯總表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1billtype詳細(xì)類型varchar(30)GGSN｜P_GW2datadate統(tǒng)計(jì)日期date3cgidCG名稱網(wǎng)維varchar(30)4nodeidCG名稱業(yè)支varchar(30)5ipaddressGGSNIP地址varchar(30)6rattype網(wǎng)絡(luò)類型int7fcipSFurnishChargingInformationint0：FCI=16、1：FCI=11、2：FCI其他8volumetype流量類型int0：省內(nèi)、1：漫入9UpVolume上行流量（Byte）Bigint10DownVolume下行流量（Byte）bigint11spName廠商名稱varchar(20)ERICSSON、NOKIASIERMENS、HUAWEI、ZTE12Cgcount記錄數(shù)bigint13stattime統(tǒng)計(jì)時(shí)間timestamp14city地市Varchar(50)NumberSegment(號(hào)段表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1numberseg號(hào)段varchar(10)2province省份varchar(50)3city地市varchar(50)4telcode區(qū)號(hào)varchar(10)HSC_Route_MobileNo(散號(hào)表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1msisdn號(hào)碼varchar(50)2telcode區(qū)號(hào)varchar(50)HSC_Route_NoSect(號(hào)段表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1Sectstart起始號(hào)碼varchar(50)2sectend結(jié)束號(hào)碼Varchar(50)3telcode區(qū)號(hào)varchar(50)CGData_V2(輸出接口數(shù)據(jù)匯總表2)序號(hào)字段名具體描述數(shù)據(jù)類型備注1billtype詳細(xì)類型varchar(30)GGSN｜P_GW2datadate統(tǒng)計(jì)日期date3cgidCG名稱網(wǎng)維varchar(30)4nodeidCG名稱業(yè)支varchar(30)5ipaddressGGSNIP地址varchar(30)6rattype網(wǎng)絡(luò)類型int7fcipSFurnishChargingInformationint0：FCI=16、1：FCI=11、2：FCI其他8volumetype流量類型int0：省內(nèi)、1：漫入Serviceid業(yè)務(wù)IDVarchar(30)9UpVolume上行流量（Byte）Bigint10DownVolume下行流量（Byte）bigint11spName廠商名稱varchar(20)ERICSSON、NOKIASIERMENS、HUAWEI、ZTE12Cgcount業(yè)務(wù)條數(shù)bigintCgcount1話單數(shù)bigint13stattime統(tǒng)計(jì)時(shí)間timestamp14city地市Varchar(50)MSC_CITY_MAP(網(wǎng)元地市對(duì)照表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1cgid網(wǎng)元IDvarchar(20)2city地市varchar(20)3spname廠商名varchar(20)CGData_Voice(輸出接口語(yǔ)音數(shù)據(jù)匯總表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1datadate統(tǒng)計(jì)日期date2city地市varchar(20)3filecount文件數(shù)Bigint4Filesize文件大小Bigint單位：KB5Moduration主叫通知時(shí)長(zhǎng)bigint單位:秒6mocalls主叫次數(shù)bigint7Mtduration被叫通知時(shí)長(zhǎng)bigint單位:秒8mtcalls被叫次數(shù)bigint9fwduration前轉(zhuǎn)通知時(shí)長(zhǎng)bigint單位:秒10fwcalls前轉(zhuǎn)次數(shù)bigint11stattime統(tǒng)計(jì)時(shí)間timestamp12spName廠商名稱varchar(20)ERICSSON、HUAWEI、ZTECGData_SMS(輸出接口短信數(shù)據(jù)匯總表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1Datafilename文件名Text2datafilesize文件大小Int3datadate統(tǒng)計(jì)日期date4Hostname主機(jī)名Text5datacount文件行數(shù)int6spName廠商名稱varchar(20)HUAWEI、ZTE7insertedtime統(tǒng)計(jì)時(shí)間timestampCGData_OCG(輸出接口智能網(wǎng)關(guān)數(shù)據(jù)匯總表)序號(hào)字段名具體描述數(shù)據(jù)類型備注1datadate統(tǒng)計(jì)日期date2nosect萬(wàn)號(hào)段varchar(20)3Moduration主叫通知時(shí)長(zhǎng)bigint單位:秒4mocalls主叫次數(shù)bigint5Mtduration被叫通知時(shí)長(zhǎng)bigint單位:秒6mtcalls被叫次數(shù)bigint7fwduration前轉(zhuǎn)通知時(shí)長(zhǎng)bigint單位:秒8fwcalls前轉(zhuǎn)次數(shù)bigint9stattime統(tǒng)計(jì)時(shí)間timestamp10spName廠商名稱varchar(20)ERICSSON、HUAWEI、ZTE統(tǒng)計(jì)表GGSN_WW(網(wǎng)管GGSN維度數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1idIDintkey,自增2vGgsnNameGGSN名稱varchar(30)3vGgsnIpAddressGGSNIP地址varchar(30)4irATType網(wǎng)絡(luò)類型int()rATType值5iDataVolumeGPRSUplink上行流量bigint()Byte6iDataVolumeGPRSDownlink下行流量bigint()Byte7iDataVolumeGPRSTotallink總流量bigint()Byte8iPSFurnishChargingInformationFCIint()0：FCI=16、1：FCI=11、2：FCI其他9iFlowType流量類型int()0：省內(nèi)、1：漫入10vStatTime日期(入庫(kù)文件所屬日期：20140528）varchar(10)11spName廠商varchar(20)ERICSSON、NOKIASIERMENS、HUAWEI、ZTE12Cnt話單數(shù)bigintGGSN_YZ(業(yè)支GGSN維度數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1idIDintkey,自增2vGgsnNameGGSN名稱varchar(30)業(yè)支報(bào)表改字段為空3vGgsnIpAddressGGSNIP地址varchar(30)4irATType網(wǎng)絡(luò)類型int()rATType值5iDataVolumeGPRSUplink上行流量bigint()Byte6iDataVolumeGPRSDownlink下行流量bigint()Byte7iDataVolumeGPRSTotallink總流量bigint()Byte8iPSFurnishChargingInformationFCIint()0：FCI=16、1：FCI=11、2：FCI其他9iFlowType流量類型int()0：省內(nèi)、1：漫入10vStatTime日期(入庫(kù)文件所屬日期：20140528）varchar(10)11Cnt話單數(shù)bigintGGSN_GI_ESB(ESB來(lái)的GI數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1idIDintkey,自增2vGgsnNameGGSN名稱varchar(30)3iDataVolumeGPRSUplink上行流量bigint()Byte4iDataVolumeGPRSDownlink下行流量bigint()Byte5vStatTime小時(shí),文件名中小時(shí)部分varchar(20)20140701220000.csvGGSN_GI(GI匯總數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1idIDintkey,自增2vGgsnNameGGSN名稱varchar(30)3vGgsnIpAddressGGSNIP地址varchar(30)沒(méi)有用到4irATType網(wǎng)絡(luò)類型int()rATType值沒(méi)有用到5iDataVolumeGPRSUplink上行流量bigint()Byte6iDataVolumeGPRSDownlink下行流量bigint()Byte7iDataVolumeGPRSTotallink總流量bigint()Byte8iPSFurnishChargingInformationFCIint()0：FCI=16、1：FCI=11、2：FCI其他沒(méi)有用到9iFlowType流量類型int()0：省內(nèi)、1：漫入沒(méi)有用到10vStatTime日期(入庫(kù)文件所屬日期：20140528）varchar(10)CG_WW(網(wǎng)管CG維度數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類型備注1idIDintkey,自增2vCGNameWWCG局名稱_網(wǎng)管varchar(30)3vCGNameYZCG局名稱_業(yè)支varchar(30)4irATType網(wǎng)絡(luò)類型varchar(30)rATType值5iDataVolumeGPRSUplink上行流量int()Byte6iDataVolumeGPRSDownlink下行流量bigint()Byte7iDataVolumeGPRSTotallink總流量bigint()Byte8iPSFurnishChargingInformationFCIbigint()0：FCI=16、1：FCI=11、2：FCI其他9iFlowType流量類型int()0：省內(nèi)、1：漫入10vStatTime日期(入庫(kù)文件所屬日期：20140528）varchar(10)11spName數(shù)據(jù)來(lái)自的廠商