Index: trunk/ippTools/share/chiptool_completely_processed_exp.sql
===================================================================
--- trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 23363)
+++ trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 23381)
@@ -11,10 +11,12 @@
     dvodb,
     tess_id,
-    end_stage
+    end_stage,
+    all_files_magicked as magicked
 FROM
     (SELECT
         chipRun.*,
         rawImfile.class_id as rawimfile_class_id,
-        chipProcessedImfile.class_id
+        chipProcessedImfile.class_id,
+        SUM(!chipProcessedImfile.magicked) = 0 as all_files_magicked
     FROM chipRun
     JOIN rawImfile