Call Detail Errors Grid example

Call Detail Errors

The Call Detail Errors grid is available for displaying any exceptions that occurred during a Call Details Import. These Exceptions include:

Billing Errors
Rating Errors
Duplicate Records
Other Errors

This grid is very similar to the Call Details grid, except it loads with pre-applied filters to display Errors.

View Import File

A User can view the raw data of the Import File by clicking the View Import File button. If the record was manually entered the User gets a message that reflects that it's a manually entered record. Otherwise, the User is able to view the record's raw data.

Call Details Import File form example

Reprocess Rating Errors

The button reprocesses "Rating Errors", such as missing Call Rates or failures to determine the Call Type during the Rating Process.

Rerate Call Details Errors Dialogue

This is an intensive process and it is not recommended to run this event during working hours.

Archive

Due to the large quantity of data typically associated with Call Details, there is an automatic Data Archiving function that runs on the Call Details records. When there is an Archives available, it shows up to the User in a drop-down selection on the grid:

Within the Archive Selector, a User finds a list of the archived data. This list should look like the following image:

Table Selector dropdown field example

Call Detail Errors are Archived after the Calls are 3 months old in the CALL_DETAILS table. The Archived items are stored with a format of two number year and two number month like so: CALL_DETAILS_YYMM. To view an archived grid simply select the Year/Month of Details that is required by clicking its checkmark, and click anywhere else in the application. The Archive loads and be possible to view.

Call Detail Errors can also be manually archived by selecting them in the grid and clicking on the button. This process only works for Calls either in a Billed status or an Error status.

Error Statuses

The following is a listing of the Call Statuses and what they mean:

Duplicate - Same Call Start Time, Duration, Origination Number, and Destination Number as a previous Call. Duplicates do not appear on the Bill.
Error - An error occurred during the Import File processing. This will re-try each night.
Unrecoverable Error - An error that cannot be fixed, so it will not try again each night.
Rating Error - An error during Rating. This will re-try each night.
Billing Error - Indicates an error during Billing.

Call Detail Errors Additional

PCR-360 supports a set of configurable additional columns/fields that can be added to the CALL_DETAILS table. These fields can be used to store any information that is needed for business or reporting purposes. Defining these additional fields is done in the application Configuration Options. Contact PCR for assistance defining these fields.

Browser not supported