RATING_SESSION_@NUMBER@

Description


The RATING_SESSION_@NUMBER@ tables store charging session data that relate to the digital service consumption of end customers. @NUMBER@ is a variable part of the name. There are 480 tables with the same pattern name. The total count of tables depends on the database partitioning of SAP Convergent Charging. See the SAP CC Library for more information about the database partitioning.

Technical Data


Schema Version 4.5.13
Tablespace SESSION_RATING_DATA
Partitioned No

Summary


The RATING_SESSION_@NUMBER@ table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
SUAC_OID PK_RATING_SESSION_@NUMBER@      SUBSCRIBER_ACCOUNT (OID)
 
 
SESSION_ID PK_RATING_SESSION_@NUMBER@         
NEXT_CLEANUP_DATE          
SESSION_DATA          

Column Details


SUAC_OID

Definition The unique ID of the subscriber account that relates to the end customer
Type DECIMAL(28), NOT NULL
Primary Key PK_RATING_SESSION_@NUMBER@

SESSION_ID

Definition The charging session ID; in newer releases of SAP Convergent Charging; this identifier includes the multiservice session ID.
Type VARCHAR2(256 CHAR), NOT NULL
Primary Key PK_RATING_SESSION_@NUMBER@

NEXT_CLEANUP_DATE

Definition The next cleanup date of the subscriber account
Type DATE, NOT NULL

SESSION_DATA

Definition The history of the subscriber account
Type BLOB, NOT NULL

Primary Key Details


PK_RATING_SESSION_@NUMBER@

Column(s) SUAC_OID,SESSION_ID
Tablespace SESSION_RATING_INDX