Table:
RATING_RECORD
|
Table Name
|
RATING_RECORD |
| Table Description |
The RATING_RECORD table contains the data related to the prerating. Rating records are stored when a prerating operation
is
initially received. Each reserved event is stored in another rating record until the last postrating is received or the initial
prerating has expired.
|
| Tablespace |
PRERATING_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The RATING_RECORD database table is defined by the following columns.
Column: OID
| Value Type |
BIGINT, NOT NULL |
|
| Index(es) |
IXK_RATING_RECORD (unique) (oracle)
IXK_RATING_RECORD (unique) (sqlserver)
IX_RR_SUBSCRIPTION
|
| Column Description |
The identifier of the rating record. |
Column: SUAC_OID
| Value Type |
BIGINT |
|
| Column Description |
The identifier of the subscriber account. |
Column: SUBS_OID
| Value Type |
BIGINT |
|
| Index(es) |
IX_RR_SUBSCRIPTION
|
| Column Description |
The identifier of the subscription. |
Column: ACTI_OID
| Value Type |
BIGINT |
|
| Column Description |
The identifier of the charge activation. |
Column: TRANSACTION_SET_ID
| Value Type |
BIGINT |
|
| Column Description |
The ID of the transaction set which the transaction belongs to. |
Column: SEQUENCE_ID
| Value Type |
BIGINT |
|
| Column Description |
The sequence of the rating record. |
Column: ORIGIN
| Value Type |
DECIMAL(1) |
|
| Column Description |
The type of the rating record. Possible values are:
- 0: prerating
- 1: rating
- 2: activation
- 3: modification
|
Column: RREC_DATE
| Value Type |
DATE |
|
| Column Description |
The date of the rating record. |
Column: EXPIRATION_DATE
| Value Type |
DATE |
|
| Column Description |
The date when the time to live expires. |
Column: LAST_ACTIVATION_DATE
| Value Type |
DATE |
|
| Column Description |
The date of the last activation for the charge activation. |
Column: RESERVATION_UID
| Value Type |
BIGINT |
|
| Index(es) |
IX_RR_RESERVATION
|
| Column Description |
The identifier of the TIF reservation. |
Column: USER_SERVICE_ID
| Value Type |
VARCHAR(128) |
|
| Column Description |
The identifier of the user. |
Column: SERVICE_ID
| Value Type |
VARCHAR(128) |
|
| Column Description |
The identifier of the user service. |
Column: PRODUCT_CODE
| Value Type |
VARCHAR(256) |
|
| Column Description |
The code of the product. |
Column: CI_NAME
| Value Type |
VARCHAR(256) |
|
| Column Description |
The name of the chargeable item. |
Column: DEFAULT_RESOLUTION
| Value Type |
DECIMAL(1) |
|
| Column Description |
The default resolution of the record. Possible values are:
- 0: unresolved
- 1: confirmed
- 2: cancelled
|
Column: RESOLUTION
| Value Type |
DECIMAL(1) |
|
| Column Description |
The resolution of the record. Possible values are:
- 0: unresolved
- 1: confirmed
- 2: cancelled
|
Column: PARTITION_ID
| Value Type |
SMALLINT |
|
| Column Description |
The partition of the subscriber account. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.