Home | Overview | Browser | Access | Login | Cookbook 
  OSA logo

Glossary of OSA attributes

This Glossary alphabetically lists all attributes used in the OSAv20230621 database(s) held in the OSA. If you would like to have more information about the schema tables please use the OSAv20230621 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

V

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
v_i hipparcos_new_reduction GAIADR1 V-I colour index float 8 mag   phot.color;em.opt.V;em.opt.I
va hipparcos_new_reduction GAIADR1 Reference to variability annex int 4     meta.note
var hipparcos_new_reduction GAIADR1 Cosmic dispersion added (stochastc solution) float 8     stat.fit.residual
var iras_psc IRAS percent Likelihood of Variability smallint 2     meta.code;src.var
VAR_EXP_ID twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 XMM If the source is detected as variable (that is, if VAR_FLAG is set to True), the exposure ID ('S' or 'U' followed by a three-digit number) of the exposure with the smallest Chi² probability is given here. varchar 4      
VAR_EXP_ID xmm3dr4 XMM If the source is detected as variable (that is, if VAR_FLAG is set to True), the exposure ID ('S' or 'U' followed by a three-digit number) of the exposure with the smallest Chi² probability is given here. varchar 50      
VAR_FLAG twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 XMM The flag is set to True if this source was detected as variable (Chi² probability < 1E-5, see PN_CHI2PROB, M1_CHI2PROB, M2_CHI2PROB) in at least one exposure. varchar 5      
VAR_FLAG xmm3dr4 XMM The flag is set to 1 if this source was detected as variable (Chi² probability < 1E-5, see PN_CHI2PROB, M1_CHI2PROB, M2_CHI2PROB) in at least one exposure. bit 1      
var_flg allwise_sc WISE Variability flag. The variability flag is a four-character string, one character per band, in which the value for each band is related to the probability that the source flux measured on the individual WISE exposures was not constant with time. The probability calculation uses the standard deviation of the single exposure flux measurements, w?sigp1, as well as the band-to-band flux correlation significance, q12,q23,q34. CAUTION: Estimation of flux variability is unreliable for sources that are extended (ext_flg>0), and sources whose measurements are contaminated by image artifacts in a band (cc_flags[b] != '0'). varchar 4      
The probability is computed for a band only when there are at least six single-exposure measurements available that satisfy minimum quality criteria. A value of "n" in a band indicates insufficient or inadequate data to make a determination of possible variability. Values of "0" through "9" indicate increasing probabilities of variation. Values of "0" through "5" are most likely not variables. Sources with values of "6" and "7" are likely flux variables, but are the most susceptible to false-positive variability. Var_flg values greater than "7" have the highest probability of being true flux variables in a band.
var_flg wise_allskysc WISE Variability flag.
The variability flag is a four-character string, one character per band, in which the value for each band is related to the probability that the source flux measured on the individual WISE exposures was not constant with time.
char 4   NONE  
var_flg wise_prelimsc WISE Variability flag
The variability flag is a four-character string, one character per band, in which the value for each band is related to the probability that the source flux measured on the individual WISE exposures was not constant with time
char 4   NONE  
var_flg_ALLWISE ravedr5Source RAVE probability that flux varied in any band greater than amount expected from unc.s varchar 5     meta.code
VAR_INST_ID twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 XMM If the source is detected as variable (that is, if VAR_FLAG is set to True), the instrument ID (PN, M1, M2) of the exposure given in VAR_EXP_ID is listed here. varchar 2      
VAR_INST_ID xmm3dr4 XMM If the source is detected as variable (that is, if VAR_FLAG is set to True), the instrument ID (PN, M1, M2) of the exposure given in VAR_EXP_ID is listed here. varchar 50      
variabilityTable Programme ATLASDR1 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASDR2 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASDR3 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASDR4 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASDR5 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASv20131127 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASv20160425 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme ATLASv20180209 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme VPHASDR3 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme VPHASv20160112 Table name of merged variable sources varchar 64   'NONE' ??
variabilityTable Programme VPHASv20170222 Table name of merged variable sources varchar 64   'NONE' ??
vc twomass_sixx2_xsc TWOMASS visual verification score for source smallint 2      
vc twomass_xsc TWOMASS visual verification score for source. smallint 2     meta.code
vegaToAB Filter ATLASDR2 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter ATLASDR3 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter ATLASDR4 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter ATLASDR5 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter ATLASv20131127 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter ATLASv20160425 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter ATLASv20180209 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter VPHASDR3 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter VPHASv20160112 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter VPHASv20170222 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
vegaToAB Filter, FilterSections ATLASDR1 The constant to convert Vega magnitudes to AB magnitudes. real 4 mag -0.9999995e9  
versionNum Multiframe ATLASDR1 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASDR2 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASDR3 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASDR4 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASDR5 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASv20131127 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASv20160425 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe ATLASv20180209 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe VPHASDR3 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe VPHASv20160112 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versionNum Multiframe VPHASv20170222 a version number for this frame (if available) real 4   -0.9999995e9 meta.id
For deep stacks and mosaics produced in Edinburgh, (frameType=deep%stack, fileName=eYYYYMMDD_%) this refers to the database release number. For all other files, the versNum refers to the CASU pipeline version number.
versNum AstrCalVers ATLASDR1 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASDR2 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASDR3 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASDR4 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASDR5 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASv20131127 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASv20160425 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers ATLASv20180209 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers VPHASDR3 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers VPHASv20160112 Version number of current astrometric solution int 4     meta.software
versNum AstrCalVers VPHASv20170222 Version number of current astrometric solution int 4     meta.software
versNum PhotCalVers ATLASDR2 the version number of the calibration int 4     meta.software
versNum PhotCalVers ATLASDR3 the version number of the calibration int 4     meta.software
versNum PhotCalVers ATLASDR4 the version number of the calibration int 4     meta.software
versNum PhotCalVers ATLASDR5 the version number of the calibration int 4     meta.software
versNum PhotCalVers ATLASv20131127 the version number of the calibration int 4     meta.software
versNum PhotCalVers ATLASv20160425 the version number of the calibration int 4     meta.software
versNum PhotCalVers ATLASv20180209 the version number of the calibration int 4     meta.software
versNum PhotCalVers VPHASDR3 the version number of the calibration int 4     meta.software
versNum PhotCalVers VPHASv20160112 the version number of the calibration int 4     meta.software
versNum PhotCalVers VPHASv20170222 the version number of the calibration int 4     meta.software
versNum PhotCalVers, PreviousMFDZP ATLASDR1 the version number of the calibration int 4     meta.software
vFlag rosat_bsc, rosat_fsc ROSAT variability flag varchar 1     meta.code
vigF rosat_fsc ROSAT vignetting factor float 8     instr.param
vigf rosat_bsc ROSAT vignetting factor float 8     instr.param
visibility_periods_used gaia_source GAIADR2 Number of visibility periods uased in the astrometric solution smallint 2     meta.number
vMag ukirtFSstars ATLASDR1 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASDR2 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASDR3 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASDR4 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASDR5 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASv20131127 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASv20160425 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars ATLASv20180209 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars VPHASDR3 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars VPHASv20160112 V band total magnitude real 4 mag -0.9999995e9 phot.mag
vMag ukirtFSstars VPHASv20170222 V band total magnitude real 4 mag -0.9999995e9 phot.mag
Vmag_APASSDR9 ravedr5Source RAVE V magnitude from APASSDR9 real 4 mag   phot.mag;em.opt.V
vr_m_opt twomass_psc TWOMASS Visual or red magnitude of the associated optical source. real 4 mag   phot.flux
vstRunNo Multiframe ATLASDR1 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASDR2 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASDR3 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASDR4 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASDR5 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASv20131127 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASv20160425 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe ATLASv20180209 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe VPHASDR3 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe VPHASv20160112 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vstRunNo Multiframe VPHASv20170222 Original VST Atlas run number (from filename) int 4   -99999999 meta.bib
vt_mag tycho2 GAIADR1 Tycho2 VT magnitude real 4 mag   phot.mag;em.opt.V
VTmag_TYCHO2 ravedr5Source RAVE magnitude from TYCHO2 real 4 mag VT   phot.mag;em.opt.V



Home | Overview | Browser | Access | Login | Cookbook
Listing | FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK

osa-support@roe.ac.uk
27/06/2023