ACTI_TIER_TABLE_INSTANCE

Definition

The ACTI_TIER_TABLE_INSTANCE table contains information about tier table instances in charge activations

Technical Data

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

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_ACTI_TTI_OID				ACTI_TIER_TABLE_ROW (TINS_OID)
TTAB_CODE
ACTI_OID			IX_ACTI_TIERTI_ACTI_OID	CHARGE_ACTIVATION (OID)
NAME
VALIDATION_DATE
ROOT_SUBS_OID			IX_ACTI_TIERTI_RS_OID
PARTITION_ID

Column Details

OID

Definition	The identifier of the tier table instance
Type	DECIMAL(28), NOT NULL
Primary Key	PK_ACTI_TTI_OID

TTAB_CODE

Definition	The code of the tier table owning the instance
Type	NVARCHAR(256), NULL

ACTI_OID

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

NAME

Definition	The name of the instance
Type	NVARCHAR(256), NULL

VALIDATION_DATE

Definition	The date when the instance becomes valid
Type	DATETIME, NULL

ROOT_SUBS_OID

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

PARTITION_ID

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

Primary Key Details

PK_ACTI_TTI_OID

Column(s)	OID
Segment	SUBSCRIBER_INDX

Index Details

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

IX_ACTI_TIERTI_RS_OID

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

IX_ACTI_TIERTI_ACTI_OID

Indexed Column(s)	ACTI_OID
Unique	No
Partitioned	Yes
Clustered	No
Segment	SUBSCRIBER_INDX