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 which procedure the Specimen is obtained.
specimen_id	Yes	integer	Tumor Specimen ID
reference_specimen_id	No	integer	ID of Normal specimen related to 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_gene2_id	No	varchar(50)	A foreign key identifier to the target_gene table for which the variant information is recorded when translocation variant is occurred.
reference_sequence	No	varchar(50)	Transcript id based on a protein coding RNA (mRNA) which is composed with accession number and version number
rs_id	No	varchar(50)	Reference ID (rsID) maintained by dbSNP
reference_allele	No	varchar(MAX)	Reference allele sequence (ex. A)
alternative_allele	No	varchar(MAX)	Variant allele sequence (ex. C)
hgvs_c	No	varchar(MAX)	HGVS nomenclature about the sequence variant on DNA level.
hgvs_p	No	varchar(MAX)	HGVS nomenclature about the sequence varianton Protein level.
variant_exon_number	No	integer	Exon number where variant occurred
variant_read_depth	No	integer	Variant depth divided by read depth
variant_allele_frequency	No	float	Frequency of allele that occurred variation
copy_number	No	integer	Copy number value for CNV data
cnv_locus	No	varchar(MAX)	Locus information for CNV
fusion_breakpoint	No	integer	sequential position that fusion variant occurred
fusion_supporting_reads	No	integer	Supporting read count of fusion
sequence_alteration	No	varchar(MAX)	Structural variant type
variant_feature	No	varchar(MAX)	Functional variant type
genotype	No	varchar(50)	Allele state