ACTI_PARAMETER

Definition

The ACTI_PARAMETER table contains information about parameters in charge activations

Description

The ACTI_PARAMETER table contains information about parameters in charge activations. These parameters are first created in the price plan of the charge component corresponding to the charge activation. Then they are redefined in the charge activation.

Technical Data

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

Summary

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

Name	PK	FK	IX	Uses	Used by	Definition
INDEX_IN_ACTI						The index of the parameter in the charge activation
PARA_KEY						The identifier of the parameter
DESCRIPTION						The description of the parameter
VALUE_TYPE						The type of the parameter More...
NUMBER_VALUE						The value of the parameter when it is a number
STRING_VALUE						The value of the parameter when it is a string
DATE_VALUE						The value of the parameter when it is a date
ACTI_OID			IX_ACPA_ACTI	CHARGE_ACTIVATION (OID)		The identifier of the charge activation owning the parameter
VALIDATION_DATE						The date when the parameter becomes valid
ROOT_SUBS_OID			IX_AP_ROOT_SUBS_OID			The root subscription for the charge activation
PARTITION_ID						The partition 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:

INDEX_IN_ACTI

Definition	The index of the parameter in the charge activation
Type	DECIMAL(5), NOT NULL

PARA_KEY

Definition	The identifier of the parameter
Type	DECIMAL(6), NOT NULL

DESCRIPTION

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

VALUE_TYPE

Definition	The type of the parameter
Format	The possible values are: 0: number 1: string 2: date
Type	DECIMAL(1), NOT NULL

NUMBER_VALUE

Definition	The value of the parameter when it is a number
Type	DECIMAL(28,6), NULL

STRING_VALUE

Definition	The value of the parameter when it is a string
Type	VARCHAR(2000), NULL

DATE_VALUE

Definition	The value of the parameter when it is a date
Type	TIMESTAMP, NULL

ACTI_OID

Definition	The identifier of the charge activation owning the parameter
Type	DECIMAL(28), NOT NULL
Available Index	IX_ACPA_ACTI

VALIDATION_DATE

Definition	The date when the parameter becomes valid
Type	TIMESTAMP, NULL

ROOT_SUBS_OID

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

PARTITION_ID

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

Index Details

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

IX_AP_ROOT_SUBS_OID

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

IX_ACPA_ACTI

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