Home | Overview | Browser | Access | Login | Cookbook | nonSurvey

Glossary of WSA attributes
This Glossary alphabetically lists all attributes used in the UKIDSSDR5 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR5 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

O
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
object	Multiframe	WSA	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	ID_TARGET
object	Multiframe	WSACalib	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	ID_TARGET
object	Multiframe	WSATransit	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	ID_TARGET
objID	CompleteStars, ReliableGalaxies, ReliableStars, Source	SSA	Unique identifier of merged source	bigint	8			ID_MAIN
objID	Detection	SSA	Unique object identification number	bigint	8			ID_MAIN
objID	JunkDetection	SSA	Unique object identification number from Detection	bigint	8			ID_MAIN
objID	dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, UKIDSSDetection, udsListRemeasurement	WSA	Unique identifier for this detection, or default for no detection	bigint	8		-99999999	ID_MAIN
objID	dxsDetection, gcsDetection, gpsDetection, lasDetection, udsDetection	WSA	Unique identifier for this detection, or default for no detection	bigint	8		-99999999	ID_MAIN
			This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID	ptsDetection	WSATransit	Unique identifier for this detection, or default for no detection	bigint	8		-99999999	ID_MAIN
			This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information.
objID	ukirtFSstars	WSA	Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563)	bigint	8
objID	ukirtFSstars	WSACalib	Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563)	bigint	8
objIDB	CompleteStars, ReliableGalaxies, ReliableStars, Source	SSA	objID for B band detection merged into this object	bigint	8		0	ID_ASSOCIATED
objIDI	CompleteStars, ReliableGalaxies, ReliableStars, Source	SSA	objID for I band detection merged into this object	bigint	8		0	ID_ASSOCIATED
objIDR1	CompleteStars, ReliableGalaxies, ReliableStars, Source	SSA	objID for R1 band detection merged into this object	bigint	8		0	ID_ASSOCIATED
objIDR2	CompleteStars, ReliableGalaxies, ReliableStars, Source	SSA	objID for R2 band detection merged into this object	bigint	8		0	ID_ASSOCIATED
objNum	Plate	SSA	No. of objects detected on plate	int	4			NUMBER
OBS_CLASS	twoxmm	XMM	Quality classification of the whole observation based on the area flagged as bad in the manual flagging process as compared to the whole detection area. 0 means nothing has been flagged; 1 indicates that 0% < area < 0.1% of the total detection mask has been flagged; 2 indicates that 0.1% <= area < 1% has been flagged; 3 indicates that 1% <= area < 10% has been flagged; 4 indicates that 10% <= area < 100% has been flagged; and 5 means that the whole field was flagged as bad.	int	4
obsDecPnt	Plate	SSA	Observed plate centre Dec	float	8	radians		POS_EQ_DEC_MAIN
observed	StdFieldInfo	WSA	yes or no identifier - have the secondary standards been set up?	tinyint	1		0
observed	StdFieldInfo	WSACalib	yes or no identifier - have the secondary standards been set up?	tinyint	1		0
observer	Multiframe	WSA	Observers names {image primary HDU keyword: OBSERVER}	varchar	64		NONE	ID_HUMAN
observer	Multiframe	WSACalib	Observers names {image primary HDU keyword: OBSERVER}	varchar	64		NONE	ID_HUMAN
observer	Multiframe	WSATransit	Observers names {image primary HDU keyword: OBSERVER}	varchar	64		NONE	ID_HUMAN
OBSID	twoxmm	XMM	The XMM-Newton observation identification.	varchar	10
obsNum	Multiframe	WSA	Observation number {image primary HDU keyword: OBSNUM}	int	4		-99999999	NUMBER
obsNum	Multiframe	WSACalib	Observation number {image primary HDU keyword: OBSNUM}	int	4		-99999999	NUMBER
obsNum	Multiframe	WSATransit	Observation number {image primary HDU keyword: OBSNUM}	int	4		-99999999	NUMBER
obsRaPnt	Plate	SSA	Observed plate centre RA	float	8	radians		POS_EQ_RA_MAIN
obsref	Multiframe	WSA	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	REFER_CODE
obsref	Multiframe	WSACalib	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	REFER_CODE
obsref	Multiframe	WSATransit	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	REFER_CODE
obstype	Multiframe	WSA	Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE}	varchar	32			??
obstype	Multiframe	WSACalib	Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE}	varchar	32			??
obstype	Multiframe	WSATransit	Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE}	varchar	32			??
oneSecMLVg	Filter	WSA	The Vega magnitude limit of a 1s exposure in this filter	real	4	mag	-0.9999995e9
oneSecMLVg	Filter	WSACalib	The Vega magnitude limit of a 1s exposure in this filter	real	4	mag	-0.9999995e9
oneSecMLVg	Filter	WSATransit	The Vega magnitude limit of a 1s exposure in this filter	real	4	mag	-0.9999995e9
operator	Plate	SSA	Machine operator's username	varchar	3			ID_HUMAN
orgDate	rosat_bsc, rosat_fsc	ROSAT	date when source was included (MM-DD-YYYY)	datetime	8	mm-dd-yyyy		TIME_DATE
orientation	Plate	SSA	SuperCOSMOS plate orientation, eg. news	varchar	4			INST_PARAM
orientMean	Plate	SSA	Mean orientation in IAM file	real	4	degrees		POS_POS-ANG
orientMed	Plate	SSA	Median orientation in IAM file	real	4	degrees		POS_POS-ANG
orientMode	Plate	SSA	Modal orientation in IAM file	real	4	degrees		POS_POS-ANG
origin	Multiframe	WSA	Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN}	varchar	32		NONE
origin	Multiframe	WSACalib	Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN}	varchar	32		NONE
origin	Multiframe	WSATransit	Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN}	varchar	32		NONE