Index: /trunk/ippMonitor/def/fullforceFailedSkyfile.d
===================================================================
--- /trunk/ippMonitor/def/fullforceFailedSkyfile.d	(revision 38223)
+++ /trunk/ippMonitor/def/fullforceFailedSkyfile.d	(revision 38223)
@@ -0,0 +1,26 @@
+TABLE staticskyInput, staticskyRun, stackRun, staticskyResult
+TITLE Static Sky Processed 
+FILE  staticskyFailedSkyfile.php
+MENU  ipp.stack.dat
+
+WHERE staticskyRun.sky_id = staticskyInput.sky_id
+WHERE staticskyInput.stack_id = stackRun.stack_id
+WHERE staticskyInput.sky_id = staticskyResult.sky_id
+WHERE staticskyResult.fault != 0
+
+#        field                          size  format  name           show     link to         extras
+FIELD staticskyRun.sky_id,          5, %s,     Sky ID
+FIELD staticskyRun.label,    	    7, %s,     Label
+FIELD staticskyRun.state,    	    7, %s,     State
+FIELD stackRun.stack_id,            5, %s,     Stack ID
+FIELD stackRun.skycell_id,          5, %s,     Skycell ID
+FIELD stackRun.tess_id,             5, %s,     Tess ID
+FIELD stackRun.filter,              5, %s,     Filter 
+FIELD stackRun.label,               5, %s,     Stack Label
+FIELD staticskyRun.data_group, 	    7, %s,     data grp
+FIELD staticskyRun.dist_group, 	    7, %s,     dist grp
+FIELD staticskyResult.dtime_phot,   7, %.2f,   t(phot)
+FIELD staticskyResult.dtime_script, 7, %.2f,   t(script)
+FIELD staticskyResult.sources,      7, %d,     n(sources)
+FIELD staticskyResult.fault,        7, %d,     fault
+FIELD staticskyResult.quality,      7, %d,     quality
Index: /trunk/ippMonitor/def/fullforceProcessedSkyfile.d
===================================================================
--- /trunk/ippMonitor/def/fullforceProcessedSkyfile.d	(revision 38223)
+++ /trunk/ippMonitor/def/fullforceProcessedSkyfile.d	(revision 38223)
@@ -0,0 +1,25 @@
+TABLE staticskyInput, staticskyRun, stackRun, staticskyResult
+TITLE Static Sky Processed 
+FILE  staticskyProcessedSkyfile.php
+MENU  ipp.stack.dat
+
+WHERE staticskyRun.sky_id = staticskyInput.sky_id
+WHERE staticskyInput.stack_id = stackRun.stack_id
+WHERE staticskyInput.sky_id = staticskyResult.sky_id
+
+#        field                          size  format  name           show     link to         extras
+FIELD staticskyRun.sky_id,          5, %s,     Sky ID
+FIELD staticskyRun.label,    	    7, %s,     Label
+FIELD staticskyRun.state,    	    7, %s,     State
+FIELD stackRun.stack_id,            5, %s,     Stack ID
+FIELD stackRun.skycell_id,          5, %s,     Skycell ID
+FIELD stackRun.tess_id,             5, %s,     Tess ID
+FIELD stackRun.filter,              5, %s,     Filter 
+FIELD stackRun.label,               5, %s,     Stack Label
+FIELD staticskyRun.data_group, 	    7, %s,     data grp
+FIELD staticskyRun.dist_group, 	    7, %s,     dist grp
+FIELD staticskyResult.dtime_phot,   7, %.2f,   t(phot)
+FIELD staticskyResult.dtime_script, 7, %.2f,   t(script)
+FIELD staticskyResult.sources,      7, %d,     n(sources)
+FIELD staticskyResult.fault,        7, %d,     fault
+FIELD staticskyResult.quality,      7, %d,     quality
Index: /trunk/ippMonitor/def/fullforceRun.d
===================================================================
--- /trunk/ippMonitor/def/fullforceRun.d	(revision 38223)
+++ /trunk/ippMonitor/def/fullforceRun.d	(revision 38223)
@@ -0,0 +1,15 @@
+TABLE staticskyRun
+TITLE staticskyRun
+FILE  staticskyRun.php
+MENU  ipp.stack.dat
+
+#        field          size  format  name           show     link to         extras
+FIELD    sky_id,	 5,   %s,     Sky ID
+# FIELD    skycell_id,	 5,   %s,     Skycell ID
+FIELD    label,	 	 5,   %s,     Label
+FIELD    data_group, 	 5,   %s,     Data grp
+FIELD    dist_group,	 5,   %s,     Dist grp
+FIELD    state,		 5,   %s,     State
+
+#FIELD    registered,	 5,   %s,     time registered
+#FIELD    workdir,	10,   %s,     workdir
Index: /trunk/ippMonitor/def/fullforceSummary.d
===================================================================
--- /trunk/ippMonitor/def/fullforceSummary.d	(revision 38223)
+++ /trunk/ippMonitor/def/fullforceSummary.d	(revision 38223)
@@ -0,0 +1,16 @@
+TABLE staticskyRun
+TITLE Static Sky Summary
+FILE  staticskySummary.php
+MENU  ipp.stack.dat
+
+#     field           size  format  name         show    link to         extras
+FIELD label,    	 15, %s,    label
+FIELD data_group,        10, %s,    data_group
+FIELD workdir,    	 7, %s,     workdir
+FIELD state,    	 7, %s,     state
+FIELD count(state) as n, 7, %d,     count
+
+MODE  summary
+GROUP state
+GROUP label
+GROUP workdir
Index: /trunk/ippMonitor/def/fullforce_failure.d
===================================================================
--- /trunk/ippMonitor/def/fullforce_failure.d	(revision 38223)
+++ /trunk/ippMonitor/def/fullforce_failure.d	(revision 38223)
@@ -0,0 +1,27 @@
+TABLE staticskyRun JOIN staticskyResult USING(sky_id) JOIN staticskyInput USING(sky_id) JOIN stackRun USING(stack_id)
+TITLE Static Sky Failed (Log)
+FILE  failedStaticsky.php
+MENU  ipp.stack.dat
+
+WHERE staticskyResult.fault != 0
+
+ARGS  ARG1   staticskyResult.path_base=$staticskyResult.path_base
+
+#        field                          size  format  name           show     link to         extras
+FIELD staticskyRun.sky_id,          5, %d,     Sky ID
+FIELD staticskyRun.label,    	    7, %s,     Label
+FIELD staticskyRun.state,    	    7, %s,     State,		value,		staticsky_failure.php, ARG1
+FIELD stackRun.skycell_id,          5, %s,     Skycell ID
+FIELD stackRun.tess_id,             5, %s,     Tess ID
+FIELD count(stackRun.filter),       5, %d,     #Filters	
+FIELD stackRun.label,               5, %s,     Stack Label
+FIELD staticskyRun.data_group, 	    7, %s,     data grp
+FIELD staticskyRun.dist_group, 	    7, %s,     dist grp
+FIELD staticskyResult.sources,      7, %d,     n(sources)
+FIELD staticskyResult.fault,        7, %d,     fault
+FIELD staticskyResult.quality,      7, %d,     quality
+FIELD staticskyResult.path_base,    5, %s,     path_base,     none
+
+GROUP staticskyRun.sky_id
+
+TAIL PHP insert_log ('LOG.EXP');
