Table:
RR_PROPERTY
|
Table Name
|
RR_PROPERTY |
| Table Description |
The RR_PROPERTY table contains rating record properties. These properties correspond to the state of chargeable item properties
or the state of a counter of the subscription.
|
| Tablespace |
PRERATING_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The RR_PROPERTY database table is defined by the following columns.
Column: RREC_OID
| Value Type |
BIGINT |
|
| Index(es) |
IX_PROPERTY_RR
|
| Column Description |
The identifier of the rating record. |
Column: VALUE_TYPE
| Value Type |
DECIMAL(1) |
|
| Column Description |
The type of the property. Possible values are:
- 0: number
- 1: string
- 2: date
|
Column: NUMBER_VALUE
| Value Type |
DECIMAL(28,6) |
|
| Column Description |
The value of the property if it is a number. |
Column: DATE_VALUE
| Value Type |
DATE |
|
| Column Description |
The value of the property if it is a date (used only if the CATEGORY is 1). |
Column: STRING_VALUE
| Value Type |
VARCHAR(256) |
|
| Column Description |
The value of the property if it is a string (used only if the CATEGORY is 1). |
Column: NAME
| Value Type |
VARCHAR(256) |
|
| Column Description |
The name of the property (used only if the CATEGORY is 1). |
Column: CATEGORY
| Value Type |
DECIMAL(1) |
|
| Column Description |
The category of the property. Possible values are:
- 0: counter
- 1: chargeable item property
|
Column: COUN_HOLD_OID
| Value Type |
BIGINT |
|
| Column Description |
The identifier of the subscription or the charge activation owning the counter (used only if the CATEGORY is 0). |
Column: COUN_KEY
| Value Type |
DECIMAL(6) |
|
| Column Description |
The identifier of the counter (used only if the CATEGORY is 0). |
Column: PARTITION_ID
| Value Type |
SMALLINT |
|
| Column Description |
The partition of the subscriber account owning the subscription. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.