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

Glossary of WSA attributes
This Glossary alphabetically lists all attributes used in the UKIDSSDR9 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR9 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	gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, UKIDSSDetection, udsListRemeasurement	WSA	Unique identifier for this detection, or default for no detection	bigint	8		-99999999	ID_MAIN
objID	calDetection	WSACalib	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	calListRemeasurement	WSACalib	Unique identifier for this detection, or default for no detection	bigint	8		-99999999	ID_MAIN
objID	dxsDetection	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	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
OBS_CLASS	twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0	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
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, twoxmm_v1_2, twoxmmi_dr3_v1_0	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
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
orgDate	rosat_bsc, rosat_fsc	ROSAT	date when source was included (MM-DD-YYYY)	datetime	8	mm-dd-yyyy		TIME_DATE
orient	dxsAstrometricInfo, udsAstrometricInfo	WSA	Orientation of axes	float	8	degrees	-0.9999995e9	??
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