invantive documentation
Invantive Support ForumsLog In / Sign Up

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_ACTION varchar2(30) Action Action.
CREATE_BILLING_ID varchar2 Billing ID ID for billing.
CREATE_CALLING_PROVIDER_ALIAS varchar2(240) Calling Provider Alias Calling provider alias.
CREATE_CALL_SAFE_NAME_OVERRULE varchar2 Call Safe Name Overrule Overruled name of the table.
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_CALLING_PROVIDER_ALIAS varchar2(240) Calling Provider Alias Calling provider alias.
MODIFIED_CALL_SAFE_NAME_OVERRULE varchar2 Call Safe Name Overrule Overruled name of the table.
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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: