== Detection Batches (PV2) ==

as a reference, the old (pv1) version of the tables -> [wiki:ippToPsps_Stack]

== Proposed ippToPsps mappings ==

||'''ODM attribute'''||	'''units'''	||'''Data type'''	||'''Default'''	||'''Description'''	||'''IPP source'''	||'''IPP variable/notes'''||'''HAFcomments''' ||
||'''StackDetection'''|| || || || || || || ||
||objID 		||dimensionless ||	BIGINT 	8 ||	NA ||	ODM object identifier
||surveyID 	||dimensionless ||	TINYINT	1 ||	NA 	||survey flag identifier
||skyCellID 	||dimensionless ||	INT 	4 ||	-999 	||skycell identifier
||primarySkyCell ||	dimensionless ||	TINYINT 1 ||	255|| 	identifies best stack detection for Stacks overlapping the same region of the sky.
||projectionCell || Ddimensionless ||	INT 	4 ||	-999 	||projection cell identifier
||stackDetectID ||	dimensionless ||	BIGINT 	8 ||	NA ||	ODM detection identifier
||ippDetectID 	|| dimensionless ||	BIGINT 	8 ||	NA 	||detection ID generated by IPP
||assocDate 	|| dimensionless ||	DATE 	8  ||     28881231 ||	date object association assigned
||historyModNum || 	dimensionless ||	SMALLINT 2 ||	0 ||	modification number in the O-D association history
||dataRelease 	|| dimensionless ||	TINYINT 1 ||	NA|| 	Data release when this detection was originally taken.
||repeat below for each filter  || || || || attributes for all  stack detections in all filters (these are currently forced anyway) 
||gStackMetaID ||	dimensionless 	||BIGINT 	8 	||NA 	stack identifier
||gxPos 	        ||pixels 	||	REAL 	4 ||	-999 	||measured x in sky Cell from PSF fit
||gyPos 	        ||pixels 	||	REAL 	4 ||	-999 	||measured y in sky Cell from PSF fit
||gxPosErr 	||pixels 	||	REAL 	4 ||	-999 	||estimated error in x
||gyPosErr 	||pixels    ||		REAL 	4|| 	-999 ||	estimated error in y
||gra            ||  degrees         || FLOAT   8  ||      NA       ||Right Ascension   || from stackDetectionCalib
||gdec            || degrees    ||      FLOAT   8    ||    NA      || Declination        || from stackDetectionCalib
||graErr           ||arcsec   ||	REAL    4      ||  NA      || Right Ascension error || from stackDetectionCalib
||gdecErr          ||arcsec  || 	REAL    4       || NA      || Declination error  (same as RA error - need?) || from stackDetectionCalib
||gzp              ||magnitude   ||     REAL    4       || 0        ||zeropoint , no error given  || from stackDetectionCalib
||gexpTime   ||      seconds      ||    REAL    4        ||-999     ||total exposure time (informational) || from stackDetectionCalib
||gpsfFlux  ||	adu/seconds  ||	REAL 	4 	 ||-999  ||	PSF instrumental flux
||gpsfFluxErr  ||	adu/seconds || 	REAL 	4  ||	-999 	 ||Estimated error in instrumental flux
||gpeakFlux  ||	adu 	 ||	REAL 	4  ||	-999  ||	ratio of peak  flux to total flux
||gpsfMajorFWHM 	 ||arcsec 	 ||	REAL 	4 	 ||-999 	 ||PSF width in major axis
||gpsfMinorFWHM 	 ||arcsec 	 ||	REAL 	4 	 ||-999 	 ||PSF width in minor axis
||gpsfThetaFWHM || 	degrees 	 ||REAL 	4  ||	-999 	 ||PSF orientation angle. Degrees East of North.
||gpsfMxx 	 ||pixels squared  ||	REAL 	4  ||	-999  ||	PSF orientation angle. Degrees East of North.
||gpsfMxy 	 ||pixels squared   ||REAL	4  ||	-999  ||	PSF width in major axis
||gpsfMyy 	 ||pixels squared	 ||REAL 	4  ||	-999  ||	PSF width in minor axis
||gpsfLikelihood  ||	dimensionless 	 ||REAL 	4  ||	-999  ||	PSF likelihood
||gpsfQf 		 ||dimensionless 	 ||REAL 	4  ||	-999  ||	PSF coverage factor
||gpsfQfPerfect  ||	dimensionless 	 ||REAL 	4  ||	-999  ||	PSF-weighted fraction of pixels totally unmasked
||gpsfChiSq 	 ||dimensionless 	 ||REAL 	4  ||	-999  ||	PSF-weighted fraction of pixels to.
||gmomentXX 	 ||pixels squared ||	REAL 	4  ||	-999 || 	moment XX
||gmomentXY  ||	pixels squared	 ||REAL 	4  ||	-999  ||	moment XY
||gmomentYY  ||	pixels squared	 ||REAL 	4  ||	-999  ||	moment YY
||gmomentM3C ||	pixels squared 	||REAL 	4 ||	-999 ||	moment M3C
||gmomentM3S ||	pixels squared 	||REAL 	4 ||	-999 ||	moment M3S
||gmomentM4C ||	pixels squared ||	REAL 	4 ||	-999 ||	moment M4C
||gmomentM4S ||	pixels squared|| 	REAL 	4 ||	-999 ||	moment M4S
||gmomentR1 ||	pixels 	||	REAL 	4 ||	-999 ||	moment R1
||gmomentRH ||	sqrt pixels ||	REAL 	4 ||	-999 ||	moment RH   (drop?)
||gApFlux ||	adu/seconds 	||REAL 	4 ||	-999 	||Aperture magnitude
||gApFluxErr ||	adu/seconds 	||REAL 	4 ||	-999 	||Aperture magnitude error
||gApFillFac    ||  dimensionless  || REAL    4  ||     -999 ||   Aperture fill factor - ~ redundant with psfQF, keep?
||gKronFlux ||	adu/seconds 	||REAL 	4 ||	-999 ||	Kron flux
||gKronFluxErr|| 	adu/seconds ||	REAL 	4|| 	-999 ||	Kron flux error
||gKronRad ||	arcsec 		||REAL 	4 ||	-999 ||	Kron radius
||gSky 	||	adu/secs/pixel ||	REAL 	4 ||	-999 ||	PSF sky level at source (adu)
||gSkyErr ||	adu/secs/pixel ||	REAL 	4 ||	-999 ||	estimated error in sky
||gSGsep1 	||dimensionless ||	REAL 	4 ||	-999 ||	star/galaxy separator
||ginfoFlag 	||dimensionless ||	BIGINT 	8 ||	-999 ||	indicator of strange propeties
||gnFrames 	||dimensionless|| 	INT 	4 ||	-999 ||	Number of frames contributing to source

Heather has a lot of problems with this - it looks more like an object table, not the stack table. It's lacking metadata to go back to the stacks, and it's lacking time domain information.  ippToPsps ingests one stack at a time, this would imply 5 (?).