Index: /trunk/ippTools/notes.txt
===================================================================
--- /trunk/ippTools/notes.txt	(revision 18447)
+++ /trunk/ippTools/notes.txt	(revision 18448)
@@ -1,2 +1,24 @@
+
+2008.07.09 EAM
+
+  In order to implement the 'cleanup' and 'update' strategies, we have
+  changed the state names and defined addtional states as follows:
+
+  * new          : entry is unprocessed (was 'run')
+  * full         : entry is processed and has all output data products (was 'done')
+  * goto_cleaned : entry should be processed by the 'cleanup' system
+  * cleaned   	 : entry has been processed by the 'cleanup' system --
+    		   some output data products are now missing.
+		   
+  * goto_full    : entry should be re-processed by the 'update' system
+  * full         : entry has been re-processed by the 'update' system
+  
+  * goto_purged  : entry should be processed by the 'cleanup' ssytem
+    		   to purge all output data
+  * purged       : entry has been purged
+
+
+
+2008.05.16 EAM
 
 caltool
@@ -4,3 +26,2 @@
   * add the -region 
   * change 'catdir' to 'dvo_id'
-  * 	
Index: /trunk/ippTools/share/difftool_inputskyfile.sql
===================================================================
--- /trunk/ippTools/share/difftool_inputskyfile.sql	(revision 18447)
+++ /trunk/ippTools/share/difftool_inputskyfile.sql	(revision 18448)
@@ -34,5 +34,5 @@
         AND fakeRun.state = 'stop'
         AND camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
     UNION
     SELECT 
@@ -70,4 +70,4 @@
         AND fakeRun.state = 'stop'
         AND camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
     ) as Foo
Index: /trunk/ippTools/share/difftool_todiffskyfile.sql
===================================================================
--- /trunk/ippTools/share/difftool_todiffskyfile.sql	(revision 18447)
+++ /trunk/ippTools/share/difftool_todiffskyfile.sql	(revision 18448)
@@ -29,4 +29,4 @@
   AND fakeRun.state = 'stop'
   AND camRun.state = 'stop'
-  AND chipRun.state = 'stop'
+  AND chipRun.state = 'full'
   AND diffSkyfile.diff_id IS NULL
Index: /trunk/ippTools/share/faketool_find_camrun.sql
===================================================================
--- /trunk/ippTools/share/faketool_find_camrun.sql	(revision 18447)
+++ /trunk/ippTools/share/faketool_find_camrun.sql	(revision 18448)
@@ -33,4 +33,4 @@
     WHERE
         camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
 ) as Foo
Index: /trunk/ippTools/share/faketool_find_pendingexp.sql
===================================================================
--- /trunk/ippTools/share/faketool_find_pendingexp.sql	(revision 18447)
+++ /trunk/ippTools/share/faketool_find_pendingexp.sql	(revision 18448)
@@ -27,5 +27,5 @@
         fakeRun.state = 'run'
         AND camRun.state = 'stop'
-        AND chipRun.state = 'stop'
+        AND chipRun.state = 'full'
         AND fakeMask.label IS NULL
         AND fakeProcessedImfile.fake_id IS NULL
Index: /trunk/ippTools/share/warptool_imfile.sql
===================================================================
--- /trunk/ippTools/share/warptool_imfile.sql	(revision 18447)
+++ /trunk/ippTools/share/warptool_imfile.sql	(revision 18448)
@@ -24,4 +24,4 @@
     AND fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
 
Index: /trunk/ippTools/share/warptool_scmap.sql
===================================================================
--- /trunk/ippTools/share/warptool_scmap.sql	(revision 18447)
+++ /trunk/ippTools/share/warptool_scmap.sql	(revision 18448)
@@ -22,3 +22,3 @@
     fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
Index: /trunk/ippTools/share/warptool_tooverlap.sql
===================================================================
--- /trunk/ippTools/share/warptool_tooverlap.sql	(revision 18447)
+++ /trunk/ippTools/share/warptool_tooverlap.sql	(revision 18448)
@@ -25,5 +25,5 @@
     AND fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
     AND warpSkyCellMap.warp_id IS NULL
     AND warpMask.label IS NULL
Index: /trunk/ippTools/share/warptool_towarped.sql
===================================================================
--- /trunk/ippTools/share/warptool_towarped.sql	(revision 18447)
+++ /trunk/ippTools/share/warptool_towarped.sql	(revision 18448)
@@ -30,5 +30,5 @@
     AND fakeRun.state = 'stop'
     AND camRun.state = 'stop'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
     AND warpSkyfile.warp_id IS NULL
     AND warpSkyfile.skycell_id IS NULL