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

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

E

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
e_DEcs nvssSource NVSS Mean error on Dec real 4 arcsec   ERROR
e_majAxis nvssSource NVSS Mean error on majAxis real 4 arcsec   ERROR
e_minAxis nvssSource NVSS Mean error on minAxis real 4 arcsec   ERROR
e_PA nvssSource NVSS Mean error on PA real 4 degrees   ERROR
e_polFlux nvssSource NVSS Mean error on polFlux real 4 mJy   ERROR
e_polPA nvssSource NVSS Mean error on polPA real 4 mJy   ERROR
e_RAs nvssSource NVSS Mean error on RA real 4 s   ERROR
e_S14 nvssSource NVSS Mean error on S14 real 4 mJy   ERROR
e_score twomass_xsc 2MASS extended score: 1(extended) < e_score < 2(point-like). real 4     CODE_MISC
Ebmv CompleteStars, ReliableGalaxies, ReliableStars, Source SSA The estimated foreground reddening at this position from Schlegel et al. (1998) real 4 mag   PHOT_EXTINCTION_GAL
eBV dxsJKsource, dxsSource, lasExtendedSource, lasPointSource, lasSource, lasYJHKsource, reliableDxsSource, reliableLasPointSource, reliableUdsSource, udsSource WSA The galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. This uses the correction given in Bonifacio, Monai & Beers (2000). This correction reduces the extinction value in regions of high extinction (E(B-V)>0.1) real 4   -0.9999995e9  
eFlag rosat_bsc, rosat_fsc ROSAT source extended beyond SASS extraction radius varchar 1     CODE_MISC
ell UKIDSSDetection WSA 1-b/a, where a/b=semi-major/minor axes real 4     PHYS_ELLIPTICITY
ell dxsDetection, dxsListRemeasurement, gcsDetection, gcsListRemeasurement, gpsDetection, gpsListRemeasurement, lasDetection, lasListRemeasurement, udsListRemeasurement WSA 1-b/a, where a/b=semi-major/minor axes {catalogue TType keyword: Ellipticity} real 4     PHYS_ELLIPTICITY
ell ptsDetection WSATransit 1-b/a, where a/b=semi-major/minor axes {catalogue TType keyword: Ellipticity} real 4     PHYS_ELLIPTICITY
ell udsDetection WSA 1-b/a, where a/b=semi-major/minor axes (SE: THETA_IMAGE) {catalogue TType keyword: Ellipticity} real 4     PHYS_ELLIPTICITY
ellfit_flg twomass_xsc 2MASS ellipse fitting contamination flag. smallint 2     CODE_MISC
ellipB CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Ellipticity of B band detection real 4   -0.99999995e9 PHYS_ELLIPTICITY
ellipI CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Ellipticity of I band detection real 4   -0.99999995e9 PHYS_ELLIPTICITY
ellipMax Plate SSA Maximum object ellipticity in IAM file real 4     PHYS_ELLIPTICITY
ellipMean Plate SSA Mean object ellipticity in IAM file real 4     PHYS_ELLIPTICITY
ellipMed Plate SSA Median ellipticity in IAM file real 4     PHYS_ELLIPTICITY
ellipMin Plate SSA Minimum object ellipticity in IAM file real 4     PHYS_ELLIPTICITY
ellipMode Plate SSA Modal object ellipticity in IAM file real 4     PHYS_ELLIPTICITY
ellipR1 CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Ellipticity of R1 band detection real 4   -0.99999995e9 PHYS_ELLIPTICITY
ellipR2 CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Ellipticity of R2 band detection real 4   -0.99999995e9 PHYS_ELLIPTICITY
ELLIPTICITY mgcDetection MGC 1 - B_IMAGE/A_IMAGE real 4      
emulpos Plate SSA SuperCOSMOS emulsion position, eg. up varchar 4     INST_PARAM
emulsion Plate SSA Kodak emulsion type, eg. 103a-E, IIIa-J, IV-N varchar 8     INST_PLATE_EMULSION
endCol MultiframeDetector WSA End column of array readout {image extension keyword: RDOUT_X2} smallint 2     NUMBER
endCol MultiframeDetector WSATransit End column of array readout {image extension keyword: RDOUT_X2} smallint 2     NUMBER
endDate AstrCalVers WSA MJD of the end time for this version of the calibration float 8 Julian days   TIME_DATE
endDate AstrCalVers WSATransit MJD of the end time for this version of the calibration float 8 Julian days   TIME_DATE
endDate PhotCalVers WSA Date time of end time for this version of the calibration (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
endDate PhotCalVers WSATransit Date time of end time for this version of the calibration (MM-DD-YYYY) datetime 8 MM-DD-YYYY 12-31-9999 TIME_DATE
endRow MultiframeDetector WSA End row of array readout {image extension keyword: RDOUT_Y2} smallint 2     NUMBER
endRow MultiframeDetector WSATransit End row of array readout {image extension keyword: RDOUT_Y2} smallint 2     NUMBER
EP_1_FLUX twoxmm XMM EP band 1 flux real 4 erg/cm**2/s    
EP_1_FLUX_ERR twoxmm XMM EP band 1 flux error
EP_1_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_1_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_2_FLUX twoxmm XMM EP band 2 flux real 4 erg/cm**2/s    
EP_2_FLUX_ERR twoxmm XMM EP band 2 flux error
EP_2_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_2_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_3_FLUX twoxmm XMM EP band 3 flux real 4 erg/cm**2/s    
EP_3_FLUX_ERR twoxmm XMM EP band 3 flux error
EP_3_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_3_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_4_FLUX twoxmm XMM EP band 4 flux real 4 erg/cm**2/s    
EP_4_FLUX_ERR twoxmm XMM EP band 4 flux error
EP_4_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_4_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_5_FLUX twoxmm XMM EP band 5 flux real 4 erg/cm**2/s    
EP_5_FLUX_ERR twoxmm XMM EP band 5 flux error
EP_5_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_5_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_8_CTS twoxmm XMM Combined band source counts real 4 counts    
EP_8_CTS_ERR twoxmm XMM Combined band source counts 1 σ error real 4 counts    
EP_8_DET_ML twoxmm XMM EP band 8 Maximum likelihood real 4      
EP_8_FLUX twoxmm XMM EP band 8 flux real 4 erg/cm**2/s    
EP_8_FLUX_ERR twoxmm XMM EP band 8 flux error
EP_8_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_8_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_8_RATE twoxmm XMM EP band 8 Count rates real 4 counts/s    
EP_8_RATE_ERR twoxmm XMM EP band 8 Count rates error real 4 counts/s    
EP_9_DET_ML twoxmm XMM EP band 9 Maximum likelihood real 4      
EP_9_FLUX twoxmm XMM EP band 9 flux real 4 erg/cm**2/s    
EP_9_FLUX_ERR twoxmm XMM EP band 9 flux error
EP_9_FLUX_ERR = SQRT ( 1.0 / SUM ( 1 / ca_9_FLUX_ERR2 )), where ca = PN, M1, M2		 real 4 erg/cm**2/s    
EP_9_RATE twoxmm XMM EP band 9 Count rates real 4 counts/s    
EP_9_RATE_ERR twoxmm XMM EP band 9 Count rates error real 4 counts/s    
EP_CHI2PROB twoxmm XMM The Chi² probability (based on the null hypothesis) that the source as detected by any of the cameras, is constant. The minimum value of the available camera probabilities (PN_CHI2PROB, M1_CHI2PROB, M2_CHI2PROB) is given. real 4      
EP_EXTENT twoxmm XMM The Extent radius of a source detected as extended. real 4 arcsec    
EP_EXTENT_ERR twoxmm XMM The Extent error of a source detected as extended. real 4 arcsec    
EP_EXTENT_ML twoxmm XMM The extent likelihood is the likelihood of the detection being extended as given by P = - ln (EXTENT_ML) , where P is the probability the extent occurring by chance. real 4      
EP_FLAG twoxmm XMM EPIC flag string made of the flags 1 - 12 (counted from left to right), where flag 10 is not used: it combines the PN, M1, and M2 flags, that is, a flag is set in EP_FLAG if at least one of the camera-dependent flags is set. varchar 12      
EP_HR1 twoxmm XMM The EP hardness ratio between the bands 1 & 2
In the case where the rate in one band is 0.0 (i.e., too faint to be detected in this band) the hardness ratio will be -1 or +1 which is only a lower or upper limit, respectively.		 real 4      
EP_HR1_ERR twoxmm XMM The 1 σ error of the EP hardness ratio between the bands 1 & 2 real 4      
EP_HR2 twoxmm XMM The EP hardness ratio between the bands 2 & 3
In the case where the rate in one band is 0.0 (i.e., too faint to be detected in this band) the hardness ratio will be -1 or +1 which is only a lower or upper limit, respectively.		 real 4      
EP_HR2_ERR twoxmm XMM The 1 σ error of the EP hardness ratio between the bands 2 & 3 real 4      
EP_HR3 twoxmm XMM The EP hardness ratio between the bands 3 & 4
In the case where the rate in one band is 0.0 (i.e., too faint to be detected in this band) the hardness ratio will be -1 or +1 which is only a lower or upper limit, respectively.		 real 4      
EP_HR3_ERR twoxmm XMM The 1 σ error of the EP hardness ratio between the bands 3 & 4 real 4      
EP_HR4 twoxmm XMM The EP hardness ratio between the bands 4 & 5
In the case where the rate in one band is 0.0 (i.e., too faint to be detected in this band) the hardness ratio will be -1 or +1 which is only a lower or upper limit, respectively.		 real 4      
EP_HR4_ERR twoxmm XMM The 1 σ error of the EP hardness ratio between the bands 4 & 5 real 4      
epoch CompleteStars, ReliableGalaxies, ReliableStars, Source SSA Epoch of position (variance weighted mean epoch of available measures) real 4 year   TIME_EPOCH
epoch Plate SSA Epoch of observation real 4 years   TIME_EPOCH
epoch dxsSourceRemeasurement, gcsSourceRemeasurement, gpsSourceRemeasurement, lasSourceRemeasurement, udsSourceRemeasurement WSA Epoch of position measurement float 8 Years -0.9999995e9 TIME_EPOCH
epoch dxsVariability, udsVariability WSA Epoch of measurement float 8 Years   TIME_EPOCH
The Variability table contains statistics from the set of observations of each source. At present, the mean ra and dec and the error in two tangential directions are calculated. The "ra" direction is defined as tangential to both the radial direction and the cartesian z-axis and the "dec" direction is defined as both the radial direction and the "ra" direction. Since the current model is just the mean and standard deviation of the data, then the chi-squared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in non-synoptic filters: the one observation in these bands can help. In future releases a fit will be made to the rms data as a function of magnitude in each band, as has already happened for photometric data and a motion model that incorporates proper motion (and possibly parallax) will be used. The motion model is a parameter in the VarFrameSetInfo table.
epoch gcsPointSource, gcsSource, gcsZYJHKsource, gpsJHKsource, gpsPointSource, gpsSource, lasExtendedSource, lasPointSource, lasSource, lasYJHKsource, reliableGcsPointSource, reliableGpsPointSource, reliableLasPointSource WSA Epoch of position measurement float 8 Years   TIME_EPOCH
epoch ukirtFSstars WSA The epoch of columns ra and dec real 4 years -0.9999995e9  
epochMax Survey SSA Maximum epoch of observations real 4 year   TIME_EPOCH
epochMin Survey SSA Minimum epoch of observations real 4 year   TIME_EPOCH
epTsys Survey SSA Time system for epoch values in SurveyCatalog varchar 16     NOTE
eqTsys Plate SSA Time system of equinox, eg. BESSELIAN varchar 12     NOTE
eqTsys Survey SSA Time system for equinox in SurveyCatalog varchar 16     NOTE
equinox Multiframe WSA Equinox of object position {image primary HDU keyword: EQUINOX} real 4 years -0.9999995e9 TIME_EQUINOX
equinox Multiframe WSATransit Equinox of object position {image primary HDU keyword: EQUINOX} real 4 years -0.9999995e9 TIME_EQUINOX
equinox Plate SSA Equinox of raPnt and decPnt real 4 year   TIME_EQUINOX
equinox Survey SSA Equinox for positions in SurveyCatalog real 4 year   TIME_EQUINOX
equinRef Plate SSA Equinox of refstar positions real 4     TIME_EQUINOX
err_ang twomass_psc 2MASS Position angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North) smallint 2 degrees   POS_POS-ANG
err_maj twomass_psc 2MASS Semi-major axis length of the one sigma position uncertainty ellipse real 4 arcsec   EXTENSION_RAD
err_min twomass_psc 2MASS Semi-minor axis length of the one sigma position uncertainty ellipse real 4 arcsec   EXTENSION_RAD
ERRA_IMAGE mgcDetection MGC Position error along major axis real 4 pixel    
ERRB_IMAGE mgcDetection MGC Position error along minor axis real 4 pixel    
errBits UKIDSSDetection WSA processing warning/error bitwise flags int 4     CODE_MISC
errBits dxsDetection, gcsDetection, gpsDetection, lasDetection WSA processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
Apparently not actually an error bit flag, but a count of the number of zero confidence pixels in the default (2 arcsec diameter) aperture.
errBits dxsListRemeasurement, gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, udsListRemeasurement WSA processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
errBits ptsDetection WSATransit processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
Apparently not actually an error bit flag, but a count of the number of zero confidence pixels in the default (2 arcsec diameter) aperture.
errBits udsDetection WSA processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} int 4     CODE_MISC
This uses the FLAGS attribute in SE. The individual bit flags that this can be decomposed into are as follows:
Bit FlagMeaning
1The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected).
2The object was originally blended with another
4At least one pixel is saturated (or very close to)
8The object is truncated (too close to an image boundary)
16Object's aperture data are incomplete or corrupted
32Object's isophotal data are imcomplete or corrupted. This is an old flag inherited from SE v1.0, and is kept for compatability reasons. It doesn't have any consequence for the extracted parameters.
64Memory overflow occurred during deblending
128Memory overflow occurred during extraction

errHr1 rosat_bsc, rosat_fsc ROSAT error of hardness ratio 1 float 8     ERROR
errHr2 rosat_bsc, rosat_fsc ROSAT error of hardness ratio 2 float 8     ERROR
errP rosat_bsc ROSAT total positional error (1-sigma-radius; including 6" systematic error) tinyint 1 arcsec   ERROR
errP rosat_fsc ROSAT total positional error (1-sigma-radius; including 6" systematic error) smallint 2 arcsec   ERROR
errSrcCps rosat_bsc, rosat_fsc ROSAT error of source countrate, vignetting corrected real 4 counts/s   ERROR
eta CurrentAstrometry WSATransit SDSS system spherical co-ordinate 2 of device centre float 8 Degrees   POS
eta CurrentAstrometry, PreviousAstrometry WSA SDSS system spherical co-ordinate 2 of device centre float 8 Degrees   POS
eta dxsDetection, dxsJKsource, dxsListRemeasurement, dxsSource, dxsSourceRemeasurement, gcsDetection, gcsListRemeasurement, gcsPointSource, gcsSource, gcsSourceRemeasurement, gcsZYJHKsource, gpsDetection, gpsJHKsource, gpsListRemeasurement, gpsPointSource, gpsSource, gpsSourceRemeasurement, lasDetection, lasExtendedSource, lasListRemeasurement, lasPointSource, lasSource, lasSourceRemeasurement, lasYJHKsource, reliableDxsSource, reliableGcsPointSource, reliableGpsPointSource, reliableLasPointSource, reliableUdsSource, UKIDSSDetection, udsDetection, udsListRemeasurement, udsSource, udsSourceRemeasurement WSA SDSS system spherical co-ordinate 2 float 8 Degrees   POS
eta ptsDetection WSATransit SDSS system spherical co-ordinate 2 float 8 Degrees   POS
ETA_TYPE mgcGalaxyStruct MGC 2dFGRS Eta type real 4   -99.9  
expLength Plate SSA Exposure time real 4 minutes   TIME_EXPTIME
expTime Multiframe WSA Integration time per exposure {image primary HDU keyword: EXP_TIME} real 4 seconds -0.9999995e9 TIME_EXPTIME
expTime Multiframe WSATransit Integration time per exposure {image primary HDU keyword: EXP_TIME} real 4 seconds -0.9999995e9 TIME_EXPTIME
expTime rosat_bsc ROSAT exposure time smallint 2 sec   TIME_EXPTIME
expTime rosat_fsc ROSAT exposure time int 4 sec   TIME_EXPTIME
ext rosat_bsc, rosat_fsc ROSAT source extent smallint 2 arcsec   EXTENSION_DIAM
ext_key twomass_psc 2MASS Unique identification number of the record in the XSC that corresponds to this point source. int 4     ID_NUMBER
ext_key twomass_xsc 2MASS entry counter (key) number (unique within table). int 4     ID_NUMBER
extinction Multiframe WSA Extinction coefficient {image primary HDU keyword: EXTINCT} real 4 mag -0.9999995e9  
extinction Multiframe WSATransit Extinction coefficient {image primary HDU keyword: EXTINCT} real 4 mag -0.9999995e9  
extinctionCat MultiframeDetector WSA Extinction coefficient for the catalogue data {catalogue extension keyword:  EXTINCT} real 4 mags -0.9999995e9 ??
For WFCAM these are currently set to a constant clear night level, which within the current measuring error is the same for all passbands. Note that the frame-by-frame derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view.
extinctionCat MultiframeDetector WSATransit Extinction coefficient for the catalogue data {catalogue extension keyword:  EXTINCT} real 4 mags -0.9999995e9 ??
For WFCAM these are currently set to a constant clear night level, which within the current measuring error is the same for all passbands. Note that the frame-by-frame derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view.
extinctionExt MultiframeDetector WSA Extinction coefficient of the detector {image extension keyword: EXTINCT} real 4 mags -0.9999995e9 ??
For WFCAM these are currently set to a constant clear night level, which within the current measuring error is the same for all passbands. Note that the frame-by-frame derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view.
extinctionExt MultiframeDetector WSATransit Extinction coefficient of the detector {image extension keyword: EXTINCT} real 4 mags -0.9999995e9 ??
For WFCAM these are currently set to a constant clear night level, which within the current measuring error is the same for all passbands. Note that the frame-by-frame derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view.
extl rosat_bsc, rosat_fsc ROSAT likelihood of source extent smallint 2     STAT_LIKELIHOOD
extNum allFrameSets, CurrentAstrometry, dxsDetection, dxsFrameSets, dxsListRemeasurement, dxsSourceXDetectionBestMatch, gcsDetection, gcsFrameSets, gcsListRemeasurement, gpsDetection, gpsFrameSets, gpsListRemeasurement, lasDetection, lasFrameSets, lasListRemeasurement, MultiframeDetector, PreviousAstrometry, PreviousMFDZP, UKIDSSDetection, udsDetection, udsFrameSets, udsListRemeasurement, udsSourceXDetectionBestMatch WSA the extension number of this frame tinyint 1     NUMBER
extNum CurrentAstrometry, ptsDetection WSATransit the extension number of this frame tinyint 1     NUMBER
extProgID RequiredNeighbours WSA the unique programme ID for second table if there are multiple programmes in the neighbour survey int 4   -99999999 ID_SURVEY
extProgID RequiredNeighbours WSATransit the unique programme ID for second table if there are multiple programmes in the neighbour survey int 4   -99999999 ID_SURVEY
extr rosat_bsc, rosat_fsc ROSAT extraction radius smallint 2 arcsec   REDUCT_EXTR-RAD
extractTool RequiredMosaic WSATransit Name of extraction tool to be used varchar 8   'CASU' ??
extractTool RequiredMosaic, RequiredStack WSA Name of extraction tool to be used varchar 8   'CASU' ??
extTableID ExternalSurveyTable WSATransit the unique table ID int 4     ID_MAIN
extTableID ExternalSurveyTable, RequiredNeighbours WSA the unique table ID int 4     ID_MAIN
extTableName ExternalSurveyTable WSA the name of the table varchar 256     ID_TABLE
extTableName ExternalSurveyTable WSATransit the name of the table varchar 256     ID_TABLE


Home | Overview | Browser | Access | Login | Cookbook | nonSurvey
Listing | Region | MenuQuery | FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK
Tel +44 131 668 8356 (office)
or +44 131 668 8100 (switchboard)

wsa-support@roe.ac.uk
30/04/2009