Navigation: Capture >

Batches and documents

Overview

This command will list the batches and the related documents.

Related tables

Table	Description	Primary key (PK)	Connection tables
DCFILECAPTBATCH	Capture batch	CDFILECAPTBATCH
DCCAPTURESETTING	Capture configuration	CDCAPTURESETTING	DCFILECAPTBATCH
DCFCBATCHDOC	Documents from the batch	CDFILECAPTBATCH CDBATCHDOC	DCFILECAPTBATCH
ADUSER	User	CDUSER	DCFILECAPTBATCH

Oracle/Postgres/SQL Server

SELECT
   DCC.IDCAPTURESETTING,
   DCC.NMCAPTURESETTING,
   DCF.IDFILECAPTBATCH,
   DCF.NMFILECAPTBATCH,
   DBD.QTFILES,
   DBD.IDDOCUMENT,
   DBD.NMTITLE,
   US.NMUSER AS NMUSEREMIT, /*NOTE1*/
   CASE
   WHEN DCF.FGFILECAPTSTEP = 1  THEN  'Capture'
   WHEN DCF.FGFILECAPTSTEP = 5  THEN  'Quality control'
   WHEN DCF.FGFILECAPTSTEP = 12 THEN  'Separation'
   WHEN DCF.FGFILECAPTSTEP = 15 THEN  'Recognition'
   WHEN DCF.FGFILECAPTSTEP = 20 THEN  'Validation'
   WHEN DCF.FGFILECAPTSTEP = 21 THEN  'Typing'
   WHEN DCF.FGFILECAPTSTEP = 22 THEN  'Relationship'
   WHEN DCF.FGFILECAPTSTEP = 23 THEN  'Verification'
   WHEN DCF.FGFILECAPTSTEP = 25 THEN  'Indexing'
   WHEN DCF.FGFILECAPTSTEP = 30 THEN  'Closed'
     WHEN DCF.FGFILECAPTSTEP = 50 THEN  'Cancelled'
   END AS FGFILECAPTSETP /*NOTE2*/
FROM DCFILECAPTBATCH DCF , DCCAPTURESETTING DCC, DCFCBATCHDOC DBD, ADUSER US
WHERE DCC.CDCAPTURESETTING = DCF.CDCAPTURESETTING
AND DCF.CDFILECAPTBATCH = DBD.CDFILECAPTBATCH
AND DCF.CDUSEREMIT = US.CDUSER
AND DBD.IDDOCUMENT IS NOT NULL /*NOTE3*/
ORDER BY DCC.IDCAPTURESETTING, DCF.IDFILECAPTBATCH

Notes

▪1: Name of the user who started the batch. Information obtained through a relationship with the ADUSER table.

▪2: Batch step converted into text.

▪3: Filter added to return only records with information of documents created from the batch.

Fields used on the view screen

captura-02

#	Field ID	Type	Description
1	DCC.IDCAPTURESETTING	VARCHAR(50)
2	DCC.NMCAPTURESETTING	VARCHAR(255)
3	DCF.IDFILECAPTBATCH	VARCHAR(50)
4	DCF.NMFILECAPTBATCH	VARCHAR(255)
5	DCF.FGFILECAPTSETP	NUMERIC(2)	Converted into text mode.
6	NMUSEREMIT(US.NMUSER)	VARCHAR(255)
7	DBD.IDDOCUMENT	VARCHAR(50)
8	DBD.NMTITLE	VARCHAR(255)
9	DBD.QTFILES	NUMERIC(10)