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 in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by |
|---|---|---|---|---|---|
| SESSION_ID | PK_RERATING_SESSION | The ID of the rerating session
|
|||
| 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
|
||||
| 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:
|
| 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 |