Module: biospecimens

Module Contents

  1. lcl-prod
    1.CENTER_NO (*PK)
    2.PERSON_ID
    3.LCL_CID (*PK)
    4.LCL_PROD_TYPE
    5.LCL_TYPE_REM
    6.LCL_DISCARDED
    7.LCL_MYCOPLASMA
    8.LCL_RECOVERY
    9.GENERATION
    10.LCL_CID_SOURCE
    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 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 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_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


6 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


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

Error Description
must be 1, 2 or 9


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


9 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


10 LCL_CID_SOURCE string (11) Required:false
LCL_CID of the sample used to expand cell lines

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


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