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

Glossary of WSA attributes
This Glossary alphabetically lists all attributes used in the UKIDSSDR11 database(s) held in the WSA. If you would like to have more information about the schema tables please use the UKIDSSDR11 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
objAltName1	ObjectThin	PS1DR2	Alternate name for this object.	varchar	32			meta.id
objAltName2	ObjectThin	PS1DR2	Altername name for this object.	varchar	32			meta.id
objAltName3	ObjectThin	PS1DR2	Altername name for this object.	varchar	32			meta.id
object	Multiframe	WSA	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	meta.id
object	Multiframe	WSACalib	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	meta.id
object	Multiframe	WSATransit	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	meta.id
object	Multiframe	WSAUHS	Object name from telescope {image primary HDU keyword: OBJECT}	varchar	64		NONE	meta.id
objectID	MapApertureIDslasYselJ	WSA	The UID of the object within this survey programme table	bigint	8
objID	Detection, MeanObject, StackObjectAttributes, StackObjectThin	PS1DR2	Unique object identifier.	bigint	8
objID	ObjectThin	PS1DR2	Unique object identifier.	bigint	8			meta.id;meta.main
objID	UKIDSSDetection	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	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	uhsDetection, uhsDetectionAll	WSAUHS	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
objID	ukirtFSstars	WSAUHS	Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563)	bigint	8
objIDName	MapSurveyTables	WSA	The source unique identifier in the table	varchar	16			ID_TARGET
objIDName	MapSurveyTables	WSAUHS	The source unique identifier in the table	varchar	16			ID_TARGET
objInfoFlag	ObjectThin	PS1DR2	Information flag bitmask indicating details of the photometry. Values listed in ObjectInfoFlags	int	4		0	meta.code
objName	ObjectThin	PS1DR2	IAU name for this object.	varchar	32			meta.id
objNameHMS	ObjectThin	PS1DR2	Alternate Pan-STARRS name for this object.	varchar	32			meta.id
objPopularName	ObjectThin	PS1DR2	Well known name for this object.	varchar	140			meta.id
obReqs	RequiredFilters	WSA	For wide shallow surveys with small number of epochs, what MSB requirements for each epoch.	varchar	32		NONE	meta.note
obReqs	RequiredFilters	WSACalib	For wide shallow surveys with small number of epochs, what MSB requirements for each epoch.	varchar	32		NONE	meta.note
obReqs	RequiredFilters	WSATransit	For wide shallow surveys with small number of epochs, what MSB requirements for each epoch.	varchar	32		NONE	meta.note
obReqs	RequiredFilters	WSAUHS	For wide shallow surveys with small number of epochs, what MSB requirements for each epoch.	varchar	32		NONE	meta.note
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
OBS_CLASS	xmm3dr4	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.	smallint	2
OBS_ID	xmm3dr4	XMM	The XMM-Newton observation identification.	varchar	50
observation_time	phot_variable_time_series_g_fov	GAIADR1	Barycentric light-travle time corrected timestamp for each FoV observation	float	8	Barycentric JD in TCB - 2455197.5 days		time.epoch
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
observed	StdFieldInfo	WSAUHS	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	obs.observer
observer	Multiframe	WSACalib	Observers names {image primary HDU keyword: OBSERVER}	varchar	64		NONE	obs.observer
observer	Multiframe	WSATransit	Observers names {image primary HDU keyword: OBSERVER}	varchar	64		NONE	obs.observer
observer	Multiframe	WSAUHS	Observers names {image primary HDU keyword: OBSERVER}	varchar	64		NONE	obs.observer
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	meta.number
obsNum	Multiframe	WSACalib	Observation number {image primary HDU keyword: OBSNUM}	int	4		-99999999	meta.number
obsNum	Multiframe	WSATransit	Observation number {image primary HDU keyword: OBSNUM}	int	4		-99999999	meta.number
obsNum	Multiframe	WSAUHS	Observation number {image primary HDU keyword: OBSNUM}	int	4		-99999999	meta.number
obsref	Multiframe	WSA	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	meta.bib
obsref	Multiframe	WSACalib	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	meta.bib
obsref	Multiframe	WSATransit	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	meta.bib
obsref	Multiframe	WSAUHS	PATT or other reference {image primary HDU keyword: OBSREF}	varchar	64		NONE	meta.bib
obsTime	Detection	PS1DR2	Modified Julian Date at the midpoint of the observation.	float	8	days	-999
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			??
obstype	Multiframe	WSAUHS	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
oneSecMLVg	Filter	WSAUHS	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, gcsAstrometricInfo, gpsAstrometricInfo, lasAstrometricInfo, udsAstrometricInfo	WSA	Orientation of axes	float	8	radians	-0.9999995e9	??
orient	uhsAstrometricInfo	WSAUHS	Orientation of axes	float	8	radians	-0.9999995e9	??
orientation	RequiredMosaicTopLevel	WSAUHS	Orientation of image x-axis to N-S. If default, use natural orientation of input images.	real	4	deg	-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
origin	Multiframe	WSAUHS	Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN}	varchar	32		NONE
original_ext_source_id	gaia_hip_tycho2_match	GAIADR1	Original source identified in Hipparcos/Tycho2	varchar	16			id.cross
overLaps	RequiredMapAverages	WSA	Average over overlaps (use with average over deep frames and source merging) 0/N N/Y	tinyint	1		0
overLaps	RequiredMapAverages	WSAUHS	Average over overlaps (use with average over deep frames and source merging) 0/N N/Y	tinyint	1		0