invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPROVIDERATTRIBUTES: Data Dictionary System Provider Attributes

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: System Provider Attributes

Attributes per registered and licensed provider.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPROVIDERATTRIBUTES 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
ALLOWED_VALUES varchar2(4000) Allowed Values Values the attribute accepts, separated by a comma, when it accepts a fixed set of them.
ALLOW_DISPLAY char Allow Display Whether to allow displaying the value.
ALLOW_SET_FROM_CONNECTION_STRING char Allow Set from Connecton String Whether to allow setting the value from connection string.
ALLOW_SET_FROM_LOG_ON char Allow Set from Log On Whether to allow setting the value from log on window.
ALLOW_SET_FROM_PROVIDER_FILE char Allow Set from Provider File Whether to allow setting the value from provider file.
ALLOW_SET_FROM_SET_STATEMENT char Allow Set from Set Statement Whether to allow setting the value from set SQL statement.
CATEGORY varchar2(4000) Category Category of the attribute.
CODE varchar2(240) Code Code of the attribute.
DEFAULT_VALUE varchar2(4000) Default Value Default value of the property.
DEFINING_TYPE_ASSEMBLY_QUALIFIED_NAME varchar2(240) Defining Type Assembly Qualified Name Assembly qualified name of the defining type.
DEFINING_TYPE_NAME varchar2(240) Defining Type Name Name of the defining type.
DEFINING_TYPE_NAMESPACE varchar2(240) Defining Type Namespace Namespace of the defining type.
DEFINING_TYPE_PROVIDER_DESCRIPTION varchar2(4000) Defining Type Provider Description Description of the provider for the defining type.
DEFINING_TYPE_PROVIDER_DISPLAY_NAME varchar2(240) Defining Type Provider Display Name Display name of the provider for the defining type.
DEFINING_TYPE_PROVIDER_NAME varchar2(240) Defining Type Provider Name Name of the provider for the defining type.
DESCRIPTION varchar2(4000) Description Description of the attribute.
DISPLAY_ORDER int32 Display Order Display order.
EXPLANATION varchar2(4000) Explanation Explanation of the attribute.
HAS_GETTER char Has Getter Whether the attribute has a get method.
HAS_SETTER char Has Setter Whether the attribute has a set method.
OBSOLETED char Obsoleted Whether the attribute is obsoleted.
ORIGIN varchar2(4000) Origin Origin of the current value of the property.
PROVIDER_COMMUNITY_EDITION char Is Community Edition Is application software offered for free?
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_DOCUMENTATION varchar2(32767) Provider Documentation Documentation of the provider.
PROVIDER_DOCUMENTATION_URL varchar2(4000) Documentation (URL) Documentation URL.
PROVIDER_DOWNLOAD_IMPLEMENTATION_URL varchar2(4000) Download Implementation URL Download URL for implementation.
PROVIDER_FUNCTIONAL_DOCUMENTATION_URL varchar2(4000) Functional Documentation URL Functional documentation URL.
PROVIDER_FUNCTIONAL_SUPPORT_DISCORD_COMMUNITY varchar2(60) Functional Support Discord Community Functional support discourse community.
PROVIDER_FUNCTIONAL_SUPPORT_EMAIL_ADDRESS varchar2(60) Functional Support Email Address Functional support email address.
PROVIDER_FUNCTIONAL_SUPPORT_PHONE_NUMBER varchar2(60) Functional Support Phone Number Functional support phone number.
PROVIDER_FUNCTIONAL_SUPPORT_URL varchar2(240) Functional Support URL Functional support URL.
PROVIDER_INFLUENCES_MAXIMUM_NUMBER_JOINS char Influences Maximum Number of Joins Influences maximum number of joins?
PROVIDER_IS_DEFAULT_FLAG char Is Default? Is the default provider?
PROVIDER_IS_SERVICE_PROVIDER_FLAG char Is Service Provider? Is the provider a service provider?
PROVIDER_MARKETPLACE_URL varchar2(4000) Marketplace URL URL of the marketplace containing integrations and add-ons.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_PRODUCTION_USE_ALLOWED char Production Use Allowed Is production use allowed?
PROVIDER_PUBLIC_DATA char Is Public Data? Is the data offered publicly?
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
PROVIDER_TECHNICAL_DOCUMENTATION_URL varchar2(4000) Technical Documentation (URL) Technical documentation URL.
PROVIDER_TECHNICAL_SUPPORT_DISCORD_COMMUNITY varchar2(60) Technical Support Discord Community Technical support discourse community.
PROVIDER_TECHNICAL_SUPPORT_EMAIL_ADDRESS varchar2(60) Technical Support Email Address Technical support email address.
PROVIDER_TECHNICAL_SUPPORT_PHONE_NUMBER varchar2(60) Technical Support Phone Number Technical support phone number.
PROVIDER_TECHNICAL_SUPPORT_URL varchar2(240) Technical Support URL Technical support URL.
PROVIDER_UID guid Provider UID Unique ID of the provider.
REQUIRED char Required Whether a connection can not be made without a value for the attribute.
VALUE varchar2(4000) Value Current value of the property.
VALUE_KIND varchar2(50) Value Kind Kind of value the attribute holds, such as a directory, a list of directories or free text.
VALUE_REVEALS_OS_PROPERTIES char Value Reveals OS-properties Whether the attribute reveals OS-properties.

Keys

Key Column Refers to Kind Description
SYSTEMPROVIDERATTRIBUTES_PROVIDER_NAME_SYSTEMPROVIDERS_fk PROVIDER_NAME SYSTEMPROVIDERS.NAME Key

Release Notes

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