Index: /tags/ipp-20130307/pstamp/scripts/psstatus
===================================================================
--- /tags/ipp-20130307/pstamp/scripts/psstatus	(revision 35386)
+++ /tags/ipp-20130307/pstamp/scripts/psstatus	(revision 35387)
@@ -68,4 +68,5 @@
     IFNULL(depcount, 0) AS 'Image updates'
     , timestamp AS 'last state change (UTC)'
+    , registered AS 'Submit time (UTC)'
 FROM (
     SELECT
@@ -77,9 +78,10 @@
         pstampRequest.fault,
         timestamp,
+        registered,
         IFNULL(priority,10000) AS priority
 FROM pstampRequest
 LEFT JOIN Label USING(label)
     WHERE pstampRequest.state = 'run' or pstampRequest.state ='new' 
-    	OR pstampRequest.state = 'preview'
+    	OR pstampRequest.state = 'parsed'
    --     OR pstampRequest.state = 'run.wait'
 ) as unfinishedReq
@@ -91,5 +93,5 @@
     WHERE (pstampRequest.state = 'run' or pstampRequest.state = 'new' 
         OR pstampRequest.state = 'run.wait'
-        OR pstampRequest.state = 'preview')
+        OR pstampRequest.state = 'parsed')
     GROUP BY req_id
 ) as rowCounts
@@ -103,5 +105,5 @@
     JOIN pstampDependent USING(dep_id) 
     WHERE (pstampRequest.state = 'run' or pstampRequest.state = 'new' 
-	    OR pstampRequest.state = 'preview'
+	    OR pstampRequest.state = 'parsed'
             OR pstampRequest.state = 'run.wait')
         AND dep_id > 0
@@ -157,5 +159,5 @@
     pstampRequest.fault,
     count(job_id) as 'Finished jobs',
-    timestamp as 'last state change'
+    timestamp as 'last update'
 FROM pstampRequest
     JOIN pstampJob USING(req_id)
@@ -181,5 +183,6 @@
     IFNULL(faulted,0) AS 'Faulted Jobs',
     IFNULL(depcount, 0) AS 'Image updates completed',
-    timestamp AS 'Completion Time (UTC)'
+    timestamp AS 'Completion Time (UTC)',
+    registered AS 'Submit Time (UTC)'
 FROM (
     SELECT
@@ -190,5 +193,6 @@
 --    pstampRequest.state,
 --    pstampRequest.fault,
-    timestamp
+    timestamp,
+    registered
 FROM pstampRequest
     WHERE pstampRequest.state = 'stop'