SYSTEMPARTITIONS: Data Dictionary Partitions
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Partitions
Partitions for all active data containers.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMPARTITIONS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ALLOW_ |
char |
Allow Write | Whether the partition allows writes. | ||
CODE |
varchar2 |
Code | Unique code of the partition. | ||
COMPANY_ |
varchar2 |
Company Address | Address of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Address Line 2 | Second address line of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Address Line 3 | Third address line of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company BIC | BIC of the bank account of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company City | City of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Chamber of Commerce Number | Chamber of Commerce number of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Country | Country of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Currency Code | Code of the currency the company of the partition keeps its books in. | ||
COMPANY_ |
varchar2 |
Company Email Address | Email address of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company GLN Number | Global Location Number (GLN) of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company IBAN Number | IBAN number of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company ID | Identifier of the company of the partition on the platform. | ||
COMPANY_ |
varchar2 |
Company Legal Form | Legal form of the company of the partition, such as a private limited company. | ||
COMPANY_ |
varchar2 |
Company Name | Name of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company PayPal Identifier | PayPal account of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Phone | Phone of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company ZIP Code | ZIP-code of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company RSIN Number | RSIN number of the company of the partition. | ||
COMPANY_ |
datetime |
Company Server Move Date (UTC) | Last server move date of the company. | ||
COMPANY_ |
varchar2 |
Company State | State of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Trade Names | Trade names of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Twitter Account | Twitter account of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company VAT Number | VAT number of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Wage Tax Number | Wage tax number of the company of the partition. | ||
COMPANY_ |
varchar2 |
Company Web Site | Web site of the company of the partition. | ||
CONSUMPTION_ |
int64 |
Consumption Last Call | fetched only when named | ||
CREATED_ |
datetime |
Created | When the partition was created (UTC). | ||
DAILY_ |
int64 |
Maximum Calls per Day | fetched only when named | ||
DAILY_ |
int64 |
Remaining Calls Today | fetched only when named | ||
DAILY_ |
datetime |
Reset Time | fetched only when named | ||
DAILY_ |
int64 |
Calls Made Today | fetched only when named | ||
DESCRIPTION |
varchar2 |
Description | Description. | ||
FIRST_ |
int64 |
First Remaining Calls | fetched only when named | ||
FIRST_ |
datetime |
First Measurement Moment | fetched only when named | ||
FIRST_ |
int64 |
First Remaining Calls per Minute | fetched only when named | ||
FIRST_ |
datetime |
First Use | When the partition has been used first in this session (UTC). | ||
INSTANCE_ |
guid |
Instance UID | Unique ID of the instance. | ||
IS_ |
char |
Active | Whether the partition is active. | ||
IS_ |
char |
Archived | Whether the partition is archived. | ||
IS_ |
char |
Selected | Whether the partition is currently selected. | ||
IS_ |
char |
Selected by Default | Whether the partition is selected by default. | ||
IS_ |
char |
Used | Whether the partition has been used in this session. | ||
LABEL |
varchar2 |
Label | Label for use in lists. | ||
LAST_ |
datetime |
Measurement Moment | fetched only when named | ||
LAST_ |
varchar2 |
Last Update Remote Correlation IDs | Request ID. | ||
LAST_ |
varchar2 |
Last Updated Request ID | Request ID. | ||
MASTER_ |
varchar2 |
Master Roll-up | Master roll-up. | ||
MINUTELY_ |
int64 |
Maximum Remaining Calls per Minute | fetched only when named | ||
MINUTELY_ |
int64 |
Remaining Calls per Minute | fetched only when named | ||
MINUTELY_ |
datetime |
Reset Time per Minute | fetched only when named | ||
MODIFIED_ |
datetime |
Modified | When the partition was last modified (UTC). | ||
NAME |
varchar2 |
Name | Name. | ||
PREVIOUS_ |
int64 |
Previous Remaining Calls | fetched only when named | ||
PREVIOUS_ |
int64 |
Previous Day Remaining Calls | fetched only when named | ||
PREVIOUS_ |
datetime |
Previous Day Timestamp | fetched only when named | ||
PREVIOUS_ |
int64 |
Previous Hour Remaining Calls | fetched only when named | ||
PREVIOUS_ |
datetime |
Previous Hour Timestamp | fetched only when named | ||
PREVIOUS_ |
datetime |
Previous Measurement Moment | fetched only when named | ||
PREVIOUS_ |
int64 |
Previous Remaining Calls per Minute | fetched only when named | ||
PREVIOUS_ |
int64 |
Previous Minute Remaining Calls | fetched only when named | ||
PREVIOUS_ |
datetime |
Previous Minute Timestamp | fetched only when named | ||
PROVIDER_ |
varchar2 |
Data Container Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Data Container ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provider Description | Provider description. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Short Name | Provider short name. | ||
ROLL_ |
varchar2 |
Roll-up | Roll-up. | ||
SELECTED_ |
datetime |
Selected Last Modified (UTC) | When the partition selection was last modified (UTC). | ||
SELECTED_ |
datetime |
Selected Last Set (UTC) | When the partition selection was last set (UTC). | ||
SELECTED_ |
datetime |
Selected Last Unset (UTC) | When the partition selection was last unset (UTC). | ||
SESSION_ |
int64 |
I/O Execution Bytes Received Other | Number of bytes sent (other). | ||
SESSION_ |
int64 |
I/O Execution Bytes Received | Number of bytes sent overall. | ||
SESSION_ |
int64 |
I/O Execution Bytes Received Read | Number of bytes sent for read. | ||
SESSION_ |
int64 |
I/O Execution Bytes Received Write | Number of bytes sent for write. | ||
SESSION_ |
int64 |
I/O Execution Bytes Sent Other | Number of bytes received (other). | ||
SESSION_ |
int64 |
I/O Execution Bytes Sent | Number of bytes received overall. | ||
SESSION_ |
int64 |
I/O Execution Bytes Sent Read | Number of bytes received for read. | ||
SESSION_ |
int64 |
I/O Execution Bytes Sent Write | Number of bytes received for write. | ||
SESSION_ |
double |
I/O Execution Duration Other (ms) | Total duration for other in milliseconds. | ||
SESSION_ |
double |
I/O Execution Duration (ms) | Total duration overall in milliseconds. | ||
SESSION_ |
double |
I/O Execution Duration Read (ms) | Total duration for read in milliseconds. | ||
SESSION_ |
double |
I/O Execution Duration Write (ms) | Total duration for write in milliseconds. | ||
SESSION_ |
int64 |
I/O Execution Count Other | Number of I/Os executed (other). | ||
SESSION_ |
int64 |
I/O Execution Count | Number of I/Os executed overall. | ||
SESSION_ |
int64 |
I/O Execution Count Read | Number of I/Os executed for read. | ||
SESSION_ |
int64 |
I/O Execution Count Write | Number of I/Os executed for write. | ||
SHORT_ |
varchar2 |
Short Name | Short name. | ||
SUBSCRIPTION_ |
varchar2 |
Company Address Line 1 | Address line 1 of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company Address Line 2 | Address line 2 of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company Address Line 3 | Address line 3 of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder BIC | BIC of the bank account of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company City | City of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company CoC Number | CoC number of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Owner Company Code | Code of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company Country | Country of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder Currency Code | Code of the currency the subscription holder of the partition keeps its books in. | ||
SUBSCRIPTION_ |
varchar2 |
Company Email Address | Email address of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder GLN Number | Global Location Number (GLN) of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
guid |
Owner Company GUID | Unique GUID of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder IBAN Number | IBAN of the bank account of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Owner Company ID | Unique ID of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company Legal Form | Legal form of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Owner Company Name | Name of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder PayPal Identifier | PayPal account of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company Phone | Phone number of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company ZIP Code | Postal code of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder RSIN Number | RSIN of the subscription holder of the partition, the Dutch number for legal entities. | ||
SUBSCRIPTION_ |
varchar2 |
Company SBI Code | SBI code of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder SIRET Number | SIRET number of the subscription holder of the partition, the French number for business locations. | ||
SUBSCRIPTION_ |
varchar2 |
Company VAT Number | VAT number of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Subscription Holder Wage Tax Number | Wage tax number of the subscription holder of the partition. | ||
SUBSCRIPTION_ |
varchar2 |
Company Website | Website of the subscription holder of the partition. | ||
UPDATE_ |
int64 |
Update Count | fetched only when named | ||
UPDATE_ |
int64 |
Update with Change Count | fetched only when named |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMPARTITIONS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: