PROVIDERSYSTEMTABLES

# PROVIDERSYSTEMTABLES - Primary Keys: `rowid

Can retrieve data and change data using insert, update and delete. ## 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 | 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` | | ☑ | | | `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 | ☐ | Code of the domain. | | `rowid