The RENEW_RESERVATION_NOTIFICATION table contains the renew reservation notifications.
A renew reservation notification is identified by the related multiservice session
and
the related charging session.
| Schema Version | 5.0.6 | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The RENEW_RESERVATION_NOTIFICATION 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 |
|---|---|---|---|---|---|---|
| SESSION_ID |
|
The identifier of the multiservice session | ||||
| RESERVATION_ID |
|
The identifier of the charging session | ||||
| OID | PK_RENEW |
|
The unique identifier of the renew reservation notification. It is generated by the SAP CC system. | |||
| NOTIF_TIMESTAMP |
|
The date and time of the event reported by the renew reservation notification | ||||
| NOTIF_EXPIRATION |
|
The date and time after which the renew reservation notification is not relevant anymore | ||||
| RESEND_ATTEMPT |
|
The number of attempts to resend the notification already done | ||||
| NEXT_RESEND |
|
The date and time of the next attempt to resend the notification | ||||
| RESEND_DATA |
|
The internal data used by the resend policy to compute date and time of next attempt to send the notification | ||||
| ARG_VALUES |
|
The arguments values of the renew reservation notification | ||||
| PARTITION_ID | PK_RENEW |
|
The partition of the subscriber account owning the renew reservation notification |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The identifier of the multiservice session |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The identifier of the charging session |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The unique identifier of the renew reservation notification. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_RENEW |
| Definition | The date and time of the event reported by the renew reservation notification |
| Type | DATETIME, NOT NULL |
| Definition | The date and time after which the renew reservation notification is not relevant anymore |
| Type | DATETIME, NOT NULL |
| Definition | The number of attempts to resend the notification already done |
| Type | DECIMAL(4), NOT NULL |
| Definition | The date and time of the next attempt to resend the notification |
| Type | DATETIME, NOT NULL |
| Definition | The internal data used by the resend policy to compute date and time of next attempt to send the notification |
| Type | IMAGE, NULL |
| Definition | The arguments values of the renew reservation notification |
| Type | IMAGE, NOT NULL |
| Definition | The partition of the subscriber account owning the renew reservation notification |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_RENEW |
See the primary key information:
| Column(s) | PARTITION_ID,OID |
| Segment | SESSION_RATING_INDX |
