wiki:Hicdep_1.50/TableSamples

Version 7 (modified by stels, 6 years ago) (diff)

--

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)
TODO
find further types of samples

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