Please enable JavaScript to view this site.

Data Dictionary Forums

Data Dictionary Data Model

Navigation: Catalog: DataDictionary > Schemas > Schema: Invantive > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.
  
Disclaimer