FILE_SEQUENCES

Description

The FILE_SEQUENCES table contains information about the sequences, which are used for filenames generated by the rater or bulkloader instances of the SAP CC system during acquisition, charging, refilling, and bulkloading operations.

Notes

A given sequence is only associated to one instance, and cannot be shared between multiple instances
Each sequence can be used and incremented by one or multiple writers of a given instance

Technical Data

Schema Version	4.5.13
Tablespace	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
INSTANCE_ID			IX_FILE_SEQUENCES
SEQUENCE_ID			IX_FILE_SEQUENCES
VALUE

Column Details

INSTANCE_ID

Definition	The unique instance ID
Description	The unique instance ID, made up with three elements: An instance type A separator (#) A number of instances which identifies instances of the same type. This number is positive and not null. The instance ID is specified by the user at installation time (e.g. "rater#1", which identifies the rater number 1)
Type	VARCHAR(64), NOT NULL
Available Index	IX_FILE_SEQUENCES

SEQUENCE_ID

Definition	The sequence key identifier
Description	The identifier of the sequence, specified in the "bulkWriter" elements of the CIF configuration.
Type	VARCHAR(256), NULL
Available Index	IX_FILE_SEQUENCES

VALUE

Definition	The current value of the sequence
Description	The current value of the sequence, incremented by each bulkWriter at data file creation time.
Type	DECIMAL(6), NOT NULL

Index Details

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

IX_FILE_SEQUENCES

Indexed Column(s)	INSTANCE_ID,SEQUENCE_ID
Unique	Yes
Partitioned	No
Tablespace	CATALOG_INDX