Beispielsbericht: Capture Statistics

Frage

Wieviele Felder wurden in einem Verification-Prozessschritt verarbeitet und wieviel Aufwand war dazu notwendig?

SELECT Client, Process,

SUM(CorrectValid) AS FieldCorrect,

SUM(SuggestionCorrect) AS FieldSuggCorr,

SUM(SuggestionFaulty) AS FieldSuggWrong,

SUM(Substitutions) AS FieldSubstitutedCorrect,

(SELECT COUNT(DISTINCT FieldID) AS Expr1

FROM V_FieldPerDocument AS Sel1

WHERE (V_StepsDocReport.ProcessID=ProcessID) AND (FieldEvaluation < 4) AND (DocCreateDateOnly

BETWEEN @StartDate AND @EndDate)) AS FieldCount, COUNT(DISTINCT DocID) AS DocCount,

SUM(CASE WHEN BatchID = DocID THEN CurrentSheetCount ELSE 0 END) AS SheetCount,

SUM(CASE WHEN BatchID = DocID THEN CurrentPageCount ELSE 0 END) AS PageCount,

(SELECT SUM(CASE WHEN BatchID = DocID THEN VerificationTimeSum / 3600 ELSE 0 END) AS Expr1 FROM V_VerificationStepsDocReport AS Sel1

WHERE (V_StepsDocReport.ProcessID = ProcessID)) AS Time,

FROM V_StepsDocReport

WHERE (Client IN (@strClient)) AND (Process IN (@strProcess)) AND ((CASE WHEN ParentID = 0 THEN (CASE WHEN ReclassifiedDocName IS NULL

THEN '<not assigned>' WHEN ReclassifiedDocName = '<only sub-document types>' THEN ' ' ELSE ReclassifiedDocName END) END) IN (@RootDocumentType) OR

(CASE WHEN ParentID <> 0 THEN (CASE WHEN ReclassifiedDocName IS NULL

THEN '<not assigned>' WHEN ReclassifiedDocName = '<only sub-document types>' THEN ' ' ELSE ReclassifiedDocName END) END) IN (@SubDocumentType))

AND (DocCreateDateOnly BETWEEN @StartDate AND @EndDate)

GROUP BY Client, ProcessID, Process

Mandant (@strClient)
SELECT DISTINCT Name, ID
FROM C_Client
Prozess (@strProcess)
SELECT DISTINCT   C_Process.Name, C_Process.ClientID, C_Process.ID, C_Client.ID AS ID_Client,
                  C_Client.Name AS ID_Name
FROM              C_Process INNER JOIN
                  C_Client ON C_Process.ClientID = C_Client.ID
WHERE             (C_Client.Name IN (@strClient))
Basisdokumententyp (@RootDocumentType)
SELECT '<only sub document types>' AS RootDocumentType
UNION ALL
SELECT DISTINCT CASE WHEN ReclassifiedDocName IS NULL THEN '<not assigned>' ELSE ReclassifiedDocName END AS RootDocumentType
FROM V_StepsDocReport
WHERE (ParentID = 0) AND (Process IN (@strProcess))
Unterdokumententyp (@SubDocumentType)
SELECT '<only root document types>' AS SubDoumentType
UNION ALL
SELECT DISTINCT CASE WHEN ReclassifiedDocName IS NULL THEN '<not assigned>' ELSE ReclassifiedDocName END AS SubDoumentType
FROM V_StepsDocReport
WHERE (ParentID <> 0) AND (Process IN (@strProcess))
Dokument Erstellungsdatum von / bis
SELECT MIN(DocCreateDateOnly) AS StartDate, MAX(DocCreateDateOnly) AS EndDate
FROM V_StepsDocReport

Die Grundlage der V_StepsDocReport ergibt sich aus W_DocReport, W_Document und V_StepsReports.
Die W_DocReport wird mit Hilfe des "Agent for Reporting" gefüllt. Es muss ein Capture-Endpunkt gesetzt sein, sonst werden die Felder nicht aufbereitet.
Warum W_DocReport? Der Agent sammelt, verarbeitet und speichert die benötigten Werte in der Tabelle W_DocReport.
Warum V_StepsReports? In dieser Sicht sind alle Verarbeitungsschritte eines Dokumentes gespeichert. Die Verbindung Feld-Dokument-Verarbeitungsschrittwird hier hergestellt. Die Zuordnung zum Prozess und Mandanten erfolgt hier.
Verification Time bezieht sich auf alle Dokumente die einen "Verification" Prozessschritt durchlaufen.
Doc Count inkludiert alle Basisdokumente und Unterdokumente, die Capture-Endpunkt passiert haben und werden von dem Agenten gefüllt.
Average Time bezieht sich auf die Verification Zeit / Doc Count.

Feldbezeichnung im Bericht	Feld im Select Statement
Processed Time (Hours)	Time
Avg. Time per Document (Hours)	Time/DocCount
Root & Sub-documents	DocCount
Fields Captured (Total)	FieldCount
Fields Correct (Total)	FieldCorr
Fields Correct (%)	FieldCorr/FieldCount
Fields Suggested Correctly (Total)	FieldSuggCorr
Fields Suggested Correctly (%)	FieldSuggCorr/FieldCount
Fields Suggested Incorrectly (Total)	FieldSuggWrong
Fields Suggested Incorrectly (%)	FieldSuggWrong/FieldCount
Fields Substituted (Total)	FieldSubstituted
Fields Substituted (%)	FieldSubstituted/FieldCount