TABLE  vmcVariability

Contains statistical analysis of VMC primary sources.

Photometric variability statistics. Astrometric fit to all data
Variability statistics in Ks, J, Y 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.id
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
ksnGoodObs link to glossaryint4 Number of good detections in Ks band0meta.number;em.IR.K
ksnFlaggedObs link to glossaryint4 Number of detections in Ks band flagged as potentially spurious by vmcDetection.ppErrBits0meta.number;em.IR.K
ksnMissingObs link to glossaryint4 Number of Ks band frames that this object should have been detected on and was not0meta.number;em.IR.K
ksbestAper link to glossaryint4 Best aperture (1-6) for photometric statistics in the Ks band-9999meta.code.class;em.IR.K
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.K
ksmedianMag link to glossaryreal4magMedian Ks magnitude-0.9999995e9phot.mag;em.IR.K;stat.median;em.IR.K
ksMagRms link to glossaryreal4magrms of Ks magnitude-0.9999995e9stat.error;phot.mag;em.IR.K
ksMagMAD link to glossaryreal4magMedian Absolute Deviation of Ks magnitude-0.9999995e9stat.err;em.IR.K;phot.mag
ksskewness link to glossaryreal4magSkewness in Ks band (see Sesar et al. 2007)-0.9999995e9stat.param;em.IR.K
ksMinMag link to glossaryreal4magMinimum magnitude in Ks band, of good detections-0.9999995e9phot.mag;em.IR.K;stat.min
ksMaxMag link to glossaryreal4magMaximum magnitude in Ks band, of good detections-0.9999995e9phot.mag;em.IR.K;stat.max
ksNgt3sig link to glossarysmallint2 Number of good detections in Ks-band that are more than 3 sigma deviations (ksAperMagN < (ksMeanMag-3*ksMagRms)-9999meta.number;em.IR.K
ksExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Ks band-0.9999995e9stat.error;em.IR.K
ksIntRms link to glossaryreal4magIntrinsic rms in Ks-band-0.9999995e9stat.error;em.IR.K
kschiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9stat.fit.chi2;em.IR.K
ksndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999stat.fit.dof;em.IR.K
ksprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9stat.probability;em.IR.K
ksVarClass link to glossarysmallint2 Classification of variability in this band-9999meta.code.class;src.var;em.IR.K
jnGoodObs link to glossaryint4 Number of good detections in J band0meta.number;em.IR.J
jnFlaggedObs link to glossaryint4 Number of detections in J band flagged as potentially spurious by vmcDetection.ppErrBits0meta.number;em.IR.J
jnMissingObs link to glossaryint4 Number of J band frames that this object should have been detected on and was not0meta.number;em.IR.J
jbestAper link to glossaryint4 Best aperture (1-6) for photometric statistics in the J band-9999meta.code.class;em.IR.J
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.J
jmedianMag link to glossaryreal4magMedian J magnitude-0.9999995e9phot.mag;em.IR.J;stat.median;em.IR.J
jMagRms link to glossaryreal4magrms of J magnitude-0.9999995e9stat.error;phot.mag;em.IR.J
jMagMAD link to glossaryreal4magMedian Absolute Deviation of J magnitude-0.9999995e9stat.err;em.IR.J;phot.mag
jskewness link to glossaryreal4magSkewness in J band (see Sesar et al. 2007)-0.9999995e9stat.param;em.IR.J
jMinMag link to glossaryreal4magMinimum magnitude in J band, of good detections-0.9999995e9phot.mag;em.IR.J;stat.min
jMaxMag link to glossaryreal4magMaximum magnitude in J band, of good detections-0.9999995e9phot.mag;em.IR.J;stat.max
jNgt3sig link to glossarysmallint2 Number of good detections in J-band that are more than 3 sigma deviations (jAperMagN < (jMeanMag-3*jMagRms)-9999meta.number;em.IR.J
jExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in J band-0.9999995e9stat.error;em.IR.J
jIntRms link to glossaryreal4magIntrinsic rms in J-band-0.9999995e9stat.error;em.IR.J
jchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9stat.fit.chi2;em.IR.J
jndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999stat.fit.dof;em.IR.J
jprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9stat.probability;em.IR.J
jVarClass link to glossarysmallint2 Classification of variability in this band-9999meta.code.class;src.var;em.IR.J
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;em.IR.NIR
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;phot.mag;em.IR.NIR
yMagMAD link to glossaryreal4magMedian Absolute Deviation of Y magnitude-0.9999995e9stat.err;em.IR.NIR;phot.mag
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
yMaxMag link to glossaryreal4magMaximum magnitude in Y band, of good detections-0.9999995e9phot.mag;em.IR.NIR;stat.max
yNgt3sig link to glossarysmallint2 Number of good detections in Y-band that are more than 3 sigma deviations (yAperMagN < (yMeanMag-3*yMagRms)-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;em.IR.NIR
yndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999stat.fit.dof;em.IR.NIR
yprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9stat.probability;em.IR.NIR
yVarClass link to glossarysmallint2 Classification of variability in this band-9999meta.code.class;src.var;em.IR.NIR
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;em.IR.NIR;em.IR.J
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;em.IR.J;em.IR.K
variableClass link to glossaryint4 Classification of objects across all bands.-99999999meta.code.class
Total length350