wiki:Hicdep_1.100/TableSamples

tblSAMPLES - Blood Samples

This table contains information on the storage of blood, urine and other samples stored in a laboratory.

Core fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name

Format

Description

PATIENT

character (or numeric if possible)

patient cohort identifier

SAMP_LAB_D

yyyy-mm-dd

date when the sample was taken

SAMP_TYPE

character:

  • BS = blood serum
  • BP = blood plasma
  • C = viable cells
  • D = cell pellet (DNA)
  • S = semen
  • OTH:x = other sample type x (none of the above)

type of the sample

SAMP_ID

character

identification symbol allowing the localization of the sample in the laboratory

SAMP_LAB

character

laboratory where the samples are stored

SAMP_FREEZE_D

yyyy-mm-dd

date when the sample was frozen

SAMP_FREEZE_T

hh:mm

time when the sample was frozen

SAMP_ALIQ_NO

numeric

number of aliquots available

SAMP_ALIQ_SIZE

numeric

size of the aliquot:

  • in ml for serum, plasma and cell pellet aliquots
  • in millions of cells for viable cell aliquots

SAMP_ALIQ_U

character:

  • 0 = millions of cells
  • 1 = ml

unit of measurement for the SAMP_ALIQ_SIZE value

Additional fields

Field name

Format

Description

SAMP_LAB_T

hh:mm

time when the sample was taken

SAMP_TEMP

numeric

temperature of the storage unit containing the samples (in °C)

SAMP_DEFROST

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

have the samples already been defrosted?

QA Checks

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
Last modified 19 months ago Last modified on 12/02/15 09:39:32