SELECT
DCC.IDCAPTURESETTING,
DCC.NMCAPTURESETTING,
DCF.IDFILECAPTBATCH,
DCF.NMFILECAPTBATCH,
DBD.QTFILES,
DBD.IDDOCUMENT,
DBD.NMTITLE,
TIX.NMINDEX,
IX.DSINDEXVALUE,
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 /*NOTE1*/
FROM DCFILECAPTBATCH DCF
INNER JOIN DCCAPTURESETTING DCC ON DCC.CDCAPTURESETTING = DCF.CDCAPTURESETTING
INNER JOIN DCFCBATCHDOC DBD ON DCF.CDFILECAPTBATCH = DBD.CDFILECAPTBATCH
INNER JOIN DCFCOCRINDEX IX ON IX.CDFILECAPTBATCH = DBD.CDFILECAPTBATCH AND IX.CDBATCHDOC = DBD.CDBATCHDOC
INNER JOIN DCOCRTEMPLATEINDEX TIX ON TIX.CDINDEX = IX.CDOCRINDEX AND TIX.CDTEMPLATE = IX.CDOCRTEMPLATE
WHERE DBD.IDDOCUMENT IS NOT NULL /*NOTE2*/
ORDER BY DCC.IDCAPTURESETTING, DCF.IDFILECAPTBATCH
|