Data Entry > Viewing log information > Querying logs with DM Query > DataCollectionAudit_Analysis.mdd audit file definition
 
DataCollectionAudit_Analysis.mdd audit file definition
The DataCollectionAudit_Analysis.mdd audit file includes the following fields:
Field
Data Type
Description
AuditCaseID
mtText
The case respondent ID. This field functions as the audit data identification. Any record can be located by its AuditCaseId value.
AuditProject
mtText
The project name.
AuditDataFile
mtText
Target data file name. This is the data entry batch file name.
AuditCollection
mtArray
The loop that stores all interactions with the respondent. The loop consists of the following sub-fields.
- AuditUser
mtText
The InterviewId. The interviewer or data entry operator.
- AuditWorkStationId
mtText
The Microsoft Windows workstation ID.
- AuditWorkStationUser
mtText
The Microsoft Windows user currently signed into the workstation.
- AuditStartTime
mtDate
Timestamp of when the interaction started.
- AuditFinishTime
mtDate
Timestamp of when the interaction completed.
- AuditOperation
mtCategorical
The data operation (initial, data entry, partial, or full verification). The default value is DataEntry.
- AuditCollectionMode
mtCategorical
The data entry mode (Initial, Partial, or Full). Reports use this field to filter data for different modes.
- AuditCaseStatus
mtCategorical
The case status when the audit entry was created (Completed or Suspended).
- AuditText
mtText
Optional text regarding the operation.
- AuditEntryCount
mtLong
The total number of times questions were answered in the Data Entry Player.
AuditAlphanumeric
KeystrokeCount
mtLong
Keystroke count of alphanumeric (A through Z and 0 through 9) characters. The count is the accumulated keystroke value of all verification operations for a particular interaction.
- AuditValidationCount
mtLong
The total number of times verification changes were accepted. Changes are only tallied for in the partial or full verification entry modes.
- AuditVerification
mtArray
The loop that stores error information in verification mode. The loop consists of the following sub-fields.
- AuditVariablename
mtText
The variable has a response change.
- AuditOriginalResponse
mtText
The original answer before verification. For categorical questions, this field stores the selected category names.
- AuditVerifiedResponse
mtText
New answer input after verification. For categorical questions, this field stores the selected category names.
You can use the DM Query utility to query the DataCollectionAudit_Analysis.ddf file. For more information, see Querying logs with DM Query. You can use the MDM Explorer utility to view the audit file metadata in theDataCollectionAudit_Analysis.mdd file. Both tools are installed with the UNICOM Intelligence Developer Documentation Library.
Examples using DM Query with DataCollectionAudit_Analysis.ddf
Viewing all records in DataCollectionAudit_Analysis.ddf:
select * from hdata
Viewing all cases for a specific project:
select * from hdata where AuditProject = ‘PROJECTNAME’
Viewing all initial data entry cases worked on by a specific user:
select AuditUser, ^.AuditProject as AuditProject, ^.AuditDataFile as AuditDataFile, AuditCollectionMode, AuditOperation,
AuditStartTime, AuditFinishTime, AuditEntryCount, AuditValidationCount, AuditWorkstationId, AuditWorkstationUser, ^.AuditCaseId
as AuditCaseId, AuditCaseStatus, AuditText from hdata.AuditCollection where AuditUser = ‘USER’
Viewing all completed initial data entry records for a project entered by a specific user:
select AuditUser, ^.AuditProject as AuditProject, ^.AuditDataFile as AuditDataFile, AuditCollectionMode, AuditOperation,
AuditStartTime, AuditFinishTime, AuditEntryCount, AuditValidationCount, AuditWorkstationId, AuditWorkstationUser, ^.AuditCaseId
as AuditCaseId, AuditCaseStatus, AuditText from hdata.AuditCollection where (AuditOperation = {Initial}) AND (AuditCaseStatus =
{Completed}) <> -1) AND ^.AuditProject = 'PROJECTNAME' AND AuditUser = 'USER'
Viewing the total number of times questions where answered in initial data entry mode for a project entered by a specific user:
select Sum(AuditEntryCount) from hdata.AuditCollection where (AuditOperation = {Initial}) <> -1) AND ^.AuditProject =
'PROJECTNAME' AND AuditUser = 'USER'
Viewing the total number of times verification changes were accepted for a project entered by a specific user:
select Sum(AuditValidationCount) from hdata.AuditCollection where ^.AuditProject = 'PROJECTNAME' AND AuditUser = 'USER'
See
Querying logs with DM Query