VARIANT_OCCURRENCE

Field	Required	Type	Description
variant_occurrence_id	Yes	integer	A unique identifier for each variant occurrence event
procedure_occurrence_id	Yes	integer	A foreign key identifier to the Procedure_occurrence table for the procedure used to obtain the specimen
specimen_id	Yes	integer	Tumor specimen ID
reference_specimen_id	No	integer	ID of the normal specimen related to the tumor specimen
target_gene1_id	No	varchar(50)	A foreign key identifier to the Target_gene table for which the variant information is recorded
target_gene1_symbol	No	varchar(255)	A symbol of gene where the variant information is recorded
target_gene2_id	No	varchar(50)	A foreign key identifier to the Target_gene table for which the variant information is recorded when a translocation variant occurs
target_gene2_symbol	No	varchar(255)	A symbol of gene where the variant information is recorded
reference_sequence	No	varchar(50)	Transcript ID based on a protein-coding RNA (mRNA) made up of the accession number and version number
rs_id	No	varchar(50)	dbSNP reference ID (rsID) maintained by NCBI
reference_allele	No	varchar(255)	Reference allele sequence (e.g., A)
alternate_allele	No	varchar(255)	Variant allele sequence (e.g., C)
hgvs_c	No	varchar(MAX)	Nomenclature for the sequence variant at the DNA level
hgvs_p	No	varchar(MAX)	Nomenclature for the sequence variant at the protein level
variant_read_depth	No	integer	Variant depth divided by read depth
variant_exon_number	No	integer	Exon number in which the variant occurred
copy_number	No	float	Copy number value for CNV data
cnv_locus	No	varchar(MAX)	Locus information for CNV
fusion_breakpoint	No	varchar(MAX)	sequential position that fusion variant occurred
fusion_supporting_reads	No	integer	Supporting read count of the fusion
sequence_alteration	No	varchar(MAX)	Structural variant type
variant_feature	No	varchar(MAX)	Functional variant type
genetic origin	No	varchar(50)	Somatic or germline origin or the variant
genotype	No	varchar(50)	Allele state