Back to ippToPsps main page

Stack batches

PSPS loads both nightly and deep stacks from the IPP. For deep stacks, two extra tables are produced: StackApFlx and StackModelFit. The input for both are IPP cmf files produced at the stack stage of the pipeline. One FITS output is generated by the interface per skycell, per filter.

PSPS tables

1 Primary extension
1 StackMeta extension per skycell
1 StackDetection extension per skycell
1 StackToImage extension
1 SkinnyObject extension
1 ObjectCalColor extension

Deep stacks have two extra extensions.

1 StackApFlx extension per skycell
1 StackModelFit extension per skycell

The full table definitions can be seen here

Current IPP to PSPS mappings

The tables below detail the current mapping between IPP and PSPS. The source of cmf files queued by ippToPsps is a list of sky_ids that are loaded into the relevant DVO database. These sky_ids are then used to obtain metadata from the IPP GPC1 database, as well as the location of the cmf file themselves. For more information on the fields listed below, see also the following links:

• ​draft psphot manual
• description of psphotStack
• ​DVO description (see section Schema for table layouts)

StackMeta
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
stackMetaID	unknown	BIGINT	0	stack identifier	GPC1 database	stackRun.stack_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables.
skycellID	unknown	INT	0	skycell region identifier	GPC1 database	stackRun.skycell_id using sky_id and filter via staticskyInput, staticskyRun, and staticskyResult tables From, eg skycell.1133.081, use 1133081
surveyID	unknown	TINYINT	0	survey flag identifier	GPC1 database/DVO	We know survey from the DVO database in use, we then get the surveyID from the PSPS 'Survey' table here
photoCalID	unknown	INT	0	photometry code numerical id	DVO	image->photcode from Image structure
filterID	unknown	TINYINT	0	filter identifier	cmf primary header	FPA.FILTER. This single character filter (grizy) is then used to get the PSPS ID from Filter table here
stackTypeID	unknown	TINYINT	0	stack type identifier	DVO	Currently we have either DEEP_STACK or NIGHTLY_STACK, which we know when queuing up stacks. This is then used to get the PSPS ID from StackType table here
magSat	unknown	REAL	-999	saturation magnitude level	cmf primary header	FSATUR (not set?)
analVer	unknown	SMALLINT	-999	analysis version index	NA	empty CZW: header PHOT_V
expTime	s	REAL	-999	exposure time	cmf primary header	EXPTIME
nP2Images	unknown	SMALLINT	-999	number of P2 images contributing to this cell	GPC1	a count of images listed in the StackToImage table - see below
completMag	unknown	REAL	-999	95% completion level in mag	cmf primary header	FLIMIT (not set?) or from the deteff extension or the detection efficiency server?
astroScat	unknown	REAL	-999	astrometric scatter for chip	NA	empty
photoScat	unknown	REAL	-999	photometric scatter for chip	NA	empty
nAstroRef	unknown	INT	-999	number of astrometric reference sources	NA	empty
nPhoRef	unknown	INT	-999	number of photometric reference sources	NA	empty
psfModelID	unknown	VARCHAR(MAX)		PSF model identifier	cmf primary header	PSFMODEL
psfFwhm_mean	unknown	FLOAT	-999	mean PSF FWHM in the stack	cmf primary header	FWHM_MAJ
psfFwhm_max	unknown	FLOAT	-999	maximum PSF FWHM in the stack	cmf primary header	FW_MJ_UQ
photoZero	unknown	REAL	-999	local derived photometric zero point	cmf primary header	FPA.ZP
photoColor	unknown	REAL	-999	local derived photometric color term	NA	empty
ctype1	unknown	VARCHAR(MAX)		name of astrometric projection in RA	cmf primary header	CTYPE1
ctype2	unknown	VARCHAR(MAX)		name of astrometric projection in DEC	cmf primary header	CTYPE2
crval1	unknown	FLOAT	-999	RA corresponding to reference pixel	cmf primary header	CRVAL1
crval2	unknown	FLOAT	-999	DEC corresponding to reference pixel	cmf primary header	CRVAL2
crpix1	unknown	FLOAT	-999	reference pixel value for RA	cmf primary header	CRPIX1
crpix2	unknown	FLOAT	-999	reference pixel value for DEC	cmf primary header	CRPIX2
cdelt1	unknown	FLOAT	-999	scale factor for RA	cmf primary header	CDELT1
cdelt2	unknown	FLOAT	-999	scale factor for DEC	cmf primary header	CDELT2
pc001001	unknown	FLOAT	-999	elements of rotation/Dcale matrix	cmf primary header	PC001001
pc001002	unknown	FLOAT	-999	elements of rotation/Dcale matrix	cmf primary header	PC001002
pc002001	unknown	FLOAT	-999	elements of rotation/Dcale matrix	cmf primary header	PC002001
pc002002	unknown	FLOAT	-999	elements of rotation/Dcale matrix	cmf primary header	PC002002
calibModNum	unknown	SMALLINT	0	calibration modification number	NA	empty
dataRelease	unknown	TINYINT	0	Data release	NA	hardcoded to 1
StackDetection
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	dimensionless	BIGINT	0	ODM object identifier	DVO	ave.extID from dvoDetection structure
stackDetectID	dimensionless	BIGINT	0	ODM detection identifier	DVO	(10 * DVO meas.extID) + filterID
ippObjID	dimensionless	BIGINT	0	IPP object identifier	DVO	ave.catID*1000000000 + ave.objID from dvoDetection structure
ippDetectID	dimensionless	BIGINT	0	detection ID generated by IPP	cmf SkyChip.psf table	IPP_IDET
filterID	dimensionless	TINYINT	0	filter identifier	cmf primary header	Same as StackMeta. See above.
stackTypeID	dimensionless	TINYINT	0	stack type identifier	DVO	Same as StackMeta. See above.
surveyID	dimensionless	TINYINT	0	survey flag identifier	GPC1 database/DVO	Same as StackMeta. See above.
primaryF	dimensionless	TINYINT	255	identifies best stack detection for Stacks overlapping the same region of the sky.	NA	hardcoded to 0
stackMetaID	dimensionless	BIGINT	0	stack identifier	GPC1 database	Same as StackMeta. See above.
skyCellID	dimensionless	INT	-999	skycell identifier	GPC1 database	Same as StackMeta. See above.
projectionCellID	dimensionless	INT	-999	projection cell identifier	NA	from, eg skycell.1133.081, use 1133
~obsTime~	~day~	~FLOAT~	~-999~	~Time of mid observation~	~cmf primary header~	~MJD-OBS~ - relabeled and moved down below to be qf_perfect
xPos	pixels	REAL	-999	measured x on skycell from PSF fit - warped pixels = 0.25 arcsec	cmf SkyChip.psf table	X_PSF
yPos	pixels	REAL	-999	measured y on skycell from PSF fit	cmf SkyChip.psf table	Y_PSF
xPosErr	pixels	REAL	-999	estimated error in x	cmf SkyChip.psf table	X_PSF_SIG
yPosErr	pixels	REAL	-999	estimated error in y	cmf SkyChip.psf table	Y_PSF_SIG
~instFlux~ psfFlux	~unknown~ adu/sec	REAL	-999	PSF instrumental flux	cmf SkyChip.psf table and GPC1	POW(10.0, (-0.4*PSF_INST_MAG)) / expTime (where expTime is from StackMeta, see above)
~instFluxErr~ psfFluxErr	~unknown~ adu/sec	REAL	-999	estimated error in instrumental flux	cmf SkyChip.psf table and GPC1	ABS((PSF_INST_MAG_SIG*(POW(10.0, (-0.4*PSF_INST_MAG)) / expTime)) / 1.085736) (where expTime from StackMeta, see above)
peakFlux	~unknown~ adu	REAL	-999	ratio of peak flux to total flux	cmf SkyChip.psf table and GPC1	POW(10.0, (-0.4*PEAK_FLUX_AS_MAG)) / expTime (where expTime is from StackMeta, see above)
sky	~unknown~ adu/sec/pixel	REAL	-999	PSF sky level at source (adu)	cmf SkyChip.psf table	SKY
skyErr	~unknown~ adu/sec/pixel	REAL	-999	estimated error in sky	cmf SkyChip.psf table	SKY_SIGMA
sgSep	dimensionless	REAL	-999	star/galaxy separator	cmf SkyChip.psf table	~EXT_NSIGMA~ TBD
psfWidMajor	pixels	REAL	-999	PSF width in major axis	cmf SkyChip.psf table	PSF_MAJOR
psfWidMinor	pixels	REAL	-999	PSF width in minor axis	cmf SkyChip.psf table	PSF_MINOR
psfTheta	degrees East of North	REAL	-999	PSF orientation angle	cmf SkyChip.psf table	PSF_THETA
psfLikelihood	dimensionless	REAL	-999	PSF likelihood	cmf SkyChip.psf table	~erfc(abs(EXT_NSIGMA) / sqrt(2))~ sign(EXT_NSIGMA)*erfc(abs(EXT_NSIGMA) / sqrt(2))
~psfCf~ psfQf	dimensionless	REAL	-999	PSF coverage factor	cmf SkyChip.psf table	PSF_QF
psfQfPerfect	dimensionless	REAL	-999	PSF QF Perfect	cmf SkyChip.psf table	PSF_QF_PERFECT
momentXX	pixels	REAL	-999	moment XX	cmf SkyChip.psf table	MOMENTS_XX
momentXY	pixels	REAL	-999	moment XY	cmf SkyChip.psf table	MOMENTS_XY
momentYY	pixels	REAL	-999	moment YY	cmf SkyChip.psf table	MOMENTS_YY
momentM3C	pixels squared	REAL	-999	moment M3C	cmf SkyChip.psf table	MOMENTS_M3C
momentM3S	pixels squared	REAL	-999	moment M3S	cmf SkyChip.psf table	MOMENTS_M3S
momentM4C	pixels squared	REAL	-999	moment M4C	cmf SkyChip.psf table	MOMENTS_M4C
momentM4S	pixels squared	REAL	-999	moment M4S	cmf SkyChip.psf table	MOMENTS_M4S
momentR1	pixels	REAL	-999	moment R1	cmf SkyChip.psf table	MOMENTS_R1
momentRH	sqrt pixels	REAL	-999	moment RH	cmf SkyChip.psf table	MOMENTS_RH
~apMag~apFlux	~magnitude~adu/sec	REAL	-999	Aperture magnitude	cmf SkyChip.psf table	AP_MAG converted to flux
~apMagErr~apFluxErr	~magnitude~adu/sec	REAL	-999	Aperture magnitude error	NA	empty
kronFlux	~magnitude~adu/sec	REAL	-999	Kron flux	cmf SkyChip.psf table	KRON_FLUX / expTime
kronFluxErr	~magnitude~adu/sec	REAL	-999	Kron flux error	cmf SkyChip.psf table	KRON_FLUX_ERR / expTime
kronRad	arcsecs	REAL	-999	Kron radius	NA	empty CZW: generally 2.5 * MOMENTS_R1, except when MOMENTS_R1 is large or small set to MOMENTS_R1 * 2.5
~kronRadErr~ psfChiSq	~arcsecs~	REAL	-999	~Kron radius error~	from cmf SkyChip.psf table	~empty~ psf_chisq
infoFlag	dimensionless	BIGINT	-999	detection properties	cmf SkyChip.psf table	old (everything prior to SAS9:FLAGS << 32 | FLAGS2)sa9: FLAGS2 <<32 | FLAGS sa10: dbflags <<45 |FLAGS2 <<32 |FLAGS
nFrames	dimensionless	INT	-999	number of frames contributing to source	cmf SkyChip.psf table	N_FRAMES
activeFlag	dimensionless	TINYINT	-999	indicates whether this detection/orphan is still a detection/orphan	NA	hardcoded to 0
assocDate	Mean Julian Days	DATE	28881231	date object association assigned	NA	date that batch has been prepared
historyModNum	dimensionless	SMALLINT	0	modification number in the O-D association history	NA	hardcoded to 0
dataRelease	Mean Julian Days	TINYINT	0	Date release when this detection was originally taken.	NA	hardcoded to 1
StackApFlx
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	dimensionless - ditto for IDs	BIGINT	0	ODM object identifier	DVO	same as StackDetection - see above
stackDetectID	unknown	BIGINT	0	ODM detection identifier	DVO	same as StackDetection - see above
ippObjID	unknown	BIGINT	0	IPP object identifier	DVO	same as StackDetection - see above
ippDetectID	unknown	BIGINT	0	detection ID generated by IPP	cmf SkyChip.xrad extension	IPP_IDET
filterID	unknown	TINYINT	0	filter identifier	cmf primary header	Same as StackMeta. See above.
stackTypeID	unknown	TINYINT	0	stack type identifier	DVO	Same as StackMeta. See above.
surveyID	unknown	TINYINT	0	survey flag identifier	GPC1 database/DVO	Same as StackMeta. See above.
primaryF	unknown	TINYINT	255	identifies best stack detection for Stacks overlapping the same region of the sky.	NA	hardcoded to 0
stackMetaID	unknown	BIGINT	0	stack identifier	GPC1 database	Same as StackMeta. See above.
~isophotMag~ isophotFlux	adu/sec	REAL	-999	isophotal magnitude	NA	empty
~isophotMagErr~ isophotFluxErr	adu/sec	REAL	-999	estimated error in isophotal magnitude	NA	empty
isophotMajAxis	pixels	REAL	-999	isophotal Major Axis	NA	empty
isophotMajAxisErr	pixels	REAL	-999	estimated error in isophotal Major Axis	NA	empty
isophotMinAxis	pixels	REAL	-999	isophotal Minor Axis	NA	empty
isophotMinAxisErr	pixels	REAL	-999	estimated error in isophotal Minor Axis	NA	empty
isophotMajAxisGrad	pixels	REAL	-999	isophotal major axis gradient	NA	empty
isophotMinAxisGrad	pixels	REAL	-999	isophotal minor axis gradient	NA	empty
isophotPA	degrees East of North	REAL	-999	isophotal position angle	NA	empty
isophotPAErr	degrees	REAL	-999	estimated error in isophotal position angle	NA	empty
isophotPAGrad	dimensionless	REAL	-999	isophotal position angle gradient	NA	empty
petRadius	pixels	REAL	-999	Petrosian radius	cmf SkyChip.xsrc extension	PETRO_RADIUS
petRadiusErr	pixels	REAL	-999	estimated error inPetrosian radius	cmf SkyChip.xsrc extension	PETRO_RADIUS_ERR
~petMag~ petFlux	adu/sec	REAL	-999	Petrosian magntiude	cmf SkyChip.xsrc extension	PETRO_MAG
~petMagErr~ petFluxErr	adu/sec	REAL	-999	estimated error in petMag	cmf SkyChip.xsrc extension	PETRO_MAG_ERR
petR50	pixels	REAL	-999	Petrosian radius at 50% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_50
petR50Err	pixels	REAL	-999	estimated error inPetrosian radius at 50% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_50_ERR
petR90	pixels	REAL	-999	Petrosian radius at 90% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_90
petR90Err	pixels	REAL	-999	estimated error in Petrosian radius at 90% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_90_ERR
petCf	dimensionless	REAL	-999	Petrosian fit coverage factor	cmf SkyChip.xsrc extension	PETRO_FILL
flxR1	adu/sec	REAL	-999	Flux inside r = 1	cmf SkyChip.xrad extension	APER_FLUX_1 where PSF_FWHM IS NULL
flxR1Err	adu/sec	REAL	-999	estimated error is flxR1	cmf SkyChip.xrad extension	APER_FLUX_ERR_1 where PSF_FWHM IS NULL
flxR1Std	adu/sec	REAL	-999	estimated standard deviation in flxR1	cmf SkyChip.xrad extension	APER_FLUX_STDEV_1 where PSF_FWHM IS NULL
flxR1Fill	dimensionless	REAL	-999	estimated filling factor at R1	cmf SkyChip.xrad extension	APER_FILL_1 where PSF_FWHM IS NULL
repeat for R=2 -> 10
c1flxR1	unknown	REAL	-999	Flux inside r = 1	cmf SkyChip.xrad extension	APER_FLUX_1 where PSF_FWHM < 7.0
c1flxR1Err	unknown	REAL	-999	estimated error is c1flxR1	cmf SkyChip.xrad extension	APER_FLUX_ERR_1 where PSF_FWHM < 7.0
c1flxR1Std	unknown	REAL	-999	estimated standard deviation in c1flxR1	cmf SkyChip.xrad extension	APER_FLUX_STDEV_1 where PSF_FWHM < 7.0
c1flxR1Fill	unknown	REAL	-999	estimated filling factor at R1	cmf SkyChip.xrad extension	APER_FILL_1 where PSF_FWHM < 7.0
repeat for R=2 -> 10
c2flxR1	unknown	REAL	-999	Flux inside r = 1	cmf SkyChip.xrad extension	APER_FLUX_1 where PSF_FWHM > 7.0
c2flxR1Err	unknown	REAL	-999	estimated error is c2flxR1	cmf SkyChip.xrad extension	APER_FLUX_ERR_1 where PSF_FWHM > 7.0
c2flxR1Std	unknown	REAL	-999	estimated standard deviation in c2flxR1	cmf SkyChip.xrad extension	APER_FLUX_STDEV_1 where PSF_FWHM > 7.0
c2flxR1Fill	unknown	REAL	-999	estimated filling factor at R1	cmf SkyChip.xrad extension	APER_FILL_1 where PSF_FWHM > 7.0
repeat for R=2 -> 10
logC	dimensionless	REAL	-999	Abraham concentration index	NA	empty
logA	dimensionless	REAL	-999	Abraham asymmetry index	NA	empty
activeFlag	dimensionless	TINYINT	-999	indicates whether this detection/orphan is still a detection/orphan	NA	hardcoded to 0
dataRelease	dimensionless	TINYINT	0	Data release when this detection was taken	NA	hardcoded to 1
StackModelFit
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	unknown	BIGINT	0	ODM object identifier	DVO	same as StackDetection - see above
stackDetectID	dimensionless	BIGINT	0	ODM detection identifier	DVO	same as StackDetection - see above
ippObjID	dimensionless	BIGINT	0	IPP object identifier	DVO	same as StackDetection - see above
ippDetectID	dimensionless	BIGINT	0	detection ID generated by IPP	from SkyChip.xfit extension	IPP_IDET
filterID	dimensionless	TINYINT	0	filter identifier	cmf primary header	Same as StackMeta. See above.
stackTypeID	dimensionless	TINYINT	0	stack type identifier	DVO	Same as StackMeta. See above.
surveyID	dimensionless	TINYINT	0	survey flag identifier	GPC1 database/DVO	Same as StackMeta. See above.
primaryF	dimensionless	TINYINT	255	identifies best stack detection for Stacks overlapping the same region of the sky.	NA	hardcoded to 0
stackMetaID	dimensionless	BIGINT	0	stack identifier	GPC1 database	Same as StackMeta. See above.
deVRadius	arcsec	REAL	-999	deVaucouleurs radius	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_DEV
deVRadiusErr	arcsec	REAL	-999	estimated error in deVaucouleurs radius	NA	empty
~deVMag~deVFlux	~unknown~ adu/sec	REAL	-999	deVaucouleurs magntiude	cmf SkyChip.xfit extension	EXT_INST_MAG where MODEL_TYPE = PS_MODEL_DEV
~deVMagErr~deVFluxErr	~unknown~ adu/sec	REAL	-999	estimated error in deV_mag	cmf SkyChip.xfit extension	EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_DEV
deVAb	dimensionless	REAL	-999	deVaucoulerus axis ratio	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_DEV
deVAbErr	dimensionless	REAL	-999	estimated error in deVaucoulerus axis ratio	NA	empty
deVPhi	degrees East of North	REAL	-999	estmated phi of deVaucouleurs axis	cmf SkyChip.xfit extension	EXT_THETA where MODEL_TYPE = PS_MODEL_DEV
deVPhiErr	degrees	REAL	-999	estmated error of phi of deVaucouleurs axis	NA	empty
raDeVOff	pixels	REAL	-999	Offset in RA of deVaucouleurs fit from PSF RA	NA	empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT
decDeVOff	pixels	REAL	-999	Offset in DEC of deVaucouleurs fit from PSF DEC	NA	empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT
raDeVOffErr	arcsec	REAL	-999	estimated error in ra offset	NA	empty
decDeVOffErr	arcsec	REAL	-999	estimated error in dec offset	NA	empty
deVCf	dimensionless	REAL	-999	deVaucouleurs fit coverage factor	NA	empty
deVLikelihood	dimensionless	REAL	-999	deVaucouleurs fit likelihood factor	NA	empty
deVCovar11	dimensionless	REAL	-999	covariance for deVaucouleurs fit	cmf SkyChip.xfit extension	EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_DEV
deVCovar12	dimensionless	REAL	-999	covariance for deVaucouleurs fit	cmf SkyChip.xfit extension	EXT_COVAR_00_01 where MODEL_TYPE = PS_MODEL_DEV
repeat until deVCovar77 and EXT_COVAR_06_06
expRadius	pixels	REAL	-999	Exponential fit radius	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_EXP
expRadiusErr	pixels	REAL	-999	estimated error in Exponential fit radius	NA	empty
~expMag~expFlux	~unknown~ adu/s	REAL	-999	Exponential fit magntiude	cmf SkyChip.xfit extension	EXT_INST_MAG where MODEL_TYPE = PS_MODEL_EXP
~expMagErr~expFluxErr	~unknown~ adu/s	REAL	-999	estimated error in expMag	cmf SkyChip.xfit extension	EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_EXP
expAb	dimensionless	REAL	-999	Exponential fit axis ratio	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_EXP
expAbErr	dimensionless	REAL	-999	estimated error in Exponential fit axis ratio	NA	empty
expPhi	degrees	REAL	-999	estmated phi of Exponential axis	cmf SkyChip.xfit extension	EXT_THETA where MODEL_TYPE = PS_MODEL_EXP
expPhiErr	degrees	REAL	-999	estmated error of phi of Exponential axis	NA	empty
raExpOff	arcsec	REAL	-999	Offset in RA of Exponential fit from PSF RA	NA	empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT
decExpOff	arcsec	REAL	-999	Offset in DEC of Exponential fit from PSF DEC	NA	empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT
raExpOffErr	arcsec	REAL	-999	estimated error in raExpOff	NA	empty
decExpOffErr	arcsec	REAL	-999	estimated error in decExpOff	NA	empty
expCf	dimensionless	REAL	-999	Exponential fit coverage factor	NA	empty
expLikelihood	dimensionless	REAL	-999	Exponential fit likelihood factor	NA	empty
expCovar11	dimensionless	REAL	-999	covariance for Exponential fit	cmf SkyChip.xfit extension	EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_EXP
expCovar12	dimensionless	REAL	-999	covariance for Exponential fit	cmf SkyChip.xfit extension	EXT_COVAR_00_01 where MODEL_TYPE = PS_MODEL_EXP
repeat until expCovar77 and EXT_COVAR_06_06
serRadius	pixels	REAL	-999	Sersic radius	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_SERSIC
serRadiusErr	pixels	REAL	-999	estimated error in Sersic radius	NA	empty
~serMag~serFlux	~unknown~ adu/s	REAL	-999	Sersic magntiude	cmf SkyChip.xfit extension	EXT_INST_MAG where MODEL_TYPE = PS_MODEL_SERSIC
~serMagErr~serFluxErr	~unknown~ adu/s	REAL	-999	estimated error in serMag	cmf SkyChip.xfit extension	EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC
serAb	dimensionless	REAL	-999	Sersic axis ratio	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_SERSIC
serAbErr	dimensionless	REAL	-999	estimated error in Sersic axis ratio	cmf SkyChip.xfit extension	EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_SERSIC
serNu	dimensionless	REAL	-999	Sersic index	cmf SkyChip.xfit extension	EXT_PAR_07 where MODEL_TYPE = PS_MODEL_SERSIC
serNuErr	dimensionless	REAL	-999	estimated error in Sersic index	cmf SkyChip.xfit extension	SQRT(EXT_COVAR_07_07) where MODEL_TYPE = PS_MODEL_SERSIC
serPhi	degrees	REAL	-999	estmated phi of Sersic axis	cmf SkyChip.xfit extension	EXT_THETA where MODEL_TYPE = PS_MODEL_SERSIC
serPhiErr	degrees	REAL	-999	estmated error of phi of Sersic axis	NA	empty
raSerOff	arcsed	REAL	-999	Offset in RA of Sersic fit from PSF RA	NA	empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT
decSerOff	arcsec	REAL	-999	Offset in DEC of Sersic fit from PSF DEC	NA	empty CZW: can be calculatd from X_PSF-X_EXT and Y_PSF-Y_EXT
raSerOffErr	arcsec	REAL	-999	estimated error in raSerOff	NA	empty
decSerOffErr	arcsec	REAL	-999	estimated error in decSerOff	NA	empty
serCf	unknown	dimensionless -ditto	-999	Sersic fit coverage factor	NA	empty
serLikelihood	unknown	REAL	-999	Sersic fit likelihood factor	NA	empty
sersicCovar11	unknown	REAL	-999	covariance for Sersic fit	cmf SkyChip.xfit extension	EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_SERSIC
sersicCovar12	unknown	REAL	-999	covariance for Sersic fit	cmf SkyChip.xfit extension	EXT_COVAR_00_01 where MODEL_TYPE = PS_MODEL_SERSIC
repeat until sersicCovar88 and EXT_COVAR_07_07
activeFlag	unknown	TINYINT	-999	indicates whether this detection/orphan is still a detection/orphan	NA	hardcoded to 0
dataRelease	unknown	TINYINT	0	Data release when this detection was taken	NA	hardcoded to 1
StackToImage
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
stackMetaID	unknown	BIGINT	0	stack identifier	GPC1 database	Same as StackMeta. See above.
imageID	unknown	BIGINT	0	hashed exposure-ccdID identifier	GPC1 database	SELECT DISTINCT CONCAT(exp_id, SUBSTR(class_id, 3, 4)) FROM ( SELECT DISTINCT exp_id,class_id FROM warpSkyCellMap ... JOIN-ed using stack_id
SkinnyObject
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	unknown	BIGINT	0	ODM object identifier index	DVO	same as StackDetection - see above
ippObjID	unknown	BIGINT	0	IPP object number	DVO	same as StackDetection - see above
projectionCellID	unknown	INT	-999	projection cell identifier at discovery time	NA	same as StackDetection - see above
dataRelease	unknown	TINYINT	0	Data release to propagate to the object	NA	hardcoded to 1
surveyID	unknown	TINYINT	255	surveyID </coluumn>	GPC1 database/DVO	Same as StackMeta. See above.
ObjectCalColor
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	unknown	BIGINT	0	ODM object identifier	DVO	same as StackDetection - see above
ippObjID	unknown	BIGINT	0	ipp object identifier	DVO	same as StackDetection - see above
filterID	unknown	TINYINT	0	filter identifier	cmf primary header	Same as StackMeta. See above.
calColor	mag	REAL	0	color adopted for magnitude calculation	NA	empty
calColorErr	mag	REAL	0	error in calibrating color	NA	empty
calibModNum	unknown	SMALLINT	0	calibration modification number	NA	empty
dataRelease	unknown	TINYINT	0	Data release when this color calibration was established	NA	hardcoded to 1
StackDetectionCalib	- previously all done by psps
ODM attribute	units	Data type	Default	Description	IPP source	IPP variable/notes
objID	BIGINT 8		NA	ODM object identifier	dvo
stackDetectID		BIGINT 8	NA	ODM detection identifier	dvo
ippObjID		BIGINT 8	NA	IPP object identifier	dvo
ippDetectID		BIGINT 8	NA	detection ID generated by IPP	dvo
filterID		TINYINT 1	NA	filter identifier	dvo
surveyID		TINYINT 1	NA	survey flag identifier	dvo
ra	degree	FLOAT 8	NA	Right Ascension	dvo
dec		FLOAT 8	NA	No comment	dvo
raErr	arcsec	REAL 4	0.0	Right Ascension error	dvo
decErr		REAL 4	NA	No comment	dvo
~calMag~ zp	mag	REAL 4	NA	~Observed, calibrated magnitude~ zeropoint	dvo
~calMagErr~ zpErr	mag	REAL 4	0.0	~Error in the observed, calibrated magnitude~ zeropoint err	dvo
~calFlux~ expTime	s	REAL 4	NA	~Calculated flux~ exptime	dvo
~calFluxErr~ airMass		REAL 4	0.0	~Error in the calculated flux~ airmass	dvo
dataRelease		TINYINT 1	NA	Data release when this detection was processed