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

1、CG舌單稽查系統(tǒng)數(shù)據(jù)字典說(shuō)明書(shū)上海新炬網(wǎng)絡(luò)技術(shù)有限公司編寫(xiě):.審核：.日期：.CG話(huà)單稽查系統(tǒng)數(shù)據(jù)字典說(shuō)明書(shū)更改記錄W更改原因更改后版本更改人生效日期備注1流量增加地市和記錄數(shù)1.1李云根2014-12-312增加ServicelD1.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目錄1. CDR話(huà)單數(shù)據(jù)表41.1. ERI_GGSN_YYYYMMDD（愛(ài)立信GGSN話(huà)單數(shù)據(jù)）41.2. ERI_P_GW

2、_YYYYMMDD（愛(ài)立信P-GW話(huà)單數(shù)據(jù)）51.3. HW_GGSN_YYYYMMDD（華為GGSN話(huà)單數(shù)據(jù)）61.4. HW_P_GW_YYYYMMDD（華為P-GW話(huà)單數(shù)據(jù)）71.5. HW_SMS_YYYYMMDD（華為短信數(shù)據(jù)）91.6. NSN_GGSN_YYYYMMDD（諾西GGSN話(huà)單數(shù)據(jù)）101.7. ZTE_P_GW_YYYYMMDD（中興P-GW話(huà)單數(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.

3、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ù)）191.16. ZTE_MTCall_YYYYMMDD（中興語(yǔ)音被叫數(shù)據(jù)）191.17. ZTE_FWCall_YYYYMMDD（中興語(yǔ)音前轉(zhuǎn)數(shù)據(jù)）211.18. HW_OCG_YYYYMMDD（華為智能網(wǎng)數(shù)據(jù)）221.19. ERI_OMM

4、_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）262.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ì)表283.1.

5、 GGSN_WW（網(wǎng)管GGSN維度數(shù)據(jù)）283.2. GGSN_YZ（業(yè)支GGSN維度數(shù)據(jù)）283.3. GGSN_GI_ESB（ESB來(lái)的GI數(shù)據(jù)）293.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名稱(chēng)對(duì)照表）323.11. CodeMap（地市代碼名稱(chēng)對(duì)照表）323.12. Service_WW（網(wǎng)管S

6、erviceID維度數(shù)據(jù)）323.13. Voice_WW（網(wǎng)管語(yǔ)音數(shù)據(jù)）333.14. DX_WW（網(wǎng)管短信數(shù)據(jù)）333.15. OCG_WW（網(wǎng)管智能網(wǎng)數(shù)據(jù)）331.CDR話(huà)單數(shù)據(jù)表1.1. ERI_GGSN_YYYYMMDD(愛(ài)立信GGSN話(huà)單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1servedIMSIIMSIvarchar(16)2ggsnAddressGGSN的ip地址varchar(16)3chargingID計(jì)費(fèi)標(biāo)識(shí)Numeric(32,0)4sgsnAddressSGSN的ip地址varchar(16)5accessPointNameNIAPNvarchar(32)6record

7、OpeningTime記錄打開(kāi)的時(shí)間timestamp7duration會(huì)話(huà)時(shí)長(zhǎng)Int8changeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)9causeForRecClosing話(huà)單關(guān)閉的原因varchar(32)10nodeID網(wǎng)元名稱(chēng)varchar(32)11servedMSISDN原始用戶(hù)號(hào)varchar(16)12msisdnMSIDNVarchar(16)13chargingCharacteristics付費(fèi)類(lèi)型varchar(10)14rATType使用的無(wú)線(xiàn)技術(shù)Int15servedIMEISVIMESVvarchar(16)16durationC合并時(shí)長(zhǎng)Int1

8、7dataVolumeGPRSUplink上行流量Int18dataVolumeGPRSDownlink下行流量Int19userLocationInformation終端位置信息varchar(32)20pSFurnishChargingInformation從OCS接收的FCIInt21consolidationResult合并結(jié)果狀態(tài)varchar(16)22msisdnSeg86后7位數(shù)字varchar(32)23IsRoamin是否漫入，1=是,0=否Int24City地市編號(hào)Varchar(8)25ServiceDataCountServiceData中的記錄數(shù)Int26Servi

9、ceDataServiceIDText27cgIDCG網(wǎng)維名稱(chēng)varchar(32)28spName）商名稱(chēng)varchar(32)ERICSSON29ProgressTime入庫(kù)時(shí)間timestamp30cdrFileName話(huà)單解碼文件名Varchar(100)31cdrFileSize話(huà)單解碼文件容量大小int32fromETLETL來(lái)源Varchar(500)33spArea網(wǎng)元所在片區(qū)Varchar(20)34distriblot分發(fā)批號(hào)varchar(200)1.2. ERI_P_GW_YYYYMMDD(愛(ài)立信P-GW話(huà)單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1servedIMSI用戶(hù)

10、的IMSIvarchar(16)2pGWAddress使用的P-GW的控制面IP地址varchar(16)3chargingIDIPCAN承載標(biāo)識(shí)用來(lái)識(shí)另JPCNs創(chuàng)建的不同IPCAN承載Numeric(32,0)4servingNodeAddress在此記錄期間使用的SGSN、S-GW的控制面IP地址的列表varchar(16)5accessPointNameNIAPN的網(wǎng)絡(luò)標(biāo)識(shí)部分varchar(32)6recordOpeningTime記錄打開(kāi)時(shí)間timestamp7duration會(huì)話(huà)時(shí)長(zhǎng)Int8changeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)9causeForRe

11、cClosing關(guān)閉原因varchar(32)10nodelDP-GW的名稱(chēng)varchar(32)11servedMSISDN原始用戶(hù)號(hào)varchar(16)12MSISDNMSISDNVarchar(16)13chargingCharacteristics此IPCAN承載應(yīng)用的計(jì)費(fèi)特性varchar(16)14pSFurnishChargingInformation實(shí)時(shí)計(jì)費(fèi)會(huì)話(huà)特定的信息Int15servedIMEISV記錄移動(dòng)設(shè)備的IMEISVvarchar(16)16rATType該字段指示MS當(dāng)前使用的無(wú)線(xiàn)接入技術(shù)類(lèi)型(RAT)Int17userLocationInformation用

12、戶(hù)的位置信息varchar(32)18IsRoamin是否漫入，1=是,0=否Int19City地市編號(hào)Varchar(8)20ServiceDataCountServiceData中的記錄數(shù)Int21ServiceDataServiceIDText22datavolumeFBCUplink上行流量Int23datavolumeFBCDownlink下行流量Int24startTime用戶(hù)IP-CAN會(huì)話(huà)開(kāi)始的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話(huà)第一個(gè)承載的話(huà)單中timestamp25stopTime用戶(hù)IP-CAN會(huì)話(huà)終止的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話(huà)最后一個(gè)承載的話(huà)單中timestam

13、p26consolidationResult合并結(jié)果狀態(tài)varchar(16)27msisdnSeg號(hào)段varchar(8)28cgIDCG網(wǎng)維名稱(chēng)varchar(32)29spName)商名稱(chēng)varchar(32)ERICSSON30ProgressTime行解析生成時(shí)間timestamp31cdrFileName話(huà)單解碼文件名Varchar(100)32cdrFileSize話(huà)單解碼文件容量大小int33fromETLETL來(lái)源Varchar(500)34spArea網(wǎng)元所在片區(qū)Varchar(20)35distriblot分發(fā)批號(hào)varchar(200)1.3. HW_GGSN_YYYY

14、MMDD(華為GGSN話(huà)單數(shù)據(jù))ID字段名具體描述數(shù)據(jù)類(lèi)型備注1servedIMSIIMSIvarchar(16)2ggsnAddressGGSN的ip地址varchar(16)3chargingID計(jì)費(fèi)標(biāo)識(shí)Numeric(32,0)4sgsnAddressSGSN的ip地址varchar(16)5accessPointNameNIAPNvarchar(32)6dataVolumeGPRSUplink上行流量Int7dataVolumeGPRSDownlink下行流量Int8recordOpeningTime記錄打開(kāi)的時(shí)間timestamp9duration會(huì)話(huà)時(shí)長(zhǎng)Int10changeTim

15、e結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)11causeForRecClosing關(guān)閉原因Int12nodeID網(wǎng)元名稱(chēng)varchar(32)13servedMSISDN原始用戶(hù)號(hào)varchar(16)14MSISDNMSISDNVarchar(16)15chargingCharacteristics付費(fèi)類(lèi)型varchar(10)16sgsnPLMNIdentifier移動(dòng)國(guó)家代號(hào)和移動(dòng)網(wǎng)絡(luò)代號(hào)varchar(100)17rATType使用的無(wú)線(xiàn)技術(shù)Int18servedIMEISVIMESVvarchar(16)19userLocationInformation用戶(hù)的位置信息varc

16、har(200)20pSFurnishChargingInformation從OCS接收的FCIInt21consolidationResult合并結(jié)果狀態(tài)varchar(200)22msisdnSeg號(hào)段varchar(8)23IsRoamin是否漫入，1=是,0=否Int24City地市編號(hào)Varchar(8)25ServiceDataCountServiceData中的記錄數(shù)Int26ServiceDataServiceIDText27cgIDCG網(wǎng)維名稱(chēng)varchar(32)28spName）商名稱(chēng)varchar(20)HUAWEI29processtime行解析生成時(shí)間timesta

17、mp30cdrFileName話(huà)單解碼文件名Varchar(100)31cdrFileSize話(huà)單解碼文件容量大小int32fromETLETL來(lái)源Varchar(500)33spArea網(wǎng)元所在片區(qū)Varchar(20)34distriblot分發(fā)批號(hào)varchar(200)1.4. HW_P_GW_YYYYMMDD(華為P-GW話(huà)單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1servedlMSI用戶(hù)的IMSIvarchar(16)2servedlMEISV記錄移動(dòng)設(shè)備的IMEISVvarchar(16)3pGWAddress使用的P-GW的控制面IP地址varchar(16)4chargingI

18、DIPCAN承載標(biāo)識(shí)用來(lái)識(shí)另JPCNs創(chuàng)建的不同IPCAN承載Numeric(32,0)5servingNodeAddress在此記錄期間使用的SGSN、S-GW的控制面IP地址的列表varchar(16)6accessPointNameNIAPN的網(wǎng)絡(luò)標(biāo)識(shí)部分varchar(32)7datavolumeFBCUplink上行流量Int8datavolumeFBCDownlink下行流量Int9recordOpeningTime記錄打開(kāi)時(shí)間timestamp10duration本話(huà)單的持續(xù)時(shí)長(zhǎng)Int11changeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)12causeForRe

19、cClosing關(guān)閉原因Int13nodeIDP-GW的名稱(chēng)varchar(32)14servedMSISDN原始用戶(hù)號(hào)varchar(16)15MSISDNMSISDNVarchar(16)16userLocationInformation用戶(hù)的位置信息varchar(200)17chargingCharacteristics此IPCAN承載應(yīng)用的計(jì)費(fèi)特性varchar(10)18pSFurnishChargingInformation實(shí)時(shí)計(jì)費(fèi)會(huì)話(huà)特定的信息Int19rATType該字段指示MS當(dāng)前使用的無(wú)線(xiàn)接入技術(shù)類(lèi)型(RAT)Int20StartTime用戶(hù)IP-CAN會(huì)話(huà)開(kāi)始的時(shí)間，該

20、字段出現(xiàn)在IP-CAN會(huì)話(huà)第一個(gè)承載的話(huà)單中timestamp21StopTime用戶(hù)IP-CAN會(huì)話(huà)終止的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話(huà)最后一個(gè)承載的話(huà)單中timestamp22consolidationResult合并結(jié)果狀態(tài)varchar(16)23msisdnSeg號(hào)段varchar(8)24IsRoamin是否漫入，1=是,0=否Int25City地市編號(hào)Varchar(8)26ServiceDataCountServiceData中的記錄數(shù)Int27ServiceDataServiceIDText28cgIDCG網(wǎng)維名稱(chēng)varchar(32)29spName名稱(chēng)：ERICSSO

21、N、NOKIASIERMENS、HUAWEI、ZTEvarchar(20)HUAWEI30processtime行解析生成時(shí)間timestamp31cdrFileName話(huà)單解碼文件名Varchar(100)32cdrFileSize話(huà)單解碼文件容量大小int33fromETLETL來(lái)源Varchar(500)34spArea網(wǎng)元所在片區(qū)Varchar(20)35distriblot分發(fā)批號(hào)varchar(200)1.5. HW_SMS_YYYYMMDD(華為短信數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1RecNo話(huà)單序號(hào)varchar(20)2MsgID短消息IDvarchar(16)3OAdd

22、ress源地址varchar(32)4OAddressTON源地址TONvarchar(8)5OaddressNPI源地址NPIvarchar(6)6TAddress目的地址varchar(32)7TAddressTON目的地址號(hào)碼類(lèi)型。varchar(8)8TAddressNPI目的地址NPIvarchar(6)9SendTime短信提交時(shí)間timestamp10LastTime最后時(shí)間timestamp11Priority優(yōu)先級(jí)Int12LastStatus最終狀態(tài)報(bào)告Int13PID短消息的協(xié)議類(lèi)型。Int14LangType編碼方案Int15MsgLength消息長(zhǎng)度Int16MsgS

23、tatus短消息的狀態(tài)Int17MsgErrorCode短消息的錯(cuò)誤碼Int18MsgType短消息的類(lèi)型Int19MsgServiceType服務(wù)類(lèi)型Int20RSUdesc發(fā)收雙方PPS用戶(hù)描述varchar(16)21OrgAccount短消息發(fā)送帳號(hào)varchar(24)22DestAccount短消息接收帳號(hào)varchar(24)23MoMscAddrMOMSC地址varchar(32)24MtMscAddrMTMSC地址varchar(32)25ulServiceFlag被叫業(yè)務(wù)類(lèi)型varchar(24)26szOrgAddress3源地址varchar(32)27OrgTON3原

24、始主叫的TONvarchar(8)28OrgNPI3主叫的NPIvarchar(6)29szDestAddress3原始的目的地址varchar(32)30DestTON3被叫的TONvarchar(8)31DestNPI3被叫的NPIvarchar(6)32SMSNumber短信中心代碼varchar(18)33HostName話(huà)單主機(jī)名稱(chēng)varchar(32)34SPName）商名稱(chēng)varchar(32)HUAWEI35ProgressTime入庫(kù)時(shí)間timestamp36distriblot分發(fā)批號(hào)varchar(200)1.6. NSN_GGSN_YYYYMMDD(諾西GGSN話(huà)單數(shù)據(jù)

25、)ID字段名具體描述數(shù)據(jù)類(lèi)型備注1servedIMSIIMSIvarchar(16)2ggsnAddressGGSN的ip地址varchar(16)3chargingID計(jì)費(fèi)標(biāo)識(shí)Numeric(32,0)4sgsnAddressSGSN的ip地址varchar(16)5accessPointNameNIAPNvarchar(32)6dataVolumeGPRSUplink上行流量Int7dataVolumeGPRSDownlink下行流量Int8recordOpeningTime記錄打開(kāi)的時(shí)間timestamp9duration會(huì)話(huà)時(shí)長(zhǎng)Int10changeTime結(jié)束時(shí)間timestamp記

26、錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)11causeForRecClosing關(guān)閉原因Int12nodeID網(wǎng)元名稱(chēng)varchar(32)13servedMSISDN原始用戶(hù)號(hào)varchar(16)14MSISDNMSISDNVarchar(16)15chargingCharacteristics付費(fèi)類(lèi)型varchar(10)16sgsnPLMNIdentifier移動(dòng)國(guó)家代號(hào)和移動(dòng)網(wǎng)絡(luò)代號(hào)varchar(100)17rATType使用的無(wú)線(xiàn)技術(shù)Int18servedIMEISVIMESVvarchar(16)19userLocationInformation用戶(hù)的位置信息varchar(200)20pSFur

27、nishChargingInformation從OCS接收的FCIInt21consolidationResult合并結(jié)果狀態(tài)varchar(200)22msisdnSeg號(hào)段varchar(8)23IsRoamin是否漫入，1=是,0=否Int24City地市編號(hào)Varchar(8)25ServiceDataCountServiceData中的記錄數(shù)Int26ServiceDataServiceIDText27cgIDCG網(wǎng)維名稱(chēng)varchar(32)28spName）商名稱(chēng)varchar(20)NOKIASIERMENS29processtime行解析生成時(shí)間timestamp30cdrF

28、ileName話(huà)單解碼文件名Varchar(100)31cdrFileSize話(huà)單解碼文件容量大小int32fromETLETL來(lái)源Varchar(500)33spArea網(wǎng)元所在片區(qū)Varchar(20)34distriblot分發(fā)批號(hào)varchar(200)1.7. ZTE_P_GW_YYYYMMDD(中興P-GW話(huà)單數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1servedIMSI用戶(hù)的IMSIvarchar(16)2servedIMEISV記錄移動(dòng)設(shè)備的IMEISVvarchar(16)3pGWAddress使用的P-GW的控制面IP地址varchar(16)4chargingIDIPCAN承

29、載標(biāo)識(shí)用來(lái)識(shí)另JPCNs創(chuàng)建的不同IPCAN承載Numeric(32,0)5servingNodeAddress在此記錄期間使用的SGSN、S-GW的控制面IP地址的列表varchar(16)6accessPointNameNIAPN的網(wǎng)絡(luò)標(biāo)識(shí)部分varchar(32)7datavolumeFBCUplink上行流量Int8datavolumeFBCDownlink下行流量Int9recordOpeningTime記錄打開(kāi)時(shí)間timestamp10duration本話(huà)單的持續(xù)時(shí)長(zhǎng)Int11changeTime結(jié)束時(shí)間timestamp記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)12causeForRecClosin

30、g關(guān)閉原因Int13nodeIDP-GW的名稱(chēng)varchar(32)14servedMSISDN原始用戶(hù)號(hào)varchar(16)15MSISDNMSISDNVarchar(16)16userLocationInformation用戶(hù)的位置信息varchar(200)17chargingCharacteristics此IPCAN承載應(yīng)用的計(jì)費(fèi)特性varchar(10)18pSFurnishChargingInformation實(shí)時(shí)計(jì)費(fèi)會(huì)話(huà)特定的信息Int19rATType該字段指示MS當(dāng)前使用的無(wú)線(xiàn)接入技術(shù)類(lèi)型(RAT)Int20StartTime用戶(hù)IP-CAN會(huì)話(huà)開(kāi)始的時(shí)間，該字段出現(xiàn)在IP

31、-CAN會(huì)話(huà)第一個(gè)承載的話(huà)單中timestamp21StopTime用戶(hù)IP-CAN會(huì)話(huà)終止的時(shí)間，該字段出現(xiàn)在IP-CAN會(huì)話(huà)最后一個(gè)承載的話(huà)單中timestamp22consolidationResult合并結(jié)果狀態(tài)varchar(16)23msisdnSeg號(hào)段varchar(8)24IsRoamin是否漫入，1=是,0=否Int25City地市編號(hào)Varchar(8)26ServiceDataCountServiceData中的記錄數(shù)Int27ServiceDataServiceIDText28cgIDCG網(wǎng)維名稱(chēng)varchar(32)29spName廠(chǎng)商名稱(chēng)：ERICSSON、NOK

32、IASIERMENS、HUAWEI、ZTEvarchar(20)ZTE30processtime行解析生成時(shí)間timestamp31cdrFileName話(huà)單解碼文件名Varchar(100)32cdrFileSize話(huà)單解碼文件容量大小int33fromETLETL來(lái)源Varchar(500)34spArea網(wǎng)元所在片區(qū)Varchar(20)35distriblot分發(fā)批號(hào)varchar(200)1.8. ZTE_SMS_YYYYMMDD(中興短信數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1RecNo話(huà)單序號(hào)varchar(20)2CallType呼叫類(lèi)別Int1:MO,2:MT3CallingN

33、umber起呼方地址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信息類(lèi)別Int11LangType編碼方式Int0:English,8:Chinese12Priority優(yōu)先標(biāo)準(zhǔn)Int0:普通，非零：優(yōu)先13SMSNumber短信中心代碼var

34、char(18)14HostName話(huà)單主機(jī)名稱(chēng)varchar(32)15spName）商名稱(chēng)varchar(32)ZTE16processtime行解析生成時(shí)間timestamp17distriblot分發(fā)批號(hào)varchar(200)1.9. ERI_MOCall_YYYYMMDD（愛(ài)立信語(yǔ)音主叫數(shù)據(jù)）序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1tACTRAFFICACTIVITYCODE(TAC)varchar(12)2CINumbercallidentificationnumbervarchar(24)3RSNumberRecordSequenceNumbervarchar(24)4TypeCSTy

35、peofCallingSubscriberINTEGER5CallingNumberCallingPartyNumbervarchar(24)6CallingSIMSICallingSubscriberIMSIvarchar(20)7CallingSIMEICallingSubscriberIMEIvarchar(20)8CalledNumberCalledPartyNumbervarchar(24)9DisconnectPDisconnectingPartyvarchar(8)10TimeForStartDatetimeforStartofChargeDatetime11TimeForSto

36、pDatetimeforStopofChargeDatetime12CdurationTheseconds(total)ofChargeableDurationINTEGER記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)13MSCIdentvarchar(24)14MSCaddressMSCAddressvarchar(16)15chargeNumberChargeNumbervarchar(24)16mMENamemMEName-NEWCALLDATAvarchar(64)PARAMETERS17mMEIdentitymMEIdentity-NEWCALLDATAPARAMETERSvarchar(16)18cgI

37、D網(wǎng)元名稱(chēng)varchar(24)19spName）商名稱(chēng)varchar(16)ERICSSON20ProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetime21cdrFilename話(huà)單解碼文件名varchar(100)22cdrFilesize話(huà)單解碼文件容量大小。INTEGER單位：KB23FromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例DN0002GSDISK1#ftp:/abc:abc24spArea網(wǎng)元所在片區(qū)Varchar(20)25distriblot分發(fā)批號(hào)varchar(200)1.10. ERI_MTCall_YYYYMMDD（愛(ài)立信語(yǔ)音被叫數(shù)據(jù)）序號(hào)字段名具

38、體描述數(shù)據(jù)類(lèi)型備注1tACTRAFFICACTIVITYCODE(TAC)varchar(12)2CINumbercallidentificationnumbervarchar(24)3RSNumberRecordSequenceNumbervarchar(24)4TypeCSTypeofCallingSubscriberINTEGER5CallingNumberCallingPartyNumbervarchar(24)6CalledNumberCallingSubscriberIMSIvarchar(20)7CalledIMSICallingSubscriberIMEIvarchar(20)

39、8CalledIMEICalledPartyNumbervarchar(24)9RoamingNumbervarchar(24)10DisconnectPDisconnectingPartyvarchar(8)11TimeForStartDatetimeforStartofChargeDatetime12TimeForStopDatetimeforStopofChargeDatetime13CdurationTheseconds(total)ofChargeableDurationINTEGER記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)14MSCIdentvarchar(24)15MSCaddressMSCAdd

40、ressvarchar(16)16mMENamemMEName-NEWCALLDATAPARAMETERSvarchar(64)17cgID網(wǎng)元名稱(chēng)varchar(24)18spName）商名稱(chēng)varchar(16)ERICSSON19ProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetime20cdrFilename話(huà)單解碼文件名varchar(100)21cdrFilesize話(huà)單解碼文件容量大小。INTEGER單位：KB22FromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例DN0002GSDISK1#ftp:/abc:abc23spArea網(wǎng)元所在片區(qū)Varchar(20)2

41、4distriblot分發(fā)批號(hào)varchar(200)1.11. ERI_FWCall_YYYYMMDD(愛(ài)立信語(yǔ)音前轉(zhuǎn)數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1tACTRAFFICACTIVITYCODE(TAC)varchar(12)2CINumbercallidentificationnumbervarchar(24)3RSNumberRecordSequenceNumbervarchar(24)4TypeCSTypeofCallingSubscriberINTEGER5CallingNumberCallingPartyNumbervarchar(24)6CalledNumberCalled

42、PartyNumbervarchar(20)7OCalledNumbervarchar(20)8RNumbervarchar(24)9Rcounter10RIMSIvarchar(24)11DisconnectPDisconnectingPartyvarchar(8)12TimeForStartDatetimeforStartofChargeDatetime13TimeForStopDatetimeforStopofChargeDatetime14CdurationTheseconds(total)ofChargeableDurationINTEGER記錄打開(kāi)時(shí)間+會(huì)話(huà)時(shí)長(zhǎng)15MSCIdent

43、varchar(24)16MSCaddressMSCAddressvarchar(16)17mMENamemMEName-NEWCALLDATAPARAMETERSvarchar(64)18cgID網(wǎng)元名稱(chēng)varchar(24)19spName）商名稱(chēng)varchar(16)ERICSSON20ProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetime21cdrFilename話(huà)單解碼文件名varchar(100)22cdrFilesize話(huà)單解碼文件容量大小。INTEGER單位：KB23FromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例DN0002GSDISK1#ftp:/abc:

44、abc24spArea網(wǎng)元所在片區(qū)Varchar(20)25distriblot分發(fā)批號(hào)varchar(200)1.12. HW_MOCall_YYYYMMDD(華為語(yǔ)音主叫數(shù)據(jù))序號(hào)字段名具體描述數(shù)據(jù)類(lèi)型備注1recordType指明本話(huà)單是主叫話(huà)單。INTEGER2servedIMSI主叫的IMSI號(hào)碼。varchar(24)3servedIMEI主叫設(shè)備的IMEI號(hào)碼varchar(24)4servedMSISDN主叫用戶(hù)的基本MSISDN號(hào)碼。varchar(24)5callingNumber主叫用戶(hù)的MSISDN號(hào)碼。varchar(24)6calledNumber被叫的目的號(hào)碼va

45、rchar(24)7translatedNumber經(jīng)過(guò)號(hào)碼變換后的被叫號(hào)碼。varchar(24)8connectedNumber最終連接的被叫號(hào)碼。varchar(24)9roamingNumber被叫用戶(hù)的漫游號(hào)碼。varchar(24)10seizureTime主叫側(cè)指配完成的時(shí)間戳。datetime11answerTime成功通話(huà)中被叫方應(yīng)答的時(shí)間戳。datetime12releaseTime釋放話(huà)務(wù)信道的時(shí)間戳。datetime13callDurationINTEGER通話(huà)的計(jì)費(fèi)時(shí)長(zhǎng)。INTEGER14calledIMSI被叫用戶(hù)的IMSIvarchar(24)15callType指示呼叫類(lèi)型INTEGER16calledIMEI被叫設(shè)備的IMEI號(hào)碼varchar(24)17officeName計(jì)費(fèi)局名稱(chēng)。varchar(32)18csfb-flagCSFB業(yè)務(wù)標(biāo)識(shí)。INTEGER19cgid網(wǎng)元名稱(chēng)varchar(24)20spName）商名稱(chēng)varchar(16)HUAWEI21ProgressTime數(shù)據(jù)處理入庫(kù)時(shí)間datetime22cdrFilename話(huà)單解碼文件名varchar(100)23cdrFilesize話(huà)單解碼文件容量大小。INTEGER單位：KB24FromETLETL來(lái)源#數(shù)據(jù)下載地址varchar(500)例DN0