Index: trunk/ippTools/share/flatcorr_camerarundone.sql
===================================================================
--- trunk/ippTools/share/flatcorr_camerarundone.sql	(revision 25890)
+++ trunk/ippTools/share/flatcorr_camerarundone.sql	(revision 25913)
@@ -7,9 +7,9 @@
 JOIN camRun
     USING(cam_id)
-LEFT JOIN addRun
-    ON camRun.cam_id = addRun.cam_id
+LEFT JOIN flatcorrAddstarLink
+    using(corr_id, cam_id)
 WHERE
     flatcorrRun.state = 'new'
     AND flatcorrCamLink.include = 1
     AND camRun.state = 'full'
-    AND addRun.cam_id is NULL
+    AND flatcorrAddstarLink.corr_id is NULL
Index: trunk/ippTools/share/flatcorr_chiprundone.sql
===================================================================
--- trunk/ippTools/share/flatcorr_chiprundone.sql	(revision 25890)
+++ trunk/ippTools/share/flatcorr_chiprundone.sql	(revision 25913)
@@ -7,9 +7,9 @@
 JOIN chipRun
     USING(chip_id)
-LEFT JOIN camRun
-    ON chipRun.chip_id = camRun.chip_id
+LEFT JOIN flatcorrCamLink
+    using(corr_id, chip_id)
 WHERE
     flatcorrRun.state = 'new'
     AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
-    AND camRun.cam_id is NULL
+    AND flatcorrCamLink.corr_id is NULL
Index: trunk/ippTools/share/flatcorr_pendingprocess.sql
===================================================================
--- trunk/ippTools/share/flatcorr_pendingprocess.sql	(revision 25890)
+++ trunk/ippTools/share/flatcorr_pendingprocess.sql	(revision 25913)
@@ -6,4 +6,5 @@
   filter,
   state,
+  make_corr,
   workdir,
   label,
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25890)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25913)
@@ -1217,4 +1217,5 @@
         filter VARCHAR(64),
         state VARCHAR(64),
+        make_corr TINYINT,
         workdir VARCHAR(255),
         label VARCHAR(64),