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 |
string(30) |
Action |
☑ |
Action. |
CREATE_BILLING_ID |
string |
Billing ID |
☐ |
ID for billing. |
CREATE_CALL_SAFE_NAME_OVERRULE |
string |
|
☐ |
Overruled name of the table. |
CREATE_CALLING_PROVIDER_ALIAS |
string(240) |
|
☐ |
Calling provider alias. |
CREATE_CATALOG_NAME |
string |
Catalog Name |
☐ |
Name of the catalog. |
CREATE_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
CREATE_DATE_DO_NOT_REMOVE_BEFORE |
datetime |
|
☐ |
Time before which not to remove. |
CREATE_DATE_REGISTERED |
datetime |
Registered |
☑ |
Time of registration. |
CREATE_EXCEPTION_CODE |
string |
Exception Code |
☐ |
Exception code. |
CREATE_EXCEPTION_TEXT |
string |
Text |
☐ |
Exception text. |
CREATE_GUI_ACTION |
string(240) |
GUI Action |
☐ |
Action performed within the user interface. |
CREATE_GUI_IP_ADDRESS_EXTERNAL |
string(240) |
GUI External IP Address |
☐ |
External IP address of the GUI application. |
CREATE_GUI_MACHINE |
string(240) |
GUI Machine |
☐ |
Name of the machine running the GUI application. |
CREATE_GUI_MODULE_NAME |
string(240) |
GUI Module Name |
☐ |
Module within the GUI application currently running. |
CREATE_GUI_MODULE_VERSION |
string(240) |
GUI Module Version |
☐ |
Version of module within the GUI application currently running. |
CREATE_GUI_OS_USER |
string(240) |
GUI OS User |
☐ |
OS user. |
CREATE_GUI_USER |
string(240) |
User |
☐ |
Application user. |
CREATE_LIFE_CYCLE_TYPE |
string(30) |
|
☑ |
Life cycle type. |
CREATE_MESSAGE_CODE |
string(30) |
Type |
☑ |
Type. |
CREATE_PARTITION |
string |
Partition |
☐ |
Specific partition on which the I/O was executed. |
CREATE_POOL_IDENTITY |
string(60) |
Pool Identity |
☐ |
Pool identity. |
CREATE_PROCESS_ID |
uint32 |
Process ID |
☐ |
Process ID. |
CREATE_REQUEST_ID |
string(240) |
Request ID |
☐ |
Request ID. |
CREATE_SCHEMA_NAME |
string |
Schema |
☐ |
Name of the schema. |
CREATE_SESSION_ID |
string(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 |
string |
Table Name |
☐ |
Name of the table. |
CREATE_TYPE |
string(30) |
Type |
☑ |
Type. |
EXISTS_FLAG |
boolean |
Exists Flag |
☐ |
Whether the file exists. |
FILE_NAME |
string(4000) |
File Name |
☑ |
File name and path. |
MODIFIED_ACTION |
string(30) |
Action |
☑ |
Action. |
MODIFIED_BILLING_ID |
string |
Billing ID |
☐ |
ID for billing. |
MODIFIED_CALL_SAFE_NAME_OVERRULE |
string |
|
☐ |
Overruled name of the table. |
MODIFIED_CALLING_PROVIDER_ALIAS |
string(240) |
|
☐ |
Calling provider alias. |
MODIFIED_CATALOG_NAME |
string |
Catalog Name |
☐ |
Name of the catalog. |
MODIFIED_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
MODIFIED_DATE_DO_NOT_REMOVE_BEFORE |
datetime |
|
☐ |
Time before which not to remove. |
MODIFIED_DATE_REGISTERED |
datetime |
Registered |
☑ |
Time of registration. |
MODIFIED_EXCEPTION_CODE |
string |
Exception Code |
☐ |
Exception code. |
MODIFIED_EXCEPTION_TEXT |
string |
Text |
☐ |
Exception text. |
MODIFIED_GUI_ACTION |
string(240) |
GUI Action |
☐ |
Action performed within the user interface. |
MODIFIED_GUI_IP_ADDRESS_EXTERNAL |
string(240) |
GUI External IP Address |
☐ |
External IP address of the GUI application. |
MODIFIED_GUI_MACHINE |
string(240) |
GUI Machine |
☐ |
Name of the machine running the GUI application. |
MODIFIED_GUI_MODULE_NAME |
string(240) |
GUI Module Name |
☐ |
Module within the GUI application currently running. |
MODIFIED_GUI_MODULE_VERSION |
string(240) |
GUI Module Version |
☐ |
Version of module within the GUI application currently running. |
MODIFIED_GUI_OS_USER |
string(240) |
GUI OS User |
☐ |
OS user. |
MODIFIED_GUI_USER |
string(240) |
User |
☐ |
Application user. |
MODIFIED_LIFE_CYCLE_TYPE |
string(30) |
|
☑ |
Life cycle type. |
MODIFIED_MESSAGE_CODE |
string(30) |
Type |
☑ |
Type. |
MODIFIED_PARTITION |
string |
Partition |
☐ |
Specific partition on which the I/O was executed. |
MODIFIED_POOL_IDENTITY |
string(60) |
Pool Identity |
☐ |
Pool identity. |
MODIFIED_PROCESS_ID |
uint32 |
Process ID |
☐ |
Process ID. |
MODIFIED_REQUEST_ID |
string(240) |
Request ID |
☐ |
Request ID. |
MODIFIED_SCHEMA_NAME |
string |
Schema |
☐ |
Name of the schema. |
MODIFIED_SESSION_ID |
string(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 |
string |
Table Name |
☐ |
Name of the table. |
MODIFIED_TYPE |
string(30) |
Type |
☑ |
Type. |
NUMBER_OF_ACTIONS |
int32 |
|
☑ |
Number of actions. |
NUMBER_OF_DELETES |
int32 |
|
☑ |
Number of deletes. |
NUMBER_OF_READS |
int32 |
|
☑ |
Number of reads. |
NUMBER_OF_WRITES |
int32 |
Number of Writes |
☑ |
Number of writes. |
TOTAL_DELETE_BYTES |
int64 |
|
☑ |
Total bytes deleted. |
TOTAL_DELETE_CHARACTERS |
int64 |
|
☑ |
Total characters deleted. |
TOTAL_READ_BYTES |
int64 |
|
☑ |
Total bytes read. |
TOTAL_READ_CHARACTERS |
int64 |
|
☑ |
Total characters read. |
TOTAL_WRITE_BYTES |
int64 |
|
☑ |
Total bytes written. |
TOTAL_WRITE_CHARACTERS |
int64 |
|
☑ |
Total characters written. |
UID |
guid |
UID |
☑ |
Unique ID. |
18-10-2024 06:49 Version 24.0.345-PROD+4945