RATING_SESSION
Definition
The RATING_SESSION table stores charging session data
Description
Tip
For detailed information about this tabel, consult the RATING_SESSION database table
in the SAP CC Core Database References.
Technical Data
| Schema Version | 4.5.12 | |
| Tablespace | SESSION_RATING_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
Summary
The RATING_SESSION 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 |
|---|---|---|---|---|---|
| SUAC_OID | UK_RATING_SESSION | The Subscriber Account ID
|
|||
| SESSION_ID | UK_RATING_SESSION | The Session ID
|
|||
| NEXT_CLEANUP_DATE | The next cleanup date of the subscriber account
|
||||
| SESSION_DATA | The history of the subscriber account
|
||||
| PARTITION_ID | UK_RATING_SESSION | The partition of the subscriber account
|
|||
| SCN | UK_RATING_SESSION | The Session Change Number
|
|||
| CCN | The Commit Change Number
|
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
SUAC_OID
| Definition | The Subscriber Account ID |
| Type | DECIMAL(28), NOT NULL |
| Available Index | UK_RATING_SESSION |
SESSION_ID
| Definition | The Session ID |
| Type | VARCHAR2(256 CHAR), NOT NULL |
| Available Index | UK_RATING_SESSION |
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, NULL |
PARTITION_ID
| Definition | The partition of the subscriber account |
| Type | DECIMAL(4), NOT NULL |
| Available Index | UK_RATING_SESSION |
SCN
| Definition | The Session Change Number |
| Type | DECIMAL(28), NOT NULL |
| Available Index | UK_RATING_SESSION |
CCN
| Definition | The Commit Change Number |
| Type | DECIMAL(28), NOT NULL |
Index Details
The following database indexes are available in the RATING_SESSION database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
UK_RATING_SESSION
| Indexed Column(s) | PARTITION_ID,SUAC_OID,SESSION_ID,SCN |
| Unique | Yes |
| Partitioned | Yes |
| Tablespace | SESSION_RATING_INDX |