Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

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.

View Columns

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