View: V_FieldDocumentReport

This view contains processed Capture values for a field, as well as corresponding information about the client, process and reporting category. Diagram:

Column	Description
FieldID	The ID of the field (FieldID in W_FieldReport).
OCRValue	The field value after the last OCR process step (Cat=OCR). (OCRValue in W_FieldReport.)
OCRValid	The status of the field after the last OCR process step (Cat=OCR). (OCRValid in W_FieldReport.)
CorrectValue	The field value of the last corrective OCR process step (Cat=CORR). (CorrectValue in W_FieldReport.)
CorrectValid	The status of the field after the last corrective OCR process step (Cat=CORR). (CorrectValid in W_FieldReport.)
FieldEvaluation	0 = CorrectValid (AUTOM_VALUE = CORR_VALUE and AUTOM_VALID = Valid) 1 = Substitution (AUTOM_VALUE <> CORR_VALUE and AUTOM_VALID = Valid) 2 = SuggestionCorrect (AUTOM_VALUE = CORR_VALUE and AUTOM_VALID <> Valid) 3 = SuggestionWithFault (AUTOM_VALUE <> CORR_VALUE and AUTOM_VALID <> Valid 4 = NoEval (no OCR_Value) (FieldEvaluation in W_FieldReport).
AutomValue	The field value after the last automatic process step (Cat=AUTOM). (AutomValue in W_FieldReport.)
AutomValid	The status of the field after the last automatic process step (Cat=AUTOM). (AutomValid in W_FieldReport.)
CaptureEndValue	The value reported after the last process step that is configured in the XBOUND reporting category as the capture end point (CaptureEndValue in W_FieldReport). For more information, see XBOUND Help topic "Configuring a reporting category".
CaptureEndValid	The status of the field after the last process step that is configured in the XBOUND reporting category as the capture end point (CaptureEndValid in W_FieldReport).
Name	The name of the field (Name in W_FieldHistory).
Type	The field type (Type in W_FieldHistory). Possible values: 0 = group 1 = string 2 = integer 3 = float 4 = datetime
VarcharValue	Field value when Type=1 (string). (VarcharValue in W_FiedlHistory.)
IntValue	Field value when Type=2 (int). (IntValue in W_FiedlHistory.)
FloatValue	Field value when Type=3 (float). (FloatValue in W_FiedlHistory.)
DatetimeValue	Field value when Type=4 (datetime). (DatetimeValue in W_FiedlHistory.)
StepID	ID of the step (StepID in W_FieldHistory).
ProcessStep	The name of the process step (ProcessStep in V_StepsReports).
ProcessStepID	ID of the process step (ProcessStepID in V_StepsReports).
DocumentID	ID of the document (DocumentID in V_StepsReports).
DocumentSiteId	Currently not used.
DocumentName	The name of the document (DocumentName in V_StepsReports).
DoneAt	When the step was executed (DoneAt in V_StepsReports).
DocType	The ID of the document type (DocType in V_StepsReports).
DocumentType	The name of the document type (DocumentType in V_StepsReports).
Process	The name of the process (Process in V_StepsReports).
Client	The name of the client (Client in V_StepsReports).
DateOnly	Only the date (not the time) from the DoneAt field (DateOnly in V_StepsReports).
CheckOutDurationHours	The period of time in hours during which the document was checked out for this step. (CheckOutDuration in V_StepsReports)
Action	Create Check out Check In Check in with Error Routed Manually Undo Check out Statistics (Action in V_StepsReports)
RepCatName	The name of the reporting category (RepCatName in V_StepsReports).
UserName	The Windows user in whose name the client process ran (User in V_StepsReports).
CheckOutDuration	The period of time in seconds during which the document was checked out for this step. (CheckOutDuration in V_StepsReports)
Machine	The computer on which the client process ran (Machine in V_StepsReports).
ID	The ID of the step (ID in V_StepsReports).
SiteId	Currently not used.
ServiceType	0 = Activity 1 = Collector 2 = Agent 3 = Global Parameter Set 4 = Client Parameter Set 5 = Process Parameter Set 6 = Interactive 7 = Platform 8 = License 9 = Activity and Parameter Set 10 = Feature Group (Service Type in V_StepsReports)
BatchID	The ID of the root document (BatchID in V_StepsReports).
ActionType	0 = Create 1 = Check out 2 = Check In 3 = Check in with Error 4 = Routed Manually 5 = Undo Check out 6 = Statistics (ActionType in V_StepsReports)
ReportingCatID	The ID of the reporting category (ReportingCatID in V_StepsReports).

SQL Script

CREATE VIEW [dbo].[V_FieldDocumentReport]
AS
SELECT  dbo.W_FieldReport.FieldID,dbo.W_FieldReport.OCRValue, dbo.W_FieldReport.OCRValid, 
	        dbo.W_FieldReport.CorrectValue, dbo.W_FieldReport.CorrectValid, dbo.W_FieldReport.FieldEvaluation, dbo.W_FieldReport.AutomValue, 
	        dbo.W_FieldReport.AutomValid, dbo.W_FieldReport.CaptureEndValue, dbo.W_FieldReport.CaptureEndValid, dbo.W_FieldHistory.Name, 
	        dbo.W_FieldHistory.Type, dbo.W_FieldHistory.VarcharValue, dbo.W_FieldHistory.IntValue, dbo.W_FieldHistory.FloatValue, 
	        dbo.W_FieldHistory.DatetimeValue, dbo.W_FieldHistory.StepID, dbo.V_StepsReports.ProcessStep, dbo.V_StepsReports.ProcessStepID, 
	        dbo.V_StepsReports.DocumentID, dbo.V_StepsReports.DocumentSiteId, dbo.V_StepsReports.DocumentName, dbo.V_StepsReports.DoneAt, 
	        dbo.V_StepsReports.DocType, dbo.V_StepsReports.DocumentType, dbo.V_StepsReports.Process, dbo.V_StepsReports.Client, dbo.V_StepsReports.DateOnly, 
	        dbo.V_StepsReports.CheckOutDurationHours, dbo.V_StepsReports.Action, dbo.V_StepsReports.RepCatName, dbo.V_StepsReports.UserName, 
	        dbo.V_StepsReports.CheckOutDuration, dbo.V_StepsReports.Machine, dbo.V_StepsReports.ID, dbo.V_StepsReports.SiteId, dbo.V_StepsReports.ServiceType, 
	        dbo.V_StepsReports.BatchID, dbo.V_StepsReports.ActionType, dbo.V_StepsReports.ReportingCatID
FROM    dbo.W_FieldReport INNER JOIN
	        dbo.W_FieldHistory ON dbo.W_FieldReport.FieldID = dbo.W_FieldHistory.FieldID AND
	        dbo.W_FieldReport.FieldSiteId = dbo.W_FieldHistory.FieldSiteId INNER JOIN
	        dbo.V_StepsReports ON dbo.W_FieldHistory.StepID = dbo.V_StepsReports.ID AND dbo.W_FieldHistory.StepSiteId = dbo.V_StepsReports.SiteId

Uses

The available tables

The available views