RERATING_SESSION

Definition


The RERATING_SESSION table contains information used by the rerating process

Technical Data


Schema Version 4.5.2
Filegroup BART_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
SESSION_ID PK_RERATING_SESSION         
LOCK_CODE          
SESSION_STATUS          
RESTORATION_DATE          
SUBSCRIPTION_COUNT          
IS_ADAPT_FROM_DATE          

Column Details


SESSION_ID

Definition The ID of the rerating session
Description The ID of the rerating session. A rerating session may include several subscriptions to rerate, therefore, several rerating session order entries.
Type DECIMAL(28), NOT NULL
Primary Key PK_RERATING_SESSION

LOCK_CODE

Definition The rerating code generated by the system to prevent the subscription from being rated during the rerating operation
Type NVARCHAR(64), NOT NULL

SESSION_STATUS

Definition The status of the rerating session
Format

The possible values are:

  • 0: New
  • 1: Rerated

Type DECIMAL(1), NOT NULL

RESTORATION_DATE

Definition
Type DATETIME, NULL

SUBSCRIPTION_COUNT

Definition
Type DECIMAL(28), NOT NULL

IS_ADAPT_FROM_DATE

Definition
Type DECIMAL(1), NOT NULL
Default 0

Primary Key Details


PK_RERATING_SESSION

Column(s) SESSION_ID
Filegroup BART_DATA