invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPROVIDERSAMPLEQUERIES: Data Dictionary Provider Sample Queries

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Provider Sample Queries

Sample queries per registered and licensed provider.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPROVIDERSAMPLEQUERIES 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_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_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_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.
SQL_STATEMENT varchar2 Sample SQL Statement Sample SQL statement.

Keys

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