Column Name Type Length Description LOAD_TIME Integer 4 Integer representing the UNIX timestamp for the load (unused in IBM CMOD V9.0+), see LOAD_TIME_DT below. APPLGRP_NAME Varchar 60 Name of the Application Group the data was loaded into. APPL_NAME Varchar 60 Name of the Application the data was loaded into. (Implies specific indexing and compression settings defined in the Application.) LOAD_ID Varchar 100 The IBM CMOD Load ID for the load. TOTAL_ELAPSED Double 8 The elapsed time in seconds and fractions of a second for the entire load to complete. INDEX_ELAPSED Double 8 The elapsed time in seconds for the indexing portion of the load. TOTAL_DOCS BigInt 8 The total number of documents inserted into the database in this load. TOTAL_PAGES BigInt 8 The total number of pages in all documents loaded as part of this load. (Where supported.) DOC_COMP_TYPE SmallInt 2 Document Compression Type – see arsapp.doc_comp_type DOC_INPUT_SIZE BigInt 8 Input size in bytes of the file to be loaded. DOC_OUTPUT_SIZE BigInt 8 Size of the data stored in CMOD after compression. RES_TYPE SmallInt 2 Describes the resource type. RES_RID Integer 4 The Resource Identifier for the loaded document. May be duplicated if the resources match a previous load. RES_COMP_TYPE SmallInt 2 Describes the resource compression type – see arsapp.doc_res_type RES_INPUT_SIZE BigInt 8 Resource size before compression. RES_OUTPUT_SIZE BigInt 8 Resource size stored after IBM CMOD compression. LOAD_AGID Integer 4 The numeric Application Group ID of the loaded file. Included because Application Group names are allowed to be changed. LOAD_AID Integer 4 The numeric Application ID used to load the file. Included because Application names can be changed. LOAD_NAME Varchar 11 The ‘Doc_Name’ portion of the Load ID. LOAD_PRI_NID Integer 4 The Primary Node ID of the Load ID. LOAD_SEC_NID Integer 4 The Secondary Node ID of the Load ID. (Deprecated and unused.) LOAD_START BigInt 8 The start date and time of the load in UNIX timestamp format. LOAD_STOP BigInt 8 The end date and time of the load in UNIX timestamp format. DOC_BGN_DATE Integer 4 The earliest document date in the Load. DOC_END_DATE Integer 4 The latest document date in the Load. INDEX_TYPE SmallInt 2 Describes the indexer that was used to index the data in the load file – see arsapp.idx_type APPL_ID Character 1 Unknown. LOCKDOWN SmallInt 2 Determines if the load was automatically held if Enhanced Retention Management is enabled. CFSOD SmallInt 2 Describes if CFS:OD was used on the Load. INPUT_FILENAME Varchar 1024 The name of the file that was loaded. DOC_NAME Varchar 11 Internal object name of the log file. DOC_OFF Integer 4 Internal offset inside the object name of the log file. DOC_LEN Integer 4 Internal length of the log file inside the object. COMP_OFF Integer 4 Internal compressed offset of the log file. COMP_LEN Integer 4 Internal compressed length of the log file. ANNOT Character 1 Was there an annotation added to the log file? COMP_TYPE Character 1 Compression type of the log file. RESOURCE Integer 4 Resource ID of the log file. PRI_NID Integer 4 Primary Node ID where the log file object is stored. SEC_NID Integer 4 Secondary Node ID – deprecated and unused. LOAD_TIME_DT TimeStamp 10 A timestamp of when the file was loaded in the database’s internal date/time format. LOAD_START_DT TimeStamp 10 A timestamp of when the file started loading into CMOD, in the database’s internal date/time format. LOAD_STOP_DT TimeStamp 10 A timestamp of when the file finished loading into CMOD, in the database’s internal date/time format. DOC_BGN_DT Date 4 A timestamp representing the earliest document date in the load, in the database’s internal date format. DOC_END_DT Date 4 A timestamp representing the latest document date in the load, in the database’s internal date format. INPUT_FILE_SIZE BigInt 8 Size of the loaded file in bytes.