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),
Index: trunk/ippTools/src/flatcorr.c
===================================================================
--- trunk/ippTools/src/flatcorr.c	(revision 25890)
+++ trunk/ippTools/src/flatcorr.c	(revision 25913)
@@ -133,4 +133,5 @@
     PXOPT_LOOKUP_STR(tess_id, config->args, "-set_tess_id", false, false);
     PXOPT_LOOKUP_STR(region, config->args, "-set_region", false, false);
+    PXOPT_LOOKUP_BOOL(make_correction, config->args, "-make_correction", false);
     PXOPT_LOOKUP_STR(note, config->args, "-set_note", false, false);
 
@@ -203,4 +204,5 @@
             filter,
             "reg",  // state
+	    make_correction,
             workdir,
             label,
@@ -294,4 +296,5 @@
     PXOPT_LOOKUP_STR(tess_id, config->args, "-set_tess_id", false, false);
     PXOPT_LOOKUP_STR(region, config->args, "-set_region", false, false);
+    PXOPT_LOOKUP_BOOL(make_correction, config->args, "-make_correction", false);
     // XXX probably should make the region in -set_region match ra_min, ra_max, etc
 
@@ -315,4 +318,5 @@
 	filter,
 	"reg",  // state
+	make_correction,
 	workdir,
 	label,
Index: trunk/ippTools/src/flatcorrConfig.c
===================================================================
--- trunk/ippTools/src/flatcorrConfig.c	(revision 25890)
+++ trunk/ippTools/src/flatcorrConfig.c	(revision 25913)
@@ -59,4 +59,5 @@
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_tess_id",  0,            "define tessalation", NULL);
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_region",   0,            "define region", NULL);
+    psMetadataAddBool(definebyqueryArgs, PS_LIST_TAIL, "-make_correction",  0,       "generate a correction image and add to detrend database", false);
 
     psMetadataAddBool(definebyqueryArgs, PS_LIST_TAIL, "-pretend",  0,            "print the exposures that would be included in the detrend run and exit", false);
@@ -76,4 +77,5 @@
     psMetadataAddStr(definerunArgs, PS_LIST_TAIL, "-set_tess_id",  0,            "define tessalation", NULL);
     psMetadataAddStr(definerunArgs, PS_LIST_TAIL, "-set_region",  0,            "define region", NULL);
+    psMetadataAddBool(definerunArgs, PS_LIST_TAIL, "-make_correction",  0,       "generate a correction image and add to detrend database", false);
     psMetadataAddBool(definerunArgs, PS_LIST_TAIL, "-simple", 0,            "use the simple output format", false);
 
@@ -129,4 +131,5 @@
     psMetadataAddS64(updaterunArgs, PS_LIST_TAIL, "-corr_id", 0, "define correction id (required)", 0);
     psMetadataAddStr(updaterunArgs, PS_LIST_TAIL, "-state",   0, "set state (required)", NULL);
+    // XXX add mechanism to change this value: psMetadataAddBool(updaterunArgs, PS_LIST_TAIL, "-set_correction",  0, "generate a correction image and add to detrend database", false);
 
     // -inputexp