---
title: "PROVIDERSYSTEMTABLES (In-Memory)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/inmemorystorage/PROVIDERSYSTEMTABLES
original: https://documentation.invantive.eu/en/datamodels/inmemorystorage/PROVIDERSYSTEMTABLES
updated: 2026-11-01T16:14:50Z
license: https://documentation.invantive.eu/en/
---

# PROVIDERSYSTEMTABLES: In-Memory

`insert` `update` `delete`

- Catalog: ``
- Primary Keys: `rowid$`

Can retrieve data and change data using `insert`, `update` and `delete`.

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Estimated rows | 0 |
| Estimated size (bytes) | 5,756 |

## Table Columns

The columns of the table `PROVIDERSYSTEMTABLES` 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 |
|---|---|---|:---:|---|---|
| `CACHE_RESULT` | `char` | Cache Result | [ ] |  | Whether the result of the execution can be cached for the lifetime of the statement. |
| `CAN_DELETE` | `char` | Can Delete | [ ] |  | Indicator whether you can delete data in this table. |
| `CAN_INSERT` | `char` | Can Insert | [ ] |  | Indicator whether you can insert data in this table. |
| `CAN_SELECT` | `char` | Can Select | [ ] |  | Indicator whether you can select data in this table. |
| `CAN_UPDATE` | `char` | Can Update | [ ] |  | Indicator whether you can update data in this table. |
| `CATALOG` | `varchar2` | Catalog | [ ] |  | Catalog where the tables are contained in. |
| `CLIENT_SIDE_CACHEABLE` | `char` | Client-Side Cacheable | [ ] |  | Are the contents eligible for caching on the client? |
| `DESCRIPTION` | `varchar2` | Description | [ ] |  | Description of the contents. |
| `DOCUMENTATION` | `varchar2` | Documentation | [ ] |  | Documentation. |
| `EDI_CLASS_NAME` | `varchar2(240)` | EDI Class Name | [ ] |  | EDI: master class name. |
| `EDI_PATH_FROM_MASTER` | `varchar2(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` | `varchar2` | Example | [ ] |  | Example of the contents. |
| `FULL_QUALIFIED_NAME` | `varchar2` | Full Qualified Name | [ ] |  | Fully qualified name. |
| `IS_PARTITION_SPECIFIC` | `char` | Is Partition Specific | [ ] |  | Indicator whether the contents of this table typically differ per partition. |
| `LABEL_PLURAL` | `varchar2` | Label Plural | [ ] |  | Label of the table contents in plural form. |
| `LABEL_SINGULAR` | `varchar2` | Label Singular | [ ] |  | Label of the table contents in singular form. |
| `NAME` | `varchar2` | Name | [ ] |  | Name of the table or view. |
| `ODATA_BASE_PATH` | `varchar2(240)` | OData Base Path | [ ] |  | OData: base path. |
| `ODATA_FIELD_SELECTION_METHOD` | `varchar2(240)` | OData Field Selection Method | [ ] |  | OData: field selection method. |
| `ODATA_METADATA_URL` | `varchar2(4000)` | OData Metadata URL | [ ] |  | OData: URL for retrieving metadata. |
| `ODATA_SERVER_SIDE_FILTERS` | `varchar2` | OData Server-side Filters | [ ] |  | OData: text representation of server-side filters. |
| `ODATA_SERVICE_URL_FOR_DELETE` | `varchar2(4000)` | OData Service URL for Delete | [ ] |  | OData: service URL for deleting data. |
| `ODATA_SERVICE_URL_FOR_INSERT` | `varchar2(4000)` | OData Service URL for Insert | [ ] |  | OData: service URL for inserting data. |
| `ODATA_SERVICE_URL_FOR_SELECT` | `varchar2(4000)` | OData Service URL for Select | [ ] |  | OData: service URL for retrieving data. |
| `ODATA_SERVICE_URL_FOR_UPDATE` | `varchar2(4000)` | OData Service URL for Update | [ ] |  | OData: service URL for updating data. |
| `PRIMARY_KEY_FIELD` | `varchar2(4000)` | Primary Key Columns | [ ] |  | Primary key column(s) of the table. |
| `PROVIDER_DATA_CONTAINER_ALIAS` | `varchar2(4000)` | Data Container Alias | [ ] |  | Data container alias. |
| `RUN_ID` | `guid` |  | [x] | `run_id` |  |
| `SCHEMA` | `varchar2` | Schema | [ ] |  | Schema within the catalog where the table is contained in. |
| `SHORT_NAME` | `varchar2` | Short Name | [ ] |  | Typical alias for the table. |
| `SOAP_ACTION` | `varchar2(240)` | SOAP Action | [ ] |  | SOAP: action. |
| `STATIC_AVERAGE_ACCESS_LATENCY_MS` | `double` | 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` | `varchar2(240)` | Swagger Delete Operation | [ ] |  | SWAGGER: delete operation. |
| `SWAGGER_INSERT_OPERATION` | `varchar2(240)` | Swagger Insert Operation | [ ] |  | SWAGGER: insert operation. |
| `SWAGGER_SELECT_OPERATION` | `varchar2(240)` | Swagger Select Operation | [ ] |  | SWAGGER: select operation. |
| `SWAGGER_UPDATE_OPERATION` | `varchar2(240)` | Swagger Update Operation | [ ] |  | SWAGGER: update operation. |
| `TABLE_PARAMETERS` | `varchar2(4000)` | Parameters | [ ] |  | Parameters defined on the table. |
| `TECHNICAL_DOCUMENTATION` | `varchar2` | Technical Documentation | [ ] |  | Technical documentation. |
| `TYPE` | `varchar2` | Type | [ ] |  | Type, can be either 'view' or 'table'. |
| `WEBHOOK_KEY_FIELD` | `varchar2(4000)` | Webhook Key Column | [ ] |  | Key column on webhook messages. |
| `WEBHOOK_TOPIC` | `varchar2(4000)` | Topic | [ ] |  | Webhook topic. |
| `XML_BASE_XPATH` | `varchar2(240)` | Base XPath | [ ] |  | XML: XPath expression which forms the root containing all rows. |
| `XML_DEFAULT_NAMESPACE_PREFIX` | `varchar2(240)` | Default Namespace Prefix | [ ] |  | XML: default namespace prefix. |
| `XML_NAMED_COMPLEX_TYPE` | `varchar2(240)` | Named Complex Type | [ ] |  | XML: name of the complex type. |
| `XML_SERVER_SIDE_FILTERS` | `varchar2` | Server-side Filters | [ ] |  | XML: text representation of server-side filters. |
| `XML_SERVICE_URL` | `varchar2(240)` | Service URL | [ ] |  | XML: Service URL. |
| `XML_TOPIC` | `varchar2(240)` | Topic | [ ] |  | XML: topic or action as known on the remote server. Defaults to Name when not set. |
| `XML_XPATH` | `varchar2(240)` | XPath | [ ] |  | XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath. |
| `domain_code` | `varchar2` | Domain Code | [ ] | `domain_code` | Code of the domain. |
| `rowid$` | `number` | Row ID | [x] | computed | Artificial primary key of an in-memory table. |



## Release Notes

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

- [In-Memory Storage](/en/release-notes/drivers?driver=in-memory-storage)

