...
If errors occur during the process above, the billing record is moved into an error queue for manual investigation and handling. Therefore, knowledge of the rating and billing process is key for the investigation and resolution of rating errors.
This page document describes the activities in steps 3.1 and 3.2 in the table above, and can be used to trouble shoot rating errors.
| Warning |
|---|
Knowledge of CDRator Product Configuration is a prerequisite for understanding of this pagedocument. |
Rating (Standard Prices)
...
Several steps of the process will compare information fields of the billing record with that elements of the product configuration.
...
| Field(s) | Description |
|---|---|
| Subscriber's information | Allows identification of the subscriber responsible for the usage. The fields depend on the network specification, but normally one can expect the presence of ICC, IMSI or the A-Number. |
| Event Date | Date and time when the event began. |
| B-Number | Number receiving the phone call, message. This applies only to certain types of usage. |
| Duration | Duration of the phone call or the amount of data. This applies only to certain types of usage and some networks may define two separate fields: one for phone calls and one for data sessions. |
| Event Type | Network's defined fields that specify exactly the type of usage, e.g. national call to a fixedline number, premium SMS, roaming call, etc. |
| Cost Price | Price of the usage as determined by the network. |
| Rating code, rating key | Determined by mediation. |
2: Rate Plan
This step looks for the subscriber and his/her rate plan. The subscriber's info in the billing record is used in tables like:
servicesimcarda_number
Eventually the corresponding subscription record is found and from that the process goes into load the corresponding billing_group_member record:
| Field(s) | Description |
|---|---|
subscription_id | Compared to subscription.id. |
from_date, to_date | Compared to the event date on the billing record. The configuration that is valid when the event began is the only one considered. |
rate_plan_id | This points to the rate plan that will be used by the following steps. |
...
| Info | ||
|---|---|---|
| ||
The tele rates configuration of a rate plan can be analyzed by selecting the rate plan in the Product Configuration GUI and clicking the Edit button. This will open the Edit Rate Plan popup. Select the rating code on the table on the left (Tele Rates frame, Service Code column). The associated number plan is displayed on the right (Number Plans frame). The columns From Date and To Date specify whether the link between a rating code and a number plan has restrictions on time. |
...
The screenshot below shows the tele rates configuration of the Fixedline rate plan. The rating code NATIONAL CALL is linked to the number plan Mobile National without date restrictions.
4: Execute the B-Number Method
...
| Info | ||
|---|---|---|
| ||
For investigation purposes it is important to know the logic of the B-Number method. Click on the number plan on the Product Configuration GUI and then the Edit button. This will open the Edit Number Plan pop-up GUI where the operator can check the method that is configured for the number plan and read its description. |
The most common B-Number Methods methods are getRatingKey and getBNumber, and they . They will return the billing record's rating key and B-Number, respectively.
Example
In the screenshot below, the b-number method of the number plan Mobile National is getRatingKey. This means that the billing record's rating key will be used to find the plan element.
5: Find the Plan Element
...
The algorithm is explained below.
Dot (".") as Plan Element Name
Not always does the The plan element found by the best match algorithm point is not always the one that points to the charges. The plan elements tree can be used to group several elements under one parent, which points to charges that are valid for all its children.
...
The process loads the relevant rate day attached to the plan element. The billing record's event date is compared with the start and end dates configured in the rate day itself.
...
| Info | ||
|---|---|---|
| ||
In the Product Configuration GUI, click on a plan element and the GUI will automatically display the corresponding rate days in the Rate Day frame below the plan elements tree. |
...
In the screenshot below, the rate day assigned to the MOBILE plan element is N-SINGLE and it has an open start and end date.
7: Day Charge
Day charges are used to specify the charge depending on the day of the week (Monday to Sunday). In most cases, a rate day has one single day charge which includes all the days of the week. The billing record's event date is used again to find the relevant day charge.
...
| Info | ||
|---|---|---|
| ||
Day charges are displayed in the Edit Rate Day pop-up GUI. Select a rate day and click the Edit button on the Rate Day frame. |
Example
A rate day in which charges are separate between weekdays and weekends is displayed below.
...
| Info | ||
|---|---|---|
| ||
Time charges are displayed in the Edit Rate Day pop-up GUI, Time Charge frame once the day charge is selected. |
Example
...
. |
...
9: Charges
Each time charge can define the initial charge, the recurrent charge or both of them.
...