Please enable JavaScript to view this site.

Navigation: » No topics above this level «

dc_tables: Tables

Name: dc_tables

Structure for all rows in a data set.

Catalog: Cache

Schema: Invantive

Alias: tbe

Primary Keys: tbe_id

Label: Tables

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Table Columns

Name

Data Type

Label

Required

Documentation

dcr_id

decimal

Datacontainer ID

Reference to a data container.

tbe_check_count_rows_max

decimal

Check Count of Rows (Max)

Maximum number of rows that all table partitions of this table should contain.

tbe_check_count_rows_min

decimal

Check Count of Rows (Min)

Minimum number of rows that all table partitions of this table should contain.

tbe_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.

tbe_created_by

string(60)

Created by

Who created the record.

tbe_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.

tbe_date_lv_last_got_created

datetime

Date Logical View Last Got Created

Date/time at which the overall and/or partition logical views were last maintained.

tbe_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.

tbe_facts_table_name

string(30)

Facts Table Name

Name of the facts table with last downloaded data for this table.

tbe_fragment_code

string(5)

Table Name Fragment Code

Random sequence of characters used to compose the name of the facts table with.

tbe_full_qualified_name

string(240)

Full Qualified Name

Full qualified name of the table to be downloaded.

tbe_history_table_md5

string(60)

MD5 of History Table

MD5 of the SQL used to create the history table.

tbe_history_table_name

string(30)

History Table Name

Name of the history table with current and all previous seen data for this table.

tbe_id

decimal

ID

Unique identifier.

tbe_index_facts_table_flag

string(1)

Index Facts Table?

Whether indexes on facts table must be created and maintained.

tbe_index_history_table_flag

string(1)

Index History Table?

Whether indexes on history table must be created and maintained.

tbe_lv_overall_active_flag

string(1)

Maintain Overall Logical Views

Whether overall logical views must be created and maintained.

tbe_lv_overall_view_name

string(240)

Name of Overall Logical View

Name of the overall logical view.

tbe_lv_ptn_active_flag

string(1)

Maintain Partition Logical Views

Whether partition logical views must be created and maintained.

tbe_lv_ptn_view_name_postfix

string(30)

Postfix Partition Logical View Name

Postfix for the name of a partition logical view.

tbe_lv_ptn_view_name_prefix

string(30)

Prefix Partition Logical View Name

Prefix for the name of a partition logical view.

tbe_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.

tbe_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.

tbe_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.

tbe_orig_system_reference

string(240)

Original System Reference

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

tbe_seconds_before_droppable

decimal

Seconds before Droppable

Default for minimum number of seconds before a table partition version facts table becomes droppable.

tbe_seconds_before_obsolete

decimal

Seconds before Obsolete

Default for minimum number of seconds before a table partition version facts table becomes obsolete.

tbe_seconds_metadata_is_droppable

decimal

Seconds before Metadata Droppable

Default for minimum number of seconds before a table partition version facts table becomes obsolete.

tbe_session_created

string(240)

Session Created

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

tbe_session_modified

string(240)

Session Updated

The ID of the session which last updated the record.

tbe_table_md5

string(60)

MD5 of Facts Table

MD5 of the SQL used to create the facts table.

tbe_transaction_created

string(240)

Transaction Created

The ID of the transaction which created the record.

tbe_transaction_modified

string(240)

Transaction Updated

The ID of the transaction which last updated the record.

 

26-06-2020 06:4820.1.99-BETA+2846