Data Dictionary Data Model

CLIENT_SIDE_CACHEABLE

boolean

Table Client-Side Cacheable

Are the contents eligible for caching on the client?

DATA_CONTAINER_ALIAS

string(240)

Data Container Alias

☐

Alias of the data container.

DATABASE_DATA_TYPE

string

Database Data Type

Data type in the database.

DOCUMENTATION

string

Documentation

Documentation.

DOTNET_DATA_TYPE

string

.NET Data Type

Data type for .NET.

GET_VALUE

string

Get Value

☐

Function used for post-processing.

ID

int32

ID

Unique ID of the column.

IS_NEW

boolean

Is New

Is the field new.

LABEL_SINGULAR

string

Label Singular

Human-readable label in singular form.

MAX_LENGTH

int64

Maximum Length

Maximum length.

NAME

string

Name

Name of the column.

NULLABLE

boolean

Nullable

Whether the value is optional.

POST_PROCESS_GET_VALUE

string

Post-process Get Value

☐

Whether the value is completed by Invantive after processing.

PRECISION

int64

Precision

Precision.

SCALE

int64

Scale

Scale.

SERVICE_URL

string

URL

URL being accessed

TABLE_CALL_SAFE_NAME

string

Table Call Safe Name

Name for use within SQL with special characters escaped.

TABLE_CAN_DELETE

boolean

Table Can Delete

Indicator whether you can delete data in this table.

TABLE_CAN_INSERT

boolean

Table Can Insert

Indicator whether you can insert data in this table.

TABLE_CAN_SELECT

boolean

Table Can Select

Indicator whether you can select data in this table.

TABLE_CAN_UPDATE

boolean

Table Can Update

Indicator whether you can update data in this table.

TABLE_CATALOG_NAME

string

Table Catalog

Catalog where the tables are contained in.

TABLE_CREATION_DATE_UTC

datetime

Table Creation Date

Date at which the table was originally created (UTC).

TABLE_DESCRIPTION

string

Table Description

Description of the contents.

TABLE_DOCUMENTATION

string

Table Documentation

Documentation of the table or view.

TABLE_ESTIMATED_NUMBER_OF_ROWS

int64

Table Estimated Number of Rows

Estimated number of rows in this table per partition

TABLE_ESTIMATED_SIZE_BYTES

int64

Table Estimated Size in Bytes

Estimated size in bytes of this table per partition.

TABLE_EXAMPLE

string

Table Example

Example of the contents.

TABLE_IS_NEW

boolean

Table is New

Is the table new.

TABLE_IS_PARTITION_SPECIFIC

boolean

Table Is Partition Specific

Indicator whether the contents of this table typically differ per partition.

TABLE_LABEL_LIST

string

Table Label for List

Label of the table for use in lists.

TABLE_LABEL_PLURAL

string

Table Label Plural

Label of the table contents in plural form.

TABLE_LABEL_SINGULAR

string

Table Label Singular

Label of the table contents in singular form.

TABLE_LAST_UPDATE_DATE_UTC

datetime

Table Last Update Date

Date at which the table's structure was last modified (UTC).

TABLE_NAME

string

Table Name

Name of the table or view.

TABLE_PRIMARY_KEY_FIELD

string

Table Primary key

The primary key field of the table.

TABLE_SCHEMA_NAME

string

Table Schema

Schema within the catalog where the table is contained in.

TABLE_SHORT_NAME

string

Table Short Name

Typical alias for the table.

TABLE_TYPE

string

Table Type

Type, can be either 'view' or 'table'.

TABLE_VALID

boolean

Table Valid

Whether the structure of the table is valid.