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)
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 Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes