Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 12254)
+++ trunk/ippTools/share/Makefile.am	(revision 12259)
@@ -11,4 +11,6 @@
 	chiptool_queuerawexp.sql \
 	chiptool_queuerawimfile.sql \
+	detselect_search.sql \
+	detselect_select.sql \
 	regtool_find_unprocessed_exp.sql \
 	regtool_find_unprocessed_imfile.sql \
@@ -18,2 +20,3 @@
 	regtool_processedimfile.sql \
 	warptool_tooverlap.sql
+
Index: trunk/ippTools/share/camtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 12254)
+++ trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 12259)
@@ -7,5 +7,6 @@
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope
+    rawExp.telescope,
+    rawExp.filelevel
 FROM camPendingExp
 JOIN chipProcessedExp
Index: trunk/ippTools/share/camtool_find_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 12254)
+++ trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 12259)
@@ -14,5 +14,6 @@
         rawExp.exp_id,
         rawExp.camera,
-        rawExp.telescope
+        rawExp.telescope,
+        rawExp.filelevel
     FROM camPendingExp
     JOIN chipProcessedExp
Index: trunk/ippTools/share/camtool_find_processedexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_processedexp.sql	(revision 12254)
+++ trunk/ippTools/share/camtool_find_processedexp.sql	(revision 12259)
@@ -1,6 +1,8 @@
 SELECT
     camProcessedExp.*,
+    rawExp.exp_id,
     rawExp.camera,
-    rawExp.workdir
+    rawExp.telescope,
+    rawExp.filelevel
 FROM camProcessedExp
 JOIN chipProcessedExp
Index: trunk/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 12254)
+++ trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 12259)
@@ -5,5 +5,6 @@
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope
+    rawExp.telescope,
+    rawExp.filelevel
 FROM chipPendingImfile
 JOIN chipPendingExp
Index: trunk/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_processedimfile.sql	(revision 12254)
+++ trunk/ippTools/share/chiptool_processedimfile.sql	(revision 12259)
@@ -9,5 +9,6 @@
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope
+    rawExp.telescope,
+    rawExp.filelevel
 FROM chipProcessedImfile
 JOIN chipProcessedExp
Index: trunk/ippTools/share/detselect_search.sql
===================================================================
--- trunk/ippTools/share/detselect_search.sql	(revision 12259)
+++ trunk/ippTools/share/detselect_search.sql	(revision 12259)
@@ -0,0 +1,15 @@
+SELECT DISTINCT
+    detRunSummary.det_id,
+    detRunSummary.iteration
+    rawExp.filelevel
+FROM detRun
+JOIN detRunSummary
+    USING(det_id)
+JOIN detInputExp
+    USING(det_id)
+JOIN rawExp
+    ON detInputExp.exp_tag = rawExp.exp_tag
+WHERE
+    detRun.state = 'stop'
+   AND detRun.mode  = 'master'
+   AND detRunSummary.accept = 1
Index: trunk/ippTools/share/detselect_select.sql
===================================================================
--- trunk/ippTools/share/detselect_select.sql	(revision 12259)
+++ trunk/ippTools/share/detselect_select.sql	(revision 12259)
@@ -0,0 +1,12 @@
+SELECT DISTINCT
+    detNormalizedImfile.*
+FROM detNormalizedImfile
+JOIN detRun
+    USING(det_id)
+JOIN detRunSummary
+    ON detNormalizedImfile.det_id = detRunSummary.det_id
+    AND detNormalizedImfile.iteration = detRunSummary.iteration
+WHERE
+    detRun.state = 'stop'
+    AND detRun.mode  = 'master'
+    AND detRunSummary.accept = 1
Index: trunk/ippTools/share/regtool_processedimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_processedimfile.sql	(revision 12254)
+++ trunk/ippTools/share/regtool_processedimfile.sql	(revision 12259)
@@ -1,5 +1,12 @@
 SELECT
-    *
+    rawImfile.*
+    rawExp.exp_id,
+    rawExp.camera,
+    rawExp.telescope,
+    rawExp.filelevel,
+    rawExp.workdir
 FROM rawImfile
+JOIN rawExp
+    USING(exp_tag)
 -- bogus conditional so there is a where clause to append to
 WHERE rawImfile.exp_tag is NOT NULL