RATE_COMPONENT_HOLDER

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	4.5.13
Segment	CATALOG_DATA
Partitioned	No

Summary

The RATE_COMPONENT_HOLDER table is defined by the following columns. See the column details for more information.

Name	PK	FK	IX	Uses	Used by
OID	PK_RCOH				RATE_COMPONENT (RCHO_OID)
USRA_OID			IX_RCOH_USRA	USAGE_RATE (OID)
RERA_OID			IX_RCOH_RERA	RECURRING_RATE (OID)
OSRA_OID			IX_RCOH_OSRA	ONE_SHOT_RATE (OID)
EVRA_OID			IX_RCOH_EVRA	EVENT_RATE (OID)
AERA_OID			IX_RCOH_AERA
MACR_OID			IX_RCOH_MACR	PRICING_MACRO (OID)
CHPL_OID				CHARGING_PLAN (OID)
VALIDATION_DATE

Column Details

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

PK_RCOH

Column(s)	OID
Segment	CATALOG_INDX

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
Segment	CATALOG_INDX

IX_RCOH_RERA

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

IX_RCOH_USRA

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

IX_RCOH_MACR

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

IX_RCOH_AERA

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

IX_RCOH_EVRA

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