RATING_RECORD
Description
Technical Data
| Schema Version |
4.5.13 |
|
| Partitioned |
No |
Summary
The RATING_RECORD table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The identifier of the rating record |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IXK_RATING_RECORD |
SUAC_OID
| Definition |
The identifier of the subscriber account that relates to the end customer |
| Type |
DECIMAL(28), NULL |
SUBS_OID
| Definition |
The identifier of the subscription |
| Type |
DECIMAL(28), NULL |
| Available Index |
IX_RR_SUBSCRIPTION |
ACTI_OID
| Definition |
The identifier of the charge activation |
| Type |
DECIMAL(28), NULL |
TRANSACTION_SET_ID
| Definition |
The ID of the transaction set which the transaction belongs to |
| Type |
DECIMAL(28), NULL |
SEQUENCE_ID
| Definition |
The sequence of the rating record |
| Type |
DECIMAL(28), NULL |
ORIGIN
| Definition |
The type of the rating record |
| Format |
The possible values are:
0: Prerating
1: Rating
2: Activation
3: Modification
|
| Type |
DECIMAL(1), NULL |
RREC_DATE
| Definition |
The date of the rating record |
| Type |
SECONDDATE, NULL |
EXPIRATION_DATE
| Definition |
The date when the time to live expires |
| Type |
SECONDDATE, NULL |
LAST_ACTIVATION_DATE
| Definition |
The date of the last activation for the charge activation |
| Type |
SECONDDATE, NULL |
RESERVATION_UID
| Definition |
The identifier of the TIF reservation |
| Type |
DECIMAL(28), NULL |
| Available Index |
IX_RR_RESERVATION |
USER_SERVICE_ID
| Definition |
The technical identifier of the end customer who consumes a specific service |
| Description |
The User Service ID (USID) information is a technical key that uniquely identifies
an end customer when he consumes a customer service.
|
| Type |
NVARCHAR(128), NULL |
SERVICE_ID
| Definition |
The technical identifier of the customer service |
| Type |
NVARCHAR(128), NULL |
PRODUCT_CODE
| Definition |
The identification code of the chargeable item package (previously named product) |
| Description |
The identification code of the chargeable item package defined in the PRODUCT table.
The product term is replaced by the chargeable item package term.
|
| Type |
NVARCHAR(256), NULL |
CI_NAME
| Definition |
The name of the chargeable item |
| Type |
NVARCHAR(256), NULL |
DEFAULT_RESOLUTION
| Definition |
The default resolution of the record |
| Format |
The possible values are:
0: Unresolved
1: Confirmed
2: Canceled
|
| Type |
DECIMAL(1), NULL |
RESOLUTION
| Definition |
The resolution of the record |
| Format |
The possible values are:
0: unresolved
1: confirmed
2: canceled
|
| Type |
DECIMAL(1), NULL |
PARTITION_ID
| Definition |
The partition of the subscriber account |
| Type |
DECIMAL(4), NULL |
Index Details
The following database indexes are available in the
RATING_RECORD database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IXK_RATING_RECORD
| Indexed Column(s) |
OID |
| Unique |
No |
| Partitioned |
Yes |
IX_RR_RESERVATION
| Indexed Column(s) |
RESERVATION_UID |
| Unique |
No |
| Partitioned |
Yes |
IX_RR_SUBSCRIPTION
| Indexed Column(s) |
SUBS_OID |
| Unique |
No |
| Partitioned |
Yes |
