SYSTEMTABLES: Data Dictionary Tables

CACHE_RESULT

boolean

Cache Result

☐

Whether the result of the execution can be cached for the lifetime of the statement.

CALL_SAFE_NAME

string

Call Safe Name

Name for use within SQL with special characters escaped.

CAN_DELETE

boolean

Can Delete

Indicator whether you can delete data in this table.

CAN_INSERT

boolean

Can Insert

Indicator whether you can insert data in this table.

CAN_SELECT

boolean

Can Select

Indicator whether you can select data in this table.

CAN_UPDATE

boolean

Can Update

Indicator whether you can update data in this table.

CATALOG

string

Catalog

Catalog where the tables are contained in.

CLIENT_SIDE_CACHEABLE

boolean

Client-Side Cacheable

Are the contents eligible for caching on the client?

CREATION_DATE_UTC

datetime

Creation Date

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

DESCRIPTION

string

Description

Description of the contents.

DOCUMENTATION

string

Documentation

Documentation.

EDI_CLASS_NAME

string(240)

EDI Class Name

☐

EDI: master class name.

EDI_PATH_FROM_MASTER

string(240)

EDI Path from Master

☐

EDI: path from the master instance.

ESTIMATED_NUMBER_OF_ROWS

int64

Estimated Number of Rows

Estimated number of rows in this table per partition.

ESTIMATED_SIZE_BYTES

int64

Estimated Size in Bytes

Estimated size in bytes of this table per partition.

EXAMPLE

string

Example

Example of the contents.

FULL_QUALIFIED_NAME

string

Full Qualified Name

Fully qualified name.

FULL_SCAN_ROWS

int32

Full Scan (rows)

Number of full scans row processed.

FULL_SCANS_ELAPSED_TIME_MS

int32

Full Scans Elapsed Time (ms)

Time elapsed during full scans (ms).

FULL_SCANS_EXECUTED

int32

Full Scans Executed

Number of full scans executed.

ID

int32

ID

Unique ID of the table.

IS_PARTITION_SPECIFIC

boolean

Is Partition Specific

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

LABEL_LIST_I18N

string

Translated Label List

Translated label of the table for use in lists.

LABEL_LIST

string

Label for List

Label of the table for use in lists.

LABEL_PLURAL_I18N

string

Translated Label Plural

Label of the table contents in plural form.

LABEL_PLURAL

string

Label Plural

Label of the table contents in plural form.

LABEL_SINGULAR_I18N

string

Translated Label Singular

Translated label of the table contents in singular form.

LABEL_SINGULAR

string

Label Singular

Label of the table contents in singular form.

LAST_UPDATE_DATE_UTC

datetime

Last Update Date

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

MEASURED_AVERAGE_ACCESS_LATENCY_MS

int32

Measured Average Access Latency (ms)

Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.

MEASURED_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE

int32

Measured Average Number Full Scan Row per Minute

Measured average number of rows that fetched per minute on a full table scan.

MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE

int32

Measured Average Number Point Query Rows per Minute

Measured average number of rows processed per minute on point queries.

MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE

int32

Measured Average Number Rows Written per Minute

Measured average number of rows written per minute.

NAME

string

Name

Name of the table or view.

ODATA_BASE_PATH

string(240)

OData Base Path

☐

OData: base path.

ODATA_FIELD_SELECTION_METHOD

string(240)

OData Field Selection Method

☐

OData: field selection method.

ODATA_METADATA_URL

string(4000)

OData Metadata URL

☐

OData: URL for retrieving metadata.

ODATA_SERVER_SIDE_FILTERS

string

OData Server-side Filters

☐

OData: text representation of server-side filters.

ODATA_SERVICE_URL_FOR_DELETE

string(4000)

OData Service URL for Delete

☐

OData: service URL for deleting data.

ODATA_SERVICE_URL_FOR_INSERT

string(4000)

OData Service URL for Insert

☐

OData: service URL for inserting data.

ODATA_SERVICE_URL_FOR_SELECT

string(4000)

OData Service URL for Select

☐

OData: service URL for retrieving data.

ODATA_SERVICE_URL_FOR_UPDATE

string(4000)

OData Service URL for Update

☐

OData: service URL for updating data.

POINT_QUERIES_ELAPSED_TIME_MS

int32

Time Spent in Point Queries (ms)

Time elapsed during point queries (ms).

POINT_QUERIES_EXECUTED

int32

Rows through Point Queries

Number of point queries executed.

PRIMARY_KEY_FIELD

string(4000)

Primary Key Columns

Primary key column(s) of the table.

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_INSTANCE_UID

guid

Provider Instance UID

☑

Unique ID of the provider instance.

PROVIDER_NAME

string(240)

Provider Name

☑

Name of the provider.

PROVIDER_SHORT_NAME

string(240)

Provider Short Name

☑

Provider short name.

SCHEMA

string

Schema

Schema within the catalog where the table is contained in.

SHORT_NAME

string

Short Name

Typical alias for the table.

SOAP_ACTION

string(240)

SOAP Action

☐

SOAP: action.

STATIC_AVERAGE_ACCESS_LATENCY_MS

int32

Static Average Access Latency (ms)

Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.

STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE

int32

Static Average Rows per Minute on Full Scan

Average number of rows that fetched per minute on a full table scan, statically configured.

STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE

int32

Static Average Rows per Minute on Point Query

Average number of rows processed per minute on point queries, statically configured.

STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE

int32

Static Average Rows per Minute Written

Average number of rows written per minute, statically configured.

SWAGGER_DELETE_OPERATION

string(240)

Swagger Delete Operation

☐

SWAGGER: delete operation.

SWAGGER_INSERT_OPERATION

string(240)

Swagger Insert Operation

☐

SWAGGER: insert operation.

SWAGGER_SELECT_OPERATION

string(240)

Swagger Select Operation

☐

SWAGGER: select operation.

SWAGGER_UPDATE_OPERATION

string(240)

Swagger Update Operation

☐

SWAGGER: update operation.

TABLE_PARAMETERS

string(4000)

Parameters

Parameters defined on the table.

TYPE

string

Type

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

VALID

boolean

Valid

Whether the structure of the table is valid.

WEBHOOK_KEY_FIELD

string(4000)

Webhook Key Column

☐

Key column on webhook messages.

WEBHOOK_TOPIC

string(4000)

Topic

☐

Webhook topic.

WRITE_ELAPSED_TIME_MS

int32

Elapsed Write Time (ms)

Time elapsed during point queries (ms).

WRITES_EXECUTED

int32

Writes Executed

Number of writes executed.

WRITTEN_ROWS

int32

Rows Written

Number of rows written.

XML_BASE_XPATH

string(240)

Base XPath

☐

XML: XPath expression which forms the root containing all rows.

XML_DEFAULT_NAMESPACE_PREFIX

string(240)

Default Namespace Prefix

☐

XML: default namespace prefix.

XML_NAMED_COMPLEX_TYPE

string(240)

Named Complex Type

☐

XML: name of the complex type.

XML_SERVER_SIDE_FILTERS

string

Server-side Filters

☐

XML: text representation of server-side filters.

XML_SERVICE_URL

string(240)

Service URL

☐

XML: Service URL.

XML_TOPIC

string(240)

Topic

☐

XML: topic or action as known on the remote server. Defaults to Name when not set.

XML_XPATH

string(240)

XPath

☐

XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath.