tblSAMPLES - Blood Samples


holds information on the storage of blood, urine and other biological samples

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
Format
Description
character (or numeric if possible)
patient cohort identifier
yyyy-mm-dd
date when the sample was taken

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
character
identification symbol allowing the localization of the sample in the laboratory
character
laboratory where the samples are stored
yyyy-mm-dd
date when the sample was frozen
hh:mm
time when the sample was frozen
numeric
number of aliquots available
numeric

size of the aliquot:

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

character:

  • 0 = millions of cells
  • 1 = ml
unit of measurement for the SAMP_ALIQ_SIZE value

Additional Fields

Field name
Format
Description
hh:mm
time when the sample was taken
numeric
temperature of the storage unit containing the samples (in °C)

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown
have the samples already been defrosted?

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes