Index: /branches/sc_branches/ippMonitorLap/def/lapExposures.d
===================================================================
--- /branches/sc_branches/ippMonitorLap/def/lapExposures.d	(revision 31739)
+++ /branches/sc_branches/ippMonitorLap/def/lapExposures.d	(revision 31740)
@@ -1,3 +1,3 @@
-TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) 
+TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun USING(chip_id)
 #JOIN chipRun USING(lapExp.chip_id) 
 #JOIN chipRun AS pairRun USING(lapExp.pair_id)
@@ -13,7 +13,8 @@
 FIELD lapRun.seq_id,          6, %d,     seq_id
 FIELD lapExp.lap_id,          6, %d,     lap_id
+FIELD lapExp.data_state,      6, %s,     State (lapExp)
 FIELD lapExp.exp_id,          6, %d,     Exp ID,	value, rawImfile.php, ARG1
 FIELD lapExp.chip_id,         6, %d,     Chip ID,	value, chipStageExp.php, ARG2
-#FIELD chipRun.state,          6, %s,     State
+FIELD chipRun.state,          6, %s,     State (chipRun)
 FIELD lapExp.pair_id,         6, %d,     Pair ID,	value, chipStageExp.php, ARG3
 FIELD lapRun.tess_id,         8, %s,     tess_id
@@ -30,5 +31,4 @@
 FIELD lapExp.pairwise,        2, %d,     Pairwise
 FIELD lapExp.active,          2, %d,     Active
-FIELD lapExp.data_state,      15, %s,    State (lapExp)
 FIELD rawExp.dateobs,         19, %T,     Date/Time
 FIELD rawExp.object, 	      8, %s,     Object