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

T
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
tableExtName	MultiframeDetector	WSA	Extension name of source FITS binary table {catalogue extension keyword:  EXTNAME}	varchar	16		NONE	??
tableExtName	MultiframeDetector	WSATransit	Extension name of source FITS binary table {catalogue extension keyword:  EXTNAME}	varchar	16		NONE	??
tableFields	MultiframeDetector	WSA	No. of fields per row in source FITS binary table {catalogue extension keyword:  TFIELDS}	smallint	2		-9999	??
tableFields	MultiframeDetector	WSATransit	No. of fields per row in source FITS binary table {catalogue extension keyword:  TFIELDS}	smallint	2		-9999	??
tableGcount	MultiframeDetector	WSA	FITS binary table required keyword {catalogue extension keyword:  GCOUNT}	smallint	2		-9999	??
tableGcount	MultiframeDetector	WSATransit	FITS binary table required keyword {catalogue extension keyword:  GCOUNT}	smallint	2		-9999	??
tableID	ProgrammeTable	WSA	the unique table ID	int	4			ID_MAIN
tableID	ProgrammeTable	WSATransit	the unique table ID	int	4			ID_MAIN
tableID	RequiredListDrivenProduct	WSA	the unique ID of the table with the source list driving the remeasurements	int	4			ID_MAIN
tableID	RequiredListDrivenProduct	WSATransit	the unique ID of the table with the source list driving the remeasurements	int	4			ID_MAIN
tableID	RequiredNeighbours	WSA	the unique identifier for the programme table	int	4			ID_SURVEY
tableID	RequiredNeighbours	WSATransit	the unique identifier for the programme table	int	4			ID_SURVEY
tableName	ProgrammeTable	WSA	the name of the table	varchar	256			ID_TABLE
tableName	ProgrammeTable	WSATransit	the name of the table	varchar	256			ID_TABLE
tablePcount	MultiframeDetector	WSA	FITS binary table required keyword {catalogue extension keyword:  PCOUNT}	smallint	2		-9999	??
tablePcount	MultiframeDetector	WSATransit	FITS binary table required keyword {catalogue extension keyword:  PCOUNT}	smallint	2		-9999	??
tableRows	MultiframeDetector	WSA	No. of rows in source FITS binary table {catalogue extension keyword:  NAXIS2}	int	4		-99999999	??
tableRows	MultiframeDetector	WSATransit	No. of rows in source FITS binary table {catalogue extension keyword:  NAXIS2}	int	4		-99999999	??
tableWidth	MultiframeDetector	WSA	Row size of source FITS binary table {catalogue extension keyword:  NAXIS1}	smallint	2	bytes	-9999	??
tableWidth	MultiframeDetector	WSATransit	Row size of source FITS binary table {catalogue extension keyword:  NAXIS1}	smallint	2	bytes	-9999	??
tauCSO	Multiframe	WSA	Tau at 225 GHz from CSO {image primary HDU keyword: CSOTAU}	real	4		-0.9999995e9	PHYS_OPTICAL-DEPTH
tauCSO	Multiframe	WSATransit	Tau at 225 GHz from CSO {image primary HDU keyword: CSOTAU}	real	4		-0.9999995e9	PHYS_OPTICAL-DEPTH
tauDate	Multiframe	WSA	Time and date of Tau reading {image primary HDU keyword: TAUDATE}	datetime	8	MM-DD-YYYY	12-31-9999	TIME_DATE
tauDate	Multiframe	WSATransit	Time and date of Tau reading {image primary HDU keyword: TAUDATE}	datetime	8	MM-DD-YYYY	12-31-9999	TIME_DATE
tauSource	Multiframe	WSA	Source of opacity data {image primary HDU keyword: TAUSRC}	varchar	64		NONE	DATA_LINK
tauSource	Multiframe	WSATransit	Source of opacity data {image primary HDU keyword: TAUSRC}	varchar	64		NONE	DATA_LINK
TDFGRS_BJG	mgcBrightSpec	MGC	2dFGRS final b_J magnitude	real	4
TDFGRS_CLASS	mgcBrightSpec	MGC	MGC translation of TDFGRS_IGAL	smallint	2
TDFGRS_DEC	mgcBrightSpec	MGC	2dFGRS object declination in deg (J2000)	float	8
TDFGRS_N	mgcBrightSpec	MGC	Number of 2dFGRS objects/spectra for this MGC object	smallint	2
TDFGRS_NAME	mgcBrightSpec	MGC	2dFGRS object name	varchar	10
TDFGRS_RA	mgcBrightSpec	MGC	2dFGRS object right ascension in deg (J2000)	float	8
TDFGRS_SBBJMAG	mgcBrightSpec	MGC	SSS b_J magnitude	real	4
TDFGRS_SEQNUM	mgcBrightSpec	MGC	2dFGRS sequence number	bigint	8
TDFGRS_SEQNUM	mgcGalaxyStruct	MGC	2dFGRS Serial number	bigint	8		0
TDFGRS_SRRMAG	mgcBrightSpec	MGC	SSS R magnitude	real	4
TDFGRS_UKST	mgcBrightSpec	MGC	UKST survey field number	int	4
TDFGRS_ZHELIO	mgcBrightSpec	MGC	2dFGRS heliocentric redshift	real	4
TDFGRS_ZQUAL	mgcBrightSpec	MGC	2dFGRS redshift quality	tinyint	1
TDGRS_BJSEL	mgcBrightSpec	MGC	2dFGRS final extinction corrected b_J magnitude	real	4
TDGRS_IGAL	mgcBrightSpec	MGC	2dFGRS classification	tinyint	1
tel_temp	twomass_scn	2MASS	Telescope girdle temperature at beginning of scan.	real	4	degC		PHYS_TEMP_MISC
telAperture	Survey	SSA	Telescope aperture	float	8	metres		TEL_SIZE
telDec	Multiframe	WSA	Current telescope declination {image primary HDU keyword: TELDEC}	float	8	degrees	-0.9999995e9	POS_EQ_DEC_MAIN
telDec	Multiframe	WSATransit	Current telescope declination {image primary HDU keyword: TELDEC}	float	8	degrees	-0.9999995e9	POS_EQ_DEC_MAIN
telescope	Multiframe	WSA	Telescope name {image primary HDU keyword: TELESCOP}	varchar	32		NONE
telescope	Multiframe	WSATransit	Telescope name {image primary HDU keyword: TELESCOP}	varchar	32		NONE
telescope	Survey	SSA	UK, ESO or Palomar Oschin Schmidt	varchar	64			TEL_ID
telFocus	Multiframe	WSA	Telescope focus {image primary HDU keyword: TCS_FOC}	real	4		-0.9999995e9
telFocus	Multiframe	WSATransit	Telescope focus {image primary HDU keyword: TCS_FOC}	real	4		-0.9999995e9
telHeight	Survey	SSA	Telescope altitude	real	4	metres		OBSTY_ALTITUDE
telLat	Survey	SSA	Telescope latitude	float	8	degress		POS_EARTH_LAT_MAIN
telLong	Survey	SSA	Telescope longitude	float	8	degrees		POS_EARTH_LON_MAIN
telRa	Multiframe	WSA	Current telescope right ascension {image primary HDU keyword: TELRA}	float	8	hours	-0.9999995e9	POS_EQ_RA_MAIN
telRa	Multiframe	WSATransit	Current telescope right ascension {image primary HDU keyword: TELRA}	float	8	hours	-0.9999995e9	POS_EQ_RA_MAIN
THETA_IMAGE	mgcDetection	MGC	Position angle wrt x axis	real	4	deg
thetaI	Detection	SSA	Position angle (wrt x-axis) of intensity-weighted fitted ellipse	smallint	2	degrees		POS_POS-ANG
thetaU	Detection	SSA	Position angle (wrt x-axis) of unweighted fitted ellipse	smallint	2	degrees		POS_POS-ANG
THRESH	mgcDetection	MGC	Detection threshold above background	real	4	count
threshold	RequiredMosaic	WSATransit	CASU/SEX source extraction tool option for the isophotal analysis threshold (recommended value=1.5)	real	4	sigma	-0.9999995e9	??
threshold	RequiredMosaic, RequiredStack	WSA	CASU/SEX source extraction tool option for the isophotal analysis threshold (recommended value=1.5)	real	4	sigma	-0.9999995e9	??
thresholdIsoph	MultiframeDetector	WSA	Isophotal analysis threshold {catalogue extension keyword:  THRESHOL}	real	4	counts	-0.9999995e9	??
			Tunable parameter, the default is to set this to 1.5 skynoise as a compromise between detecting close to the limit of the data and not being swamped by spurious sources. It is possible to push the data limit fainter but at the expense of a large increase in spurious sources. LSBG detection requires a more subtle add-on to the catalogue and could be added given suitable demand.
thresholdIsoph	MultiframeDetector	WSATransit	Isophotal analysis threshold {catalogue extension keyword:  THRESHOL}	real	4	counts	-0.9999995e9	??
			Tunable parameter, the default is to set this to 1.5 skynoise as a compromise between detecting close to the limit of the data and not being swamped by spurious sources. It is possible to push the data limit fainter but at the expense of a large increase in spurious sources. LSBG detection requires a more subtle add-on to the catalogue and could be added given suitable demand.
tile	twomass_scn	2MASS	Tile identification number.	int	4			ID_NUMBER
tileNum	Multiframe	WSA	Tile number applied to all members {image primary HDU keyword: TILENUM}	int	4		-99999999
tileNum	Multiframe	WSATransit	Tile number applied to all members {image primary HDU keyword: TILENUM}	int	4		-99999999
timeMeas	Plate	SSA	Measurement time (local), eg. 15:33:47	varchar	8			TIME_MISC
timeStamp	ArchiveCurationHistory	WSA	Time of the completion of the whole task	datetime	8	UTC		TIME_DATE
timeStamp	ArchiveCurationHistory	WSATransit	Time of the completion of the whole task	datetime	8	UTC		TIME_DATE
timeStamp	ProgrammeCurationHistory	WSA	Time of individual programme curation completion	datetime	8	UTC		TIME_DATE
timeStamp	ProgrammeCurationHistory	WSATransit	Time of individual programme curation completion	datetime	8	UTC		TIME_DATE
title	Programme	WSA	a short title for the programme, eg. "UKIDSS Large Area Survey"	varchar	32			NOTE
title	Programme	WSATransit	a short title for the programme, eg. "UKIDSS Large Area Survey"	varchar	32			NOTE
tmassID	glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca	GLIMPSE	Unique identification number for the 2MASS source from the 2MASS All-Sky PSC	int	4
tmassName	glimpse1_hrc, glimpse1_mca, glimpse2_hrc, glimpse2_mca	GLIMPSE	Source name from 2MASS All-Sky point source catalog (PSC)	varchar	32			ID_MAIN
topAirTempNW	Multiframe	WSA	Top air NW {image primary HDU keyword: TOPAIRNW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
topAirTempNW	Multiframe	WSATransit	Top air NW {image primary HDU keyword: TOPAIRNW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
topRingTemp	Multiframe	WSA	Top ring temperature {image primary HDU keyword: TR_TEMP}	real	4	degrees_Kelvin	-0.9999995e9
topRingTemp	Multiframe	WSATransit	Top ring temperature {image primary HDU keyword: TR_TEMP}	real	4	degrees_Kelvin	-0.9999995e9
totalExpTime	MultiframeDetector	WSA	Total exposure time for this detector	real	4	seconds	-0.9999995e9
totalExpTime	MultiframeDetector	WSATransit	Total exposure time for this detector	real	4	seconds	-0.9999995e9
TQZ_BJ	mgcBrightSpec	MGC	2QZ bJ magnitude	real	4
TQZ_BJMR	mgcBrightSpec	MGC	2QZ bJ-R colour	real	4
TQZ_CLASS	mgcBrightSpec	MGC	MGC translation of TQZ_IDENT	smallint	2
TQZ_DEC	mgcBrightSpec	MGC	2QZ object declination in deg (J2000)	float	8
TQZ_DUST	mgcBrightSpec	MGC	2QZ E(B-V)	real	4
TQZ_IDENT	mgcBrightSpec	MGC	2QZ identification	varchar	10
TQZ_NAME	mgcBrightSpec	MGC	2QZ object name	varchar	20
TQZ_NOBS	mgcBrightSpec	MGC	Number of 2QZ spectra for this MGC object	tinyint	1
TQZ_RA	mgcBrightSpec	MGC	2QZ object right ascension in deg (J2000)	float	8
TQZ_UKST	mgcBrightSpec	MGC	UKST survey field number	int	4
TQZ_UMBJ	mgcBrightSpec	MGC	2QZ U-bJ colour	real	4
TQZ_ZQUAL	mgcBrightSpec	MGC	2QZ redshift quality	tinyint	1
trackAngle	JunkDetection	SSA	Angle of track or diffraction spike	real	4	degrees	-999.995	POS_POS-ANG
trackSys	Multiframe	WSA	Telescope tracking coordinate system {image primary HDU keyword: TRACKSYS}	varchar	64		NONE	TIME_EQUINOX
trackSys	Multiframe	WSATransit	Telescope tracking coordinate system {image primary HDU keyword: TRACKSYS}	varchar	64		NONE	TIME_EQUINOX
transFile	RequiredListDrivenProduct	WSA	CASU list-driven photometry tool option specifying the source of the driving list (e.g. "use=radeclist")	varchar	16			??
transFile	RequiredListDrivenProduct	WSATransit	CASU list-driven photometry tool option specifying the source of the driving list (e.g. "use=radeclist")	varchar	16			??
trefAmpl	Multiframe	WSA	Trefoil: Amplitude {image primary HDU keyword: TAMP}	real	4		-0.9999995e9
trefAmpl	Multiframe	WSATransit	Trefoil: Amplitude {image primary HDU keyword: TAMP}	real	4		-0.9999995e9
trefPhi	Multiframe	WSA	Trefoil: angle {image primary HDU keyword: TPHI}	real	4		-0.9999995e9
trefPhi	Multiframe	WSATransit	Trefoil: angle {image primary HDU keyword: TPHI}	real	4		-0.9999995e9
tropl	Plate	SSA	Tropospheric lapse rate	real	4	K/m		MODEL_PARAM
trussTempENE	Multiframe	WSA	Truss leg ENE {image primary HDU keyword: TRUSSENE}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
trussTempENE	Multiframe	WSATransit	Truss leg ENE {image primary HDU keyword: TRUSSENE}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
trussTempWSW	Multiframe	WSA	Truss leg WSW {image primary HDU keyword: TRUSSWSW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
trussTempWSW	Multiframe	WSATransit	Truss leg WSW {image primary HDU keyword: TRUSSWSW}	real	4	degrees_Celsius	-0.9999995e9	PHYS_TEMP_MISC
TSERIES	twoxmm	XMM	The flag is set to True if this source has a time series made in at least one exposure.	varchar	5
tSnr_100	iras_psc	IRAS	ten times the minimum signal-to-noise ratio (100 micron)	smallint	2		INST_S/N
tSnr_12	iras_psc	IRAS	ten times the minimum signal-to-noise ratio (12 micron)	smallint	2		INST_S/N
tSnr_25	iras_psc	IRAS	ten times the minimum signal-to-noise ratio (25 micron)	smallint	2		INST_S/N
tSnr_60	iras_psc	IRAS	ten times the minimum signal-to-noise ratio (60 micron)	smallint	2		INST_S/N
tSysRef	Plate	SSA	Time system of equinox of refstar positions, eg. JULIAN	varchar	12			NOTE
type	iras_asc	IRAS	Source Type/Spectral Class	varchar	5			SPECT_TYPE_GENERAL