Index: trunk/ippToPsps/config/object/tables.xml
===================================================================
--- trunk/ippToPsps/config/object/tables.xml	(revision 28564)
+++ trunk/ippToPsps/config/object/tables.xml	(revision 28564)
@@ -0,0 +1,105 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<tableDescriptions type="object">
+  <table name="Object">
+    <column name="objID" type="TLONGLONG" default="0" comment="ODM object identifier index"></column>
+    <column name="ippObjID" type="TLONGLONG" default="0" comment="IPP object number"></column>
+    <column name="projectionCellID" type="TLONG" default="-999" comment="projection cell identifier at discovery time"></column>
+    <column name="htmID" type="TLONGLONG" default="0" comment="HTM index"></column>
+    <column name="zoneID" type="TLONG" default="0" comment="Zone index"></column>
+    <column name="stackVer" type="TSHORT" default="-999 -" comment="static stack version number"></column>
+    <column name="objInfoFlag" type="TLONG" default="-999" comment="flag indicating odd properties"></column>
+    <column name="varFlag" type="TBYTE" default="0" comment="variable in difference image detections"></column>
+    <column name="surveyID" type="TBYTE" default="255" comment="Survey ID"></column>
+    <column name="ra" type="TDOUBLE" default="0" comment="Right Ascension"></column>
+    <column name="dec" type="TDOUBLE" default="0" comment="Declination"></column>
+    <column name="raErr" type="TFLOAT" default="0.0" comment="Right Ascension error"></column>
+    <column name="decErr" type="TFLOAT" default="0.0" comment="Declination error"></column>
+    <column name="cx" type="TDOUBLE" default="0" comment="Cartesian x"></column>
+    <column name="cy" type="TDOUBLE" default="0" comment="Cartesian y"></column>
+    <column name="cz" type="TDOUBLE" default="0" comment="Cartesian z"></column>
+    <column name="lambda" type="TDOUBLE" default="-999" comment="ecliptic longitude"></column>
+    <column name="beta" type="TDOUBLE" default="-999" comment="ecliptic latitude"></column>
+    <column name="l" type="TDOUBLE" default="-999" comment="galactic longitude"></column>
+    <column name="b" type="TDOUBLE" default="-999" comment="galactic latitude"></column>
+    <column name="lsg" type="TDOUBLE" default="-999" comment="supergalactic longitude"></column>
+    <column name="bsg" type="TDOUBLE" default="-999" comment="supergalactic latitude"></column>
+    <column name="nDetections" type="TSHORT" default="-999" comment="total number of detection measurements in all filters"></column>
+    <column name="raMean" type="TDOUBLE" default="-999" comment="mean RA of object"></column>
+    <column name="decMean" type="TDOUBLE" default="-999" comment="mean DEC of object"></column>
+    <column name="raMeanErr" type="TFLOAT" default="-999" comment="estimated error in raMean"></column>
+    <column name="decMeanErr" type="TFLOAT" default="-999" comment="estimated error in decMean"></column>
+    <column name="ng" type="TSHORT" default="-999" comment="number of measures in g filter"></column>
+    <column name="gMeanMag" type="TFLOAT" default="-999" comment="mean g magnitude"></column>
+    <column name="gMeanFlux" type="TFLOAT" default="-999" comment="mean g flux"></column>
+    <column name="gMeanMagErr" type="TFLOAT" default="-999" comment="estimated error of g magnitude mean"></column>
+    <column name="gMeanFluxErr" type="TFLOAT" default="-999" comment="estimated error of g flux mean"></column>
+    <column name="gMin" type="TFLOAT" default="-999" comment="minimum g magnitide"></column>
+    <column name="gMax" type="TFLOAT" default="-999" comment="maximum g magnitude"></column>
+    <column name="nr" type="TSHORT" default="-999" comment="number of measures in r filter"></column>
+    <column name="rMeanMag" type="TFLOAT" default="-999" comment="mean r magnitude"></column>
+    <column name="rMeanFlux" type="TFLOAT" default="-999" comment="mean r flux"></column>
+    <column name="rMeanMagErr" type="TFLOAT" default="-999" comment="estimated error of r magnitude mean"></column>
+    <column name="rMeanFluxErr" type="TFLOAT" default="-999" comment="estimated error of r flux mean"></column>
+    <column name="rMin" type="TFLOAT" default="-999" comment="minimum r magnitude"></column>
+    <column name="rMax" type="TFLOAT" default="-999" comment="maximum r magnitude"></column>
+    <column name="ni" type="TSHORT" default="-999" comment="number of measures in i filter"></column>
+    <column name="iMeanMag" type="TFLOAT" default="-999" comment="mean i magnitude"></column>
+    <column name="iMeanFlux" type="TFLOAT" default="-999" comment="mean i flux"></column>
+    <column name="iMeanMagErr" type="TFLOAT" default="-999" comment="estimated error of i magitude mean"></column>
+    <column name="iMeanFluxErr" type="TFLOAT" default="-999" comment="estimated error of i flux mean"></column>
+    <column name="iMin" type="TFLOAT" default="-999" comment="minimum i magniutde"></column>
+    <column name="iMax" type="TFLOAT" default="-999" comment="maximum i magnitude"></column>
+    <column name="nz" type="TSHORT" default="-999" comment="number of measures in z filter"></column>
+    <column name="zMeanMag" type="TFLOAT" default="-999" comment="mean z magnitude"></column>
+    <column name="zMeanFlux" type="TFLOAT" default="-999" comment="mean z flux"></column>
+    <column name="zMeanMagErr" type="TFLOAT" default="-999" comment="estimated error of z magnitude mean"></column>
+    <column name="zMeanFluxErr" type="TFLOAT" default="-999" comment="estimated error of z flux mean"></column>
+    <column name="zMin" type="TFLOAT" default="-999" comment="minimum z magnitude"></column>
+    <column name="zMax" type="TFLOAT" default="-999" comment="maximum z magnitude"></column>
+    <column name="ny" type="TSHORT" default="-999" comment="number of measures in y filter"></column>
+    <column name="yMeanMag" type="TFLOAT" default="-999" comment="mean y magnitude"></column>
+    <column name="yMeanFlux" type="TFLOAT" default="-999" comment="mean y flux"></column>
+    <column name="yMeanMagErr" type="TFLOAT" default="-999" comment="estimated error of y magnitude mean"></column>
+    <column name="yMeanFluxErr" type="TFLOAT" default="-999" comment="estimated error of y flux mean"></column>
+    <column name="yMin" type="TFLOAT" default="-999" comment="minimum y magnitude"></column>
+    <column name="yMax" type="TFLOAT" default="-999" comment="maximum y magnitude"></column>
+    <column name="nw" type="TSHORT" default="-999" comment="number of measures in the wide (w) solar system filter"></column>
+    <column name="wMeanMag" type="TFLOAT" default="-999" comment="mean w magnitude"></column>
+    <column name="wMeanFlux" type="TFLOAT" default="-999" comment="mean w flux"></column>
+    <column name="wMeanMagErr" type="TFLOAT" default="-999" comment="estimated error of w magnitude mean"></column>
+    <column name="wMeanFluxErr" type="TFLOAT" default="-999" comment="estimated error of w flux mean"></column>
+    <column name="wMin" type="TFLOAT" default="-999" comment="minimum w magnitude"></column>
+    <column name="wMax" type="TFLOAT" default="-999" comment="maximum w magnitude"></column>
+    <column name="grMeanColor" type="TFLOAT" default="-999" comment="g-r color from gMean &amp;amp; rMean"></column>
+    <column name="riMeanColor" type="TFLOAT" default="-999" comment="r-i color from rMean &amp;amp; iMean"></column>
+    <column name="izMeanColor" type="TFLOAT" default="-999" comment="i-z color from iMean &amp;amp; zMean"></column>
+    <column name="zyMeanColor" type="TFLOAT" default="-999" comment="z-y color from zMean &amp;amp; yMean"></column>
+    <column name="grMeanColorErr" type="TFLOAT" default="-999" comment="Estimated error in g-r color from gMean &amp;amp; rMean"></column>
+    <column name="riMeanColorErr" type="TFLOAT" default="-999" comment="Estimated error in r-i color from rMean &amp;amp; iMean"></column>
+    <column name="izMeanColorErr" type="TFLOAT" default="-999" comment="Estimated error in i-z color from iMean &amp;amp; zMean"></column>
+    <column name="zyMeanColorErr" type="TFLOAT" default="-999" comment="Estimated error in z-y color from zMean &amp;amp; yMean"></column>
+    <column name="gMagBest" type="TFLOAT" default="-999" comment="g magnitude from stack frames"></column>
+    <column name="gModID" type="TSHORT" default="-999" comment="index of which g model magnitude was used from stack"></column>
+    <column name="rMagBest" type="TFLOAT" default="-999" comment="r magnitude from stack frames"></column>
+    <column name="rModID" type="TSHORT" default="-999" comment="index of which r model magnitude was used from stack"></column>
+    <column name="iMagBest" type="TFLOAT" default="-999" comment="i magnitude from stack frames"></column>
+    <column name="iModID" type="TSHORT" default="-999" comment="index of which i model magnitude was used from stack"></column>
+    <column name="zMagBest" type="TFLOAT" default="-999" comment="z magnitude from stack frames"></column>
+    <column name="zModID" type="TSHORT" default="-999" comment="index of which z model magnitude was used from stack"></column>
+    <column name="yMagBest" type="TFLOAT" default="-999" comment="y magnitude from stack frames"></column>
+    <column name="yModID" type="TSHORT" default="-999" comment="index of which y model magnitude was used from stack"></column>
+    <column name="grColor" type="TFLOAT" default="-999" comment="g-r color from gmag and rmag"></column>
+    <column name="riColor" type="TFLOAT" default="-999" comment="r-i color from rmag and imag"></column>
+    <column name="izColor" type="TFLOAT" default="-999" comment="i-z color from imag and zmag"></column>
+    <column name="zyColor" type="TFLOAT" default="-999" comment="z-y color from zmag and ymag"></column>
+    <column name="g" type="TFLOAT" default="-999" comment="star/galaxy separator in g filer"></column>
+    <column name="r" type="TFLOAT" default="-999" comment="star/galaxy separator in r filer"></column>
+    <column name="i" type="TFLOAT" default="-999" comment="star/galaxy separator in i filer"></column>
+    <column name="z" type="TFLOAT" default="-999" comment="star/galaxy separator in z filer"></column>
+    <column name="y" type="TFLOAT" default="-999" comment="star/galaxy separator in y filer"></column>
+    <column name="sgSep" type="TFLOAT" default="-999" comment="star/galaxy separator - true if any one color is"></column>
+    <column name="consistencyFlag" type="TSHORT" default="0" comment="Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation"></column>
+    <column name="dataRelease" type="TBYTE" default="0" comment="Data release"></column>
+  </table>
+</tableDescriptions>
Index: trunk/ippToPsps/scripts/pspsSchema2xml.pl
===================================================================
--- trunk/ippToPsps/scripts/pspsSchema2xml.pl	(revision 28559)
+++ trunk/ippToPsps/scripts/pspsSchema2xml.pl	(revision 28564)
@@ -31,5 +31,5 @@
         -msg => "\n   Required options:\n\n".
         "--schema <path to PSPS schema>\n".
-        "--type <init|det|diff|stack>\n".
+        "--type <init|det|diff|stack|object>\n".
         -exitval => 3
         ) unless
@@ -37,5 +37,5 @@
 defined $type;
 
-if ($type ne "init" && $type ne "det" && $type ne "diff" && $type ne "stack") {
+if ($type ne "init" && $type ne "det" && $type ne "diff" && $type ne "stack" && $type ne "object" ) {
 
     print "Don't understand type '$type'\n"; 
@@ -60,4 +60,5 @@
 elsif ($type eq "diff") {createDiffs();}
 elsif ($type eq "stack") {createStacks();}
+elsif ($type eq "object") {createObjects();}
 
 # finish up XML
@@ -170,4 +171,14 @@
 #######################################################################################
 #
+# Creates object batch tables
+#
+#######################################################################################
+sub createObjects {
+
+    parseTable("Object");
+}
+
+#######################################################################################
+#
 # Parses a particular table from the SQL file and converts it to an XML description 
 #
