Detection Batches (PV2)

as a reference, the old (pv1) version of the tables -> 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 (?).