RATING_SESSION
Definition
The RATING_SESSION table contains information related to the batch rating and charging
sessions
Technical Data
| Schema Version |
4.5.2 |
| Segment |
BART_DATA |
| Partitioned |
No |
Summary
The RATING_SESSION table is defined by the
following columns.
See the column details for more information.
Column Details
OID
BGRP_OID
| Definition |
The ID of the CDR group, called "batch rating group ID" in SAP CC |
| Type |
DECIMAL(2), NOT NULL |
CDR_SUBSCRIPTION_ID
| Definition |
The subscription ID of the rating session |
| Description |
The subscription ID of the rating session. The ID is used for the rerating process. |
| Type |
DECIMAL(28), NULL |
START_DATE
| Definition |
The start date of the rating session (batch charging session) |
| Type |
DATETIME, NOT NULL |
DURATION
| Definition |
The duration of the rating session in seconds |
| Type |
DECIMAL(28), NULL |
RATING_MODE
| Definition |
The rating mode of the rating session |
| Type |
DECIMAL(1), NOT NULL |
MAX_CDR_CONSUMPTION_DATE
| Definition |
The CDRs before this date are rated |
| Type |
DATETIME, NOT NULL |
NB_CDR_RATED
| Definition |
The number of rated CDRs |
| Type |
DECIMAL(28), NULL |
NB_CDR_ERROR
| Definition |
The number of erroneous CDRs |
| Type |
DECIMAL(28), NULL |
DESCRIPTION
| Definition |
The description of the batch rating/charging session |
| Type |
NVARCHAR(2000), NULL |
STATUS
| Definition |
The current status of the session |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
Primary Key Details
PK_RATING_SESSION
Index Details
The following database indexes are available in the
RATING_SESSION database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_RATING_SESSION
| Indexed Column(s) |
OID |
| Unique |
No |
| Partitioned |
No |
| Clustered |
No |
| Segment |
BART_INDX |
