# SYSTEMMANAGEDFILES: Data Dictionary Managed Files Managed files. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `mfe` - Label: Managed Files This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMMANAGEDFILES` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CREATE_ACTION` | `varchar2`(30) | Action | ☑ | Action. | | `CREATE_BILLING_ID` | `varchar2` | Billing ID | ☐ | ID for billing. | | `CREATE_CALL_SAFE_NAME_OVERRULE` | `varchar2` | Call Safe Name Overrule | ☐ | Overruled name of the table. | | `CREATE_CALLING_PROVIDER_ALIAS` | `varchar2`(240) | Calling Provider Alias | ☐ | Calling provider alias. | | `CREATE_CATALOG_NAME` | `varchar2` | Catalog Name | ☐ | Name of the catalog. | | `CREATE_DATA_CONTAINER_ID` | `varchar2`(4000) | Data Container ID | ☐ | Data container ID. | | `CREATE_DATE_DO_NOT_REMOVE_BEFORE` | `datetime` | Do Not Remove Before | ☐ | Time before which not to remove. | | `CREATE_DATE_REGISTERED` | `datetime` | Registered | ☑ | Time of registration. | | `CREATE_EXCEPTION_CODE` | `varchar2` | Exception Code | ☐ | Exception code. | | `CREATE_EXCEPTION_TEXT` | `varchar2` | Text | ☐ | Exception text. | | `CREATE_EXECUTION_STEP_ID` | `int64` | SQL Execution Step ID | | ID of the SQL execution step. | | `CREATE_GUI_ACTION` | `varchar2`(240) | GUI Action | ☐ | Action performed within the user interface. | | `CREATE_GUI_IP_ADDRESS_EXTERNAL` | `varchar2`(240) | GUI External IP Address | ☐ | External IP address of the GUI application. | | `CREATE_GUI_IP_PORT` | `uint16` | GUI External IP Port | ☐ | External IP port of the GUI application. | | `CREATE_GUI_MACHINE` | `varchar2`(240) | GUI Machine | ☐ | Name of the machine running the GUI application. | | `CREATE_GUI_MODULE_NAME` | `varchar2`(240) | GUI Module Name | ☐ | Module within the GUI application currently running. | | `CREATE_GUI_MODULE_VERSION` | `varchar2`(240) | GUI Module Version | ☐ | Version of module within the GUI application currently running. | | `CREATE_GUI_OS_USER` | `varchar2`(240) | GUI OS User | ☐ | OS user. | | `CREATE_GUI_USER` | `varchar2`(240) | User | ☐ | Application user. | | `CREATE_LIFE_CYCLE_TYPE` | `varchar2`(30) | Life Cycle Type | ☑ | Life cycle type. | | `CREATE_MESSAGE_CODE` | `varchar2`(30) | Type | ☑ | Type. | | `CREATE_PARTITION` | `varchar2` | Partition | ☐ | Specific partition on which the I/O was executed. | | `CREATE_POOL_IDENTITY` | `varchar2`(60) | Pool Identity | ☐ | Pool identity. | | `CREATE_PROCESS_ID` | `uint32` | Process ID | ☐ | Process ID. | | `CREATE_PROVIDER_NAME` | `varchar2`(240) | Provider Name | ☐ | Name of the provider. | | `CREATE_REQUEST_ID` | `varchar2`(240) | Request ID | ☐ | Request ID. | | `CREATE_SCHEMA_NAME` | `varchar2` | Schema | ☐ | Name of the schema. | | `CREATE_SESSION_ID` | `varchar2`(240) | Session ID | ☐ | ID of the session. | | `CREATE_SIZE_BYTES` | `int64` | Bytes | ☐ | Size in bytes. | | `CREATE_SIZE_CHARACTERS` | `int64` | Characters | ☐ | Size in characters. | | `CREATE_TABLE_NAME` | `varchar2` | Table Name | ☐ | Name of the table. | | `CREATE_TYPE` | `varchar2`(30) | Type | ☑ | Type. | | `EXISTS_FLAG` | `boolean` | Exists Flag | ☐ | Whether the file exists. | | `FILE_NAME` | `varchar2`(4000) | File Name | ☑ | File name and path. | | `MODIFIED_ACTION` | `varchar2`(30) | Action | ☑ | Action. | | `MODIFIED_BILLING_ID` | `varchar2` | Billing ID | ☐ | ID for billing. | | `MODIFIED_CALL_SAFE_NAME_OVERRULE` | `varchar2` | Call Safe Name Overrule | ☐ | Overruled name of the table. | | `MODIFIED_CALLING_PROVIDER_ALIAS` | `varchar2`(240) | Calling Provider Alias | ☐ | Calling provider alias. | | `MODIFIED_CATALOG_NAME` | `varchar2` | Catalog Name | ☐ | Name of the catalog. | | `MODIFIED_DATA_CONTAINER_ID` | `varchar2`(4000) | Data Container ID | ☐ | Data container ID. | | `MODIFIED_DATE_DO_NOT_REMOVE_BEFORE` | `datetime` | Do Not Remove Before | ☐ | Time before which not to remove. | | `MODIFIED_DATE_REGISTERED` | `datetime` | Registered | ☑ | Time of registration. | | `MODIFIED_EXCEPTION_CODE` | `varchar2` | Exception Code | ☐ | Exception code. | | `MODIFIED_EXCEPTION_TEXT` | `varchar2` | Text | ☐ | Exception text. | | `MODIFIED_EXECUTION_STEP_ID` | `int64` | SQL Execution Step ID | | ID of the SQL execution step. | | `MODIFIED_GUI_ACTION` | `varchar2`(240) | GUI Action | ☐ | Action performed within the user interface. | | `MODIFIED_GUI_IP_ADDRESS_EXTERNAL` | `varchar2`(240) | GUI External IP Address | ☐ | External IP address of the GUI application. | | `MODIFIED_GUI_IP_PORT` | `uint16` | GUI External IP Port | ☐ | External IP port of the GUI application. | | `MODIFIED_GUI_MACHINE` | `varchar2`(240) | GUI Machine | ☐ | Name of the machine running the GUI application. | | `MODIFIED_GUI_MODULE_NAME` | `varchar2`(240) | GUI Module Name | ☐ | Module within the GUI application currently running. | | `MODIFIED_GUI_MODULE_VERSION` | `varchar2`(240) | GUI Module Version | ☐ | Version of module within the GUI application currently running. | | `MODIFIED_GUI_OS_USER` | `varchar2`(240) | GUI OS User | ☐ | OS user. | | `MODIFIED_GUI_USER` | `varchar2`(240) | User | ☐ | Application user. | | `MODIFIED_LIFE_CYCLE_TYPE` | `varchar2`(30) | Life Cycle Type | ☑ | Life cycle type. | | `MODIFIED_MESSAGE_CODE` | `varchar2`(30) | Type | ☑ | Type. | | `MODIFIED_PARTITION` | `varchar2` | Partition | ☐ | Specific partition on which the I/O was executed. | | `MODIFIED_POOL_IDENTITY` | `varchar2`(60) | Pool Identity | ☐ | Pool identity. | | `MODIFIED_PROCESS_ID` | `uint32` | Process ID | ☐ | Process ID. | | `MODIFIED_PROVIDER_NAME` | `varchar2`(240) | Provider Name | ☐ | Name of the provider. | | `MODIFIED_REQUEST_ID` | `varchar2`(240) | Request ID | ☐ | Request ID. | | `MODIFIED_SCHEMA_NAME` | `varchar2` | Schema | ☐ | Name of the schema. | | `MODIFIED_SESSION_ID` | `varchar2`(240) | Session ID | ☐ | ID of the session. | | `MODIFIED_SIZE_BYTES` | `int64` | Bytes | ☐ | Size in bytes. | | `MODIFIED_SIZE_CHARACTERS` | `int64` | Characters | ☐ | Size in characters. | | `MODIFIED_TABLE_NAME` | `varchar2` | Table Name | ☐ | Name of the table. | | `MODIFIED_TYPE` | `varchar2`(30) | Type | ☑ | Type. | | `NUMBER_OF_ACTIONS` | `int32` | Number of Actions | ☑ | Number of actions. | | `NUMBER_OF_DELETES` | `int32` | Number of Deletes | ☑ | Number of deletes. | | `NUMBER_OF_READS` | `int32` | Number of Reads | ☑ | Number of reads. | | `NUMBER_OF_WRITES` | `int32` | Number of Writes | ☑ | Number of writes. | | `TOTAL_DELETE_BYTES` | `int64` | Total Delete Bytes | ☑ | Total bytes deleted. | | `TOTAL_DELETE_CHARACTERS` | `int64` | Total Delete Characters | ☑ | Total characters deleted. | | `TOTAL_READ_BYTES` | `int64` | Total Read Bytes | ☑ | Total bytes read. | | `TOTAL_READ_CHARACTERS` | `int64` | Total Read Characters | ☐ | Total characters read. | | `TOTAL_WRITE_BYTES` | `int64` | Total Write Bytes | ☑ | Total bytes written. | | `TOTAL_WRITE_CHARACTERS` | `int64` | Total Write Characters | ☐ | Total characters written. | | `UID` | `guid` | UID | ☑ | Unique ID. |