RERATING_SESSION

Definition


The RERATING_SESSION table contains information used by the rerating process

Technical Data


Schema Version 5.0.5
Filegroup BART_DATA
Partitioned No

Summary


The RERATING_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
SESSION_ID PK_RERATING_SESSION       

    The ID of the rerating session

    More...

    LOCK_CODE        

      The rerating code generated by the system to prevent the subscription from being rated during the rerating operation
      SESSION_STATUS        

        The status of the rerating session

        More...

        RESTORATION_DATE        

          SUBSCRIPTION_COUNT        

            IS_ADAPT_FROM_DATE        

              Column Details

              The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

              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

              See the primary key information:

              PK_RERATING_SESSION

              Column(s) SESSION_ID
              Filegroup BART_DATA