Home | Overview | Browser | Access | Login | Cookbook | nonSurvey  ** Announcement - Workshop: Science from UKIDSS II, 15-17 Dec 2008, London UK **

Glossary of WSA attributes
This Glossary alphabetically lists all attributes used in the UKIDSSR1 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSR1 Schema Browser (other Browser versions).

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

M
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
magCol	Plate	SSA	Name of magnitude column in reference catalogue	varchar	16			REMARKS
magLimit	Survey	SSA	Nominal mag limit of survey, eg. 22.5 for Bj	real	4			PHOT_MAG_LIMIT
magMax	Plate	SSA	Maximum instrumental mag in IAM file	real	4			PHOT_MAG_LIMIT
magMin	Plate	SSA	Minimum instrumental mag in IAM file	real	4			PHOT_MAG_LIMIT
maj	firstSource	FIRST	major axes derived from the elliptical Gaussian model for the source after deconvolution.	real	4	arcsec		EXTENSION_FWHM_MAJ
major	iras_psc	IRAS	Uncertainty ellipse major axis	smallint	2	arcsec		ERROR
maskID	Multiframe	WSA	UID of library object mask frame {image extension keyword: CIR_OPM}	bigint	8		-99999999	ID_FRAME
masterObjID	commSourceNeighbours, commSourceXDR2PhotoObj, commSourceXSSASource, commSourceXfirstSource, commSourceXiras_psc, commSourceXrosat_bsc, commSourceXrosat_fsc, commSourceXtwomass_psc, commSourceXusnob_psc	WSA	The unique ID in commSource (=sourceID)	bigint	8			ID_MAIN
masterObjID	dxsSourceNeighbours	WSA	The unique ID in dxsSource (=sourceID)	bigint	8			ID_MAIN
masterObjID	gcsSourceNeighbours, gcsSourceXtwomass_psc	WSA	The unique ID in gcsSource (=sourceID)	bigint	8			ID_MAIN
masterObjID	gpsSourceNeighbours, gpsSourceXtwomass_psc	WSA	The unique ID in gpsSource (=sourceID)	bigint	8			ID_MAIN
masterObjID	lasSourceNeighbours, lasSourceXDR2PhotoObj, lasSourceXSSASource, lasSourceXfirstSource, lasSourceXiras_psc, lasSourceXrosat_bsc, lasSourceXrosat_fsc, lasSourceXtwomass_psc, lasSourceXusnob_psc	WSA	The unique ID in lasSource (=sourceID)	bigint	8			ID_MAIN
masterObjID	udsSourceNeighbours	WSA	The unique ID in udsSource (=sourceID)	bigint	8			ID_MAIN
maxDec	CurrentAstrometry, PreviousAstrometry	WSA	The maximum Dec (J2000) on the device	float	8	Degrees		POS_EQ_DEC_MAIN
maxIter	Plate	SSA	Maximum no. of iterations for non-linear astrometric fit	int	4			NUMBER
maxRa	CurrentAstrometry, PreviousAstrometry	WSA	The maximum RA (J2000) on the device	float	8	Degrees		POS_EQ_RA_OTHER
meanClass	Source	SSA	Estimate of image class based on unit-weighted mean of individual classes	tinyint	1			CLASS_OBJECT
mergedClass	commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource	WSA	Class flag from available measurements (1|0|-1|-2|-3|-9=galaxy|noise|stellar|probableStar|probableGalaxy|saturated)	smallint	2			CODE_MISC
mergedClass	dxsSourceRemeasurement, gcsSourceRemeasurement, gpsSourceRemeasurement, lasSourceRemeasurement, udsSourceRemeasurement	WSA	Class flag based on list remeasurement prescription	smallint	2			CODE_MISC
mergeLogTable	Programme	WSA	Table name of curation log for source merging	varchar	64			??
mergeSwVersion	calMergeLog, commMergeLog, dxsMergeLog, gcsMergeLog, gpsMergeLog, lasMergeLog, udsMergeLog	WSA	version number of the software used to merge the frames	real	4			ID_VERSION
method	RequiredDiffImage	WSA	CASU difference image tool option string specifying the method to employ (recommended value=adaptive/back/zerosky)	varchar	64			??
mFlag	rosat_bsc, rosat_fsc	ROSAT	source missed by SASS	varchar	1			CODE_MISC
mHcon	iras_psc	IRAS	Possible number of HCONs	tinyint	1			NUMBER
min	firstSource	FIRST	minor axes derived from the elliptical Gaussian model for the source after deconvolution.	real	4	arcsec		EXTENSION_FWHM_MIN
minDec	CurrentAstrometry, PreviousAstrometry	WSA	The minimum Dec (J2000) on the device	float	8	Degrees		POS_EQ_DEC_MAIN
minor	iras_psc	IRAS	Uncertainty ellipse minor axis	smallint	2	arcsec		ERROR
minRa	CurrentAstrometry, PreviousAstrometry	WSA	The minimum RA (J2000) on the device	float	8	Degrees		POS_EQ_RA_OTHER
mirrBottTempNW	Multiframe	WSA	Mirror bottom temp. NW {image primary HDU keyword: MIRRBTNW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mirrTempBSW	Multiframe	WSA	Mirror temperature B SW {image primary HDU keyword: MIRRBSW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mirrTempNE	Multiframe	WSA	Mirror temperature NE {image primary HDU keyword: MIRRNE}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mirrTempNW	Multiframe	WSA	Mirror temperature NW {image primary HDU keyword: MIRRNW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mirrTempSE	Multiframe	WSA	Mirror temperature SE {image primary HDU keyword: MIRRSE}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mirrTempSW	Multiframe	WSA	Mirror temperature SW {image primary HDU keyword: MIRRSW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mirrTopTempNW	Multiframe	WSA	Mirror top temp. NW {image primary HDU keyword: MIRRTPNW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
mjd	Plate	SSA	Modified Julian Date at mid exposure	float	8	Julian days		TIME_DATE
mjdObs	Multiframe	WSA	Modified Julian Date of the observation {image primary HDU keyword: MJD-OBS}	float	8		-0.9999995e9	TIME_DATE
modDate	rosat_bsc, rosat_fsc	ROSAT	date when source properties were changed (MM-DD-YYYY)	datetime	8	mm-dd-yyyy		TIME_DATE
mosaicID	MosaicImage	WSA	the unique ID number identifying all stored mosaic images	bigint	8			ID_FRAME
mosaicStacks	RequiredMosaic	WSA	Indicates if stacks are to be mosaiced (=1) or not (=0)	tinyint	1			??
mp_flg	twomass_psc	2MASS	Minor Planet Flag.	smallint	2			CODE_MISC
mp_key	twomass_xsc	2MASS	key to minor planet prediction DB record.	int	4			ID_NUMBER
msbID	Multiframe	WSA	Id min.-schedulable block {image primary HDU keyword: MSBID}	varchar	64		NONE	ID_NUMBER
muAcosD	Source	SSA	Proper motion in RA direction	real	4	mas/yr	-0.99999995e9	POS_EQ_PMRA
muD	Source	SSA	Proper motion in Dec direction	real	4	mas/yr	-0.99999995e9	POS_EQ_PMDEC
muDec	commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource	WSA	Proper motion in Dec direction	real	4	mas/yr	-0.9999995e9	POS_EQ_PMDEC
multiframeID	CurrentAstrometry, calDetection, commDetection, dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, PreviousAstrometry, u05a18Detection, udsDetection, udsListRemeasurement	WSA	the UID of the relevant multiframe	bigint	8			ID_FRAME
multiframeID	Multiframe	WSA	UID of the multiframe (assigned sequentially by the archive ingest process)	bigint	8			ID_FRAME
multiframeID	MultiframeDetector	WSA	UID of the relevant multiframe	bigint	8			ID_FRAME
multiframeID	ProgrammeFrame	WSA	UID of the multiframe: 6-digit UKIRT run number; 8-digit UT date observed; 5-digit "WSA day number" of processing	bigint	8			ID_FRAME
multiframeID	Provenance	WSA	the UID of the component frame	bigint	8			ID_FRAME
muRa	commSource, dxsSource, gcsSource, gpsSource, lasSource, udsSource	WSA	Proper motion in RA direction	real	4	mas/yr	-0.9999995e9	POS_EQ_PMRA