Module: biospecimens

Module Contents

  1. qc-test-outcome
    1.CENTER_NO (*PK)
    2.NUC_ACID_CID (*PK)
    3.QC_AGAROSE_GEL
    4.QC_ECOR1
    5.QC_HIND_III
    6.QC_STR1
    7.QC_STR2
    8.QC_Y
    9.QC_CROSS_CHECK
    10.QC_CROSS_MATCH
    11.QC_SUMMARY
    12.QC_SUMM_FAIL
    13.QC_CC
    14.QC_CC_FAIL
    15.QC_IC

1 CENTER_NO (*PK) number (2,0) Required:true
Center Identification Number. *CENTER_NO + NUC_ACID_CID are the primary key for the table.
Allowable Values
11 Sinai Health Systems (formerly Cancer Care Ontario)
12 Cedars-Sinai & Cleveland Clinic (formerly USC Consortium)
13 University of Melbourne
14 University of Hawaii Cancer Center
15 Mayo Clinic
16 Fred Hutch, Seattle
17 UCSF: University of California at San Franscisco (formerly CPIC, originally Northern California (NCCC))


2 NUC_ACID_CID (*PK) string (40) Required:true
Identifier used internally by centers for a nucleic acid sample from a single extraction. *CENTER_NO + NUC_ACID_CID are the primary key for the table.

3 QC_AGAROSE_GEL number (1,0) Required:false
Quality of DNA or RNA. The behavior on the gel indicates integrity of DNA or RNA.
Allowable Values
1 Good
2 Not Good
3 Poor (for RNA only)
9 not done


4 QC_ECOR1 number (1,0) Required:false
Digestibility with the restriction endonuclease EcoR1.
Allowable Values
1 Good
2 Not Good
9 Not done


5 QC_HIND_III number (1,0) Required:false
Digestibility with the restriction endonuclease Hind III.
Allowable Values
1 Good
2 Not Good
9 Not done


6 QC_STR1 number (1,0) Required:false
Microsatellite STR1 [UT1699 (D10S526)].
Allowable Values
1 Homozygote
2 Heterozygote
9 Not done


7 QC_STR2 number (1,0) Required:false
Microsatellite STR2 [UT1091 (D22S417)].
Allowable Values
1 Homozygote
2 Heterozygote
9 Not done


8 QC_Y number (1,0) Required:false
Y Chromosome test.
Allowable Values
0 Negative
1 Positive
9 Not done


9 QC_CROSS_CHECK number (1,0) Required:false
Sent to lab for QC testing.
Allowable Values
1 Yes/Sent
2 No/Not Sent


10 QC_CROSS_MATCH number (1,0) Required:false
Results from second lab identical.
Allowable Values
1 Yes
2 No


11 QC_SUMMARY number (1,0) Required:false
Summary result of QC procedures
Allowable Values
1 Passed (research lab protocol)
2 Passed (clinical lab protocol)
3 Failed
9 Not Done


12 QC_SUMM_FAIL string (150) Required:false
Text field to indicate which component (gel/RE/PCR) was problematic.

13 QC_CC number (1,0) Required:false
Cross-check quality control testing.
Allowable Values
1 Pass
2 Fail
9 Not done


14 QC_CC_FAIL string (150) Required:false
Text field to indicate which component of quality control cross check failed.

15 QC_IC number (1,0) Required:false
Microsatellite markers in DNA specimen matched Guthrie spot for this individual.
Allowable Values
1 Yes
2 No
9 Not done