Billing Guide
Appendix C: Example Call Detail Block File

Table Of Contents

Example Call Detail Block File


Example Call Detail Block File


Revised: March 11, 2009, OL-4486-12

This section provides an example of an actual call detail block (CDB) record generated by the Cisco BTS 10200 Softswitch's Element Management System (EMS) for a Local POTS SIP to MGCP Line Call. The ASCII text as created is depicted below with a translation matrix after it to decode the contents of the record within the file. The billing file shown contains only a single record.

The times shown in the record below are in Pacific Standard Time (PST), which is offset minus 8 hours from Greenwich Mean Time (GMT).

This CDB is configured to use the semicolon (;) as a field separator and the vertical bar (|) as a record separator. Where the value for a given field is denoted by an empty field, two field separators in a row [semicolons (;;)], it indicates that the field is irrelevant in the call context shown.

The contents of the billing file are:

001;04.5;2004-09-01 10:35:10;CA146|| 3;1009190106;1009190127;;;1009190108;1009190108;1009190127;;;;;;;;;;;00:00:19;;; 1009190127;9725581000;9775551232;9725581000;;9775551232;;;;;;;;;;;;;;1;0;16;0;5; 0;158;;;;;;;;;0;;;;;;;;1056;515;168960;80608;0;344;2;0;0;0;;0;0;1;0;0;;0;CA14638 1;;;;CA146;2;;;;;;;;;;;;;;;;;;;;;;0;0;;;;;9725581000;757C88A2-3AA111CC-81B98F4D-B468D474@10.9.27.4 ;10.89.227.58;;;;;;;;;;;;;;;;;;;;;8;10;2;;;;;;1;;;;9725581000;0;0;0;0;0;1;DAL000 22;10.0.1.4;10.0.4.9;;;;;;223344;1;ANONYMOUS;3;;||1;

2004-09-01 10:35:30

Header information:

Header/TrailerVersionNumber=001

CDBVersion=04.5

StartingTime=2004-09-01 10:35:10

CAName=CA146

Trailer information:

NumberOfRecords=1

Close/FinishTime=2004-09-01 10:35:30

The record is decoded as follows.

This is not intended to mirror the CDB REPORT command on the Cisco BTS 10200 exactly; this is for illustrative purposes only.

CALLTYPE=LOCAL

SIGSTARTTIME=2004-09-1 10:35:06

SIGSTOPTIME=2004-09-1 10:35:27

ICSTARTTIME=

ICSTOPTIME=

CALLCONNECTTIME=2004-09-1 10:35:08

CALLDISCONNTECTTIME=2004-09-1 10:35:08

CALLANSWERTIME=2004-09-1 10:35:27

DBQUERYTIME1=

SERVICEINSTANCETIME1=

SERVICEINSTANCETIME2=

SERVICEINSTANCETIME3=

SERVICEACTIVATIONTIME1=

SERVICEACTIVATIONTIME2=

SERVICEACTIVATIONTIME3=

SERVICEDEACTIVATIONTIME1=

SERVICEDEACTIVATIONTIME2=

SERVICEDEACTIVATIONTIME3=

CALLELAPSEDTIME=00:00:19

INTERCONNECTELAPSEDTIME=

ORIGQOSTIME=

TERMQOSTIME=2004-09-1 10:35:27

ORIGNUMBER=972-555-1000

TERMNUMBER=977-555-1232

CHARGENUMBER=972-555-1000

LOCROUTINGNUMBER=

DIALEDDIGITS=9775551232

FORWARDINGNUMBER=

SERVICETYPE1=

SERVICETYPE2=

SERVICETYPE3=

FEATUREDATA1=

FEATUREDATA2=

FEATUREDATA3=

AUTHCODE=

ACCTCODE=

QUERYTYPE=

QUERYRESULTCODE=

RETURNEDDATA1=

MLHGROUP= (Release 4.5.1)

OFFHOOKIND=Yes

SHORTOFFHOOKIND=No

CALLTERMCAUSE=Normal Call Clearing

OPERATORACTION=Auto Identified, Customer Dialed

ORIGSIGNALINGTYPE=SIP

TERMSIGNALINGTYPE=MGCP Line

ORIGTRUNKGROUPNUMBER=158

TERMTRUNKGROUPNUMBER=

OUTGOINGTRUNKNUMBER=

CARRIERID=

ORIGCIRCUITID=

TERMCIRCUITID=

PICSOURCE=

ICINCID=

ICINCEVENTSTATUSIND=

ICINCRTIND=

ORIGQOSPACKETSSENT=

ORIGQOSPACKETSRECD=

ORIGQOSOCTETSSENT=

ORIGQOSOCTETSRECD=

ORIGQOSPACKETSLOST=

ORIGQOSJITTER=

ORIGQOSAVGLATENCY=

TERMQOSPACKETSSENT=1056

TERMQOSPACKETSRECD=515

TERMQOSOCTETSSENT=168960

TERMQOSOCTETSRECD=80608

TERMQOSPACKETSLOST=0

TERMQOSJITTER=344

TERMQOSAVGLATENCY=2

OPERATORINVOLVED=No

CASUALCALL=No

CONNECTIONTYPE=IP

PACKETIZATIONTIME=

SILENCESUPPRESSION=No

ECHOCANCELLATION=No

CODECTYPE=PCMU G711

INTERSTATEINDICATOR=No

RECORDTYPE=Normal Record

TIMERINDICATOR=

PRESENTTIME=

OVERALLCORRELATIONID=CA146381

JIP=

ORIGCLLI=

TERMCLLI=

CALLAGENTID=CA146

ORIGPOPTIMEZONE=CST

USAGESENSITIVE1=

USAGESENSITIVE2=

USAGESENSITIVE3=

ORIGH323CALLORIGIN=

ORIGH323CALLTYPE=

ORIGH323CONFID=

ORIGH323REMOTEADDRESS=

ORIGH323TIMEDAY=

ORIGH323VOICEQUALITY=

ORIGH323SUBSCRIBER=

ORIGH323GATEWAYID=

ORIGH323GATEKEEPERID=

TERMH323CALLORIGIN=

TERMH323CALLTYPE=

TERMH323CONFID=

TERMH323REMOTEADDRESS=

TERMH323TIMEDAY=

TERMH323VOICEQUALITY=

TERMH323SUBSCRIBER=

TERMH323GATEWAYID=

TERMH323GATEKEPERID=

ORIGTYPE=ON NET

TERMTYPE=ON NET

SOURCESERVICEPROVIDERID=

DESTINATIONSERVICEPROVIDERID=

SOURCECARRIERID=

DESTINATIONCARRIERID=

ORIGSIPUSERNAME=9725551000

ORIGSIPCALLID=757C88A2-3AA111CC-81B98F4D-B468D474@1.2.3.4

ORIGSIPADJACENTHOPADDR=1.2.3.4

DBQUERYTIME2=

QUERYRESULTCODE2=

QUERYTYPE2=

RETURNEDDATA2=

DBQUERYTIME3=

QUERYRESULTCODE3=

QUERYTYPE3=

RETURNEDDATA3=

RESULTCODE1=

RESULTCODE2=

RESULTCODE3=

NASERRORCODE=

NASDLCXREASON=

NASPREAUTHENTICATIONRESULT=

FAXINDICATOR=Voice Only

FAXPAGESSENT=

FAXPAGESRECEIVED=

SERVICEINTERROGATIONTIME1=

SERVICEINTERROGATIONTIME2=

SERVICEINTERROGATIONTIME3=

ORIGPOPID=8

TERMPOPID=10

TERMPOPTIMEZONE=CST

DIALPLANID=

GTDGLOBALCALLINDICATOR=

TERMSIPUSERNAME=

TERMSIPCALLID=

TERMSIPADJACENTHOPADDRESS=

ORIGSIPCALLTYPE=Subscriber

TERMSIPCALLTYPE=

ORIGH323NETWORKPROVIDERID=

DESTH323NETWORKPROVIDERID=

ORIGINALORIGNUMBER=972-555-1000

VIDEOCODEC=

CALLINGPARTYCATEGORY=

CALLEDPARTYINDICATOR=

CAllEDPARTYPORTEDIN=NO

CAllINGPARTYPORTEDIN=NO

BILLINGRATEINDICATOR=FLAT RATE 1

ACCOUNTID=DAL00022

ORIGENDPOINTADDR=10.0.1.4

TERMENDPOINTADDR=10.0.4.9

ORIGCMTSID=

TERMCMTSID=

ORIGFIBERNODEID=

TERMFIBERNODEID=

CALLSUBTYPE=

SENSORID=223344

ORIGINTL=NO

ORIGCALLINGNAME=ANONYMOUS

ORIGPRIVACYIND=FULL

ORIGCALLEDPORTEDNOA=NONE

TERMCALLEDPORTEDNOA=NONE

CHARGINUNITS= (Release 4.5.1)

ORIGLINEINFO= (Release 4.5.1)

CENTREXGROUP= (Release 4.5.1)

COUNTRYCODE= (Release 4.5.1, MR1)