The RATING_SESSION_@NUMBER@ tables store charging session data that relate to the
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 Application Help for more information
about the database partitioning.
| Schema Version | 5.0.6 | |
| Tablespace | SESSION_RATING_DATA | |
| Partitioned | No | |
The RATING_SESSION_@NUMBER@ 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 | PK_RATING_SESSION_@NUMBER@ | SUBSCRIBER_ACCOUNT (OID)
|
|
The unique ID of the subscriber account that relates to the end customer | ||
| SESSION_ID | PK_RATING_SESSION_@NUMBER@ |
|
The charging session ID; in newer releases of SAP Convergent Charging; this identifier includes the multiservice session ID. | |||
| NEXT_CLEANUP_DATE |
|
The next cleanup date of the subscriber account | ||||
| SESSION_DATA |
|
The history of the subscriber account |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| 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@ |
| Definition | The charging session ID; in newer releases of SAP Convergent Charging; this identifier includes the multiservice session ID. |
| Type | VARCHAR(256), NOT NULL |
| Primary Key | PK_RATING_SESSION_@NUMBER@ |
| Definition | The next cleanup date of the subscriber account |
| Type | TIMESTAMP, NOT NULL |
| Definition | The history of the subscriber account |
| Type | BLOB, NOT NULL |
See the primary key information:
| Column(s) | SUAC_OID,SESSION_ID |
| Tablespace | SESSION_RATING_INDX |
