invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMDOMAINCODEVALUES: Data Dictionary Domain Values

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Domain Values

Domain codes and their values.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMDOMAINCODEVALUES 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
CODE varchar2 Code Code value.
DESCRIPTION varchar2(4000) Description Description of value.
DOMAIN_CODE varchar2 Domain 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.
RESOURCE_CODE varchar2(240) Resource Code fetched only when named Resource code for internationalization.

Keys

Key Column Refers to Kind Description
SYSTEMDOMAINCODEVALUES_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMDOMAINCODEVALUES_PROVIDER_INSTANCE_UID_SYSTEMDOMAINCODES_fk PROVIDER_INSTANCE_UID SYSTEMDOMAINCODES.PROVIDER_INSTANCE_UID Key
SYSTEMDOMAINCODEVALUES_PROVIDER_INSTANCE_UID_SYSTEMDOMAINCODES_fk DOMAIN_CODE SYSTEMDOMAINCODES.CODE Key

Release Notes

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