RERATING_SESSION_ORDER
Definition
The table contains the request sent by SAP Convergent Charging for rerating CDRs
Technical Data
| Schema Version |
4.5.2 |
| Filegroup |
BART_DATA |
| Partitioned |
No |
Summary
The RERATING_SESSION_ORDER table is defined by the
following columns.
See the column details for more information.
Column Details
SESSION_ID
SUBSCRIPTION_ID
BGRP_OID
PARTITION_ID
| Definition |
The partition of the subscriber account related to the subscription |
| Type |
DECIMAL(4), NOT NULL |
FROM_DATE
| Definition |
The date from which the subscription must be rerated |
| Type |
DATETIME, NOT NULL |
ACTIVATE_DATE
| Definition |
The date from which the subscription must be activated |
| Type |
DATETIME, NULL |
FROM_SNAPSHOT_ID
| Definition |
The identifier of the snapshot from which the subscription must be restored |
| Type |
DECIMAL(8), NOT NULL |
| Default |
0 |
ORDER_STATUS
| Definition |
The status of the rerating order |
| Format |
The possible values are:
-
0: Received
1: Locked
2: Unlocked
3: Error
|
| Type |
DECIMAL(1), NOT NULL |
CHARGE_TYPE
| Definition |
The type of the charge (subscription/charging contract) |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
Index Details
The following database indexes are available in the
RERATING_SESSION_ORDER database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_RERATING_SESSION_ORDER
| Indexed Column(s) |
SESSION_ID,BGRP_OID,SUBSCRIPTION_ID |
| Unique |
Yes |
| Partitioned |
No |
| Clustered |
No |
| Filegroup |
BART_INDX |
