Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

SYSTEMDOMAINCODES: Data Dictionary Code/value Domains

 Contents Previous Home Next More

Domain maps of code/values.

Catalog: DataDictionary

Schema: Invantive

Alias: dmn

Label: Code/value Domains

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

View Columns

The columns of the view SYSTEMDOMAINCODES are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CATALOG_NAME

string

 

 

Catalog where the tables are contained in.

CODE

string

Code

 

Code of the domain.

ID

int32

ID

 

Unique ID of the code domain.

PROVIDER_DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

☐

Data container alias.

PROVIDER_DATA_CONTAINER_ID

string(4000)

Data Container ID

☐

Data container ID.

PROVIDER_DESCRIPTION

string(16000)

Provider Description

☑

Provider description.

PROVIDER_NAME

string(240)

Provider Name

☑

Name of the provider.

PROVIDER_SHORT_NAME

string(240)

Provider Short Name

☑

Provider short name.

SCHEMA_NAME

string

Schema

 

Schema within the catalog where the table is contained in.

TABLE_DESCRIPTION

string

Table Description

 

Description of the contents.

TABLE_EXAMPLE

string

Table Example

 

Example of the contents.

TABLE_LABEL_PLURAL

string

Table Label Plural

 

Label of the table contents in plural form.

TABLE_NAME

string

Table Name

 

Name of the table or view.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191