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
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)
  • WB = whole blood
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


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