Module: biospecimens

Module Contents

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

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.

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

QC_ECOR1

number (1,0)

Required:false

Digestibility with the restriction endonuclease EcoR1.

Allowable Values
1	Good
2	Not Good
9	Not done

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

QC_STR1

number (1,0)

Required:false

Microsatellite STR1 [UT1699 (D10S526)].

Allowable Values
1	Homozygote
2	Heterozygote
9	Not done

QC_STR2

number (1,0)

Required:false

Microsatellite STR2 [UT1091 (D22S417)].

Allowable Values
1	Homozygote
2	Heterozygote
9	Not done

QC_Y

number (1,0)

Required:false

Y Chromosome test.

Allowable Values
0	Negative
1	Positive
9	Not done

QC_CROSS_CHECK

number (1,0)

Required:false

Sent to lab for QC testing.

Allowable Values
1	Yes/Sent
2	No/Not Sent

QC_CROSS_MATCH

number (1,0)

Required:false

Results from second lab identical.

Allowable Values
1	Yes
2	No

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.

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.

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