Back to ippToPsps main page

Outline

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 following table details 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.

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
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	NA	empty
analVer	unknown	SMALLINT	-999	analysis version index	NA	empty
expTime	s	REAL	-999	exposure time	GPC1	SELECT SUM(exp_time) * (COUNT(warp_id) - reject_images) / COUNT(warp_id) as EXPTIME FROM staticskyRun. JOIN-ed through numerous tables using stack_id starting point
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	NA	empty
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	NA	empty
psfFwhm_max	unknown	FLOAT	-999	maximum PSF FWHM in the stack	NA	empty
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	unknown	BIGINT	0	ODM object identifier	DVO	ave.extID from dvoDetection structure
stackDetectID	unknown	BIGINT	0	ODM detection identifier	DVO	meas.extID from dvoDetection structure
ippObjID	unknown	BIGINT	0	IPP object identifier	DVO	ave.catID*1000000000 + ave.objID from dvoDetection structure
ippDetectID	unknown	BIGINT	0	detection ID generated by IPP	cmf SkyChip.psf table	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.
skyCellID	unknown	INT	-999	skycell identifier	GPC1 database	Same as StackMeta. See above.
projectionCellID	unknown	INT	-999	projection cell identifier	NA	empty
obsTime	day	FLOAT	-999	Time of mid observation	cmf primary header	MJD-OBS
xPos	unknown	REAL	-999	measured x on CCD from PSF fit	cmf SkyChip.psf table	X_PSF
yPos	unknown	REAL	-999	measured y on CCD from PSF fit	cmf SkyChip.psf table	Y_PSF
xPosErr	unknown	REAL	-999	estimated error in x	cmf SkyChip.psf table	X_PSF_SIG
yPosErr	unknown	REAL	-999	estimated error in y	cmf SkyChip.psf table	Y_PSF_SIG
instFlux	unknown	REAL	-999	PSF instrumental flux	cmf SkyChip.psf table and GPC1	POW(10.0, (-0.4*PSF_INST_MAG)) / expTime (where expTime is as derived in StackMeta, see above)
instFluxErr	unknown	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 is as derived in StackMeta, see above)
peakFlux	unknown	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 as derived in StackMeta, see above)
sky	unknown	REAL	-999	PSF sky level at source (adu)	cmf SkyChip.psf table	SKY
skyErr	unknown	REAL	-999	estimated error in sky	cmf SkyChip.psf table	SKY_SIGMA
sgSep	unknown	REAL	-999	star/galaxy separator	cmf SkyChip.psf table	EXT_NSIGMA
psfWidMajor	unknown	REAL	-999	PSF width in major axis	cmf SkyChip.psf table	PSF_MAJOR
psfWidMinor	unknown	REAL	-999	PSF width in minor axis	cmf SkyChip.psf table	PSF_MINOR
psfTheta	unknown	REAL	-999	PSF orientation angle	cmf SkyChip.psf table	PSF_THETA
psfLikelihood	unknown	REAL	-999	PSF likelihood	NA	empty
psfCf	unknown	REAL	-999	PSF coverage factor	cmf SkyChip.psf table	PSF_QF
momentXX	arcsec	REAL	-999	moment XX	cmf SkyChip.psf table	MOMENTS_XX
momentXY	arcsec	REAL	-999	moment XY	cmf SkyChip.psf table	MOMENTS_XY
momentYY	arcsec	REAL	-999	moment YY	cmf SkyChip.psf table	MOMENTS_YY
momentM3C	arcsec	REAL	-999	moment M3C	cmf SkyChip.psf table	MOMENTS_M3C
momentM3S	arcsec	REAL	-999	moment M3S	cmf SkyChip.psf table	MOMENTS_M3S
momentM4C	arcsec	REAL	-999	moment M4C	cmf SkyChip.psf table	MOMENTS_M4C
momentM4S	arcsec	REAL	-999	moment M4S	cmf SkyChip.psf table	MOMENTS_M4S
momentR1	arcsec	REAL	-999	moment R1	cmf SkyChip.psf table	MOMENTS_R1
momentRH	arcsec	REAL	-999	moment RH	cmf SkyChip.psf table	MOMENTS_RH
apMag	magnitude	REAL	-999	Aperture magnitude	cmf SkyChip.psf table	AP_MAG
apMagErr	magnitude	REAL	-999	Aperture magnitude error	NA	empty
kronFlux	magnitude	REAL	-999	Kron flux	cmf SkyChip.psf table	KRON_FLUX
kronFluxErr	magnitude	REAL	-999	Kron flux error	cmf SkyChip.psf table	KRON_FLUX_ERR
kronRad	arcsecs	REAL	-999	Kron radius	NA	empty
kronRadErr	arcsecs	REAL	-999	Kron radius error	NA	empty
infoFlag	unknown	BIGINT	-999	indicator of strange propeties	cmf SkyChip.psf table	FLAGS << 32 | FLAGS2
nFrames	unknown	INT	-999	number of frames contributing to source	cmf SkyChip.psf table	N_FRAMES
activeFlag	unknown	TINYINT	-999	indicates whether this detection/orphan is still a detection/orphan	NA	hardcoded to 0
assocDate	unknown	DATE	28881231	date object association assigned	NA	date that batch has been prepared
historyModNum	unknown	SMALLINT	0	modification number in the O-D association history	NA	hardcoded to 0
dataRelease	unknown	TINYINT	0	Data 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	unknown	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	unknown	REAL	-999	isophotal magnitude	NA	empty
isophotMagErr	unknown	REAL	-999	estimated error in isophotal magnitude	NA	empty
isophotMajAxis	unknown	REAL	-999	isophotal Major Axis	NA	empty
isophotMajAxisErr	unknown	REAL	-999	estimated error in isophotal Major Axis	NA	empty
isophotMinAxis	unknown	REAL	-999	isophotal Minor Axis	NA	empty
isophotMinAxisErr	unknown	REAL	-999	estimated error in isophotal Minor Axis	NA	empty
isophotMajAxisGrad	unknown	REAL	-999	isophotal major axis gradient	NA	empty
isophotMinAxisGrad	unknown	REAL	-999	isophotal minor axis gradient	NA	empty
isophotPA	unknown	REAL	-999	isophotal position angle	NA	empty
isophotPAErr	unknown	REAL	-999	estimated error in isophotal position angle	NA	empty
isophotPAGrad	unknown	REAL	-999	isophotal position angle gradient	NA	empty
petRadius	unknown	REAL	-999	Petrosian radius	cmf SkyChip.xsrc extension	PETRO_RADIUS
petRadiusErr	unknown	REAL	-999	estimated error inPetrosian radius	cmf SkyChip.xsrc extension	PETRO_RADIUS_ERR
petMag	unknown	REAL	-999	Petrosian magntiude	cmf SkyChip.xsrc extension	PETRO_MAG
petMagErr	unknown	REAL	-999	estimated error in petMag	cmf SkyChip.xsrc extension	PETRO_MAG_ERR
petR50	unknown	REAL	-999	Petrosian radius at 50% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_50
petR50Err	unknown	REAL	-999	estimated error inPetrosian radius at 50% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_50_ERR
petR90	unknown	REAL	-999	Petrosian radius at 90% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_90
petR90Err	unknown	REAL	-999	estimated error in Petrosian radius at 90% light	cmf SkyChip.xsrc extension	PETRO_RADIUS_90_ERR
petCf	unknown	REAL	-999	Petrosian fit coverage factor	NA	empty
flxR1	unknown	REAL	-999	Flux inside r = 1	NA	empty
flxR1Err	unknown	REAL	-999	estimated error is flxR1	NA	empty
flxR1Std	unknown	REAL	-999	estimated standard deviation in flxR1	NA	empty
flxR1Fill	unknown	REAL	-999	estimated filling factor at R1	NA	empty
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	unknown	REAL	-999	Abraham concentration index	NA	empty
logA	unknown	REAL	-999	Abraham asymmetry index	NA	empty
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
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	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	from SkyChip.xfit 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.
deVRadius	unknown	REAL	-999	deVaucouleurs radius	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ where MODEL_TYPE = PS_MODEL_DEV
deVRadiusErr	unknown	REAL	-999	estimated error in deVaucouleurs radius	NA	empty
deVMag	unknown	REAL	-999	deVaucouleurs magntiude	cmf SkyChip.xfit extension	EXT_INST_MAG where MODEL_TYPE = PS_MODEL_DEV
deVMagErr	unknown	REAL	-999	estimated error in deV_mag	cmf SkyChip.xfit extension	EXT_INST_MAG_SIG where MODEL_TYPE = PS_MODEL_DEV
deVAb	unknown	REAL	-999	deVaucoulerus axis ratio	cmf SkyChip.xfit extension	EXT_WIDTH_MAJ/b.EXT_WIDTH_MIN where MODEL_TYPE = PS_MODEL_DEV
deVAbErr	unknown	REAL	-999	estimated error in deVaucoulerus axis ratio	NA	empty
deVPhi	unknown	REAL	-999	estmated phi of deVaucouleurs axis	cmf SkyChip.xfit extension	EXT_THETA
deVPhiErr	unknown	REAL	-999	estmated error of phi of deVaucouleurs axis	NA	empty
raDeVOff	unknown	REAL	-999	Offset in RA of deVaucouleurs fit from PSF RA	NA	empty
decDeVOff	unknown	REAL	-999	Offset in DEC of deVaucouleurs fit from PSF DEC	NA	empty
raDeVOffErr	unknown	REAL	-999	estimated error in ra offset	NA	empty
decDeVOffErr	unknown	REAL	-999	estimated error in dec offset	NA	empty
deVCf	unknown	REAL	-999	deVaucouleurs fit coverage factor	NA	empty
deVLikelihood	unknown	REAL	-999	deVaucouleurs fit likelihood factor	NA	empty
deVCovar11	unknown	REAL	-999	covariance for deVaucouleurs fit	cmf SkyChip.xfit extension	EXT_COVAR_00_00 where MODEL_TYPE = PS_MODEL_DEV
deVCovar12	unknown	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	unknown	REAL	-999	Exponential fit radius
expRadiusErr	unknown	REAL	-999	estimated error in Exponential fit radius
expMag	unknown	REAL	-999	Exponential fit magntiude
expMagErr	unknown	REAL	-999	estimated error in expMag
expAb	unknown	REAL	-999	Exponential fit axis ratio
expAbErr	unknown	REAL	-999	estimated error in Exponential fit axis ratio
expPhi	unknown	REAL	-999	estmated phi of Exponential axis
expPhiErr	unknown	REAL	-999	estmated error of phi of Exponential axis
raExpOff	unknown	REAL	-999	Offset in RA of Exponential fit from PSF RA
decExpOff	unknown	REAL	-999	Offset in DEC of Exponential fit from PSF DEC
raExpOffErr	unknown	REAL	-999	estimated error in raExpOff
decExpOffErr	unknown	REAL	-999	estimated error in decExpOff
expCf	unknown	REAL	-999	Exponential fit coverage factor
expLikelihood	unknown	REAL	-999	Exponential fit likelihood factor
expCovar11	unknown	REAL	-999	covariance for Exponential fit
expCovar12	unknown	REAL	-999	covariance for Exponential fit
expCovar13	unknown	REAL	-999	covariance for Exponential fit
expCovar14	unknown	REAL	-999	covariance for Exponential fit
expCovar15	unknown	REAL	-999	covariance for Exponential fit
expCovar16	unknown	REAL	-999	covariance for Exponential fit
expCovar17	unknown	REAL	-999	covariance for Exponential fit
expCovar22	unknown	REAL	-999	covariance for Exponential fit
expCovar23	unknown	REAL	-999	covariance for Exponential fit
expCovar24	unknown	REAL	-999	covariance for Exponential fit
expCovar25	unknown	REAL	-999	covariance for Exponential fit
expCovar26	unknown	REAL	-999	covariance for Exponential fit
expCovar27	unknown	REAL	-999	covariance for Exponential fit
expCovar33	unknown	REAL	-999	covariance for Exponential fit
expCovar34	unknown	REAL	-999	covariance for Exponential fit
expCovar35	unknown	REAL	-999	covariance for Exponential fit
expCovar36	unknown	REAL	-999	covariance for Exponential fit
expCovar37	unknown	REAL	-999	covariance for Exponential fit
expCovar44	unknown	REAL	-999	covariance for Exponential fit
expCovar45	unknown	REAL	-999	covariance for Exponential fit
expCovar46	unknown	REAL	-999	covariance for Exponential fit
expCovar47	unknown	REAL	-999	covariance for Exponential fit
expCovar55	unknown	REAL	-999	covariance for Exponential fit
expCovar56	unknown	REAL	-999	covariance for Exponential fit
expCovar57	unknown	REAL	-999	covariance for Exponential fit
expCovar66	unknown	REAL	-999	covariance for Exponential fit
expCovar67	unknown	REAL	-999	covariance for Exponential fit
expCovar77	unknown	REAL	-999	covariance for Exponential fit
serRadius	unknown	REAL	-999	Sersic radius
serRadiusErr	unknown	REAL	-999	estimated error in Sersic radius
serMag	unknown	REAL	-999	Sersic magntiude
serMagErr	unknown	REAL	-999	estimated error in serMag
serAb	unknown	REAL	-999	Sersic axis ratio
serAbErr	unknown	REAL	-999	estimated error in Sersic axis ratio
serNu	unknown	REAL	-999	Sersic index
serNuErr	unknown	REAL	-999	estimated error in Sersic index
serPhi	unknown	REAL	-999	estmated phi of Sersic axis
serPhiErr	unknown	REAL	-999	estmated error of phi of Sersic axis
raSerOff	unknown	REAL	-999	Offset in RA of Sersic fit from PSF RA
decSerOff	unknown	REAL	-999	Offset in DEC of Sersic fit from PSF DEC
raSerOffErr	unknown	REAL	-999	estimated error in raSerOff
decSerOffErr	unknown	REAL	-999	estimated error in decSerOff
serCf	unknown	REAL	-999	Sersic fit coverage factor
serLikelihood	unknown	REAL	-999	Sersic fit likelihood factor
sersicCovar11	unknown	REAL	-999	covariance for Sersic fit
sersicCovar12	unknown	REAL	-999	covariance for Sersic fit
sersicCovar13	unknown	REAL	-999	covariance for Sersic fit
sersicCovar14	unknown	REAL	-999	covariance for Sersic fit
sersicCovar15	unknown	REAL	-999	covariance for Sersic fit
sersicCovar16	unknown	REAL	-999	covariance for Sersic fit
sersicCovar17	unknown	REAL	-999	covariance for Sersic fit
sersicCovar18	unknown	REAL	-999	covariance for Sersic fit
sersicCovar22	unknown	REAL	-999	covariance for Sersic fit
sersicCovar23	unknown	REAL	-999	covariance for Sersic fit
sersicCovar24	unknown	REAL	-999	covariance for Sersic fit
sersicCovar25	unknown	REAL	-999	covariance for Sersic fit
sersicCovar26	unknown	REAL	-999	covariance for Sersic fit
sersicCovar27	unknown	REAL	-999	covariance for Sersic fit
sersicCovar28	unknown	REAL	-999	covariance for Sersic fit
sersicCovar33	unknown	REAL	-999	covariance for Sersic fit
sersicCovar34	unknown	REAL	-999	covariance for Sersic fit
sersicCovar35	unknown	REAL	-999	covariance for Sersic fit
sersicCovar36	unknown	REAL	-999	covariance for Sersic fit
sersicCovar37	unknown	REAL	-999	covariance for Sersic fit
sersicCovar38	unknown	REAL	-999	covariance for Sersic fit
sersicCovar44	unknown	REAL	-999	covariance for Sersic fit
sersicCovar45	unknown	REAL	-999	covariance for Sersic fit
sersicCovar46	unknown	REAL	-999	covariance for Sersic fit
sersicCovar47	unknown	REAL	-999	covariance for Sersic fit
sersicCovar48	unknown	REAL	-999	covariance for Sersic fit
sersicCovar55	unknown	REAL	-999	covariance for Sersic fit
sersicCovar56	unknown	REAL	-999	covariance for Sersic fit
sersicCovar57	unknown	REAL	-999	covariance for Sersic fit
sersicCovar58	unknown	REAL	-999	covariance for Sersic fit
sersicCovar66	unknown	REAL	-999	covariance for Sersic fit
sersicCovar67	unknown	REAL	-999	covariance for Sersic fit
sersicCovar68	unknown	REAL	-999	covariance for Sersic fit
sersicCovar77	unknown	REAL	-999	covariance for Sersic fit
sersicCovar78	unknown	REAL	-999	covariance for Sersic fit
sersicCovar88	unknown	REAL	-999	covariance for Sersic fit
activeFlag	unknown	TINYINT	-999	indicates whether this detection/orphan is still a detection/orphan
dataRelease	unknown	TINYINT	0	Data release when this detection was taken
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
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
dataRelease	unknown	TINYINT	0	Data release to propagate to the object
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
calColorErr	mag	REAL	0	error in calibrating color
calibModNum	unknown	SMALLINT	0	calibration modification number
dataRelease	unknown	TINYINT	0	Data release when this color calibration was established

Running