E 
Name  Schema Table  Database  Description  Type  Length  Unit  Default Value  Unified Content Descriptor 
e_b_v 
hipparcos_new_reduction 
GAIADR1 
Formal error on BV colour index 
float 
8 
mag 

em.opt;phot.colour;stat.error 
e_bp_min_rp_percentile_lower 
gaia_source 
GAIADR2 
Lower uncertainty on e_bp_min_rp_val 
real 
4 
mag 


e_bp_min_rp_percentile_Upper 
gaia_source 
GAIADR2 
Upper uncertainty on e_bp_min_rp_val 
real 
4 
mag 


e_bp_min_rp_val 
gaia_source 
GAIADR2 
Lineofsight reddening E(BPRP) 
real 
4 
mag 


e_bt_mag 
tycho2 
GAIADR1 
Standard error on BT 
real 
4 
mag 

stat.error 
e_de_deg 
tycho2 
GAIADR1 
Standard error of observed Tycho2 Dec 
float 
8 
milliarcsec 

stat.error 
e_de_m_deg 
tycho2 
GAIADR1 
Standard error of mean Tycho2 Dec 
float 
8 
milliarcsec 

stat.error 
e_de_rad 
hipparcos_new_reduction 
GAIADR1 
Formal error on de_rad 
float 
8 
milliarcsec 

pos.eq.dec;stat.error 
e_DEcs 
nvssSource 
NVSS 
Mean error on Dec 
real 
4 
arcsec 

ERROR 
e_hp_mag 
hipparcos_new_reduction 
GAIADR1 
Error on mean Hipparcos magnitude 
float 
8 
mag 

em.opt.V;phot.mag;stat.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_plx 
hipparcos_new_reduction 
GAIADR1 
Formal error on parallax 
float 
8 
milliarcsec 

pos.parallax;stat.error 
e_pm_de 
hipparcos_new_reduction 
GAIADR1 
Formal error on pm_de 
float 
8 
milliarcsec/year 

pos.eq.dec;pos.pm;stat.error 
e_pm_de 
tycho2 
GAIADR1 
Standard error of Dec proper motion 
real 
4 
milliarcsec/year 

stat.error 
e_pm_ra 
hipparcos_new_reduction 
GAIADR1 
Formal error on pm_ra 
float 
8 
milliarcsec/year 

pos.eq.ra;pos.pm;stat.error 
e_pm_ra 
tycho2 
GAIADR1 
Standard error in RA*cos(Dec) of RA proper motion 
real 
4 
milliarcsec/year 

stat.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_ra_deg 
tycho2 
GAIADR1 
Standard error in RA*cos(Dec) of observed Tycho2 RA 
float 
8 
milliarcsec 

stat.error 
e_ra_m_deg 
tycho2 
GAIADR1 
Standard error in RA*cos(Dec) of mean Tycho2 RA 
float 
8 
milliarcsec 

stat.error 
e_ra_rad 
hipparcos_new_reduction 
GAIADR1 
Formal error on ra_rad 
float 
8 
milliarcsec 

pos.eq.ra;stat.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(pointlike). 
real 
4 


CODE_MISC 
e_vt_mag 
tycho2 
GAIADR1 
Standard error on VT 
real 
4 
mag 

stat.error 
eBV 
calSource 
WSACalib 
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(BV)>0.1) 
real 
4 

0.9999995e9 

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(BV)>0.1) 
real 
4 

0.9999995e9 

eBV 
lasYselJSourceRemeasurement 
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(BV)>0.1) 
real 
4 

0.9999995e9 
phys.absorption.gal 
eBV 
uhsSource, uhsSourceAll 
WSAUHS 
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(BV)>0.1) 
real 
4 

0.9999995e9 

ebv 
twompzPhotoz 
TWOMPZ 
The Galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. {image primary HDU keyword: EBV} 
real 
4 
mag 
0.9999995e9 
phys.absorption.gal 
ebv 
wiseScosPhotoz, wiseScosPhotozRejects, wiseScosSvm 
WISExSCOSPZ 
The Galactic dust extinction value measured from the Schlegel, Finkbeiner & Davis (1998) maps. {image primary HDU keyword: Ebmv} 
real 
4 
mag 
0.9999995e9 
phys.absorption.gal 
ecl_lat 
gaia_source 
GAIADR2 
Ecliptic latitude 
float 
8 
degrees 

pos.ecliptic.lat 
ecl_lat 
gaia_source 
GAIAEDR3 
Ecliptic latitude 
float 
8 
degrees 

pos.ecliptic.lat 
ecl_lat 
gaia_source, tgas_source 
GAIADR1 
Ecliptic latitude 
float 
8 
degrees 

pos.ecliptic.lat 
ecl_lon 
gaia_source 
GAIADR2 
Ecliptic longitude 
float 
8 
degrees 

pos.ecliptic.lon 
ecl_lon 
gaia_source 
GAIAEDR3 
Ecliptic longitude 
float 
8 
degrees 

pos.ecliptic.lon 
ecl_lon 
gaia_source, tgas_source 
GAIADR1 
Ecliptic longitude 
float 
8 
degrees 

pos.ecliptic.lon 
ecliptic_lat 
igsl_source 
GAIADR1 
Ecliptic latitude 
real 
4 
degrees 

pos.ecliptic.lat 
ecliptic_lon 
igsl_source 
GAIADR1 
Ecliptic longitude 
real 
4 
degrees 

pos.ecliptic.lon 
eFlag 
rosat_bsc, rosat_fsc 
ROSAT 
source extended beyond SASS extraction radius 
varchar 
1 


CODE_MISC 
elat 
allwise_sc 
WISE 
Ecliptic latitude computed from the nonmoving source fit equatorial position. CAUTION: This coordinate should not be used as an astrometric reference. 
float 
8 
deg 


elat 
catwise_2020, catwise_prelim 
WISE 
ecliptic latitude 
float 
8 
deg 


elat 
wise_allskysc 
WISE 
Ecliptic latitude. CAUTION: This coordinate should not be used as an astrometric reference. 
float 
8 
degrees 


elat 
wise_prelimsc 
WISE 
Ecliptic latitude. CAUTION: This coordinate should not be used as an astrometric reference 
float 
8 
degrees 


elat_avg 
catwise_2020, catwise_prelim 
WISE 
averaged ecliptic latitude 
float 
8 
deg 


elatSig 
catwise_2020, catwise_prelim 
WISE 
onesigma uncertainty in elat 
real 
4 
arcsec 


ell 
UKIDSSDetection 
WSA 
1b/a, where a/b=semimajor/minor axes 
real 
4 


PHYS_ELLIPTICITY 
ell 
calDetection 
WSACalib 
1b/a, where a/b=semimajor/minor axes {catalogue TType keyword: Ellipticity} 
real 
4 


PHYS_ELLIPTICITY 
ell 
dxsDetection, gcsDetection, gpsDetection, lasDetection 
WSA 
1b/a, where a/b=semimajor/minor axes {catalogue TType keyword: Ellipticity} 
real 
4 


PHYS_ELLIPTICITY 
ell 
lasMapRemeasAver 
WSA 
Averaged 1b/a, where a/b=semimajor/minor axes (SE: THETA_IMAGE) 
real 
4 


src.ellipticity 
ell 
lasMapRemeasurement 
WSA 
1b/a, where a/b=semimajor/minor axes (SE: THETA_IMAGE) {catalogue TType keyword: Ellipticity} 
real 
4 


src.ellipticity 
ell 
ptsDetection 
WSATransit 
1b/a, where a/b=semimajor/minor axes {catalogue TType keyword: Ellipticity} 
real 
4 


PHYS_ELLIPTICITY 
ell 
udsDetection 
WSA 
1b/a, where a/b=semimajor/minor axes (SE: THETA_IMAGE) {catalogue TType keyword: Ellipticity} 
real 
4 


PHYS_ELLIPTICITY 
ell 
uhsDetection, uhsDetectionAll 
WSAUHS 
1b/a, where a/b=semimajor/minor axes {catalogue TType keyword: Ellipticity} 
real 
4 


PHYS_ELLIPTICITY 
ellfit_flg 
twomass_xsc 
2MASS 
ellipse fitting contamination flag. 
smallint 
2 


CODE_MISC 
ELLIPTICITY 
mgcDetection 
MGC 
1  B_IMAGE/A_IMAGE 
real 
4 



elon 
allwise_sc 
WISE 
Ecliptic longitude computed from the nonmoving source fit equatorial position. CAUTION: This coordinate should not be used as an astrometric reference. 
float 
8 
deg 


elon 
catwise_2020, catwise_prelim 
WISE 
ecliptic longitude 
float 
8 
deg 


elon 
wise_allskysc 
WISE 
Ecliptic longitude. CAUTION: This coordinate should not be used as an astrometric reference. 
float 
8 
degrees 


elon 
wise_prelimsc 
WISE 
Ecliptic longitude. CAUTION: This coordinate should not be used as an astrometric reference 
float 
8 
degrees 


elon_avg 
catwise_2020, catwise_prelim 
WISE 
averaged ecliptic longitude 
float 
8 
deg 


elonSig 
catwise_2020, catwise_prelim 
WISE 
onesigma uncertainty in elon 
real 
4 
arcsec 


endCol 
MultiframeDetector 
WSA 
End column of array readout {image extension keyword: RDOUT_X2} 
smallint 
2 


meta.number 
endCol 
MultiframeDetector 
WSACalib 
End column of array readout {image extension keyword: RDOUT_X2} 
smallint 
2 


meta.number 
endCol 
MultiframeDetector 
WSATransit 
End column of array readout {image extension keyword: RDOUT_X2} 
smallint 
2 


meta.number 
endCol 
MultiframeDetector 
WSAUHS 
End column of array readout {image extension keyword: RDOUT_X2} 
smallint 
2 


meta.number 
endDate 
AstrCalVers 
WSA 
MJD of the end time for this version of the calibration 
float 
8 
Julian days 

time.epoch 
endDate 
AstrCalVers 
WSACalib 
MJD of the end time for this version of the calibration 
float 
8 
Julian days 

time.epoch 
endDate 
AstrCalVers 
WSATransit 
MJD of the end time for this version of the calibration 
float 
8 
Julian days 

time.epoch 
endDate 
AstrCalVers 
WSAUHS 
MJD of the end time for this version of the calibration 
float 
8 
Julian days 

time.epoch 
endDate 
PhotCalVers 
WSA 
Date time of end time for this version of the calibration (MMDDYYYY) 
datetime 
8 
MMDDYYYY 
12319999 
time.epoch 
endDate 
PhotCalVers 
WSACalib 
Date time of end time for this version of the calibration (MMDDYYYY) 
datetime 
8 
MMDDYYYY 
12319999 
time.epoch 
endDate 
PhotCalVers 
WSATransit 
Date time of end time for this version of the calibration (MMDDYYYY) 
datetime 
8 
MMDDYYYY 
12319999 
time.epoch 
endDate 
PhotCalVers 
WSAUHS 
Date time of end time for this version of the calibration (MMDDYYYY) 
datetime 
8 
MMDDYYYY 
12319999 
time.epoch 
endRow 
MultiframeDetector 
WSA 
End row of array readout {image extension keyword: RDOUT_Y2} 
smallint 
2 


meta.number 
endRow 
MultiframeDetector 
WSACalib 
End row of array readout {image extension keyword: RDOUT_Y2} 
smallint 
2 


meta.number 
endRow 
MultiframeDetector 
WSATransit 
End row of array readout {image extension keyword: RDOUT_Y2} 
smallint 
2 


meta.number 
endRow 
MultiframeDetector 
WSAUHS 
End row of array readout {image extension keyword: RDOUT_Y2} 
smallint 
2 


meta.number 
EP_1_FLUX 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 1 flux 
real 
4 
erg/cm**2/s 


EP_1_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 2 flux 
real 
4 
erg/cm**2/s 


EP_2_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 3 flux 
real 
4 
erg/cm**2/s 


EP_3_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 4 flux 
real 
4 
erg/cm**2/s 


EP_4_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 5 flux 
real 
4 
erg/cm**2/s 


EP_5_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
Combined band source counts 
real 
4 
counts 


EP_8_CTS_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
Combined band source counts 1 σ error 
real 
4 
counts 


EP_8_DET_ML 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 8 Maximum likelihood 
real 
4 



EP_8_FLUX 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 8 flux 
real 
4 
erg/cm**2/s 


EP_8_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 8 Count rates 
real 
4 
counts/s 


EP_8_RATE_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 8 Count rates error 
real 
4 
counts/s 


EP_9_DET_ML 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 9 Maximum likelihood 
real 
4 



EP_9_FLUX 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 9 flux 
real 
4 
erg/cm**2/s 


EP_9_FLUX_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 9 Count rates 
real 
4 
counts/s 


EP_9_RATE_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
EP band 9 Count rates error 
real 
4 
counts/s 


EP_CHI2PROB 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 
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_CHI2PROB 
xmm3dr4 
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. 
float 
8 



ep_de1990 
tycho2 
GAIADR1 
Epoch  1990 of de_deg 
real 
4 
years 

time.epoch 
ep_de_m 
tycho2 
GAIADR1 
Mean epoch of dec (Julian years) 
real 
4 
years 

time.epoch 
EP_DIST_NN 
twoxmmi_dr3_v1_0 
XMM 
The distance to the nearest neighbouring detection. An internal threshold of 6 arseconds (before positional fitting) is used for splitting a source into two. 
real 
4 
arcsec 


EP_EXTENT 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The Extent radius of a source detected as extended. 
real 
4 
arcsec 


EP_EXTENT_ERR 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The Extent error of a source detected as extended. 
real 
4 
arcsec 


EP_EXTENT_ML 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0 
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 cameradependent flags is set. 
varchar 
12 



EP_FLAG 
xmm3dr4 
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 cameradependent flags is set. 
varchar 
50 



EP_HR1 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The 1 σ error of the EP hardness ratio between the bands 1 & 2 
real 
4 



EP_HR2 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The 1 σ error of the EP hardness ratio between the bands 2 & 3 
real 
4 



EP_HR3 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The 1 σ error of the EP hardness ratio between the bands 3 & 4 
real 
4 



EP_HR4 
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
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, twoxmm_v1_2, twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The 1 σ error of the EP hardness ratio between the bands 4 & 5 
real 
4 



EP_OFFAX 
twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The EP offaxis angle (the distance between the detection position and the onaxis position on the respective detector). The offaxis angle for a camera can be larger than 15 arcminutes when the detection is located outside the FOV of that camera. 
real 
4 
arcmin 


EP_ONTIME 
twoxmmi_dr3_v1_0, xmm3dr4 
XMM 
The EP ontime value (the total good exposure time (after GTI filtering) of the CCD where the detection is positioned). If a source position falls into CCD gaps or outside of the detector it will have a NULL given. 
real 
4 
s 


ep_ra1990 
tycho2 
GAIADR1 
Epoch  1990 of ra_deg 
real 
4 
years 

time.epoch 
ep_ra_m 
tycho2 
GAIADR1 
Mean epoch of ra (Julian years) 
real 
4 
years 

time.epoch 
epoch 
RequiredMergeLogMultiEpoch 
WSA 
Epoch number in MergeLog table 
tinyint 
1 



epoch 
RequiredMergeLogMultiEpoch 
WSAUHS 
Epoch number in MergeLog table 
tinyint 
1 



epoch 
calVariability 
WSACalib 
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 zaxis 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 chisquared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in nonsynoptic 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 
dxsVariability, gcsVariability, gpsVariability, lasVariability, 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 zaxis 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 chisquared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in nonsynoptic 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 
uhsVariability 
WSAUHS 
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 zaxis 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 chisquared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in nonsynoptic 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 
ukirtFSstars 
WSA 
The epoch of columns ra and dec 
real 
4 
years 
0.9999995e9 

epoch 
ukirtFSstars 
WSACalib 
The epoch of columns ra and dec 
real 
4 
years 
0.9999995e9 

epoch 
ukirtFSstars 
WSAUHS 
The epoch of columns ra and dec 
real 
4 
years 
0.9999995e9 

epoch_g 
cepheid, rrlyrae 
GAIADR1 
Epoch of the maximum of the light curve in the G band 
float 
8 
Barycentric JD in TCB  2455197.5 days 

time.epoch;stat.max 
epoch_g_error 
cepheid, rrlyrae 
GAIADR1 
Uncertainty on epoch of the maximum of the light curve in the G band 
float 
8 
days 

stat.error;time.epoch 
epochFrameType 
Programme 
WSA 
The frame type to be used for each epoch (stack, tile) 
varchar 
16 

NONE 

epochFrameType 
Programme 
WSACalib 
The frame type to be used for each epoch (stack, tile) 
varchar 
16 

NONE 

epochFrameType 
Programme 
WSATransit 
The frame type to be used for each epoch (stack, tile) 
varchar 
16 

NONE 

epochFrameType 
Programme 
WSAUHS 
The frame type to be used for each epoch (stack, tile) 
varchar 
16 

NONE 

epochMean 
ObjectThin 
PS1DR2 
Modified Julian Date of the mean epoch corresponding to raMean, decMean (equinox J2000). Note that Gaia DR1 data is sometimes included in the mean position; in those cases, the epochMean value is near the Gaia DR1 epoch 2015.5 = MJD 15023. As a result, epochMean is not necessarily near the mean value of the PS1 measurement dates. 
float 
8 
days 
999 

epochTolerance 
Programme 
WSA 
Minimum separation of epochs for proper motion calculation 
real 
4 
days 
0.9999995e9 
?? 
epochTolerance 
Programme 
WSACalib 
Minimum separation of epochs for proper motion calculation 
real 
4 
days 
0.9999995e9 
?? 
epochTolerance 
Programme 
WSATransit 
Minimum separation of epochs for proper motion calculation 
real 
4 
days 
0.9999995e9 
?? 
epochTolerance 
Programme 
WSAUHS 
Minimum separation of epochs for proper motion calculation 
real 
4 
days 
0.9999995e9 
?? 
equinox 
Multiframe 
WSA 
Equinox of object position {image primary HDU keyword: EQUINOX} 
real 
4 
years 
0.9999995e9 
time.equinox 
equinox 
Multiframe 
WSACalib 
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 
Multiframe 
WSAUHS 
Equinox of object position {image primary HDU keyword: EQUINOX} 
real 
4 
years 
0.9999995e9 
time.equinox 
err_ang 
twomass_psc 
2MASS 
Position angle on the sky of the semimajor axis of the position uncertainty ellipse (East of North) 
smallint 
2 
degrees 

POS_POSANG 
err_ang 
twomass_sixx2_psc 
2MASS 
angle of error ellipse major axis (E of N) 
smallint 
2 
deg 


err_maj 
twomass_psc 
2MASS 
Semimajor axis length of the one sigma position uncertainty ellipse 
real 
4 
arcsec 

EXTENSION_RAD 
err_maj 
twomass_sixx2_psc 
2MASS 
major axis of 1sigma error ellipse 
real 
4 
arcsec 


err_min 
twomass_psc 
2MASS 
Semiminor axis length of the one sigma position uncertainty ellipse 
real 
4 
arcsec 

EXTENSION_RAD 
err_min 
twomass_sixx2_psc 
2MASS 
minor axis of 1sigma error ellipse 
real 
4 
arcsec 


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 
calDetection 
WSACalib 
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 
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 
lasMapRemeasurement 
WSA 
processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} 
int 
4 


meta.code 
This uses the FLAGS attribute in SE. The individual bit flags that this can be decomposed into are as follows: Bit Flag  Meaning   1  The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected).   2  The object was originally blended with another   4  At least one pixel is saturated (or very close to)   8  The object is truncated (too close to an image boundary)   16  Object's aperture data are incomplete or corrupted   32  Object'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.   64  Memory overflow occurred during deblending   128  Memory overflow occurred during extraction  

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 Flag  Meaning   1  The object has neighbours, bright enough and close enough to significantly bias the MAG_AUTO photometry or bad pixels (more than 10% of photometry affected).   2  The object was originally blended with another   4  At least one pixel is saturated (or very close to)   8  The object is truncated (too close to an image boundary)   16  Object's aperture data are incomplete or corrupted   32  Object'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.   64  Memory overflow occurred during deblending   128  Memory overflow occurred during extraction  

errBits 
uhsDetection, uhsDetectionAll 
WSAUHS 
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. 
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 (1sigmaradius; including 6" systematic error) 
tinyint 
1 
arcsec 

ERROR 
errP 
rosat_fsc 
ROSAT 
total positional error (1sigmaradius; 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 
WSACalib 
SDSS system spherical coordinate 2 of device centre 
float 
8 
Degrees 

pos 
eta 
CurrentAstrometry 
WSATransit 
SDSS system spherical coordinate 2 of device centre 
float 
8 
Degrees 

pos 
eta 
CurrentAstrometry 
WSAUHS 
SDSS system spherical coordinate 2 of device centre 
float 
8 
Degrees 

pos 
eta 
CurrentAstrometry, PreviousAstrometry 
WSA 
SDSS system spherical coordinate 2 of device centre 
float 
8 
Degrees 

pos 
eta 
dxsDetection, dxsJKsource, dxsSource, gcsDetection, gcsPointSource, gcsSource, gcsZYJHKsource, gpsDetection, gpsJHKsource, gpsPointSource, gpsSource, lasDetection, lasExtendedSource, lasPointSource, lasSource, lasYJHKsource, reliableDxsSource, reliableGcsPointSource, reliableGpsPointSource, reliableLasPointSource, reliableUdsSource, UKIDSSDetection, udsDetection, udsSource 
WSA 
SDSS system spherical coordinate 2 
float 
8 
Degrees 

POS 
eta 
calDetection, calSource, calSynopticSource 
WSACalib 
SDSS system spherical coordinate 2 
float 
8 
Degrees 

POS 
eta 
gaiaxwise_matches 
GAIAXWISE 
Photometric logarithmic likelihood ratio of GaiaWISE match, as described by equation 37 of Wilson & Naylor (2018a, MNRAS, 473, 5570). 
float 
8 
dimensionless 


eta 
lasMapRemeasAver, lasMapRemeasurement 
WSA 
SDSS system spherical coordinate 2 
float 
8 
Degrees 

pos 
eta 
lasYselJSourceRemeasurement 
WSA 
SDSS system spherical coordinate 2 of aperture 
float 
8 
Degrees 

pos 
eta 
ptsDetection 
WSATransit 
SDSS system spherical coordinate 2 
float 
8 
Degrees 

POS 
eta 
uhsDetection, uhsDetectionAll, uhsSource, uhsSourceAll 
WSAUHS 
SDSS system spherical coordinate 2 
float 
8 
Degrees 

POS 
ETA_TYPE 
mgcGalaxyStruct 
MGC 
2dFGRS Eta type 
real 
4 

99.9 

expAstErr 
calVariability 
WSACalib 
Rms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude 
real 
4 
arcsec 
0.9999995e9 

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 zaxis 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 chisquared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in nonsynoptic 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. 
expAstErr 
dxsVariability, gcsVariability, gpsVariability, lasVariability, udsVariability 
WSA 
Rms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude 
real 
4 
arcsec 
0.9999995e9 

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 zaxis 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 chisquared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in nonsynoptic 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. 
expAstErr 
uhsVariability 
WSAUHS 
Rms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude 
real 
4 
arcsec 
0.9999995e9 

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 zaxis 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 chisquared of the fit=1. Data from good frames across all bands go into the astrometric model determination. This will include bands in nonsynoptic 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. 
expTime 
Detection 
PS1DR2 
Exposure time of the frame/exposure. Necessary for converting listed fluxes and magnitudes back to measured ADU counts. 
real 
4 
seconds 
999 

expTime 
Multiframe 
WSA 
Integration time per exposure {image primary HDU keyword: EXP_TIME} 
real 
4 
seconds 
0.9999995e9 
time.duration;obs.exposure 
expTime 
Multiframe 
WSACalib 
Integration time per exposure {image primary HDU keyword: EXP_TIME} 
real 
4 
seconds 
0.9999995e9 
time.duration;obs.exposure 
expTime 
Multiframe 
WSATransit 
Integration time per exposure {image primary HDU keyword: EXP_TIME} 
real 
4 
seconds 
0.9999995e9 
time.duration;obs.exposure 
expTime 
Multiframe 
WSAUHS 
Integration time per exposure {image primary HDU keyword: EXP_TIME} 
real 
4 
seconds 
0.9999995e9 
time.duration;obs.exposure 
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_cat_solution_type 
gaia_hip_tycho2_match 
GAIADR1 
Type of solution in the Hipparcos/Tycho2 catalogue 
varchar 
1 


meta.code 
ext_flg 
allwise_sc 
WISE 
Extended source flag. This is an integer flag, the value of which indicates whether or not the morphology of a source is consistent with the WISE point spread function in any band, or whether the source is associated with or superimposed on a previously known extended object from the 2MASS Extended Source Catalog (XSC). CAUTION: WISE profilefit (w?mpro) and standard aperture (w?mag) measurements are optimized for point sources and will systematically underestimate the true flux of resolved objects. If a source entry has ext_flg>0, you may wish to examine the large aperture photometry, or the elliptical aperture photometry which are measured using areas that are scaled from 2MASS XSC morphologies. 
int 
4 



The values of the ext_flg indicate the following conditions:  0  The source shape is consistent with a pointsource and the source is not associated with or superimposed on a 2MASS XSC source
 1  The profilefit photometry goodnessoffit, w?rchi2, is >3.0 in one or more bands.
 2  The source falls within the extrapolated isophotal footprint of a 2MASS XSC source.
 3  The profilefit photometry goodnessoffit,w?rchi2, is >3.0 in one or more bands, and the source falls within the extrapolated isophotal footprint of a 2MASS XSC source.
 4  The source position falls within 5" of a 2MASS XSC source.
 5  The profilefit photometry goodnessoffit,w?rchi2, is >3.0 in one or more bands, and the source position falls within 5" of a 2MASS XSC source.

ext_flg 
wise_allskysc 
WISE 
Extended source flag. This flag indicates whether or not the morphology of a source is consistent with the WISE point spread function in any band or whether the source is associated with or superimposed on a previously known extended object from the 2MASS Extended Source Catalog (XSC): 0  The source shape is consistent with a pointsource; 1  The source shape is not consistent with a pointsource; 2  The source falls within the extrapolated isophotal footprint of a 2MASS XSC source; 3  The profilefit photometry goodnessoffit, w?rchi2, is >3.0 in one or more bands, and The source falls within the extrapolated isophotal footprint of a 2MASS XSC source; 4  The source position falls within 5" of a 2MASS XSC source; 5  The profilefit photometry goodnessoffit, w?rchi2, is >3.0 in one or more bands, and the source position falls within 5" of a 2MASS XSC source. CAUTION: WISE profilefit (w?mpro) and standard aperture (w?mag) measurements are optimized for point sources and will systematically underestimate the true flux of resolved objects. 
tinyint 
1 



ext_flg 
wise_prelimsc 
WISE 
Extended source flag This flag indicates whether or not the morphology of a source is consistent with the WISE point spread function in any band: 0  The source shape is consistent with a pointsource; 1  The source shape is not consistent with a pointsource 
tinyint 
1 



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 
WSACalib 
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 

extinction 
Multiframe 
WSAUHS 
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 framebyframe derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view. 
extinctionCat 
MultiframeDetector 
WSACalib 
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 framebyframe 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 framebyframe derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view. 
extinctionCat 
MultiframeDetector 
WSAUHS 
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 framebyframe 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 framebyframe derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view. 
extinctionExt 
MultiframeDetector 
WSACalib 
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 framebyframe 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 framebyframe derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view. 
extinctionExt 
MultiframeDetector 
WSAUHS 
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 framebyframe derived ZP from 2MASS automatically corrects for extinction variations, assuming they are uniform across the field of view. 
extinctionMapList 
Programme 
WSA 
A list of 3D extinction maps that should be matched to this survey 
varchar 
32 

NONE 
meta.id 
extinctionMapList 
Programme 
WSACalib 
A list of 3D extinction maps that should be matched to this survey 
varchar 
32 

NONE 
meta.id 
extinctionMapList 
Programme 
WSATransit 
A list of 3D extinction maps that should be matched to this survey 
varchar 
32 

NONE 
meta.id 
extinctionMapList 
Programme 
WSAUHS 
A list of 3D extinction maps that should be matched to this survey 
varchar 
32 

NONE 
meta.id 
extl 
rosat_bsc, rosat_fsc 
ROSAT 
likelihood of source extent 
smallint 
2 


STAT_LIKELIHOOD 
extMapID 
gpsSourceExtinction 
WSA 
UID of 3D extinction map used 
tinyint 
1 

0 

extNSigma 
Detection 
PS1DR2 
An extendedness measure based on the deviation between PSF and Kron (1980) magnitudes, normalized by the PSF magnitude uncertainty. 
real 
4 

0 

extNum 
CurrentAstrometry 
WSACalib 
the extension number of this frame 
tinyint 
1 


meta.number 
extNum 
CurrentAstrometry 
WSATransit 
the extension number of this frame 
tinyint 
1 


meta.number 
extNum 
CurrentAstrometry 
WSAUHS 
the extension number of this frame 
tinyint 
1 


meta.number 
extNum 
CurrentAstrometry, EpochFrameStatus, lasMapRemeasurement, MultiframeDetector, PreviousAstrometry, PreviousMFDZP 
WSA 
the extension number of this frame 
tinyint 
1 


meta.number 
extNum 
dxsAstrometricInfo, dxsDetection, dxsFrameSets, dxsOrphan, dxsSourceXDetectionBestMatch, gcsAstrometricInfo, gcsDetection, gcsFrameSets, gcsOrphan, gcsSourceXDetectionBestMatch, gpsAstrometricInfo, gpsDetection, gpsFrameSets, gpsOrphan, gpsSourceXDetectionBestMatch, lasAstrometricInfo, lasDetection, lasFrameSets, lasOrphan, lasSourceXDetectionBestMatch, UKIDSSDetection, udsAstrometricInfo, udsDetection, udsFrameSets, udsOrphan, udsSourceXDetectionBestMatch 
WSA 
the extension number of this frame 
tinyint 
1 


NUMBER 
extNum 
calDetection 
WSACalib 
the extension number of this frame 
tinyint 
1 


NUMBER 
extNum 
lasMapRemeasAver 
WSA 
the extension number of this frame. 
tinyint 
1 


meta.number 
extNum 
ptsDetection 
WSATransit 
the extension number of this frame 
tinyint 
1 


NUMBER 
extNum 
uhsAstrometricInfo, uhsDetection, uhsDetectionAll, uhsOrphan, uhsSourceXDetectionBestMatch 
WSAUHS 
the extension number of this frame 
tinyint 
1 


NUMBER 
extPixelID 
gpsSourceExtinction 
WSA 
Pixel ID from 3D extinction map that matches source position 
int 
4 

99999999 

extProgID 
RequiredNeighbours 
WSA 
the unique programme ID for second table if there are multiple programmes in the neighbour survey 
int 
4 

99999999 
meta.id 
extProgID 
RequiredNeighbours 
WSACalib 
the unique programme ID for second table if there are multiple programmes in the neighbour survey 
int 
4 

99999999 
meta.id 
extProgID 
RequiredNeighbours 
WSATransit 
the unique programme ID for second table if there are multiple programmes in the neighbour survey 
int 
4 

99999999 
meta.id 
extProgID 
RequiredNeighbours 
WSAUHS 
the unique programme ID for second table if there are multiple programmes in the neighbour survey 
int 
4 

99999999 
meta.id 
extr 
rosat_bsc, rosat_fsc 
ROSAT 
extraction radius 
smallint 
2 
arcsec 

REDUCT_EXTRRAD 
extractor 
RequiredMatchedApertureProduct 
WSA 
CASU list driven or SExtractor dual image mode 
varchar 
16 



extractor 
RequiredMatchedApertureProduct 
WSAUHS 
CASU list driven or SExtractor dual image mode 
varchar 
16 



extractor 
RequiredMosaicTopLevel 
WSAUHS 
Extraction software (e.g. SExtractor) 
varchar 
16 



extractParamTemp 
RequiredMosaicTopLevel 
WSAUHS 
Template file for SWARP parameters 
varchar 
32 

NONE 

extractTool 
Programme 
WSA 
Name of extraction tool to be used 
varchar 
8 

NONE 
?? 
extractTool 
Programme 
WSACalib 
Name of extraction tool to be used 
varchar 
8 

NONE 
?? 
extractTool 
Programme 
WSATransit 
Name of extraction tool to be used 
varchar 
8 

NONE 
?? 
extractTool 
Programme 
WSAUHS 
Name of extraction tool to be used 
varchar 
8 

NONE 
?? 
extTableID 
ExternalSurveyTable 
WSACalib 
the unique table ID 
int 
4 


meta.id;meta.main 
extTableID 
ExternalSurveyTable 
WSATransit 
the unique table ID 
int 
4 


meta.id;meta.main 
extTableID 
ExternalSurveyTable 
WSAUHS 
the unique table ID 
int 
4 


meta.id;meta.main 
extTableID 
ExternalSurveyTable, RequiredNeighbours 
WSA 
the unique table ID 
int 
4 


meta.id;meta.main 
extTableName 
ExternalSurveyTable 
WSA 
the name of the table 
varchar 
256 


meta.id;meta.dataset 
extTableName 
ExternalSurveyTable 
WSACalib 
the name of the table 
varchar 
256 


meta.id;meta.dataset 
extTableName 
ExternalSurveyTable 
WSATransit 
the name of the table 
varchar 
256 


meta.id;meta.dataset 
extTableName 
ExternalSurveyTable 
WSAUHS 
the name of the table 
varchar 
256 


meta.id;meta.dataset 