TABLE  udsVariability

Contains statistical analysis of UDS primary sources.

Photometric variability statistics. Astrometric fit to all data

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
sourceIDbigint8 UID (unique over entire WSA via programme ID prefix) of this merged detection as assigned by merge algorithm ID_MAIN
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
frameSetID link to glossarybigint8 frame set ID, unique over the whole WSA via programme ID prefix, assigned by merging procedure ID_FIELD
ra link to glossaryfloat8DegreesCelestial Right Ascension POS_EQ_RA_MAIN
dec link to glossaryfloat8DegreesCelestial Declination POS_EQ_DEC_MAIN
sigRareal4DegreesUncertainty in RA-0.9999995e9ERROR
sigDecreal4DegreesUncertainty in Dec-0.9999995e9ERROR
epochfloat8YearsEpoch of position measurement TIME_EPOCH
muRareal4mas/yrProper motion in RA direction-0.9999995e9POS_EQ_PMRA
muDecreal4mas/yrProper motion in Dec direction-0.9999995e9POS_EQ_PMDEC
sigMuRareal4mas/yrError on proper motion in RA direction-0.9999995e9ERROR
sigMuDecreal4mas/yrError on proper motion in Dec direction-0.9999995e9ERROR
parallaxreal4masParallax of star-0.9999995e9 
minPllxreal4masLower limit of 90% confidence interval for parallax measurement-0.9999995e9 
maxPllxreal4masUpper limit of 90% confidence interval for parallax measurement-0.9999995e9 
chi2real4 Chi-squared value of astrometric solution-0.9999995e9FIT_CHI2
nFramesint4 Number of frames with good detections used to calculate astrometric fits0NUMBER
jnGoodObsint4 Number of good detections in J band0 
jnFlaggedObsint4 Number of detections in J band flagged as potentially spurious by udsDetection.ppErrBits0 
jnMissingObsint4 Number of J band frames that this object should have been detected on and was not0 
jbestAperint4 Best aperture (1-6) for photometric statistics in the J band-9999 
jminCadencereal4daysminimum gap between observations-0.9999995e9 
jmedCadencereal4daysmedian gap between observations-0.9999995e9 
jmaxCadencereal4daysmaximum gap between observations-0.9999995e9 
jtotalPeriodreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
jmeanMagreal4magMean J magnitude-0.9999995e9 
jmedianMagreal4magMedian J magnitude-0.9999995e9 
jMagRmsreal4magrms of J magnitude-0.9999995e9 
jMagMADreal4magMedian Absolute Deviation of J magnitude-0.9999995e9 
jskewnessreal4 Skewness in J band (see Sesar et al. 2007)-0.9999995e9 
jExpRmsreal4magRms calculated from polynomial fit to minimum RMS as a function of magnitude in J band-0.9999995e9 
jIntRmsreal4magIntrinsic rms in J-band-0.9999995e9 
jchiSqpdreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)0.9999995e9 
jndofint4 Number of degrees of freedom for chisquare-9999 
jprobVarreal4 Probability of variable from chi-square (and other data)0.9999995e9 
jVarClasssmallint2 Classification of variability in this band-9999 
hnGoodObsint4 Number of good detections in H band0 
hnFlaggedObsint4 Number of detections in H band flagged as potentially spurious by udsDetection.ppErrBits0 
hnMissingObsint4 Number of H band frames that this object should have been detected on and was not0 
hbestAperint4 Best aperture (1-6) for photometric statistics in the H band-9999 
hminCadencereal4daysminimum gap between observations-0.9999995e9 
hmedCadencereal4daysmedian gap between observations-0.9999995e9 
hmaxCadencereal4daysmaximum gap between observations-0.9999995e9 
htotalPeriodreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
hmeanMagreal4magMean H magnitude-0.9999995e9 
hmedianMagreal4magMedian H magnitude-0.9999995e9 
hMagRmsreal4magrms of H magnitude-0.9999995e9 
hMagMADreal4magMedian Absolute Deviation of H magnitude-0.9999995e9 
hskewnessreal4 Skewness in H band (see Sesar et al. 2007)-0.9999995e9 
hExpRmsreal4magRms calculated from polynomial fit to minimum RMS as a function of magnitude in H band-0.9999995e9 
hIntRmsreal4magIntrinsic rms in H-band-0.9999995e9 
hchiSqpdreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)0.9999995e9 
hndofint4 Number of degrees of freedom for chisquare-9999 
hprobVarreal4 Probability of variable from chi-square (and other data)0.9999995e9 
hVarClasssmallint2 Classification of variability in this band-9999 
knGoodObsint4 Number of good detections in K band0 
knFlaggedObsint4 Number of detections in K band flagged as potentially spurious by udsDetection.ppErrBits0 
knMissingObsint4 Number of K band frames that this object should have been detected on and was not0 
kbestAperint4 Best aperture (1-6) for photometric statistics in the K band-9999 
kminCadencereal4daysminimum gap between observations-0.9999995e9 
kmedCadencereal4daysmedian gap between observations-0.9999995e9 
kmaxCadencereal4daysmaximum gap between observations-0.9999995e9 
ktotalPeriodreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
kmeanMagreal4magMean K magnitude-0.9999995e9 
kmedianMagreal4magMedian K magnitude-0.9999995e9 
kMagRmsreal4magrms of K magnitude-0.9999995e9 
kMagMADreal4magMedian Absolute Deviation of K magnitude-0.9999995e9 
kskewnessreal4 Skewness in K band (see Sesar et al. 2007)-0.9999995e9 
kExpRmsreal4magRms calculated from polynomial fit to minimum RMS as a function of magnitude in K band-0.9999995e9 
kIntRmsreal4magIntrinsic rms in K-band-0.9999995e9 
kchiSqpdreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)0.9999995e9 
kndofint4 Number of degrees of freedom for chisquare-9999 
kprobVarreal4 Probability of variable from chi-square (and other data)0.9999995e9 
kVarClasssmallint2 Classification of variability in this band-9999 
variableClassint4 Classification of objects across all bands.-99999999 
Total length314