SUAC_ADDITIONAL_INFO

Subscriber Account Additional Information

Definition

The SUAC_ADDITIONAL_INFO table contains the additional information of a subscriber account

Technical Data

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

Summary

The SUAC_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
SUAC_OID			IX_SUAI_SUAC	SUBSCRIBER_ACCOUNT (OID)		The identifier of the subscriber account
NAME						The name of the additional information
VALUE_TYPE						The type of the 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
PARTITION_ID						The partition of the subscriber account

Column Details

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

SUAC_OID

Definition	The identifier of the subscriber account
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUAI_SUAC

NAME

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

VALUE_TYPE

Definition	The type of the 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	VARCHAR(2000), NULL

DATE_VALUE

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

PARTITION_ID

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

Index Details

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

IX_SUAI_SUAC

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