RENEW_RESERVATION_NOTIFICATION

Description


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.

Technical Data


Schema Version 4.5.13
Partitioned No

Summary


The RENEW_RESERVATION_NOTIFICATION table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
SESSION_ID          
RESERVATION_ID          
OID PK_RENEW         
NOTIF_TIMESTAMP          
NOTIF_EXPIRATION          
RESEND_ATTEMPT          
NEXT_RESEND          
RESEND_DATA          
ARG_VALUES          
PARTITION_ID PK_RENEW         

Column Details


SESSION_ID

Definition The identifier of the multiservice session
Type NVARCHAR(256), NOT NULL

RESERVATION_ID

Definition The identifier of the charging session
Type NVARCHAR(256), NOT NULL

OID

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

NOTIF_TIMESTAMP

Definition The date and time of the event reported by the renew reservation notification
Type SECONDDATE, NOT NULL

NOTIF_EXPIRATION

Definition The date and time after which the renew reservation notification is not relevant anymore
Type SECONDDATE, NOT NULL

RESEND_ATTEMPT

Definition The number of attempts to resend the notification already done
Type DECIMAL(4), NOT NULL

NEXT_RESEND

Definition The date and time of the next attempt to resend the notification
Type SECONDDATE, NOT NULL

RESEND_DATA

Definition The internal data used by the resend policy to compute date and time of next attempt to send the notification
Type BLOB, NULL

ARG_VALUES

Definition The arguments values of the renew reservation notification
Type BLOB, NOT NULL

PARTITION_ID

Definition The partition of the subscriber account owning the renew reservation notification
Type DECIMAL(4), NOT NULL
Primary Key PK_RENEW

Primary Key Details


PK_RENEW

Column(s) PARTITION_ID,OID
Tablespace SESSION_RATING_INDX