ACTI_DEPENDENT

Definition

The ACTI_DEPENDENT table contains the dependent charge activation(s) of a charge activation

Technical Data

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

Summary

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

Name	IX	Uses	Definition
ACTI_OID	IX_CA_DEPENDENT		The OID of the charge activation
DEP_ACTI_OID			The OID of the dependent charge activation
DEP_SUBS_OID	IX_CA_DEP_SUBS	SUBSCRIPTION (OID)	The OID of the subscription to which belongs the dependent charge activation
DEPENDENT_INDEX			The index of the dependency
VALIDATION_DATE			The date from when the dependency is active
ROOT_SUBS_OID	IX_AD_ROOT_SUBS_OID		The root subscription for the charge activation
PARTITION_ID			The partition ID of the subscriber account containing the charge activation

Column Details

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

ACTI_OID

Definition	The OID of the charge activation
Type	DECIMAL(28), NOT NULL
Available Index	IX_CA_DEPENDENT

DEP_ACTI_OID

Definition	The OID of the dependent charge activation
Type	DECIMAL(28), NOT NULL

DEP_SUBS_OID

Definition	The OID of the subscription to which belongs the dependent charge activation
Type	DECIMAL(28), NOT NULL
Available Index	IX_CA_DEP_SUBS

DEPENDENT_INDEX

Definition	The index of the dependency
Type	DECIMAL(3), NULL

VALIDATION_DATE

Definition	The date from when the dependency is active
Type	DATETIME, NULL

ROOT_SUBS_OID

Definition	The root subscription for the charge activation
Type	DECIMAL(28), NOT NULL
Available Index	IX_AD_ROOT_SUBS_OID

PARTITION_ID

Definition	The partition ID of the subscriber account containing the charge activation
Type	DECIMAL(4), NOT NULL

Index Details

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

IX_CA_DEP_SUBS

Indexed Column(s)	DEP_SUBS_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_CA_DEPENDENT

Indexed Column(s)	ACTI_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_AD_ROOT_SUBS_OID

Indexed Column(s)	ROOT_SUBS_OID
Unique	No
Partitioned	Yes
Clustered	Yes
Filegroup	SUBSCRIBER_INDX