Navigation: » No topics above this level «

dc_table_partitions: Data Cache Table Partitions

Structure for all rows in a data set of a specific partition.

Catalog: Cache

Schema: Invantive

Alias: tpt

Primary Keys: tpt_id

Label: Table Partitions

This is a read-only view. The Data Cache API may not support changing the data or the Invantive SQL driver for Data Cache does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Cache API.

View Columns

The columns of the view dc_table_partitions are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
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.

17-08-2023 08:37 Version 22.1.262-BETA+4120

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Data Cache Data Model Data Cache Forums

dc_table_partitions: Data Cache Table Partitions

View Columns

Important Safety and Usage Information