| Schema Version | 5.0.6 | |
| Filegroup | PRERATING_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The RATING_RECORD table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| OID | IXK_RATING_RECORD |
|
The identifier of the rating record | |||
| SUAC_OID |
|
The identifier of the subscriber account that relates to the end customer | ||||
| SUBS_OID | IX_RR_SUBSCRIPTION |
|
The identifier of the subscription | |||
| ACTI_OID |
|
The identifier of the charge activation | ||||
| TRANSACTION_SET_ID |
|
The ID of the transaction set which the transaction belongs to | ||||
| SEQUENCE_ID |
|
The sequence of the rating record | ||||
| ORIGIN |
|
The type of the rating record | ||||
| RREC_DATE |
|
The date of the rating record | ||||
| EXPIRATION_DATE |
|
The date when the time to live expires | ||||
| LAST_ACTIVATION_DATE |
|
The date of the last activation for the charge activation | ||||
| RESERVATION_UID | IX_RR_RESERVATION |
|
The identifier of the TIF reservation | |||
| USER_SERVICE_ID |
|
The technical identifier of the end customer who consumes a specific service | ||||
| SERVICE_ID |
|
The technical identifier of the customer service | ||||
| PRODUCT_CODE |
|
The identification code of the chargeable item package (previously named product) | ||||
| CI_NAME |
|
The name of the chargeable item | ||||
| DEFAULT_RESOLUTION |
|
The default resolution of the record | ||||
| RESOLUTION |
|
The resolution of the record | ||||
| PARTITION_ID |
|
The partition of the subscriber account |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The identifier of the rating record |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IXK_RATING_RECORD |
| Definition | The identifier of the subscriber account that relates to the end customer |
| Type | DECIMAL(28), NULL |
| Definition | The identifier of the subscription |
| Type | DECIMAL(28), NULL |
| Available Index | IX_RR_SUBSCRIPTION |
| Definition | The identifier of the charge activation |
| Type | DECIMAL(28), NULL |
| Definition | The ID of the transaction set which the transaction belongs to |
| Type | DECIMAL(28), NULL |
| Definition | The sequence of the rating record |
| Type | DECIMAL(28), NULL |
| Definition | The type of the rating record |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The date of the rating record |
| Type | DATETIME, NULL |
| Definition | The date when the time to live expires |
| Type | DATETIME, NULL |
| Definition | The date of the last activation for the charge activation |
| Type | DATETIME, NULL |
| Definition | The identifier of the TIF reservation |
| Type | DECIMAL(28), NULL |
| Available Index | IX_RR_RESERVATION |
| Definition | The technical identifier of the end customer who consumes a specific service |
| Description |
|
| Type | NVARCHAR(128), NULL |
| Definition | The technical identifier of the customer service |
| Type | NVARCHAR(128), NULL |
| 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 |
| Definition | The name of the chargeable item |
| Type | NVARCHAR(256), NULL |
| Definition | The default resolution of the record |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The resolution of the record |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The partition of the subscriber account |
| Type | DECIMAL(4), NULL |
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:
| Indexed Column(s) | OID |
| Unique | No |
| Partitioned | Yes |
| Clustered | Yes |
| Filegroup | PRERATING_INDX |
| Indexed Column(s) | RESERVATION_UID |
| Unique | No |
| Partitioned | Yes |
| Clustered | No |
| Filegroup | PRERATING_INDX |
| Indexed Column(s) | SUBS_OID |
| Unique | No |
| Partitioned | Yes |
| Clustered | No |
| Filegroup | PRERATING_INDX |
