Exempelrapport: Capture Statistics

Fråga

Hur många fält verifierades i ett Verification-processteg, och hur lång tid tog det?

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

Klient (@strClient)
SELECT DISTINCT Name, ID
FROM C_Client
Process (@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))
Rotdokumenttyp (@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))
Underdokumenttyp (@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 framställningsdatum från/till
SELECT MIN(DocCreateDateOnly) AS StartDate, MAX(DocCreateDateOnly) AS EndDate
FROM V_StepsDocReport

V_StepsDocReport härleds från W_DocReport, W_Document, och V_StepsReports.
W_DocReport fylls i av XBOUND Agent for Reporting. En Slutpunkt för capture måste sättas för att dokument ska rapporteras här.
Varför W_DocReport? Der Agent for Reporting samlar, bearbetar och sparar de erforderliga värdena i W_DocReport tabellen.
Varför V_StepsReports? Alla processteg för ett dokument sparas i den här visningen. Sambandet mellan fält/dokument/processteg görs här, liksom tilldelning till processen och klienten.
Verification Time avser alla dokument som har passerat ett Verification processteg.
Doc Count inkluderar alla rotdokument och underdokument som passerat Capture End och fylls i av Agent for Reporting.
Average Time avser verifikationstid / Doc Count.

Fält etikett i rapporten	Fält i SELECT-uttrycket
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