RATING_SESSION_VIEW

Definition

The RATING_SESSION_VIEW view is the concatenation of all the RATING_SESSION(_[1-3]) tables

Description

The RATING_SESSION_VIEW view presents the data stored in the tables:

• RATING_SESSION represented in the view by the TABLE_ID value 0
• RATING_SESSION_1 represented in the view by the TABLE_ID value 1
• RATING_SESSION_2 represented in the view by the TABLE_ID value 2
• RATING_SESSION_3 represented in the view by the TABLE_ID value 3

Technical Data

Schema Version

5.0.3

Summary

The RATING_SESSION_VIEW view is defined by the following columns in your back-end database. See the column details for more information.

Name	Source Table	Definition
TABLE_ID		The identifier of the underlying source table
SUAC_OID	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The Subscriber Account ID
SESSION_ID	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The Session ID
NEXT_CLEANUP_DATE	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The next cleanup date of the subscriber account
SESSION_DATA	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The history of the subscriber account
PARTITION_ID	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The partition of the subscriber account
SCN	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The Session Change Number
CCN	RATING_SESSION RATING_SESSION_1 RATING_SESSION_2 RATING_SESSION_3	The Commit Change Number

Column Details

The database schema defines the following columns. Check the definitions and formats:

TABLE_ID

Definition	The identifier of the underlying source table
Type	DECIMAL(4), NOT NULL