Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

SYSTEMPARTITIONS: Data Dictionary Partitions

Contents Previous Home Next More

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 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 SYSTEMPARTITIONS are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ALLOW_WRITE

boolean

Allow Write

Whether the partition allows writes.

CODE

string(240)

Code

Unique code of the partition.

COMPANY_ADDRESS

string(4000)

Company Address

Address of the company of the partition.

COMPANY_CITY

string(4000)

Company City

City of the company of the partition.

COMPANY_COC_NUMBER

string(4000)

Company Chamber of Commerce Number

Chamber of Commerce number of the company of the partition.

COMPANY_COUNTRY

string(4000)

Company Country

Country of the company of the partition.

COMPANY_EMAIL_ADDRESS

string(4000)

Company Email Address

Email address of the company of the partition.

COMPANY_IBAN_NUMBER

string(4000)

Company IBAN Number

IBAN number of the company of the partition.

COMPANY_NAME

string(4000)

Company Name

Name of the company of the partition.

COMPANY_PHONE

string(4000)

Company Phone

Phone of the company of the partition.

COMPANY_RSIN_NUMBER

string(4000)

Company RSIN Number

RSIN number of the company of the partition.

COMPANY_STATE

string(4000)

Company State

State of the company of the partition.

COMPANY_TWITTER_ACCOUNT

string(4000)

Company Twitter Account

Twitter account of the company of the partition.

COMPANY_VAT_NUMBER

string(4000)

Company VAT Number

VAT number of the company of the partition.

COMPANY_WAGE_TAX_NUMBER

string(4000)

Company Wage Tax Number

Wage tax number of the company of the partition.

COMPANY_WEB_SITE

string(4000)

Company Web Site

Web site of the company of the partition.

COMPANY_ZIP_CODE

string(4000)

Company ZIP Code

ZIP-code of the company of the partition.

CREATED_UTC

datetime

Created

 

When the partition was created (UTC).

DESCRIPTION

string(4000)

Description

Description.

FIRST_USE_UTC

datetime

First Use

 

When the partition has been used first in this session (UTC).

IS_ACTIVE

boolean

Active

 

Whether the partition is active.

IS_ARCHIVED

boolean

Archived

 

Whether the partition is archived.

IS_SELECTED_BY_DEFAULT

boolean

Selected by Default

 

Whether the partition is selected by default.

IS_SELECTED

boolean

Selected

Whether the partition is currently selected.

IS_USED

boolean

Used

 

Whether the partition has been used in this session.

LABEL

string(4000)

Label

Label for use in lists.

MASTER_ROLL_UP

string(4000)

Master Roll-up

Master roll-up.

MODIFIED_UTC

datetime

Modified

 

When the partition was last modified (UTC).

NAME

string(4000)

Name

Name.

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.

ROLL_UP

string(4000)

Roll-up

Roll-up.

SESSION_IO_BYTES_RECEIVED_OTHER

int64

 

Number of bytes sent (other).

SESSION_IO_BYTES_RECEIVED_OVERALL

int64

 

Number of bytes sent overall.

SESSION_IO_BYTES_RECEIVED_READ

int64

 

Number of bytes sent for read.

SESSION_IO_BYTES_RECEIVED_WRITE

int64

 

Number of bytes sent for write.

SESSION_IO_BYTES_SENT_OTHER

int64

 

Number of bytes received (other).

SESSION_IO_BYTES_SENT_OVERALL

int64

 

Number of bytes received overall.

SESSION_IO_BYTES_SENT_READ

int64

 

Number of bytes received for read.

SESSION_IO_BYTES_SENT_WRITE

int64

 

Number of bytes received for write.

SESSION_IO_DURATION_MS_OTHER

int64

 

Total duration for other in milliseconds.

SESSION_IO_DURATION_MS_OVERALL

int64

 

Total duration overall in milliseconds.

SESSION_IO_DURATION_MS_READ

int64

 

Total duration for read in milliseconds.

SESSION_IO_DURATION_MS_WRITE

int64

 

Total duration for write in milliseconds.

SESSION_IO_EXECUTION_COUNT_OTHER

int64

 

Number of I/Os executed (other).

SESSION_IO_EXECUTION_COUNT_OVERALL

int64

 

Number of I/Os executed overall.

SESSION_IO_EXECUTION_COUNT_READ

int64

 

Number of I/Os executed for read.

SESSION_IO_EXECUTION_COUNT_WRITE

int64

 

Number of I/Os executed for write.

SHORT_NAME

string(4000)

Short Name

Short name.

SUBSCRIPTION_HOLDER_ADDRESS_LINE_1

string(4000)

 

Address line 1 of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_ADDRESS_LINE_2

string(4000)

 

Address line 2 of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_ADDRESS_LINE_3

string(4000)

 

Address line 3 of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_CITY

string(4000)

 

City of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_COC_NUMBER

string(4000)

 

CoC number of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_CODE

string(4000)

Owner Company Code

Code of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_COUNTRY

string(4000)

 

Country of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_EMAIL_ADDRESS

string(4000)

 

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

string(4000)

Owner Company ID

Unique ID of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_LEGAL_FORM

string(4000)

 

Legal form of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_NAME

string(4000)

Owner Company Name

Name of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_PHONE

string(4000)

 

Phone number of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_SBI_CODE

string(4000)

 

SBI code of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_VAT_NUMBER

string(4000)

 

VAT number of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_WEB_SITE

string(4000)

 

Website of the subscription holder of the partition.

SUBSCRIPTION_HOLDER_ZIP_CODE

string(4000)

 

ZIP code of the subscription holder of the partition.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191