CHARGE_ACTIVATION

Definition

The CHARGE_ACTIVATION table contains information about the charge activation

Description

The CHARGE_ACTIVATION table contains information about the charge activation. A charge activation is contained in a subscription and gives the possibility to subscribe to an existing charge condition.

Technical Data

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

Summary

The CHARGE_ACTIVATION 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_CHARGE_ACTIVATION			ACTI_TRANSLATION_INSTANCE (ACTI_OID) ACTI_TIER_TABLE_INSTANCE (ACTI_OID) ACTI_PARAMETER (ACTI_OID) ACTI_CHARGING_MAPPING (ACTI_OID)	The identifier of the charge activation
SUB_CODE		IX_CA_CODE			The code of the charge activation
DESCRIPTION					The description of the charge activation
CURRENCY_CODE					The currency code of the charge activation
EFFECTIVE_DATE					The effective date of the charge activation
EXPIRATION_DATE					The expiration date of the charge activation
CANCELLATION_DATE					The cancellation date of the charge activation
CCON_OID		IX_CA_CCON			The identifier of the charge condition corresponding to the charge activation
SUBS_OID		IX_CA_SUBSCRIPTION	SUBSCRIPTION (OID)		The identifier of the subscription containing the charge activation
ROOT_SUBS_OID		IX_CA_ROOT_SUBS_OID			The identifier of the root subscription containing the charge activation
PARTITION_ID					The identifier of the partition associated to the subscription, which contains the charge activation

Column Details

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

OID

Definition	The identifier of the charge activation
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CHARGE_ACTIVATION

SUB_CODE

Definition	The code of the charge activation
Type	VARCHAR(256), NOT NULL
Available Index	IX_CA_CODE

DESCRIPTION

Definition	The description of the charge activation
Type	VARCHAR(2000), NULL

CURRENCY_CODE

Definition	The currency code of the charge activation
Type	VARCHAR(5), NULL

EFFECTIVE_DATE

Definition	The effective date of the charge activation
Type	TIMESTAMP, NULL

EXPIRATION_DATE

Definition	The expiration date of the charge activation
Type	TIMESTAMP, NULL

CANCELLATION_DATE

Definition	The cancellation date of the charge activation
Type	TIMESTAMP, NULL

CCON_OID

Definition	The identifier of the charge condition corresponding to the charge activation
Type	DECIMAL(28), NOT NULL
Available Index	IX_CA_CCON

SUBS_OID

Definition	The identifier of the subscription containing the charge activation
Type	DECIMAL(28), NOT NULL
Available Index	IX_CA_SUBSCRIPTION

ROOT_SUBS_OID

Definition	The identifier of the root subscription containing the charge activation
Type	DECIMAL(28), NOT NULL
Available Index	IX_CA_ROOT_SUBS_OID

PARTITION_ID

Definition	The identifier of the partition associated to the subscription, which contains the charge activation
Type	DECIMAL(4), NOT NULL

Primary Key Details

See the primary key information:

PK_CHARGE_ACTIVATION

Column(s)	OID
Tablespace	SUBSCRIBER_INDX

Index Details

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

IX_CA_CCON

Indexed Column(s)	CCON_OID
Unique	No
Partitioned	No
Tablespace	SUBSCRIBER_INDX

IX_CA_ROOT_SUBS_OID

Indexed Column(s)	ROOT_SUBS_OID
Unique	No
Partitioned	Yes
Tablespace	SUBSCRIBER_INDX

IX_CA_SUBSCRIPTION

Indexed Column(s)	SUBS_OID
Unique	No
Partitioned	No
Tablespace	SUBSCRIBER_INDX

IX_CA_CODE

Indexed Column(s)	SUB_CODE
Unique	No
Partitioned	No
Tablespace	SUBSCRIBER_INDX