== Diff Object (DO) batches == Diff Object batches (new for PV2) have one table * DiffDetObject --------------------------- === DiffDetObject VOTable description of PSPS table DifDetObject === --------------------------- ||diffObjName || alphanumeric || VARCHAR(100) || NA ||IAU Name constructed from objID position PS1.x JHHMMSS.SS+/-|| ||diffObjID || dimensionless || BIGINT 8 || NA ||ODM object identifier index|| ||diffgcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| ||ippObjID || dimensionless || BIGINT 8 || NA ||IPP object number|| ||surveyID || dimensionless || TINYINT 1 || 255 ||Survey ID|| ||skyCellID || dimensionless || REAL 4 || -999 ||single float giving PrimaryCell.SkyCell identifier|| ||htmID || dimensionless || BIGINT 8 || NA ||HTM index|| ||zoneID || dimensionless || INT 4 || NA ||Zone index|| ||randomID || dimensionless || BIGINT 8 || 0 ||Random integer between 0 and 2^32 = 4,394,967,296|| ||batchID || dimensionless || BIGINT 8 || -999 ||batchID|| ||dvoRegionID || dimensionless || REAL 4 || -999 ||identifier to dvo spatial region|| ||objInfoFlag || dimensionless || BIGINT 8 || -999 ||flag indicating odd properties|| ||qualityFlag || dimensionless || TINYINT 1 || 0 ||subset of objInfoFlag - flags related to goodness of object|| ||consistencyFlag || dimensionless || SMALLINT 2 || 0 ||Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation|| ||ra || degrees || FLOAT 8 || NA || Right Ascension|| ||dec || degrees || FLOAT 8 || NA || Declination|| ||raErr || arcsec || REAL 4 || 0.0 || Right Ascension error|| ||decErr || arcsec || REAL 4 || 0.0 || Declination error|| ||cx || dimensionless || FLOAT 8 || NA ||Cartesian x || ||cy || dimensionless || FLOAT 8 || NA ||Cartesian y || ||cz || dimensionless || FLOAT 8 || NA ||Cartesian z || ||lambda || degrees || FLOAT 8 || -999 || ecliptic longitude|| ||beta || degrees || FLOAT 8 || -999 || ecliptic latitude|| ||l || degrees || FLOAT 8 || -999 || galactic longitude|| ||b || degrees || FLOAT 8 || -999 || galactic latitude|| ||qfPerfect || dimensionless || REAL 4 || -999 ||qf perfect|| ||dataRelease || dimensionless || TINYINT 1 || NA ||Data release|| ||nDetections || dimensionless || SMALLINT 2 || -999 ||total number of detection measurements in all filters|| ||ng || dimensionless || SMALLINT 2 || -999 ||number of measures in g filter|| ||nr || dimensionless || SMALLINT 2 || -999 ||number of measures in r filter|| ||ni || dimensionless || SMALLINT 2 || -999 ||number of measures in i filter|| ||nz || dimensionless || SMALLINT 2 || -999 ||number of measures in z filter|| ||ny || dimensionless || SMALLINT 2 || -999 ||number of measures in y filter||