ACTI_DEPENDENT

Definition


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

Technical Data


Schema Version 4.5.13
Partitioned No

Summary


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

Name PK FK IX Uses Used by
ACTI_OID     IX_CA_DEPENDENT     
DEP_ACTI_OID          
DEP_SUBS_OID     IX_CA_DEP_SUBS  SUBSCRIPTION (OID)
 
 
DEPENDENT_INDEX          
VALIDATION_DATE          
ROOT_SUBS_OID     IX_AD_ROOT_SUBS_OID     
PARTITION_ID          

Column Details


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 SECONDDATE, 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

IX_CA_DEPENDENT

Indexed Column(s) ACTI_OID
Unique No
Partitioned No

IX_AD_ROOT_SUBS_OID

Indexed Column(s) ROOT_SUBS_OID
Unique No
Partitioned Yes