SYSTEMPARTITIONSTATISTICS: Data Dictionary System Partition Statistics
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: System Partition Statistics
Statistics per partitions for all active data containers.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMPARTITIONSTATISTICS 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 |
|---|---|---|---|---|---|
COMPANY_ |
datetime |
Company Server Move Date (UTC) | Last server move date of the company. | ||
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. | ||
PTN_ |
char |
Partition Allow Write | Whether the partition allows writes. | ||
PTN_ |
varchar2 |
Partition Code | Unique code of the partition. | ||
PTN_ |
varchar2 |
Partition Company Address | Address of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company City | City of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company CoC Number | Chamber of Commerce number of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Country | Country of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Email Address | Email address of the company of the partition. | ||
PTN_ |
varchar2 |
Company IBAN Number | IBAN number of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Name | Name of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Phone | Phone of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company ZIP Code | ZIP-code of the company of the partition. | ||
PTN_ |
varchar2 |
Company RSIN Number | RSIN number of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company State | State of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Twitter Account | Twitter account of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company VAT Number | VAT number of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Wage Tax Number | Wage tax number of the company of the partition. | ||
PTN_ |
varchar2 |
Partition Company Web Site | Web site of the company of the partition. | ||
PTN_ |
datetime |
Partition Created | When the partition was created (UTC). | ||
PTN_ |
varchar2 |
Partition Description | Description. | ||
PTN_ |
datetime |
Partition First Use | When the partition has been used first in this session (UTC). | ||
PTN_ |
guid |
Instance UID | Unique ID of the instance. | ||
PTN_ |
char |
Partition Selected | Whether the partition is currently selected. | ||
PTN_ |
char |
Partition Selected by Default | Whether the partition is selected by default. | ||
PTN_ |
char |
Partition Used | Whether the partition has been used in this session. | ||
PTN_ |
varchar2 |
Partition Label | Label for use in lists. | ||
PTN_ |
varchar2 |
Partition Master Roll-up | Master roll-up. | ||
PTN_ |
datetime |
Partition Modified | When the partition was last modified (UTC). | ||
PTN_ |
varchar2 |
Partition Name | Name. | ||
PTN_ |
varchar2 |
Partition Roll-up | Roll-up. | ||
PTN_ |
datetime |
Selected Last Modified (UTC) | When the partition selection was last modified (UTC). | ||
PTN_ |
datetime |
Selected Last Set (UTC) | When the partition selection was last set (UTC). | ||
PTN_ |
datetime |
Selected Last Unset (UTC) | When the partition selection was last unset (UTC). | ||
PTN_ |
varchar2 |
Partition Short Name | Short name. | ||
STC_ |
varchar2 |
Code | Unique code of the partition statistic. | ||
STC_ |
datetime |
Creation Date | Date at which the entry was originally created (UTC). | ||
STC_ |
varchar2 |
Description | Description of the partition statistic. | ||
STC_ |
char |
Is Standard? | Is the statistic a standard statistic? | ||
STC_ |
varchar2 |
Reduced Accuracy Value | Reduced accuracy value of the partition statistic. | ||
STC_ |
varchar2 |
Value Type | Type of value of the partition statistic. | ||
STC_ |
varchar2 |
Value | Value of the partition statistic. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMPARTITIONSTATISTICS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: