Data Cache Data Model

stg_allow_auto_upgrade_flag

string(1)

Allow Auto Upgrade

☑

Whether the repository data model must be checked for an upgrade (and executed when deemed necessary) on every new connection to the backing database.

stg_auto_upgrade_once_flag

string(1)

Auto Upgrade Once

☑

Whether the repository data model must be checked for an upgrade (and executed when deemed necessary) on the next connection established to the backing database.

stg_created_at

string(60)

Created in

☑

The code of the function in the modules table from within which the user created the record. This value will never change after creation of the record.

stg_created_by

string(60)

Created by

☑

Who created the record.

stg_date_created

datetime

Created at

☑

The system time in UTC at which the record was created. This value will never change after creation of the record.

stg_date_modified

datetime

Updated at

☑

The system time in UTC at which the record was last updated. This value will change for every mutation of the record.

stg_dummy

string(1)

Dummy

☑

Placeholder for a unique value to ensure uniqueness and at most one row in this table.

stg_environment_id

string(30)

☑

Unique environment ID.

stg_id

decimal

ID

☑

Unique identifier.

stg_index_facts_tables_flag

char

Index Facts Tables

☑

Default whether indexes on facts tables must be created and maintained.

stg_index_history_tables_flag

char

Index History Tables

☑

Default whether indexes on history tables must be created and maintained.

stg_lv_overall_active_flag

char

Maintain Overall Logical Views

☑

Default whether overall logical views must be created and maintained.

stg_lv_overall_view_name_postfix

string(240)

Postfix Overall Logical View Name

☐

Default postfix for the name of the overall logical view.

stg_lv_overall_view_name_prefix

string(240)

Prefix Overall Logical View Name

☐

Default prefix for the name of the overall logical view.

stg_lv_ptn_active_flag

char

Maintain Partition Logical Views

☑

Default whether partition logical views must be created and maintained.

stg_lv_ptn_view_name_postfix

string(240)

Postfix Partition Logical View Name

☐

Default postfix for the name of a partition logical view.

stg_lv_ptn_view_name_prefix

string(240)

Prefix Partition Logical View Name

☐

Default prefix for the name of a partition logical view.

stg_modified_at

string(60)

Updated in

☑

The code of the function in the modules table from within which the user last updated the record. This value will change for every mutation of the record.

stg_modified_by

string(60)

Updated by

☑

The name of the user in the users table whom last updated the record. This value will change for every update of the record.

stg_orig_system_group

string(240)

Original System Group

☐

Reference for identifying the group of records on the system from which it originated. It is commonly used to group records for later validation in an application control.

stg_orig_system_reference

string(240)

Original System Reference

☐

Reference for identifying the record on the system from which it originated.

stg_sec_before_droppable

decimal

Seconds before Droppable

☑

Number of seconds after becoming obsolete before a table partition-specific facts table is droppable.

stg_sec_before_obsolete

decimal

Seconds before Obsolete

☑

Number of seconds after download before the downloaded data is considered obsolete.

stg_sec_metadata_is_droppable

decimal

Seconds before Metadata Droppable

☑

Number of seconds after the data became obsolete before the metadata is droppable.

stg_sec_retention_forwarded_incoming_messages

decimal

Seconds Retention Forwarded Incoming Messages

☑

Number of seconds after an incoming messages has been forwarded before becoming eligible for a delete.

stg_session_created

string(240)

Session Created

☑

The ID of the session which created the record. This value will not change after insert.

stg_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

stg_sql_engine_version

string(30)

SQL Engine Version

☐

Version of the SQL engine used to update the repository data model.

stg_token

string(2000)

Token

☐

Token for authentication to download messages from the Customer Service.

stg_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

stg_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.