SURT_ADDITIONAL_INFO

Definition

The SURT_ADDITIONAL_INFO table contains additional information defined in the subscriber range tables (see the SURT table)

Description

The SURT_ADDITIONAL_INFO table contains additional information defined in the subscriber range tables (see the SURT table).

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The SURT_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
SURT_OID			IX_SURT_AI	SURT (OID)		The identifier of the subscriber range table
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:

SURT_OID

Definition	The identifier of the subscriber range table
Type	DECIMAL(28), NOT NULL
Available Index	IX_SURT_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	SECONDDATE, NULL

Index Details

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

IX_SURT_AI

Indexed Column(s)	SURT_OID
Unique	No
Partitioned	No