SYSTEMPARTITIONSTATISTICS: Data Dictionary System Partition Statistics |
Contents Previous Home Next More |
Statistics per partitions for all active data containers.
Catalog: DataDictionary
Schema: Invantive
Alias: psc
Label: System Partition Statistics
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL 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.
The columns of the view SYSTEMPARTITIONSTATISTICS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
PTN_ALLOW_WRITE |
boolean |
Partition Allow Write |
☑ |
Whether the partition allows writes. |
PTN_CODE |
string(240) |
Partition Code |
☑ |
Unique code of the partition. |
PTN_COMPANY_ADDRESS |
string(4000) |
Partition Company Address |
☐ |
Address of the company of the partition. |
PTN_COMPANY_CITY |
string(4000) |
Partition Company City |
☐ |
City of the company of the partition. |
PTN_COMPANY_COC_NUMBER |
string(4000) |
Partition Company CoC Number |
☐ |
Chamber of Commerce number of the company of the partition. |
PTN_COMPANY_COUNTRY |
string(4000) |
Partition Company Country |
☐ |
Country of the company of the partition. |
PTN_COMPANY_EMAIL_ADDRESS |
string(4000) |
Partition Company Email Address |
☐ |
Email address of the company of the partition. |
PTN_COMPANY_IBAN_NUMBER |
string(4000) |
Company IBAN Number |
☐ |
IBAN number of the company of the partition. |
PTN_COMPANY_NAME |
string(4000) |
Partition Company Name |
☐ |
Name of the company of the partition. |
PTN_COMPANY_PHONE |
string(4000) |
Partition Company Phone |
☐ |
Phone of the company of the partition. |
PTN_COMPANY_RSIN_NUMBER |
string(4000) |
Company RSIN Number |
☐ |
RSIN number of the company of the partition. |
PTN_COMPANY_STATE |
string(4000) |
Partition Company State |
☐ |
State of the company of the partition. |
PTN_COMPANY_TWITTER_ACCOUNT |
string(4000) |
Partition Company Twitter Account |
☐ |
Twitter account of the company of the partition. |
PTN_COMPANY_VAT_NUMBER |
string(4000) |
Partition Company VAT Number |
☐ |
VAT number of the company of the partition. |
PTN_COMPANY_WAGE_TAX_NUMBER |
string(4000) |
Partition Company Wage Tax Number |
☐ |
Wage tax number of the company of the partition. |
PTN_COMPANY_WEB_SITE |
string(4000) |
Partition Company Web Site |
☐ |
Web site of the company of the partition. |
PTN_COMPANY_ZIP_CODE |
string(4000) |
Partition Company ZIP Code |
☐ |
ZIP-code of the company of the partition. |
PTN_CREATED_UTC |
datetime |
Partition Created |
|
When the partition was created (UTC). |
PTN_DESCRIPTION |
string(4000) |
Partition Description |
☐ |
Description. |
PTN_FIRST_USE_UTC |
datetime |
Partition First Use |
|
When the partition has been used first in this session (UTC). |
PTN_IS_SELECTED_BY_DEFAULT |
boolean |
Partition Selected by Default |
|
Whether the partition is selected by default. |
PTN_IS_SELECTED |
boolean |
Partition Selected |
☑ |
Whether the partition is currently selected. |
PTN_IS_USED |
boolean |
Partition Used |
|
Whether the partition has been used in this session. |
PTN_LABEL |
string(4000) |
Partition Label |
☑ |
Label for use in lists. |
PTN_MASTER_ROLL_UP |
string(4000) |
Partition Master Roll-up |
☐ |
Master roll-up. |
PTN_MODIFIED_UTC |
datetime |
Partition Modified |
|
When the partition was last modified (UTC). |
PTN_NAME |
string(4000) |
Partition Name |
☐ |
Name. |
PTN_ROLL_UP |
string(4000) |
Partition Roll-up |
☐ |
Roll-up. |
PTN_SHORT_NAME |
string(4000) |
Partition Short Name |
☐ |
Short name. |
STC_CODE |
string(240) |
Code |
☑ |
Unique code of the partition statistic. |
STC_CREATION_DATE_UTC |
datetime |
Creation Date |
☐ |
Date at which the entry was originally created (UTC). |
STC_DESCRIPTION |
string(240) |
Description |
☐ |
Description of the partition statistic. |
STC_IS_STANDARD |
boolean |
Is Standard? |
☑ |
Is the statistic a standard statistic? |
STC_REDUCED_ACCURACY_VALUE |
string(240) |
Reduced Accuracy Value |
☐ |
Reduced accuracy value of the partition statistic. |
STC_TYPE |
string(240) |
Value Type |
☑ |
Type of value of the partition statistic. |
STC_VALUE |
string(240) |
Value |
☐ |
Value of the partition statistic. |
17-05-2021 11:57 Version 20.1.419-BETA+3191