Module: biospecimens

Module Contents

  1. lcl-prod
    1.CENTER_NO (*PK)
    2.PERSON_ID
    3.LCL_CID (*PK)
    4.LCL_PROD_TYPE
    5.LCL_CID_SOURCE
    6.LCL_TYPE_REM
    7.LCL_DISCARDED
    8.LCL_MYCOPLASMA
    9.LCL_RECOVERY
    10.GENERATION
    11.BLOOD_PROD_CID
    12.IS_DISPATCHABLE
    13.LOCATION
    14.LCL_COUNT
    15.LCL_COUNT_REM
    16.DATE_FROZEN

1 CENTER_NO (*PK) number (2,0) Required:true
Center Identification Number. *CENTER_NO + LCL_CID are the primary key for the table.
Allowable Values
11 Cancer Care Ontario
12 USC Consortium
13 University of Melbourne
14 Cancer Research Center of Hawaii
15 Mayo Clinic
16 Fred Hutchinson, Seattle
17 Northern California (NCCC)


2 PERSON_ID string (12) Required:true
Number that uniquely identifies an individual.

3 LCL_CID (*PK) string (17) Required:true
Identifier used internally by centers for a Lymphoblast cell line transformation or expansion. *CENTER_NO + LCL_CID are the primary key for the table.

4 LCL_PROD_TYPE number (1,0) Required:true
Total type of frozen aliquots made during this transformation or expansion.
Allowable Values
1 LCL_FREEZE single
2 LCL_FREEZE set
3 LCL_cell_Pellet single
4 LCL_cell_pellet set


5 LCL_CID_SOURCE string (11) Required:false
LCL_CID value of source of this expansion.

Error Description
If GENERATION = 1, LCL_CID_SOURCE must be null
If GENERATION is greater than 1, LCL_CID_SOURCE must not be null


6 LCL_TYPE_REM number (1,0) Required:false
Type of frozen aliquots currently remaining that were made during this transformation or expansion.
Allowable Values
1 LCL_FREEZE single
2 LCL_FREEZE set
3 LCL_cell_Pellet single
4 LCL_cell_pellet set


7 LCL_DISCARDED number (1,0) Required:true
Indicates whether the materials from this Lymphoblast cell line transformation or expansion was discarded.
Allowable Values
1 Yes
2 No


8 LCL_MYCOPLASMA number (1,0) Required:true
Results of mycoplasma testing against this Lymphoblast cell line transformation or expansion.
Allowable Values
1 Positive (Mycoplamsa tested and was present)
2 Negative (Mycoplasma tested and was not present)
9 Not tested

Error Description
must be 1, 2 or 9


9 LCL_RECOVERY number (1,0) Required:true
Results of Lymphoblast cell line freeze recovery test. Pass/OK, Fail/Not OK
Allowable Values
1 Pass/O.K
2 Fail/Not O.K
9 Not tested


10 GENERATION number (1,0) Required:true
Generation or passage of culture.
Allowable Values
1 Line made from Lymphoblast (transformed)
2 Line made from LCL with GENERATION
3 Line made from LCL with GENERATION
4 Line made from LCL with GENERATION


11 BLOOD_PROD_CID string (16) Required:false
Identifier used internally by centers for a product from a blood draw.

Error Description
If GENERATION = 1, BLOOD_PROD_CID must not be null
If GENERATION greater than 1, BLOOD_PROD_CID must be null


12 IS_DISPATCHABLE number (1,0) Required:true
Indicates whether the center is willing to dispatch the material to external investigators.
Allowable Values
1 Yes
2 No


13 LOCATION number (1,0) Required:true
Storage site for a specimen.
Allowable Values
1 Center
2 CORIELL
3 SAIC
4 Multiple Sites
9 Unknown/lost


14 LCL_COUNT number (4,0) Required:false
Total number of aliquots made during this transformation or expansion.

15 LCL_COUNT_REM number (4,0) Required:false
Number of aliquots remaining from this transformation or expansion.

Error Description
LCL_COUNT_REM must be less than or equal to LCL_COUNT


16 DATE_FROZEN string (8) Required:false
Date the LCL was frozen.
Date Value Check
The date must follow to the following format:

Format YYYYMMDD. Must consist of valid date.
Components of date should be right justified and zero filled.
MM = 01 - 12, 88, 99
DD = 01 - 31, 88, 99
YYYY = Minimum year - system date year, 8888, 9999
Use 88, 8888 for not currently known, in progress to obtain information.
Use 99, 9999 for not known.
If century is known, but year is unknown then give an estimate of year or code YYYY = 9999.
If MM = 99 then DD must = 99.
If century is known, but year is unknown then give an estimate of year or code YYYY = 9999.
If YYYY = 9999 then MM and DD must = 99.

The following special parameters are used:
1980 Minimum year

Error Description
must be a valid date of format with minimum year of 1980