SUMT_ADDITIONAL_INFO

Definition

The SUMT_ADDITIONAL_INFO table contains additional information stored for some Subscriber Mapping Tables

Technical Data

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

Summary

The SUMT_ADDITIONAL_INFO 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
SUMT_OID			IX_SUMT_AI	SUMT (OID)		The unique identifier of the Subscriber Mapping Table containing the additional information
PARTITION_ID						The partition of the Subscriber Account this additional information belongs to
NAME						The name of the additional information
DESCRIPTION						The description of the additional information
VALUE_TYPE						The type of additional information More...
NUMBER_VALUE						The value of the additional information when it is a number
STRING_VALUE						The value of the additional information when it is a string
DATE_VALUE						The value of the additional information when it is a date

Column Details

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

SUMT_OID

Definition	The unique identifier of the Subscriber Mapping Table containing the additional information
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUMT_AI

PARTITION_ID

Definition	The partition of the Subscriber Account this additional information belongs to
Type	DECIMAL(4), NOT NULL

NAME

Definition	The name of the additional information
Type	NVARCHAR(256), NOT NULL

DESCRIPTION

Definition	The description of the additional information
Type	NVARCHAR(2000), NULL

VALUE_TYPE

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

NUMBER_VALUE

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

STRING_VALUE

Definition	The value of the additional information when it is a string
Type	NVARCHAR(2000), NULL

DATE_VALUE

Definition	The value of the additional information when it is a date
Type	DATETIME, NULL

Index Details

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

IX_SUMT_AI

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