SYSTEMMANAGEDFILES: Data Dictionary Managed Files
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Managed Files
Managed files.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMMANAGEDFILES 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 |
|---|---|---|---|---|---|
CREATE_ |
varchar2 |
Action | Action. | ||
CREATE_ |
varchar2 |
Billing ID | ID for billing. | ||
CREATE_ |
varchar2 |
Calling Provider Alias | Calling provider alias. | ||
CREATE_ |
varchar2 |
Call Safe Name Overrule | Overruled name of the table. | ||
CREATE_ |
varchar2 |
Catalog Name | Name of the catalog. | ||
CREATE_ |
varchar2 |
Data Container ID | Data container ID. | ||
CREATE_ |
datetime |
Do Not Remove Before | Time before which not to remove. | ||
CREATE_ |
datetime |
Registered | Time of registration. | ||
CREATE_ |
varchar2 |
Exception Code | Exception code. | ||
CREATE_ |
varchar2 |
Text | Exception text. | ||
CREATE_ |
int64 |
SQL Execution Step ID | ID of the SQL execution step. | ||
CREATE_ |
varchar2 |
GUI Action | Action performed within the user interface. | ||
CREATE_ |
varchar2 |
GUI External IP Address | External IP address of the GUI application. | ||
CREATE_ |
uint16 |
GUI External IP Port | External IP port of the GUI application. | ||
CREATE_ |
varchar2 |
GUI Machine | Name of the machine running the GUI application. | ||
CREATE_ |
varchar2 |
GUI Module Name | Module within the GUI application currently running. | ||
CREATE_ |
varchar2 |
GUI Module Version | Version of module within the GUI application currently running. | ||
CREATE_ |
varchar2 |
GUI OS User | OS user. | ||
CREATE_ |
varchar2 |
User | Application user. | ||
CREATE_ |
varchar2 |
Life Cycle Type | Life cycle type. | ||
CREATE_ |
varchar2 |
Type | Type. | ||
CREATE_ |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
CREATE_ |
varchar2 |
Pool Identity | Pool identity. | ||
CREATE_ |
uint32 |
Process ID | Process ID. | ||
CREATE_ |
varchar2 |
Provider Name | Name of the provider. | ||
CREATE_ |
varchar2 |
Request ID | Request ID. | ||
CREATE_ |
varchar2 |
Schema | Name of the schema. | ||
CREATE_ |
varchar2 |
Session ID | ID of the session. | ||
CREATE_ |
int64 |
Bytes | Size in bytes. | ||
CREATE_ |
int64 |
Characters | Size in characters. | ||
CREATE_ |
varchar2 |
Table Name | Name of the table. | ||
CREATE_ |
varchar2 |
Type | Type. | ||
EXISTS_ |
boolean |
Exists Flag | Whether the file exists. | ||
FILE_ |
varchar2 |
File Name | File name and path. | ||
MODIFIED_ |
varchar2 |
Action | Action. | ||
MODIFIED_ |
varchar2 |
Billing ID | ID for billing. | ||
MODIFIED_ |
varchar2 |
Calling Provider Alias | Calling provider alias. | ||
MODIFIED_ |
varchar2 |
Call Safe Name Overrule | Overruled name of the table. | ||
MODIFIED_ |
varchar2 |
Catalog Name | Name of the catalog. | ||
MODIFIED_ |
varchar2 |
Data Container ID | Data container ID. | ||
MODIFIED_ |
datetime |
Do Not Remove Before | Time before which not to remove. | ||
MODIFIED_ |
datetime |
Registered | Time of registration. | ||
MODIFIED_ |
varchar2 |
Exception Code | Exception code. | ||
MODIFIED_ |
varchar2 |
Text | Exception text. | ||
MODIFIED_ |
int64 |
SQL Execution Step ID | ID of the SQL execution step. | ||
MODIFIED_ |
varchar2 |
GUI Action | Action performed within the user interface. | ||
MODIFIED_ |
varchar2 |
GUI External IP Address | External IP address of the GUI application. | ||
MODIFIED_ |
uint16 |
GUI External IP Port | External IP port of the GUI application. | ||
MODIFIED_ |
varchar2 |
GUI Machine | Name of the machine running the GUI application. | ||
MODIFIED_ |
varchar2 |
GUI Module Name | Module within the GUI application currently running. | ||
MODIFIED_ |
varchar2 |
GUI Module Version | Version of module within the GUI application currently running. | ||
MODIFIED_ |
varchar2 |
GUI OS User | OS user. | ||
MODIFIED_ |
varchar2 |
User | Application user. | ||
MODIFIED_ |
varchar2 |
Life Cycle Type | Life cycle type. | ||
MODIFIED_ |
varchar2 |
Type | Type. | ||
MODIFIED_ |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
MODIFIED_ |
varchar2 |
Pool Identity | Pool identity. | ||
MODIFIED_ |
uint32 |
Process ID | Process ID. | ||
MODIFIED_ |
varchar2 |
Provider Name | Name of the provider. | ||
MODIFIED_ |
varchar2 |
Request ID | Request ID. | ||
MODIFIED_ |
varchar2 |
Schema | Name of the schema. | ||
MODIFIED_ |
varchar2 |
Session ID | ID of the session. | ||
MODIFIED_ |
int64 |
Bytes | Size in bytes. | ||
MODIFIED_ |
int64 |
Characters | Size in characters. | ||
MODIFIED_ |
varchar2 |
Table Name | Name of the table. | ||
MODIFIED_ |
varchar2 |
Type | Type. | ||
NUMBER_ |
int32 |
Number of Actions | Number of actions. | ||
NUMBER_ |
int32 |
Number of Deletes | Number of deletes. | ||
NUMBER_ |
int32 |
Number of Reads | Number of reads. | ||
NUMBER_ |
int32 |
Number of Writes | Number of writes. | ||
TOTAL_ |
int64 |
Total Delete Bytes | Total bytes deleted. | ||
TOTAL_ |
int64 |
Total Delete Characters | Total characters deleted. | ||
TOTAL_ |
int64 |
Total Read Bytes | Total bytes read. | ||
TOTAL_ |
int64 |
Total Read Characters | Total characters read. | ||
TOTAL_ |
int64 |
Total Write Bytes | Total bytes written. | ||
TOTAL_ |
int64 |
Total Write Characters | Total characters written. | ||
UID |
guid |
UID | Unique ID. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: