invantive documentation
Invantive Support ForumsLog In / Sign Up

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_SERVER_MOVE_DATE_UTC datetime Company Server Move Date (UTC) Last server move date of the company.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Data Container ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
PTN_ALLOW_WRITE char Partition Allow Write Whether the partition allows writes.
PTN_CODE varchar2(240) Partition Code Unique code of the partition.
PTN_COMPANY_ADDRESS varchar2(4000) Partition Company Address Address of the company of the partition.
PTN_COMPANY_CITY varchar2(4000) Partition Company City City of the company of the partition.
PTN_COMPANY_COC_NUMBER varchar2(4000) Partition Company CoC Number Chamber of Commerce number of the company of the partition.
PTN_COMPANY_COUNTRY varchar2(4000) Partition Company Country Country of the company of the partition.
PTN_COMPANY_EMAIL_ADDRESS varchar2(4000) Partition Company Email Address Email address of the company of the partition.
PTN_COMPANY_IBAN_NUMBER varchar2(4000) Company IBAN Number IBAN number of the company of the partition.
PTN_COMPANY_NAME varchar2(4000) Partition Company Name Name of the company of the partition.
PTN_COMPANY_PHONE varchar2(4000) Partition Company Phone Phone of the company of the partition.
PTN_COMPANY_POSTAL_CODE varchar2(4000) Partition Company ZIP Code ZIP-code of the company of the partition.
PTN_COMPANY_RSIN_NUMBER varchar2(4000) Company RSIN Number RSIN number of the company of the partition.
PTN_COMPANY_STATE varchar2(4000) Partition Company State State of the company of the partition.
PTN_COMPANY_TWITTER_ACCOUNT varchar2(4000) Partition Company Twitter Account Twitter account of the company of the partition.
PTN_COMPANY_VAT_NUMBER varchar2(4000) Partition Company VAT Number VAT number of the company of the partition.
PTN_COMPANY_WAGE_TAX_NUMBER varchar2(4000) Partition Company Wage Tax Number Wage tax number of the company of the partition.
PTN_COMPANY_WEB_SITE varchar2(4000) Partition Company Web Site Web site of the company of the partition.
PTN_CREATED_UTC datetime Partition Created When the partition was created (UTC).
PTN_DESCRIPTION varchar2(4000) Partition Description Description.
PTN_FIRST_USE_UTC datetime Partition First Use When the partition has been used first in this session (UTC).
PTN_INSTANCE_UID guid Instance UID Unique ID of the instance.
PTN_IS_SELECTED char Partition Selected Whether the partition is currently selected.
PTN_IS_SELECTED_BY_DEFAULT char Partition Selected by Default Whether the partition is selected by default.
PTN_IS_USED char Partition Used Whether the partition has been used in this session.
PTN_LABEL varchar2(4000) Partition Label Label for use in lists.
PTN_MASTER_ROLL_UP varchar2(4000) Partition Master Roll-up Master roll-up.
PTN_MODIFIED_UTC datetime Partition Modified When the partition was last modified (UTC).
PTN_NAME varchar2(4000) Partition Name Name.
PTN_ROLL_UP varchar2(4000) Partition Roll-up Roll-up.
PTN_SELECTED_LAST_MODIFIED_UTC datetime Selected Last Modified (UTC) When the partition selection was last modified (UTC).
PTN_SELECTED_LAST_SET_UTC datetime Selected Last Set (UTC) When the partition selection was last set (UTC).
PTN_SELECTED_LAST_UNSET_UTC datetime Selected Last Unset (UTC) When the partition selection was last unset (UTC).
PTN_SHORT_NAME varchar2(4000) Partition Short Name Short name.
STC_CODE varchar2(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 varchar2(240) Description Description of the partition statistic.
STC_IS_STANDARD char Is Standard? Is the statistic a standard statistic?
STC_REDUCED_ACCURACY_VALUE varchar2(240) Reduced Accuracy Value Reduced accuracy value of the partition statistic.
STC_TYPE varchar2(240) Value Type Type of value of the partition statistic.
STC_VALUE varchar2(240) Value Value of the partition statistic.

Keys

Key Column Refers to Kind Description
SYSTEMPARTITIONSTATISTICS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: