invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS: Data Dictionary Filter to Table Function Parameters

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Filter to Table Function Parameters

Mapping from filters to table function parameters.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS 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
ADDITIONAL_INFORMATION varchar2 Additional Information Additional information from specific types of translation functions.
DOCUMENTATION varchar2 Documentation Documentation.
FROM_PARAMETER_NAME varchar2 From Parameter Name From parameter name.
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.
SOURCE_COLUMN_NAME varchar2 Source Column Name Source column name.
TO_PARAMETER_NAME varchar2 To Parameter Name To parameter name.

Keys

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