Module: biospecimens

Module Contents

  1. lcl-prod


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

This special value check will pass under the following conditions:

CENTER_NO (*PK) in {11,12,13,14,15,16,17}

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

3LCL_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.

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

This special value check will pass under the following conditions:

LCL_PROD_TYPE in {1,2,3,4}

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

This special value check will pass under the following conditions:

LCL_TYPE_REM in {1,2,3,4}

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

This special value check will pass under the following conditions:

LCL_DISCARDED in {1,2}

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

Error Description
must be 1, 2 or 9

This special value check will pass under the following conditions:

LCL_MYCOPLASMA in {1,2,9}

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

This special value check will pass under the following conditions:

LCL_RECOVERY in {1,2,9}

9GENERATIONnumber (1,0)Required:true
Generation or passage of culture.
Allowable Values
1Generation 1: Initial transformed cell line
2Generation 2: Line made from Generation 1 LCL
3Generation 3: Line made from Generation 2 LCL
4Generation 4: Line made from Generation 3 LCL

This special value check will pass under the following conditions:

GENERATION in {1,2,3,4}

10LCL_CID_SOURCEstring (11)Required:false
LCL_CID of the sample used to expand cell lines
Allowable Values

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

11BLOOD_PROD_CIDstring (16)Required:false
Identifier used internally by centers for a product from a blood draw.
Allowable Values

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

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

This special value check will pass under the following conditions:

IS_DISPATCHABLE in {1,2}

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

This special value check will pass under the following conditions:

LOCATION in {1,2,3,4,9}

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

15LCL_COUNT_REMnumber (4,0)Required:false
Number of aliquots remaining from this transformation or expansion.
Allowable Values

Error Description
LCL_COUNT_REM must be less than or equal to LCL_COUNT
16DATE_FROZENstring (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:
1980Minimum year

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

This check will pass under the following conditions:

DATE_FROZEN is valid date{Minimum year:1980}