The following list shows all the columns displayed by the Choose Columns window that you can open when working with the windows such as Acquisition Topics, Rating Topics, Scheduled Job Topics, Acquisition Sessions:
OID: Displays the session identifier.
Job ID: Displays the job identifier.
User ID: Displays the user ID of the CDR.
Service ID: Displays the service ID of the CDR.
Subscription ID: Displays the ID of the subscription which the CDR relates to.
Acquisition ID: Displays the unique ID of the acquisition session during which the CDR was acquired.
Rating ID: Displays the unique ID of the rating session during which the CDR was rated and charged.
Name: Displays the CDR name.
Description: Displays the session or job description.
Start Date: Displays the date on which the session or job was launched.
Consumption Date: Displays the consumption date of the CDR.
Acquisition Date: Displays the date on which the CDR was acquired.
Rating Date: Displays the date on which the CDR was rated and charged.
Status: Displays the session status, which can be “In progress”, “Stopped” or “Ended”.
Duration (sec.): Displays the session or job duration.
Type: Displays the job type, which can be “Database Cleaning” or “Rating Session”.
Spot Speed (/sec.): Displays the current acquisition or rating speed.
Avg. Speed (/sec.): Displays the average acquisition or rating speed.
Max. Speed (/sec.): Displays the maximum acquisition or rating speed.
Acquisition Mode: Displays the session mode, which can be “Deduplicate”, “Reject duplicate” or “Acquire”.
Rating Mode: Displays the session mode, which can be Selection by subscription and stop on first fail, Selection by subscription and rate all, and so on.
No. New CDRs: Displays the number of CDRs acquired during the session.
No. Duplicated CDRs: Displays the number of CDRs duplicated during the session.
Source: Displays the acquisition source of CDRs.
Max. CDR Consumption Date: Displays the date used as a criterion for filtering CDRs. Only the CDRs whose consumption date is earlier than the Max Consumption date are rated.
No. Rated CDRs: Displays the number of CDRs rated and charged during the session.
No. Erroneous CDRs: Displays the number of erroneous CDRs occurred during the session.
Batch Rating Grp ID: Displays batch rating group.
Error Code: Displays the code of the rating error of the CDR.
Error Description: Displays the description of the error code.
Magic Number: Displays the property value used to check if the CDR is unique in the database.