Navigation: Catalog: DataDictionary > Schemas > Schema: Invantive > Tables

SYSTEMPARTITIONS: Data Dictionary Partitions

Partitions for all active data containers.

Catalog: DataDictionary

Schema: Invantive

Alias: ptn

Label: Partitions

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

View Columns

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

Name	Data Type	Label	Required	Documentation
ALLOW_WRITE	char	Allow Write	☑	Whether the partition allows writes.
CODE	varchar2(240)	Code	☑	Unique code of the partition.
COMPANY_ADDRESS	varchar2(4000)	Company Address	☐	Address of the company of the partition.
COMPANY_CITY	varchar2(4000)	Company City	☐	City of the company of the partition.
COMPANY_COC_NUMBER	varchar2(4000)	Company Chamber of Commerce Number	☐	Chamber of Commerce number of the company of the partition.
COMPANY_COUNTRY	varchar2(4000)	Company Country	☐	Country of the company of the partition.
COMPANY_EMAIL_ADDRESS	varchar2(4000)	Company Email Address	☐	Email address of the company of the partition.
COMPANY_IBAN_NUMBER	varchar2(4000)	Company IBAN Number	☐	IBAN number of the company of the partition.
COMPANY_NAME	varchar2(4000)	Company Name	☐	Name of the company of the partition.
COMPANY_PHONE	varchar2(4000)	Company Phone	☐	Phone of the company of the partition.
COMPANY_POSTAL_CODE	varchar2(4000)	Company ZIP Code	☐	ZIP-code of the company of the partition.
COMPANY_RSIN_NUMBER	varchar2(4000)	Company RSIN Number	☐	RSIN number of the company of the partition.
COMPANY_SERVER_MOVE_DATE_UTC	datetime	Company Server Move Date (UTC)	☐	Last server move date of the company.
COMPANY_STATE	varchar2(4000)	Company State	☐	State of the company of the partition.
COMPANY_TWITTER_ACCOUNT	varchar2(4000)	Company Twitter Account	☐	Twitter account of the company of the partition.
COMPANY_VAT_NUMBER	varchar2(4000)	Company VAT Number	☐	VAT number of the company of the partition.
COMPANY_WAGE_TAX_NUMBER	varchar2(4000)	Company Wage Tax Number	☐	Wage tax number of the company of the partition.
COMPANY_WEB_SITE	varchar2(4000)	Company Web Site	☐	Web site of the company of the partition.
CONSUMPTION_LAST_CALL	int64	Consumption Last Call	☐
CREATED_UTC	datetime	Created		When the partition was created (UTC).
DAILY_LIMIT	int64	Maximum Calls per Day	☐
DAILY_REMAINING	int64	Remaining Calls Today	☐
DAILY_RESET_DATE_UTC	datetime	Reset Time	☐
DAILY_USED	int64	Calls Made Today	☐
DESCRIPTION	varchar2(4000)	Description	☐	Description.
FIRST_DAILY_REMAINING	int64	First Remaining Calls	☐
FIRST_MEASUREMENT_UTC	datetime	First Measurement Moment	☐
FIRST_MINUTELY_REMAINING	int64	First Remaining Calls per Minute	☐
FIRST_USE_UTC	datetime	First Use		When the partition has been used first in this session (UTC).
INSTANCE_UID	guid		☑	Unique ID of the instance.
IS_ACTIVE	char	Active		Whether the partition is active.
IS_ARCHIVED	char	Archived		Whether the partition is archived.
IS_SELECTED_BY_DEFAULT	char	Selected by Default		Whether the partition is selected by default.
IS_SELECTED	char	Selected	☑	Whether the partition is currently selected.
IS_USED	char	Used		Whether the partition has been used in this session.
LABEL	varchar2(4000)	Label	☑	Label for use in lists.
LAST_MEASUREMENT_UTC	datetime	Measurement Moment	☐
LAST_UPDATE_REMOTE_CORRELATION_IDS	varchar2(1024)	Last Update Remote Correlation IDs	☐	Request ID.
LAST_UPDATE_REQUEST_ID	varchar2(60)	Last Updated Request ID	☐	Request ID.
MASTER_ROLL_UP	varchar2(4000)	Master Roll-up	☐	Master roll-up.
MINUTELY_LIMIT	int64	Maximum Remaining Calls per Minute	☐
MINUTELY_REMAINING	int64	Remaining Calls per Minute	☐
MINUTELY_RESET_DATE_UTC	datetime	Reset Time per Minute	☐
MODIFIED_UTC	datetime	Modified		When the partition was last modified (UTC).
NAME	varchar2(4000)	Name	☐	Name.
PREVIOUS_DAILY_REMAINING	int64	Previous Remaining Calls	☐
PREVIOUS_DAY_DAILY_REMAINING	int64	Previous Day Remaining Calls	☐
PREVIOUS_DAY_DAILY_TIMESTAMP_UTC	datetime	Previous Day Timestamp	☐
PREVIOUS_HOUR_DAILY_REMAINING	int64	Previous Hour Remaining Calls	☐
PREVIOUS_HOUR_DAILY_TIMESTAMP_UTC	datetime	Previous Hour Timestamp	☐
PREVIOUS_MEASUREMENT_UTC	datetime	Previous Measurement Moment	☐
PREVIOUS_MINUTE_DAILY_REMAINING	int64	Previous Minute Remaining Calls	☐
PREVIOUS_MINUTE_DAILY_TIMESTAMP_UTC	datetime	Previous Minute Timestamp	☐
PREVIOUS_MINUTELY_REMAINING	int64	Previous Remaining Calls per Minute	☐
PROVIDER_DATA_CONTAINER_ALIAS	varchar2(4000)	Data Container Alias	☐	Data container alias.
PROVIDER_DATA_CONTAINER_ID	varchar2(4000)	Data Container ID	☑	Data container ID.
PROVIDER_DESCRIPTION	varchar2(16000)	Provider Description	☑	Provider description.
PROVIDER_INSTANCE_UID	guid	Provider Instance UID	☑	Unique ID of the provider instance.
PROVIDER_NAME	varchar2(240)	Provider Name	☑	Name of the provider.
PROVIDER_SHORT_NAME	varchar2(240)	Provider Short Name	☑	Provider short name.
ROLL_UP	varchar2(4000)	Roll-up	☐	Roll-up.
SELECTED_LAST_MODIFIED_UTC	datetime		☑	When the partition selection was last modified (UTC).
SELECTED_LAST_SET_UTC	datetime		☐	When the partition selection was last set (UTC).
SELECTED_LAST_UNSET_UTC	datetime		☐	When the partition selection was last unset (UTC).
SESSION_IO_BYTES_RECEIVED_OTHER	int64	I/O Execution Bytes Received Other	☐	Number of bytes sent (other).
SESSION_IO_BYTES_RECEIVED_OVERALL	int64	I/O Execution Bytes Received	☐	Number of bytes sent overall.
SESSION_IO_BYTES_RECEIVED_READ	int64	I/O Execution Bytes Received Read	☐	Number of bytes sent for read.
SESSION_IO_BYTES_RECEIVED_WRITE	int64	I/O Execution Bytes Received Write	☐	Number of bytes sent for write.
SESSION_IO_BYTES_SENT_OTHER	int64	I/O Execution Bytes Sent Other	☐	Number of bytes received (other).
SESSION_IO_BYTES_SENT_OVERALL	int64	I/O Execution Bytes Sent	☐	Number of bytes received overall.
SESSION_IO_BYTES_SENT_READ	int64	I/O Execution Bytes Sent Read	☐	Number of bytes received for read.
SESSION_IO_BYTES_SENT_WRITE	int64	I/O Execution Bytes Sent Write	☐	Number of bytes received for write.
SESSION_IO_DURATION_MS_OTHER	int64	I/O Execution Duration Other (ms)	☐	Total duration for other in milliseconds.
SESSION_IO_DURATION_MS_OVERALL	int64	I/O Execution Duration (ms)	☐	Total duration overall in milliseconds.
SESSION_IO_DURATION_MS_READ	int64	I/O Execution Duration Read (ms)	☐	Total duration for read in milliseconds.
SESSION_IO_DURATION_MS_WRITE	int64	I/O Execution Duration Write (ms)	☐	Total duration for write in milliseconds.
SESSION_IO_EXECUTION_COUNT_OTHER	int64	I/O Execution Count Other	☐	Number of I/Os executed (other).
SESSION_IO_EXECUTION_COUNT_OVERALL	int64	I/O Execution Count	☐	Number of I/Os executed overall.
SESSION_IO_EXECUTION_COUNT_READ	int64	I/O Execution Count Read	☐	Number of I/Os executed for read.
SESSION_IO_EXECUTION_COUNT_WRITE	int64	I/O Execution Count Write	☐	Number of I/Os executed for write.
SHORT_NAME	varchar2(4000)	Short Name	☐	Short name.
SUBSCRIPTION_HOLDER_ADDRESS_LINE_1	varchar2(4000)	Company Address Line 1	☐	Address line 1 of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_ADDRESS_LINE_2	varchar2(4000)	Company Address Line 2	☐	Address line 2 of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_ADDRESS_LINE_3	varchar2(4000)	Company Address Line 3	☐	Address line 3 of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_CITY	varchar2(4000)	Company City	☐	City of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_COC_NUMBER	varchar2(4000)	Company CoC Number	☐	CoC number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_CODE	varchar2(4000)	Owner Company Code	☐	Code of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_COUNTRY	varchar2(4000)	Company Country	☐	Country of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_EMAIL_ADDRESS	varchar2(4000)	Company Email Address	☐	Email address of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_GUID	guid	Owner Company GUID	☐	Unique GUID of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_ID	varchar2(4000)	Owner Company ID	☐	Unique ID of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_LEGAL_FORM	varchar2(4000)	Company Legal Form	☐	Legal form of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_NAME	varchar2(4000)	Owner Company Name	☐	Name of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_PHONE	varchar2(4000)	Company Phone	☐	Phone number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_POSTAL_CODE	varchar2(4000)	Company ZIP Code	☐	Postal code of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_SBI_CODE	varchar2(4000)	Company SBI Code	☐	SBI code of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_VAT_NUMBER	varchar2(4000)	Company VAT Number	☐	VAT number of the subscription holder of the partition.
SUBSCRIPTION_HOLDER_WEB_SITE	varchar2(4000)	Company Website	☐	Website of the subscription holder of the partition.
UPDATE_COUNT	int64	Update Count	☐
UPDATE_WITH_CHANGE_COUNT	int64	Update with Change Count	☐

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 Dictionary Data Model

SYSTEMPARTITIONS: Data Dictionary Partitions

View Columns

Important Safety and Usage Information