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 Database Reference (Core Database).
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 | Definition |
|---|---|---|---|---|---|---|
| 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 |