Data Cache Data Model

ptn_id

decimal

Partition ID

☑

Reference to a partition.

tbe_id

decimal

Table ID

☑

Reference to a table.

tpn_count_rows

decimal

Rows

☐

Number of rows in the table partition version.

tpn_count_rows_deleted

decimal

Count of Deleted Rows

☐

Number of rows deleted compared to previous table partition version.

tpn_count_rows_delta

decimal

Delta of Row Count

☐

Number of rows changed compared to previous table partition version.

tpn_count_rows_inserted

decimal

Count of Inserted Rows

☐

Number of rows inserted compared to previous table partition version.

tpn_count_rows_previous

decimal

Previous Row Count

☐

Number of rows in the previous table partition version.

tpn_count_rows_updated

decimal

Count of Updated Rows

☐

Number of rows updated compard to previous table partition version.

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

tpn_created_by

string(60)

Created by

☑

Who created the record.

tpn_data_file_name_path

string(500)

Data File Name Path

☐

Storage location of the data on disk.

tpn_date_becomes_droppable

datetime

Date Becomes Droppable

☐

Date/time at which the data in the facts table may first be deleted (UTC).

tpn_date_becomes_obsolete

datetime

Date Becomes Obsolete

☐

Date/time at which the data in the facts table may first be declared obsolete (UTC).

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

tpn_date_last_fresh_check

datetime

Date Last Freshness Check

☐

Date/time at which the facts table was last checked for freshness (UTC).

tpn_date_last_got_created

datetime

Date Last Got Created

☐

Date/time at which the facts table was last created (UTC).

tpn_date_last_got_dropped

datetime

Date Last Got Dropped

☐

Date/time at which the data in the facts table was declared deleted (UTC).

tpn_date_last_got_obsoleted

datetime

Date Last Got Obsoleted

☐

Date/time at which the data in the facts table was declared obsolete (UTC).

tpn_date_last_got_ready

datetime

Date Last Got Ready

☐

Date/time at which the facts table was last made available for use (UTC).

tpn_date_last_got_seeding

datetime

Date Last Got Seeding

☐

Date/time at which the facts table was last seeded for new data (UTC).

tpn_date_last_load_start

datetime

Date Last Load Start

☐

Date/time at which the facts table was last loaded with new data (UTC).

tpn_date_metadata_is_droppable

datetime

Date Metadata is Droppable

☐

Date/time at which the metadata on the facts table may first be declared deleted (UTC).

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

tpn_estimated_size_characters

decimal

Estimated Size (characters)

☐

Estimates size of characters in the data for the table partition version.

tpn_id

decimal

ID

☑

Unique identifier.

tpn_lv_date_last_got_created

datetime

Date Logical View Last Got Created

☐

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

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

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

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

tpn_orig_system_reference

string(240)

Original System Reference

☐

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

tpn_refresh_origin

string(1)

Refresh Origin

☑

Origin of the refresh action leading to this version: 'S' for select, 'L' for load and 'R' for refresh.

tpn_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'.

tpn_seeding_approach_used_description

string

Seeding Approach Used Description

☑

Description of the seeding approach.

tpn_seeding_parameter_used_1

string

Seeding Parameter Used #1

☐

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

tpn_seeding_parameter_used_2

string

Seeding Parameter Used #2

☐

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

tpn_seeding_parameter_used_3

string

Seeding Parameter Used #3

☐

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

tpn_seeding_parameter_used_4

string

Seeding Parameter Used #4

☐

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

tpn_seeding_parameter_used_5

string

Seeding Parameter Used #5

☐

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

tpn_session_created

string(240)

Session Created

☑

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

tpn_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

tpn_state

string(1)

State Code

☑

Code of the state in which the table partition version is.

tpn_state_description

string(240)

State Description

☑

Description of the state in which the table partition version is.

tpn_state_note

string(240)

State Note

☐

Note on the state in which the table partition version is.

tpn_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

tpn_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.

tpn_version

decimal

Version Number

☑

Numeric incremental version of the table partition. Increased by 1 every time a new data set is downloaded and/or calculated.