== Detection Batches (PV2) ==

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

== Proposed ippToPsps mappings ==

||'''ODM attribute'''||	'''units'''	||'''Data type'''	||'''Default'''	||'''Description'''	||'''IPP source'''	||'''IPP variable/notes'''||'''HAFcomments''' ||
||'''Detection'''|| || || || || || || ||
||objID 		||dimensionless ||	BIGINT 	8 ||	NA ||	ODM object identifier
||detectID 	||dimensionless ||	BIGINT 	8 ||	NA ||	ODM detection identifier
||ippDetectID 	||dimensionless ||	BIGINT 	8 ||	NA ||	detection id generated by IPP
||filterID 	        ||dimensionless ||	TINYINT 	1 ||	NA ||	filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ...
||surveyID 	||dimensionless ||	TINYINT 	1 ||	NA ||	survey flag identifier
||imageID 	        ||dimensionless ||	BIGINT   	8 ||	NA ||	image id hash of frame identifier & OTA/CCD number
||obsTime 	||!MeanJulianDays ||	FLOAT   	8 ||	-999 ||	Time of mid observation in Mean Julian Days
||xPos 		||raw pixels ||	REAL 	4 ||	-999 ||	measured x on CCD from PSF fit
||yPos 		||raw pixels ||	REAL 	4 ||	-999 ||	measured y on CCD from PSF fit
||xPosErr 	        ||raw pixels ||	REAL 	4 ||	-999 ||	estimated error in x
||yPosErr 	        ||raw pixels ||	REAL 	4 ||	-999 ||	estimated error in y
||ra                   ||degrees     ||   FLOAT   8   ||    NA   ||   Right Ascension  || was in detectionCalib before
||dec                ||degrees      ||   FLOAT   8    ||   NA    ||  Declination        || was in detectionCalib before
||raErr              ||arcsec        ||  REAL    4    ||   NA    ||  Right Ascension error || was in detectionCalib before
||decErr         || arcsec      ||    REAL    4    ||   NA   ||   Declination error    || was in detectionCalib before
||zp              ||magnitude   ||    REAL    4    ||   0      || zeropoint (only thing needed to convert adu/sec to AB mag), note no zpErr  || was in detectionCalib before
||telluricExt     ||magnitude   ||    REAL    4    ||   NA     || estimated extinction due to non-photometric conditions  || new
||expTime         ||seconds       ||  REAL    4     ||  -999  ||  exposure time (informational)  || was in detectionCalib beofre
||airmass         ||dimensionless ||  REAL    4    ||   0    ||   airmass (informational)  || was in detectionCalib before
||psfFlux 	        ||adu/seconds 	||REAL 	4 	||-999 ||	PSF instrumental flux (in analog-to-digital units/sec) or adu/sec
||psfFluxErr 	||adu/seconds 	||REAL 	4 ||	-999 ||	estimated error in flux
||peakADU 	||adu 		||REAL 	4 ||	-999 ||	peak count in source pixel - where counts are anlog-to-digital units
||psfWidMajor 	||arcsec 		||REAL 	4 ||	-999 ||	model PSF width in major axis
||psfWidMinor 	||arcsec 		||REAL 	4 ||	-999 ||	model PSF width in minor axis
||psfTheta 	||degrees 	||REAL 	4 ||	-999 ||	model PSF orientation angle degrees East of North
||psfQf 		||dimensionless ||	REAL 	4 ||	-999 ||	PSF coverage factor
||psfQfPerfect 	||dimensionless ||	REAL 	4 ||	-999 ||	PSF-weighted fraction of pixels totally unmasked
||psfChiSq 	||dimensionless|| 	REAL 	4 ||	-999 ||	reduced-chisq of the psf model fit. (ndof?, npix?)
||psfLikelihood 	||dimensionless ||	REAL 	4 ||	-999 ||	PSF likelihood
||momentXX 	||raw pixels ||	REAL 	4 ||	-999 ||	moment XX
||momentXY 	||raw pixels ||	REAL 	4 ||	-999 ||	moment XY
||momentYY 	||raw pixels ||	REAL 	4 ||	-999 ||	momeny YY
||momentM3C 	||raw pixels ||	REAL 	4 ||	-999 ||	3rd moment sin(theta)    || these are new
||momentM3S 	||raw pixels ||	REAL 	4 ||	-999 ||	3rd moment cos(theta)   || these are new
||momentM4C 	||raw pixels ||	REAL 	4 ||	-999 ||	4th moment sin(theta)  || these are new
||momentM4S  	||raw pixels ||	REAL 	4 ||	-999 ||	4th moment cos(theta)   || these are new
||momentR1 	||raw pixels ||	REAL 	4 ||	-999 ||	first radial moment          || these are new
||momentRH   	||raw pixels ||	REAL 	4 ||	-999 ||	half radial moment        || these are new
||apFlux 		||adu/seconds ||	REAL 	4 ||	-999 ||	Aperture flux
||apFluxErr 	||adu/seconds 	||REAL 	4 ||	-999 ||	Aperture flux error
||apFillF            ||dimensionless  || REAL    4 ||      -999   || Aperture fill factor      || these are new 
||kronFlux 	||adu/seconds 	||REAL 	4 ||	-999 ||	Kron flux
||kronFluxErr 	||adu/seconds 	||REAL 	4 ||	-999 ||	Kron flux error
||kronRad 	||raw pixels 	||REAL 	4 ||	-999 ||	Kron radius
||kronRadErr 	||raw pixels 	||REAL 	4 ||	-999 ||	Kron radius error
||sky 		||adu/sec/pixel ||	REAL 	4 	||-999 ||	PSF sky level at source
||skyErr 		||adu/sec/pixel ||	REAL 	4 	||-999 ||	estimated error in sky
||sgSep1 		||dimensionless ||	REAL 	4 	||-999 ||	star/galaxy separator 1     || these are new - assume this is sgSep in old
||sgSep2 		||dimensionless ||	REAL 	4 	||-999 ||	star/galaxy separator 2       || these are new
||sgSep3 		||dimensionless ||	REAL 	4 	||-999 ||	star/galaxy separator 3        || these are new
||infoFlag 	        ||dimensionless ||	BIGINT 	8 	||-999 ||	flag indicating provenance information
||dataRelease 	||dimensionless ||	TINYINT 1 	||NA|| 	Data release when this detection was originally taken. Recalibrations do not affect this value.