---
title: "SYSTEMTABLECOLUMNS (Data Dictionary)"
description: "Table Columns"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLECOLUMNS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLECOLUMNS
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Label: Table Columns

Columns per table.

Can only retrieve data.

## Table Columns

The columns of the table `SYSTEMTABLECOLUMNS` 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 |
|---|---|---|:---:|---|---|
| `CAN_FILTER_SERVER_SIDE` | `char` | Can Filter Server-side | [x] |  | Whether the column can be filtered on server-side. |
| `CAN_FILTER_SERVER_SIDE_ADJACENT_TERMS` | `char` | Can Filter Server-side Adjacent Terms | [ ] |  | Whether the column can be filtered on server-side using adjacent search terms. |
| `CAN_FILTER_SERVER_SIDE_ALL_TERMS` | `char` | Can Filter Server-side All Terms | [ ] |  | Whether the column can be filtered on server-side using all search terms. |
| `CAN_FILTER_SERVER_SIDE_ANY_TERM` | `char` | Can Filter Server-side Any Term | [ ] |  | Whether the column can be filtered on server-side using any search term. |
| `CAN_FILTER_SERVER_SIDE_CONTAINS` | `char` | Can Filter Server-side Contains | [ ] |  | Whether the column can be filtered on server-side using contains text. |
| `CAN_FILTER_SERVER_SIDE_EQUALS` | `char` | Can Filter Server-side Equals | [ ] |  | Whether the column can be filtered on server-side using equals. |
| `CAN_FILTER_SERVER_SIDE_GREATER_THAN` | `char` | Can Filter Server-side Greater than | [ ] |  | Whether the column can be filtered on server-side using greater than. |
| `CAN_FILTER_SERVER_SIDE_GREATER_THAN_OR_EQUAL` | `char` | Can Filter Server-side Greater than or Equal | [ ] |  | Whether the column can be filtered on server-side using greater than or equal. |
| `CAN_FILTER_SERVER_SIDE_LESS_THAN` | `char` | Can Filter Server-side Less than | [ ] |  | Whether the column can be filtered on server-side using less than. |
| `CAN_FILTER_SERVER_SIDE_LESS_THAN_OR_EQUAL` | `char` | Can Filter Server-side Less than or Equal | [ ] |  | Whether the column can be filtered on server-side using less than or equal. |
| `CAN_FILTER_SERVER_SIDE_NOT_EQUALS` | `char` | Can Filter Server-side Not Equals | [ ] |  | Whether the column can be filtered on server-side using not equals. |
| `CAN_SCAN_SERVER_SIDE` | `char` | Can Scan Server-side | [ ] |  | Whether the column can be scanned on server-side for search terms. |
| `CAN_SORTER_SERVER_SIDE` | `char` | Can Sort Server-side | [ ] |  | Whether the column can be sorted on server-side. |
| `CHECK_SPELLING` | `char` | Check Spelling | [x] |  | Whether the column's value should preferably be checked for spelling and grammar errors in a user interface. |
| `CLIENT_SIDE_CACHEABLE` | `char` | Table Client-Side Cacheable | [ ] |  | Are the contents eligible for caching on the client? |
| `DATABASE_DATA_TYPE` | `varchar2(240)` | Database Data Type | [ ] |  | Data type in the database. |
| `DERIVED_VALUE` | `char` | Derived Value | [x] |  | Whether the column contains a derived value (calculated using an expression). |
| `DISPLAY_CONTROL` | `varchar2(240)` | Display Control | [ ] |  | Display control for displaying the column's contents. |
| `DISPLAY_IN_FILTER` | `char` | Display in Filter | [x] |  | Whether the column should be included in a search window. |
| `DISPLAY_IN_LOV` | `char` | Display in LOV | [x] |  | Whether the column should be included in a pick list. |
| `DISPLAY_IN_RECORD` | `char` | Display in Record | [x] |  | Whether the column should be included in a single record view. |
| `DISPLAY_IN_RESULTS` | `char` | Display in Results | [x] |  | Whether the column should be included in a multiple records view. |
| `DISPLAY_LENGTH_AVERAGE` | `int32` | Display Length (Average) | [ ] |  | Average length in characters of the contents of the column. |
| `DISPLAY_LENGTH_SD` | `int32` | Display Length (SD) | [ ] |  | Standard deviation in characters of the contents of the column. |
| `DISPLAY_ORDER` | `int32` | Display Order | [ ] |  | Relative position in which the column should be displayed compared to other columns. |
| `DOCUMENTATION` | `varchar2(4000)` | Documentation | [ ] |  | Documentation. |
| `DOTNET_DATA_TYPE` | `varchar2(240)` | .NET Data Type | [ ] |  | Data type for .NET. |
| `EXAMPLE` | `varchar2(4000)` | Example | [ ] |  | Example. |
| `FETCH_BY_DEFAULT` | `char` | Fetch by Default | [x] |  | Whether this field is fetched by default. True if the column is fetched by default, or false if it is being fetched when accessed. |
| `ID` | `int32` | ID | [ ] |  | Unique ID of the column. |
| `INFLUENCES_INSERT` | `char` | Influences Insert | [x] |  | Whether the column's value has an impact on the database's contents. |
| `LABEL_HEADING` | `varchar2(240)` | Label Heading | [ ] |  | Optional heading label to be shown before the column's normal label. |
| `LABEL_PLURAL` | `varchar2(4000)` | Label Plural | [ ] |  | Translatable label in plural. |
| `LABEL_PLURAL_COMPOSED` | `varchar2(4000)` | Label Plural Composed | [ ] |  | Translatable label composed of the prefix and the plural label. |
| `LABEL_PLURAL_POSTFIX` | `varchar2(240)` | Label Plural Postfix | [ ] |  | Translatable label postfix in plural. |
| `LABEL_PLURAL_PREFIX` | `varchar2(240)` | Label Plural Prefix | [ ] |  | Translatable label prefix in plural. |
| `LABEL_SINGULAR` | `varchar2(4000)` | Label Singular | [ ] |  | Human-readable label in singular form. |
| `LABEL_SINGULAR_COMPOSED` | `varchar2(4000)` | Label Singular Composed | [ ] |  | Translatable label composed of the prefix and the singular label. |
| `LABEL_SINGULAR_I18N` | `varchar2(4000)` | Translated Label Singular | [ ] |  | Translated human-readable label in singular form. |
| `LABEL_SINGULAR_POSTFIX` | `varchar2(240)` | Label Singular Postfix | [ ] |  | Translatable label postfix in singular. |
| `LABEL_SINGULAR_PREFIX` | `varchar2(240)` | Label Singular Prefix | [ ] |  | Translatable label prefix in singular. |
| `MAX_LENGTH` | `int32` | Maximum Length | [ ] |  | Maximum length. |
| `MINIMUM_LENGTH` | `int32` | Minimum Length | [x] |  | Minimum required length for a text field. |
| `MINIMUM_LENGTH_PADDING` | `varchar2(240)` | Minimum Length Padding | [x] |  | Which side padding has to be applied if the minimum length is not met. |
| `MOST_UNQUALIFIED_NAME` | `varchar2(240)` | Most Unqualified Name | [x] |  | The most unique name ('users' for 'exactonline.crm.users') |
| `NAME` | `varchar2(240)` | Name | [ ] |  | Name of the column. |
| `NULLABLE` | `char` | Nullable | [ ] |  | Whether the value is optional. |
| `POSITION` | `int32` | Position | [x] |  | Numeric ID of the column. |
| `PRECISION` | `int16` | Precision | [ ] |  | Precision. |
| `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 | [x] |  | Provider description. |
| `PROVIDER_INSTANCE_UID` | `guid` | Provider Instance UID | [x] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2(240)` | Provider Name | [x] |  | Name of the provider. |
| `PROVIDER_SHORT_NAME` | `varchar2(240)` | Provider Short Name | [x] |  | Provider short name. |
| `SCALE` | `int16` | Scale | [ ] |  | Scale. |
| `SOURCE_ADDITIONAL_INFO_1` | `varchar2(4000)` | Source Additional Information 1 | [ ] |  | Additional information, no predefined structure. |
| `SOURCE_ADDITIONAL_INFO_2` | `varchar2(4000)` | Source Additional Information 2 | [ ] |  | Additional information, no predefined structure. |
| `SOURCE_ADDITIONAL_INFO_3` | `varchar2(4000)` | Source Additional Information 3 | [ ] |  | Additional information, no predefined structure. |
| `SOURCE_PATH` | `varchar2(4000)` | Source Path | [ ] |  | Path of the source of the value. |
| `TABLE_CALL_SAFE_NAME` | `varchar2(240)` | Table Call Safe Name | [ ] |  | Name for use within SQL with special characters escaped. |
| `TABLE_CAN_DELETE` | `char` | Table Can Delete | [ ] |  | Indicator whether you can delete data in this table. |
| `TABLE_CAN_INSERT` | `char` | Table Can Insert | [ ] |  | Indicator whether you can insert data in this table. |
| `TABLE_CAN_SELECT` | `char` | Table Can Select | [ ] |  | Indicator whether you can select data in this table. |
| `TABLE_CAN_UPDATE` | `char` | Table Can Update | [ ] |  | Indicator whether you can update data in this table. |
| `TABLE_CATALOG_NAME` | `varchar2(240)` | 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` | `varchar2(4000)` | Table Description | [ ] |  | Description of the contents. |
| `TABLE_DOCUMENTATION` | `varchar2(4000)` | 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` | `varchar2(4000)` | Table Example | [ ] |  | Example of the contents. |
| `TABLE_FULL_QUALIFIED_NAME` | `varchar2(240)` | Table Full Qualified Name | [ ] |  | Full qualified name. |
| `TABLE_FULL_TABLE_SCANS_EXECUTED` | `int32` | Table Number of Full Table Scans Executed | [ ] |  | Total number of full table scans executed. |
| `TABLE_FULL_TABLE_SCAN_ROWS_RETRIEVED` | `int64` | Table Rows Retrieved during Full Table Scans | [ ] |  | Total number of rows retrieved using full table scans. |
| `TABLE_FULL_TABLE_SCAN_ROW_RETRIEVAL_TOTAL_CLOCK_TIME_MS` | `double` | Table Full Table Scan Row Retrieval Total Clock Time (ms) | [ ] |  | Total clock time spent retrieving data using full table scans. |
| `TABLE_IS_PARTITION_SPECIFIC` | `char` | Table Is Partition Specific | [ ] |  | Indicator whether the contents of this table typically differ per partition. |
| `TABLE_LABEL_LIST` | `varchar2(4000)` | Table Label for List | [ ] |  | Label of the table for use in lists. |
| `TABLE_LABEL_PLURAL` | `varchar2(4000)` | Table Label Plural | [ ] |  | Label of the table contents in plural form. |
| `TABLE_LABEL_SINGULAR` | `varchar2(4000)` | 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_MEASURED_AVERAGE_ACCESS_LATENCY_MS` | `double` | Table Measured Average Access Latency (ms) | [ ] |  | Measured Average Access Latency in milliseconds. |
| `TABLE_NAME` | `varchar2(240)` | Table Name | [ ] |  | Name of the table or view. |
| `TABLE_PARAMETERS` | `varchar2(4000)` | Parameters | [ ] |  | Parameters defined on the table. |
| `TABLE_POINT_QUERIES_EXECUTED` | `int32` | Table Number of Point Queries Executed | [ ] |  | Number of point queries executed. |
| `TABLE_POINT_QUERIES_EXECUTED_TOTAL_CLOCK_TIME_MS` | `double` | Table Total Clock Time Spent Executing Point Queries (ms) | [ ] |  | Total clock time spent retrieving data using point queries. |
| `TABLE_PRIMARY_KEY_FIELD` | `varchar2(4000)` | Primary Key Columns | [ ] |  | Primary key column(s) of the table. |
| `TABLE_ROWS_WRITE_TOTAL_CLOCK_TIME_MS` | `double` | Table Total Time Spent Writing Rows (ms) | [ ] |  | Total clock time spent writing rows in milliseconds. |
| `TABLE_ROWS_WRITTEN` | `int64` | Table Number of Rows Written | [ ] |  | Number of rows written. |
| `TABLE_SCHEMA_NAME` | `varchar2(240)` | Table Schema | [ ] |  | Schema within the catalog where the table is contained in. |
| `TABLE_SHORT_NAME` | `varchar2(240)` | Table Short Name | [ ] |  | Typical alias for the table. |
| `TABLE_STATIC_AVERAGE_ACCESS_LATENCY_MS` | `double` | Table Static Average Access Latency (ms) | [ ] |  | Statically determined average access latency in milliseconds. |
| `TABLE_STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE` | `int32` | Table Static Average Rows per Minute on Full Scan | [ ] |  | Statically determined average number of rows accessible per minute. |
| `TABLE_STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE` | `int32` | Table Static Average Rows per Minute on Point Query | [ ] |  | Statically determined average of points queries throughput per minute. |
| `TABLE_STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE` | `int32` | Table Static Average Rows per Minute Written | [ ] |  | Statically determined throughput of written rows per minute. |
| `TABLE_TYPE` | `varchar2(30)` | Table Type | [ ] |  | Type, can be either 'view' or 'table'. |
| `TABLE_VALID` | `char` | Table Valid | [ ] |  | Whether the structure of the table is valid. |
| `TABLE_WRITES_EXECUTED` | `int32` | Table Number of Writes | [ ] |  | Total number of writes executed. |
| `USER_CHANGEABLE` | `char` | User Changeable | [x] |  | Whether the column's value can be changed ever by a human user with sufficient access rights. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMDATACONTAINERS](DataDictionary.Invantive.SYSTEMDATACONTAINERS)`.PROVIDER_INSTANCE_UID` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `PROVIDER_INSTANCE_UID` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.PROVIDER_INSTANCE_UID` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `TABLE_CATALOG_NAME` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.CATALOG` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `TABLE_SCHEMA_NAME` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.SCHEMA` | Key |  |
| `SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk` | `TABLE_NAME` | [SYSTEMTABLES](DataDictionary.Invantive.SYSTEMTABLES)`.NAME` | Key |  |



## Release Notes

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

- [Data Dictionary](/en/release-notes/drivers?driver=data-dictionary)

