CSO_SCH_COND_HI
This table stores the history of the business conditions to tailor search results based on context, such as the user’s identity, location, or date and time of the query (currently not used)
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_SCH_COND_HI_PK |
RECORD_ID, ROW_START |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| CONDITION_GROUP_ID | VARCHAR2 | 32 | This is the Business condtion group Id. | |
| DATE_ADDED | TIMESTAMP | Yes | This is the datetime when the record was added. | |
| DATE_MODIFIED | TIMESTAMP | Yes | This is the datetime when the record was last modified. | |
| OPERATOR | VARCHAR2 | 64 | Yes | Operator of the business condition (e.g. greater than) |
| RECORD_ID | VARCHAR2 | 32 | Yes | Record ID, forming compound primary key with ROW_START |
| ROW_END | TIMESTAMP | This is the dateime when a specific version of the config object was modified (NULL indicates this version has not been modified and is currently active) | ||
| ROW_START | TIMESTAMP | Yes | This is the datetime when a specific version of the config object was added. | |
| VALUE | VARCHAR2 | 255 | Yes | Value of the business condition (e.g. 2016/02/12) |
| VARIABLE_NAME | VARCHAR2 | 64 | Yes | This is the Name of the business condition variable (e.g. date) |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_SCH_COND_HI_U1 | Unique | RECORD_ID, ROW_START |