Index: trunk/dbconfig/det.md
===================================================================
--- trunk/dbconfig/det.md	(revision 15315)
+++ trunk/dbconfig/det.md	(revision 19088)
@@ -56,4 +56,5 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END
@@ -75,4 +76,5 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END
@@ -96,4 +98,6 @@
     user_4      F64         0.0
     user_5      F64         0.0
+#   XXX does it make sense to 'clean' the stacked imfiled?
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END
@@ -104,7 +108,9 @@
     class_id    STR         64      # Primary Key
     norm        F32         0.0
-    fault       S16         0       # Key NOT NULL
-END
-
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
+    fault       S16         0       # Key NOT NULL
+END
+
+## XXX this must match in fields with detRegisteredImfile
 detNormalizedImfile METADATA
     det_id      S64         0       # Primary Key fkey(det_id) ref detInputExp(det_id)
@@ -121,4 +127,5 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END
@@ -137,4 +144,5 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END
@@ -179,4 +187,5 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END
@@ -205,11 +214,14 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     accept      BOOL        f
     fault       S16         0       # Key NOT NULL
 END
 
+# XXX this probably should have been defined at the start of a new iteration, not at the end.
 detRunSummary METADATA
     det_id      S64         0       # Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration)
     iteration   S32         0       # Primary Key fkey(det_id, iteration) ref detResidExp(det_id, iteration)
+    data_state  STR         64      # full, goto_cleaned, cleaned, goto_full, goto_purged, purged
     bg          F64         0.0
     bg_stdev    F64         0.0
@@ -237,4 +249,5 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END