Data Files

Data files are in CSV (comma seperated values) format, desctibed as:

The following types of data are currently available for Intelligent Routing Numbers:

Charge Data - Intelligent Routing Numbers

Call Data - Raw - Intelligent Routing Numbers (default format)

Call Data - Analysed - Intelligent Routing Numbers

 

The following types of data are currently available for Standard Route Numbers:

Call Data - Standard Route Numbers

 


Charge Data - Intelligent Routing Numbers

Filename: CRG_[Period]_[accountid]_[Date].csv

The Charge data file contains records each identifying a charge against the operating balance of the specified account, each record is of the following format

"Created","AccountID","ChargeDescription","ChargeType","ItemID","Charge","PhoneNumber"

where

Column Description

Created

Datetime Charge occurred
AccountID Specific AccountID
ChargeDescription Description of the Charge
ChargeType Charge Code
ItemID Unique ID of the Item associated with the charge e.g. service, number
Charge Amount of Charge in pence
PhoneNumber Phonenumber of the Item if appropriate to the charge

back to the top


Call Data - Raw - Intelligent Routing Numbers

Filename: CDRCallData.csv

The raw version of the Call Data file contains records identifying all calls made against an account. Each record identifies either an inbound call received on a non test number or an outbound call made. Each record contains the same fields, the inbound record has the outbound section of the record completed with the outbound call details of the last call attempt, if a diverted call attempt was made. Each record is in the following format:

"AccountID","CallID","Created","Start","Finish","Duration","CLIData","DDIData","ServiceID","Status","Type","AccountCharge","NumberID","Received","AssocCallID","ExtensionID","OutCallID","CallAccepted","OutDuration","OutStatus","OutNumber","OutCharge

where

Column Description
AccountID Specific AccountID
CallID Unique ID for this call, should not be duplicated
Created Datetime inbound call recorded
Start Datetime inbound call answered
Finish Datetime inbound call finished
Duration Duration is seconds
CLIData Caller's Line Id
DDIData Number Call received on
ServiceID

Service initiated by the call.

NOTE:
1. Although Time Of Day may be associated with the number (DDIData) this would be the service run by Time Of Day.
2. Switchboard service would be recorded rather than any services selected.

Status code representing the call status (how ended or why), explanation
Type 1 - Inbound call, 0 - Outbound call
AccountCharge amount debited from the account Operating Balance
NumberID Unique ID of the called number
Received ignore
AssocCallID For outbound call records contains the Unique CallID of the inbound call record
ExtensionID ID of the extension of the last outbound call attempt, Group Divert services only
OutCallID Unique CallID of the last outbound call attempt
CallAccepted flag indicates if the call was accepted
OutDuration Duration of the last outbound call attempt
OutStatus End of Call status of the last outbound call attempt. Code representing the call status (how ended or why), explanation
OutNumber Number dialled by the outbound call
OutCharge Cost of the last outbound call attempt

back to the top


Call Data - Analysed - Intelligent Routing Numbers

Filename: CDR_[Period]_[accountid]_[Date].csv

The analysed version of the Call Data file contains records identifying inbound and outbound calls. Each inbound call received on a non test number is listed, the outbound section of the record is completed if a diverted call attempt was made the outduration and outcost are a sum of the outbound call attempts duration and charges, these columns are highlighted in red in the table below.

Each record is in the following format:

"AccountID","CallID","Created","Start","Finish","Duration","CLIData","DDIData","ServiceID","Status","Type","AccountCharge","NumberID","Received","AssocCallID","ExtensionID","OutCallID","CallAccepted","OutDuration","OutStatus","OutNumber","OutCharge"

where

Column Description
AccountID Specific AccountID
CallID Unique ID for this call, should not be duplicated
Created Datetime inbound call recorded
Start Datetime inbound call answered
Finish Datetime inbound call finished
Duration Duration is seconds
CLIData Caller's Line Id
DDIData Number Call received on
ServiceID

Service initiated by the call.

NOTE:
1. Although Time Of Day may be associated with the number (DDIData) this would be the service run by Time Of Day.
2. Switchboard service would be recorded rather than any services selected.

Status code representing the call status (how ended or why), explanation
Type 1 - Inbound Call Record, 0 - Outbound call
AccountCharge amount debited from the account Operating Balance for this portion of the calll
NumberID Unique ID of the called number
Received ignore
AssocCallID For outbound calls records contains the Unique CallID of the inbound call record
ExtensionID ID of the extension of the last outbound call attempt, Group Divert services only
OutCallID Unique CallID of the last outbound call attempt
CallAccepted flag indicates if the call was accepted
OutDuration Sum of all the durations of the outbound call attempts
OutStatus End of Call status of the last outbound call attempt. Code representing the call status (how ended or why), explanation
OutNumber Number dialled by the last outbound call
OutCharge Sum of the Cost (AccountCharge) of all the outbound call attempts

back to the top


Call Status Explanation

The following tables lists all the possible status codes with a description.

 

Status Code Description
1 Call Starting
7 In Progress
700 Failed PIN retrieval
701 Caller Hangup during PIN retrieval
702 Too many PIN attempts
703 Requested service not active
704 Error getting PIN
705 Call disconnected by server
706 Max call time reached
707 Caller hung up
708 Called party hung up
709 Call hung up during start
710 Unknown Error
711 Prompt not found
712 Normal Call Termination
713 Terminated by Web
714 Normal Termination
715 Called Party Rejected Call
716 Not Connected
717 Inbound call on called party trunk
718 Error acquiring trunk to make call
719 Divert Rejected
720 Caller hung up before answer
721 Number Busy
722 No Answer
723 Terminated by Caller
724 Caller Hung up before Accept
725 Error returned from database lookup (MOM)
726 No caller input, hung up
1025 Caller blocked - call rejected
1034 No Active Service
1074 Number blocked
1200 Accepted
1201 Rejected
1202 Abandoned
1203 Voicemail
1204 Over Queue Max
1205 Exceeded Queue time
   

back to the top


 

Call Data - Standard Route Numbers

Filename: CDRResponse_[Period]_[accountid]_[Date].csv

The Standard Route Call Data file contains records identifying all calls made against an account using Standard Route numbers. Each record is in the following format:

"AccountID","DialledNumber","TerminationNumber","Duration","Date"

where

Column Description
AccountID Specific AccountID
DDIData Number Call received on
CLIData Caller's Line Id. ** This may be an entire CLI, only an area code, or "number withheld"
TerminationNumber The terminating number that the call is connected to
Duration Call duration in seconds
Start Datetime inbound call answered

back to the top