A Additional Result Tables

The appendix contains the following topics:

Pre-Seeded Tables
Populated by User or Loader
Unpopulated Result Entities or Tables

Pre-Seeded Tables

W_EHA_RSLT_TYPE

To store information regarding type of result stored and is based on what data is being inserted (per row inserted by loader from file). You may choose to seed more types.

Table A-1 W_EHA_RSLT_TYPE

Table Name	Column Name	Values to Seed With	Values to Seed With	Values to Seed With	Values to Seed With
W_EHA_RSLT_TYPE	RESULT_TYPE_NAME	SEQUENCING	NOCALL	GENE_EXPRESSIO	COPY_NUMBER_VARIATION
W_EHA_RSLT_TYPE	RESULT_TYPE_DESC	Sequencing results including simple variants such as snp, insertions, deletions	Nocall result for sequencing given allele	Gene expression results	Copy Number Variation results
Which loader inserts above type(s)		VCF, MAF, CGI loaders	CGI loader	Gene expression loader	No loader support

W_EHA_RSLT_FILE_TYPE

The W_EHA_RSLT_FILE_TYPE table is to be preseeded with file types currently handled by loaders, it should contain 6 rows and the pre-seeded values are mentioned in the following table:

Table A-2 W_EHA_RSLT_FILE_TYPE

Column Name	Description	Values preseeded	Values preseeded	Values preseeded	Values preseeded	Values preseeded	Values preseeded
FILE_TYPE_CODE	Short code for input file type	VCF	MAF	MAF	MAF	CGI masterVar	Tab-delim Expression
FILE_TYPE_NAME	Longer name of file type	Variant Call Format	Mutation Annotation Format	Mutation Annotation Format	Mutation Annotation Format	Complete Genomics MasterVar	Tab delimited Expression file
FILE_TYPE_DESC	Description of file type	File containing variant information including snps, inserts and deletions	Mutation Annotation Format containing snps, inserts, and deletions	Mutation Annotation Format containing snps, inserts, and deletions	Mutation Annotation Format containing snps, inserts, and deletions	Master Variation file from Complete Genomics containing snps, inserts, deletions, and no-call information	Gene Expression tab delimited file format containing probe hybridization results, 3 values per hybridization: Intensity, Call, P-value
FILE_TYPE_VERSION	Version of file type	4.1	2.0	2.1	2.2	2.0	A

W_EHA_RSLT_CHROMOSOME

This table is pre-seeded with all the possible chromosome names in a result. The user needs to insert any non-standard chromosome names contained in the results file.

Table A-3 W_EHA_RSLT_CHROMOSOME

Table Name	Column Name	Description	Values Pre-seeded
W_EHA_RSLT_CHROMOSOME	CHROMOSOME	Name of the chromosome	1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,X,Y,M

Populated by User or Loader

W_EHA_DATASOURCE

Tthis table is used to store information about specimen source and is intended to be used primarily with CDM (one record in W_EHA_DATASOURCE). However, if needed, other databases with specimen information can be linked.

Table A-4 W_EHA_DATASOURCE

Table Name	Column Name	Description	If used together with Oracle Health Sciences Cohort Explorer (OHSCE) Cohort Data Model
W_EHA_DATASOURCE	DATASOURCE_CD	Data source for Specimen	OHSCE Cohort Data Model1.1
W_EHA_DATASOURCE	DATASOURCE_NM	Name of datasource for Specimen	OHSCE Cohort Data Model1.1
W_EHA_DATASOURCE	DATASOURCE_DESC	Description of datasource for specimen	OHSCE v1.1 - Cohort Data Model
W_EHA_DATASOURCE	SCHEMA_NAME	Name of schema	CDM
W_EHA_DATASOURCE	DB_LINK_NAME	Link to database if needed

W_EHA_RSLT_FILE

This table is populated by loaders while loading results.

Table A-5 W_EHA_RSLT_FILE

Table Name	Column Name	Description	If Used Together With Regular Files	If Used Together With SecureFiles
W_EHA_RSLT_FILE	FILE_STORAGE_FLG	E for External, S for SecureFiles	E	S
W_EHA_RSLT_FILE	FILE_PATH	Path to input file	For example, C:/inputfile.txt
W_EHA_RSLT_FILE	VENDOR_NAME	Name of vendor providing file	For example, Affymetrix	For example, Affymetrix
W_EHA_RSLT_FILE	FILE_CONTENT_ID	File identifier utilized by Secure File system	Not used	Generated by SecureFiles
W_EHA_RSLT_FILE	FILE_TYPE_WID	FK to W_EHA_RSLT_FILE_TYPE	Corresponds to WID in RSLT_FILE_TYPE	Corresponds to WID in RSLT_FILE_TYPE

W_EHA_RESULT_STUDY

The user should populate study details in this table before loading the results. All imported results fall under the specified study name in the command line argument.

Table A-6 W_EHA_RESULT_STUDY

Table Name	Column Name	Description	Values Pre-seeded
W_EHA_RESULT_STUDY	RESULT_STUDY_NAME	Name of the study	<user defined values>
W_EHA_RESULT_STUDY	RESULT_STUDY_DESC	Description of the study	<user defined values>

Unpopulated Result Entities or Tables

The following table indicates result tables that are currently not being populated.

Table A-7 Unpopulated Result Entities or Tables

Table Name	Column Name	Description
W_EHA_PROBE	SEQUENCE
W_EHA_PROBE	START_POSITION
W_EHA_PROBE_XREF		No loader for this table
W_EHA_RSLT_COPY_NBR_VAR		No loader for this table
W_EHA_RSLT_CNV_X		No loader for this table
W_EHA_PROBE_ALT_LINK		No loader for this table