Extraction Timing File Column Descriptions

If the cpcsExtractionTimings option is set to true, the extraction process creates a comma-separated value (.csv) file. The CSV file contains the time it took to perform the entire extraction process for a given unit of work. The file can be opened with any spreadsheet editor to be read more easily.

Extraction timings column descriptions for the extraction are shown below:
File Name
Name of the file being created for this extraction unit of work
System Time
Time the entry was made in this CSV file
Number Items
Total number of items extracted
Total Extraction Time
Elapsed time (in milliseconds) to process this extraction from start to finish
Pass One Time
Elapsed time (in milliseconds) to process the first pass for this extraction
Pass Two Time
Elapsed time (in milliseconds) to process the second pass for this extraction
Moved to Processed Time
Number of milliseconds to move the file to the processed folder
User Control Record Exit
Number of milliseconds to perform the user control record user exit
User Status Update Exit
Number of milliseconds to perform the user status update user exit
Sorter User Exit
Number of milliseconds to perform the sorter user exit
DB Entry add
Total time (in milliseconds) the database call executed for adding a new entry
DB Presentment retrieve
Total time (in milliseconds) the database call executed for retrieving batches (ICLs)
DB ICL Record retrieve
Total time (in milliseconds) the database call(s) executed for retrieving ICL records. The number in parentheses indicates the total times this database statement was executed for this extract.
DB Tracer Group update
Total time (in milliseconds) the database call(s) executed for updating tracer groups. The number in parentheses indicates the total times this database statement was executed for this extract.
DB Entry ID's update
Total time (in milliseconds) the database call(s) executed for updating entry IDs for batches (ICLs). The number in parentheses indicates the total times this database statement was executed for this extract.
DB Credit Record retrieve
Total time (in milliseconds) the database call(s) executed for retrieving credit records. The number in parentheses indicates the total times this database statement was executed for this extract.
DB Presentment Payments retrieve
Total time (in milliseconds) the database call(s) executed for retrieving transactions for a particular batch (ICL). The number in parentheses indicates the total times this database statement was executed for this extract.
DB Tracer Group add
Total time (in milliseconds) the database call(s) executed for adding a tracer group record. The number in parentheses indicates the total times this database statement was executed for this extract.
DB Payment ISN update
Total time (in milliseconds) the database call(s) executed for updating a transaction with the new ISN. The total time includes the total time for "Process Item". The number in parentheses indicates the total times this database statement was executed for this extract.
Process Item
Total time (in milliseconds) the extraction task took to process all items for the extract.