invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMDOMAINCODES: Data Dictionary Code/value Domains

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Code/value Domains

Domain maps of code/values.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMDOMAINCODES 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
CATALOG_NAME varchar2 Catalog Name Catalog where the tables are contained in.
CODE varchar2 Code Code of the domain.
ID int32 ID Unique ID of the code domain.
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.
SCHEMA_NAME varchar2 Schema Schema within the catalog where the table is contained in.
TABLE_DESCRIPTION varchar2 Table Description Description of the contents.
TABLE_EXAMPLE varchar2 Table Example Example of the contents.
TABLE_LABEL_PLURAL varchar2 Table Label Plural Label of the table contents in plural form.
TABLE_NAME varchar2 Table Name Name of the table or view.

Keys

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

Referenced By

Release Notes

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