RR_PROPERTY

Rating Record Properties

Definition

The RR_PROPERTY table contains rating record properties

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.

Technical Data

Schema Version	5.0.6
Filegroup	PRERATING_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The RR_PROPERTY 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
RREC_OID			IX_PROPERTY_RR			The identifier of the rating record
VALUE_TYPE						The type of the property More...
NUMBER_VALUE						The value of the property if it is a number
DATE_VALUE						The value of the property if it is a date (used only if the CATEGORY is 1)
STRING_VALUE						The value of the property if it is a string (used only if the CATEGORY is 1)
NAME						The name of the property (used only if the CATEGORY is 1)
CATEGORY						The category of the property More...
COUN_HOLD_OID						The identifier of the subscription or the charge activation owning the counter (used only if the CATEGORY is 0)
COUN_KEY						The identifier of the counter (used only if the CATEGORY is 0)
PARTITION_ID						The partition of the subscriber account owning the subscription

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

RREC_OID

Definition	The identifier of the rating record
Type	DECIMAL(28), NULL
Available Index	IX_PROPERTY_RR

VALUE_TYPE

Definition	The type of the property
Format	The possible values are: 0: number 1: string 2: date
Type	DECIMAL(1), NULL

NUMBER_VALUE

Definition	The value of the property if it is a number
Type	DECIMAL(28,6), NULL

DATE_VALUE

Definition	The value of the property if it is a date (used only if the CATEGORY is 1)
Type	DATETIME, NULL

STRING_VALUE

Definition	The value of the property if it is a string (used only if the CATEGORY is 1)
Type	NVARCHAR(256), NULL

NAME

Definition	The name of the property (used only if the CATEGORY is 1)
Type	NVARCHAR(256), NULL

CATEGORY

Definition	The category of the property
Format	The possible values are: 0: counter 1: chargeable item property
Type	DECIMAL(1), NULL

COUN_HOLD_OID

Definition	The identifier of the subscription or the charge activation owning the counter (used only if the CATEGORY is 0)
Type	DECIMAL(28), NULL

COUN_KEY

Definition	The identifier of the counter (used only if the CATEGORY is 0)
Type	DECIMAL(6), NULL

PARTITION_ID

Definition	The partition of the subscriber account owning the subscription
Type	DECIMAL(4), NULL

Index Details

The following database indexes are available in the RR_PROPERTY database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_PROPERTY_RR

Indexed Column(s)	RREC_OID
Unique	No
Partitioned	Yes
Clustered	No
Filegroup	PRERATING_INDX