14 Auditing in Oracle Distributed Document Capture

The Oracle Distributed Document Capture Server audits certain activities and saves the information in the ecAudit table in the Capture database.

You can use audit information to create reports using a third-party reporting application. For example, you might build a custom report that gives the total number of pages sent per day by all users, by file cabinet. This would allow you to compare the output of client users.

This section covers the following topics:

• "ecAudit Table"

• "Activity IDs"

14.1 ecAudit Table

Table 14-1 ecAudit Table

Column Name	Data Type	Field Length	Description
ecDate	Integer	4	Date the activity occurred.
ecTime	Integer	4	Time the activity occurred.
ecUserID	Text	20	User ID of the person who performed the activity.
ecProcessID	Text	20	Process name or tool that is logging the activity. Applicable IDs include: Web Capture Service Batch Manager
ecActionID	Number	4	Activity ID of the activity being logged. This number is relevant only for the process or tool logging the activity.
ecActionDesc	Text	225	Description of the activity.
ecFileCabinet	Text	50	File Cabinet affected by the activity.
ecBatch	Text	50	Batch affected by the activity.
ecBatchID	Long Integer	4	Internal ID assigned to the batch.
ecActionDataInt	Long Integer	4	If the activity produces an integer result, that result is saved here.
ecActionDataFloat	Floating Point	8	If the activity produces a floating-point value result, that result is saved here.
ecActionDataText1	Text	255	If the activity produces a text result, that result is saved here.
ecActionDataText2	Text	255	Miscellaneous information about the activity.
ecActionDataText3	Text	255	Miscellaneous information about the activity.
ecActionDataText4	Text	255	Miscellaneous information about the activity.
ecActionDataText5	Text	255	Miscellaneous information about the activity.
ecErrorNum	Integer	4	Error number for auditing errors.
ecErrorDesc	Text	255	Error Description.

14.2 Activity IDs

All scanning and indexing audit information is tracked in the same table. This section describes which activities Oracle Distributed Document Capture audits and reports in the ecAudit table fields.

The following tables describe the data elements for Oracle Distributed Document Capture audit activity:

Table 14-2 Create Batch

Element	Description
Activity ID	1
Description	Create Batch
ecFile Cabinet	File cabinet in which the batch was created
ecBatch	Capture batch name
ecActionDataText1	Number of pages in the batch
ecActionDataText2	Capture Batch ID

Table 14-3 Commit Batch (both deferred and immediate)

Element	Description
Activity ID	10
Description	Commit Batch
ecFile Cabinet	File cabinet of the batch
ecBatch	Capture batch name
ecBatchID	Capture batch ID
ecActionDataInt	Committed page count
ecActionDataFloat	Number of documents in the batch
ecActionDataText2	Number of pages in the batch

Table 14-4 Receive Batch

Element	Description
Activity ID	400
Description	Receive Batch
ecFile Cabinet	File cabinet referenced in the batch
ecBatch	Capture batch name
ecActionDataText1	Name of the user who created the batch on the client
ecActionDataText2	Name of the user who last modified the batch
ecActionDataText3	Name of the computer that created the batch
ecActionDataText4	Date on which the batch was created on client
ecActionDataText5	Date on which the batch was last modified on client

Table 14-5 Receive Batch More Information

Element	Description
Activity ID	401
Description	Receive Batch More Information
ecFile Cabinet	File cabinet referenced in the batch
ecBatch	Capture batch name
ecActionDataText1	Version number of the client used to create this batch

Table 14-6 Post Batch Received

Element	Description
Activity ID	402
Description	Post Batch Received
ecFile Cabinet	File cabinet referenced in the batch
ecBatch	Capture batch name
ecBatchID	Capture batch unique ID. This audit entry contains the same values as the Receive Batch entry (Activity ID 400). However, it is written to the database table after the batch has been created, so its ecBatchID contains a value other than 0. You can use this ecBatchID value to link a Capture batch received by the server to the original batch sent by the client.
ecActionDataText1	Name of the user who created the batch on the client
ecActionDataText2	Name of the user who last modified the batch
ecActionDataText3	Name of the computer that created the batch
ecActionDataText4	Date on which the batch was created on client
ecActionDataText5	Date on which the batch was last modified on client