RATE_COMPONENT_HOLDER

Definition

The RATE_COMPONENT_HOLDER table implements the links between a rating or a charging component and the object, which contains the component

Description

The RATE_COMPONENT_HOLDER table implements the links between a rating or a charging component and the object, which contains the component. For a rating component, the container can be a usage rate, a recurring rate, a one-shot rate, an account event rate or a pricing macro. For a charging component, the container is a charging plan.

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The RATE_COMPONENT_HOLDER table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	IX	Uses	Used by	Definition
OID	PK_RCOH			RATE_COMPONENT (RCHO_OID)	The component unique identifier
USRA_OID		IX_RCOH_USRA	USAGE_RATE (OID)		The identifier of the usage rate if the container is a usage rate
RERA_OID		IX_RCOH_RERA	RECURRING_RATE (OID)		The identifier of the recurring rate if the container is a recurring rate
OSRA_OID		IX_RCOH_OSRA	ONE_SHOT_RATE (OID)		The identifier of the one-shot rate if the container is a one-shot rate
EVRA_OID		IX_RCOH_EVRA	EVENT_RATE (OID)		The identifier of the event rate if the container is an event rate
AERA_OID		IX_RCOH_AERA			The identifier of the account event rate if the container is an account event rate
MACR_OID		IX_RCOH_MACR	PRICING_MACRO (OID)		The identifier of the pricing macro if the container is a pricing macro
CHPL_OID			CHARGING_PLAN (OID)		The identifier of the charging plan if the component is a charging one
VALIDATION_DATE					The date when the component becomes valid

Column Details

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

OID

Definition	The component unique identifier
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RCOH

USRA_OID

Definition	The identifier of the usage rate if the container is a usage rate
Type	DECIMAL(28), NULL
Available Index	IX_RCOH_USRA

RERA_OID

Definition	The identifier of the recurring rate if the container is a recurring rate
Type	DECIMAL(28), NULL
Available Index	IX_RCOH_RERA

OSRA_OID

Definition	The identifier of the one-shot rate if the container is a one-shot rate
Type	DECIMAL(28), NULL
Available Index	IX_RCOH_OSRA

EVRA_OID

Definition	The identifier of the event rate if the container is an event rate
Type	DECIMAL(28), NULL
Available Index	IX_RCOH_EVRA

AERA_OID

Definition	The identifier of the account event rate if the container is an account event rate
Type	DECIMAL(28), NULL
Available Index	IX_RCOH_AERA

MACR_OID

Definition	The identifier of the pricing macro if the container is a pricing macro
Type	DECIMAL(28), NULL
Available Index	IX_RCOH_MACR

CHPL_OID

Definition	The identifier of the charging plan if the component is a charging one
Type	DECIMAL(28), NULL

VALIDATION_DATE

Definition	The date when the component becomes valid
Type	DATETIME, NULL

Primary Key Details

See the primary key information:

PK_RCOH

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_RCOH_OSRA

Indexed Column(s)	OSRA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_RCOH_RERA

Indexed Column(s)	RERA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_RCOH_USRA

Indexed Column(s)	USRA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_RCOH_MACR

Indexed Column(s)	MACR_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_RCOH_AERA

Indexed Column(s)	AERA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_RCOH_EVRA

Indexed Column(s)	EVRA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX