Home | Overview | Browser | Access | Login | Cookbook

Glossary of VSA attributes
This Glossary alphabetically lists all attributes used in the VSAv20110218 database(s) held in the VSA. If you would like to have more information about the schema tables please use the VSAv20110218 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
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
var	iras_psc	IRAS	percent Likelihood of Variability	smallint	2			CODE_VARIAB
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_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	combo17CDFSSource	COMBO17	variability flag (0=not variable); flag only set for objects which are detected with high S/N and which show clear variability between different observing runs (magnitude difference greater 0.15 mag, at least one magnitude has to be measured with 10 sigma, difference has to be at least 6 sigma	tinyint	1
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
variabilityTable	Programme	VSAQC	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSASVNGC253	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSASVORION	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSAUltraVISTA	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSAVHS	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSAVIDEO	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSAVIKING	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSAVMC	Table name of merged variable sources	varchar	64			??
variabilityTable	Programme	VSAVVV	Table name of merged variable sources	varchar	64			??
variableClass	ultravistaVariability	VSAUltraVISTA	Classification of objects across all bands.	int	4		-99999999
			This gives an overall classification. Currently the weighted intrinsicRMS/expectedRMS (wsrms) is calculated across all bands, where the weighting is directly proportional to the number of good observations in each band, where any bands with <5 observations have w=0 and the band with the most observations has a weighting of 1. If wsrms>3, then variableClass=1 (i.e. the source is variable), else variableClass=0. In the future, the classification will take into account other statistics, such as correlations between bands and will also include motion and skew, and will not be limited to 0 or 1.
variableClass	ultravistaVariability, videoVariability, vikingVariability, vmcVariability, vvvVariability	VSAQC	Classification of objects across all bands.	int	4		-99999999
			This gives an overall classification. Currently the weighted intrinsicRMS/expectedRMS (wsrms) is calculated across all bands, where the weighting is directly proportional to the number of good observations in each band, where any bands with <5 observations have w=0 and the band with the most observations has a weighting of 1. If wsrms>3, then variableClass=1 (i.e. the source is variable), else variableClass=0. In the future, the classification will take into account other statistics, such as correlations between bands and will also include motion and skew, and will not be limited to 0 or 1.
VbMag	combo17CDFSSource	COMBO17	Absolute restframe magnitude in Bessell V (calculated from redshifted best_fit template, depending on redshift and filter extrapolation outside the COMBO-17 filter set can be necessary, only calculated for objects classified as galaxies)	real	4	mag
vc	twomass_sixx2_xsc	2MASS	visual verification score for source	smallint	2
vc	twomass_xsc	2MASS	visual verification score for source.	smallint	2			CODE_MISC
vegaToAB	Filter	VSAQC	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSASVNGC253	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSASVORION	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSAUltraVISTA	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSAVHS	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSAVIDEO	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSAVIKING	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSAVMC	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
vegaToAB	Filter	VSAVVV	The constant to convert Vega magnitudes to AB magnitudes.	real	4	mag	-0.9999995e9
versionDate	sage_lmcIracSource, sage_lmcMips160Source, sage_lmcMips24Source, sage_lmcMips70Source	SPITZER	Date catalogue was produced in the following format, "mon dd yyyy", "Dec 5 2007"	varchar	12
versionNo	sage_lmcIracSource, sage_lmcMips160Source, sage_lmcMips24Source, sage_lmcMips70Source	SPITZER	Version number assigned by MIPS/IRAC pipeline team	real	4
versionNum	Multiframe	VSASVNGC253	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSASVORION	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSAUltraVISTA	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSAVHS	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSAVIDEO	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSAVIKING	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSAVMC	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	VSAVVV	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
			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	ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe	VSAQC	a version number for this frame (if available)	real	4		-0.9999995e9	VERSNUM
versNum	AstrCalVers	VSASVNGC253	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSASVORION	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSAUltraVISTA	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSAVHS	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSAVIDEO	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSAVIKING	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSAVMC	Version number of current astrometric solution	int	4			ID_VERSION
versNum	AstrCalVers	VSAVVV	Version number of current astrometric solution	int	4			ID_VERSION
versNum	PhotCalVers	VSASVORION	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers	VSAUltraVISTA	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers	VSAVHS	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers	VSAVIDEO	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers	VSAVIKING	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers	VSAVMC	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers	VSAVVV	the version number of the calibration	int	4			ID_VERSION
versNum	PhotCalVers, PreviousMFDZP	VSASVNGC253	the version number of the calibration	int	4			ID_VERSION
VF_D	combo17CDFSSource	COMBO17	flux in filter V in run D (07.10.-22.10.1999)	float	8
vFlag	rosat_bsc, rosat_fsc	ROSAT	variability flag	varchar	1			CODE_MISC
vigF	rosat_fsc	ROSAT	vignetting factor	float	8			INST_CORR-FACTOR
vigf	rosat_bsc	ROSAT	vignetting factor	float	8			INST_CORR-FACTOR
vistaRunNo	Multiframe	VSASVNGC253	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSASVORION	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSAUltraVISTA	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSAVHS	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSAVIDEO	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSAVIKING	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSAVMC	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	Multiframe	VSAVVV	Original VISTA run number (from filename)	int	4			REFER_CODE
vistaRunNo	ultravistaMultiframe, vhsMultiframe, videoMultiframe, vikingMultiframe, vmcMultiframe, vvvMultiframe	VSAQC	Original VISTA run number (from filename)	int	4			REFER_CODE
VjMag	combo17CDFSSource	COMBO17	Absolute restframe magnitude in Johnson V (calculated from redshifted best_fit template, depending on redshift and filter extrapolation outside the COMBO-17 filter set can be necessary, only calculated for objects classified as galaxies)	real	4	mag
Vmag	mcps_lmcSource, mcps_smcSource	MCPS	The V band magnitude	real	4	mag
vMag	ukirtFSstars	VSASVNGC253	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSASVORION	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSAUltraVISTA	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSAVHS	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSAVIDEO	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSAVIKING	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSAVMC	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
vMag	ukirtFSstars	VSAVVV	V band total magnitude	real	4	mag	-0.9999995e9	PHOT_INT-MAG
VmagOGLEII	spitzer_smcSource	SPITZER	The OGLEII V band magnitude.	real	4	mag
vr_m_opt	twomass_psc	2MASS	Visual or red magnitude of the associated optical source.	real	4	mag		SPECT_FLUX_VALUE