invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPARTITIONTAGS: Data Dictionary System Partition Tags

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: System Partition Tags

Tags per partitions for all active data containers.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPARTITIONTAGS 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
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_SERVER_MOVE_DATE_UTC datetime Company Server Move Date (UTC) Last server move date of the company.
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.
SEQ_NR int32 Sequence Unique sequence number of the tag for the partition.
TAG_CODE varchar2(240) Code Unique code of the partition tag.
TAG_CREATION_DATE datetime Creation Date Date at which the entry was originally created.
TAG_CREATOR varchar2(240) Creator Person that first assigned a value.
TAG_DOMAIN_CODE varchar2(240) Domain Code Domain of the code of the partition tag.
TAG_TYPE varchar2(240) Value Type Type of value of the partition tag.
TAG_UPDATER varchar2(240) Updater Person that last assigned a value.
TAG_UPDATE_DATE datetime Update Date Date at which the entry was last modified.
TAG_VALUE varchar2(240) Value Value of the partition tag.

Keys

Key Column Refers to Kind Description
SYSTEMPARTITIONTAGS_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: