TABLE  vmcVariability

Contains statistical analysis of VMC primary sources.

Photometric variability statistics. Astrometric fit to all data
Variability statistics in Y, J, Ks bands calculated from
matches in vmcSourceXSynopticSourceBestMatch

Required constraints:
  • Primary key is (sourceID)
  • (frameSetID) references vmcMergeLog(frameSetID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
sourceIDbigint8 UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm meta.id;meta.main
cuEventIDint4 UID of curation event giving rise to this record meta.bib
frameSetID link to glossarybigint8 frame set ID, unique over the whole VSA via programme ID prefix, assigned by merging procedure meta.id;obs.field
ra link to glossaryfloat8DegreesMean Right Ascension pos.eq.ra;meta.main
dec link to glossaryfloat8DegreesMean Declination pos.eq.dec;meta.main
sigRa link to glossaryreal4DegreesUncertainty in mean RA-0.9999995e9stat.error
sigDec link to glossaryreal4DegreesUncertainty in mean Dec-0.9999995e9stat.error
expAstErr link to glossaryreal4arcsecRms calculated from polynomial fit to minimum astrometric RMS as a function of magnitude-0.9999995e9stat.error
epoch link to glossaryfloat8YearsEpoch of measurement time.epoch
muRa link to glossaryreal4mas/yrProper motion in RA-0.9999995e9pos.eq.ra;pos.pm
muDec link to glossaryreal4mas/yrProper motion in Dec-0.9999995e9pos.eq.dec;pos.pm
sigMuRa link to glossaryreal4mas/yrError on proper motion in RA-0.9999995e9stat.error
sigMuDec link to glossaryreal4mas/yrError on proper motion in Dec-0.9999995e9stat.error
parallax link to glossaryreal4masParallax of star-0.9999995e9pos.parallax
minPllx link to glossaryreal4masLower limit of 90% confidence interval for parallax measurement-0.9999995e9pos.parallax;stat.min
maxPllx link to glossaryreal4masUpper limit of 90% confidence interval for parallax measurement-0.9999995e9pos.parallax;stat.max
chi2 link to glossaryreal4 Chi-squared value of astrometric solution-0.9999995e9stat.fit.chi2
nFrames link to glossaryint4 Number of frames with good detections used to calculate astrometric fits0meta.number
ynGoodObs link to glossaryint4 Number of good detections in Y band0meta.number;em.IR.NIR
ynFlaggedObs link to glossaryint4 Number of detections in Y band flagged as potentially spurious by vmcDetection.ppErrBits0meta.number
ynMissingObs link to glossaryint4 Number of Y band frames that this object should have been detected on and was not0meta.number;em.IR.NIR
ybestAper link to glossaryint4 Best aperture (1-6) for photometric statistics in the Y band-9999meta.code.class;em.IR.NIR
yminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9time.interval;obs;stat.min
ymedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9time.interval;obs;stat.median
ymaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9time.interval;obs;stat.max
ytotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9time.duration
ymeanMag link to glossaryreal4magMean Y magnitude-0.9999995e9phot.mag;em.IR.NIR;stat.mean;em.IR.NIR
ymedianMag link to glossaryreal4magMedian Y magnitude-0.9999995e9phot.mag;em.IR.NIR;stat.median;em.IR.NIR
yMagRms link to glossaryreal4magrms of Y magnitude-0.9999995e9stat.error;em.IR.NIR
yMagMAD link to glossaryreal4magMedian Absolute Deviation of Y magnitude-0.9999995e9stat.error;em.IR.NIR
yskewness link to glossaryreal4magSkewness in Y band (see Sesar et al. 2007)-0.9999995e9stat.param;em.IR.NIR
yMinMag link to glossaryreal4magMinimum magnitude in Y band, of good detections-0.9999995e9phot.mag;em.IR.NIR;stat.min;em.IR.NIR
yMaxMag link to glossaryreal4magMaximum magnitude in Y band, of good detections-0.9999995e9phot.mag;em.IR.NIR;stat.max;em.IR.NIR
yNgt3sig link to glossarysmallint2 Number of good detections in Y-band that are more than 3 sigma deviations-9999meta.number;em.IR.NIR
yExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Y band-0.9999995e9stat.error;em.IR.NIR
yIntRms link to glossaryreal4magIntrinsic rms in Y-band-0.9999995e9stat.error;em.IR.NIR
ychiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9stat.fit.chi2
yndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999stat.fit.dof
yprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9stat.probability
yVarClass link to glossarysmallint2 Classification of variability in this band-9999meta.code.class;src.var
jnGoodObs link to glossaryint4 Number of good detections in J band0meta.number;em.IR.NIR
jnFlaggedObs link to glossaryint4 Number of detections in J band flagged as potentially spurious by vmcDetection.ppErrBits0meta.number
jnMissingObs link to glossaryint4 Number of J band frames that this object should have been detected on and was not0meta.number;em.IR.NIR
jbestAper link to glossaryint4 Best aperture (1-6) for photometric statistics in the J band-9999meta.code.class;em.IR.NIR
jminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9time.interval;obs;stat.min
jmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9time.interval;obs;stat.median
jmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9time.interval;obs;stat.max
jtotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9time.duration
jmeanMag link to glossaryreal4magMean J magnitude-0.9999995e9phot.mag;em.IR.J;stat.mean;em.IR.NIR
jmedianMag link to glossaryreal4magMedian J magnitude-0.9999995e9phot.mag;em.IR.J;stat.median;em.IR.NIR
jMagRms link to glossaryreal4magrms of J magnitude-0.9999995e9stat.error;em.IR.NIR
jMagMAD link to glossaryreal4magMedian Absolute Deviation of J magnitude-0.9999995e9stat.error;em.IR.NIR
jskewness link to glossaryreal4magSkewness in J band (see Sesar et al. 2007)-0.9999995e9stat.param;em.IR.NIR
jMinMag link to glossaryreal4magMinimum magnitude in J band, of good detections-0.9999995e9phot.mag;em.IR.J;stat.min;em.IR.NIR
jMaxMag link to glossaryreal4magMaximum magnitude in J band, of good detections-0.9999995e9phot.mag;em.IR.J;stat.max;em.IR.NIR
jNgt3sig link to glossarysmallint2 Number of good detections in J-band that are more than 3 sigma deviations-9999meta.number;em.IR.NIR
jExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in J band-0.9999995e9stat.error;em.IR.NIR
jIntRms link to glossaryreal4magIntrinsic rms in J-band-0.9999995e9stat.error;em.IR.NIR
jchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9stat.fit.chi2
jndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999stat.fit.dof
jprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9stat.probability
jVarClass link to glossarysmallint2 Classification of variability in this band-9999meta.code.class;src.var
ksnGoodObs link to glossaryint4 Number of good detections in Ks band0meta.number;em.IR.NIR
ksnFlaggedObs link to glossaryint4 Number of detections in Ks band flagged as potentially spurious by vmcDetection.ppErrBits0meta.number
ksnMissingObs link to glossaryint4 Number of Ks band frames that this object should have been detected on and was not0meta.number;em.IR.NIR
ksbestAper link to glossaryint4 Best aperture (1-6) for photometric statistics in the Ks band-9999meta.code.class;em.IR.NIR
ksminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9time.interval;obs;stat.min
ksmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9time.interval;obs;stat.median
ksmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9time.interval;obs;stat.max
kstotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9time.duration
ksmeanMag link to glossaryreal4magMean Ks magnitude-0.9999995e9phot.mag;em.IR.K;stat.mean;em.IR.NIR
ksmedianMag link to glossaryreal4magMedian Ks magnitude-0.9999995e9phot.mag;em.IR.K;stat.median;em.IR.NIR
ksMagRms link to glossaryreal4magrms of Ks magnitude-0.9999995e9stat.error;em.IR.NIR
ksMagMAD link to glossaryreal4magMedian Absolute Deviation of Ks magnitude-0.9999995e9stat.error;em.IR.NIR
ksskewness link to glossaryreal4magSkewness in Ks band (see Sesar et al. 2007)-0.9999995e9stat.param;em.IR.NIR
ksMinMag link to glossaryreal4magMinimum magnitude in Ks band, of good detections-0.9999995e9phot.mag;em.IR.K;stat.min;em.IR.NIR
ksMaxMag link to glossaryreal4magMaximum magnitude in Ks band, of good detections-0.9999995e9phot.mag;em.IR.K;stat.max;em.IR.NIR
ksNgt3sig link to glossarysmallint2 Number of good detections in Ks-band that are more than 3 sigma deviations-9999meta.number;em.IR.NIR
ksExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Ks band-0.9999995e9stat.error;em.IR.NIR
ksIntRms link to glossaryreal4magIntrinsic rms in Ks-band-0.9999995e9stat.error;em.IR.NIR
kschiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9stat.fit.chi2
ksndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999stat.fit.dof
ksprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9stat.probability
ksVarClass link to glossarysmallint2 Classification of variability in this band-9999meta.code.class;src.var
yjiWS link to glossaryreal4 Welch-Stetson statistic between Y and J. This assumes colour does not vary much and helps remove variation due to a few poor detections-0.9999995e9stat.param
jksiWS link to glossaryreal4 Welch-Stetson statistic between J and Ks. This assumes colour does not vary much and helps remove variation due to a few poor detections-0.9999995e9stat.param
variableClass link to glossaryint4 Classification of objects across all bands.-99999999meta.code.class
Total length350