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)
The following types of data are currently available for Standard Route 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 |
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: |
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 |
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: |
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 |
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 |
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 |