Data Cache Data Model

ptn_id

decimal

Partition ID

☑

Reference to a partition.

tbe_id

decimal

Table ID

☑

Reference to a table.

tpt_check_count_rows_max

decimal

Check Count of Rows (Max)

☐

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

tpt_check_count_rows_min

decimal

Check Count of Rows (Min)

☐

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

tpt_count_rows_first

decimal

Number of Rows in First Load

☐

Number of rows in first version.

tpt_count_rows_last

decimal

Number of Rows in Last Load

☐

Number of rows in last version.

tpt_count_rows_max

decimal

Maximum Number of Rows in Load

☐

Maximum number of rows in a version ever seen.

tpt_count_rows_min

decimal

Minimum Number of Rows in Load

☐

Minimum number of rows in a version ever seen.

tpt_count_rows_total

decimal

Total Number of Rows

☐

Total number of rows in all versions.

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

tpt_created_by

string(60)

Created by

☑

Who created the record.

tpt_date_copy_activated

datetime

Date Copy Approach Activated

☐

Moment in time at which the copy approach was activated last.

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

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

tpt_date_row_cnt_last_change

datetime

Date Row Count Last Changed

☐

Moment in time at which the row count changed last.

tpt_date_smart_activated

datetime

Date Smart Approach Activated

☐

Moment in time at which the smart approach was activated last.

tpt_date_trickle_activated

datetime

Date Trickle Approach Activated

☐

Moment in time at which the trickle approach was activated last.

tpt_date_trickle_first_message

datetime

Date Reception First Message for Trickle Approach

☐

Moment in time at which a first trickle message was received first.

tpt_estimated_size_chars_first

decimal

Estimated Size in Characters in First Load

☐

Estimated size in characters in first version.

tpt_estimated_size_chars_last

decimal

Estimated Size in Characters in Last Load

☐

Estimated size in characters in last version.

tpt_estimated_size_chars_max

decimal

Maximum Estimated Size in Characters

☐

Maximum estimated size in characters in a version ever seen.

tpt_estimated_size_chars_min

decimal

Minimum Estimated Size in Characters

☐

Minimum estimated size in characters in a version ever seen.

tpt_estimated_size_chars_total

decimal

Estimated Total Size (characters)

☐

Total estimated size in characters in all versions.

tpt_id

decimal

ID

☑

Unique identifier.

tpt_lv_ptn_view_md5

string(60)

Logical Partition View MD5

☐

MD5 of the SQL used to create the logical partition view.

tpt_lv_ptn_view_name

string(240)

Logical Partition View Name

☐

Name of the logical partition view in the database.

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

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

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

tpt_orig_system_reference

string(240)

Original System Reference

☐

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

tpt_seconds_before_droppable

decimal

Seconds before Droppable

☑

Minimum number of seconds before a table partition version facts table becomes droppable.

tpt_seconds_before_obsolete

decimal

Seconds before Obsolete

☑

Minimum number of seconds before a table partition version facts table becomes obsolete.

tpt_seconds_metadata_is_droppable

decimal

Seconds before Metadata Droppable

☑

Minimum number of seconds before a table partition version facts table becomes obsolete.

tpt_seeding_approach_used_code

char

Seeding Approach Used Code

☑

Seeding approach to get a up-to-date data set. Seeding approaches include 'C' for 'Complete', 'S' for 'Smart Sampling' and ' T' for 'Trickle Loading'.

tpt_seeding_approach_used_description

string

Seeding Approach Used Description

☑

Description of the seeding approach.

tpt_seeding_parameter_used_1

string

Seeding Parameter Used #1

☐

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_2

string

Seeding Parameter Used #2

☐

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_3

string

Seeding Parameter Used #3

☐

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_4

string

Seeding Parameter Used #4

☐

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_5

string

Seeding Parameter Used #5

☐

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_time_sec_first

decimal

Seeding Time in Seconds in First Load

☐

Time in seconds to seed the facts table in first version.

tpt_seeding_time_sec_last

decimal

Seeding Time in Seconds in Last Load

☐

Time in seconds to seed the facts table in last version.

tpt_seeding_time_sec_max

decimal

Maximum Seeding Time in Seconds in Load

☐

Maximum time in seconds to seed the facts table in a version ever seen.

tpt_seeding_time_sec_min

decimal

Minimum Seeding Time in Seconds in Load

☐

Minimum time in seconds to seed the facts table in a version ever seen.

tpt_seeding_time_sec_total

decimal

☐

Total time in seconds to seed the facts table in all versions.

tpt_session_created

string(240)

Session Created

☑

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

tpt_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

tpt_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

tpt_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.

tpt_version_last

decimal

☐

Number of version that last got issued.