# | Column | Type | Notes |
1 | anatomic_site_concept_id | integer | A foreign key to a Standard Concept identifier for the anatomic location of specimen collection. |
2 | anatomic_site_source_value | string | The information about the anatomic site as detailed in the source. |
3 | disease_status_concept_id | integer | A foreign key to a Standard Concept identifier for the Disease Status of specimen collection. |
4 | disease_status_source_value | string | The information about the disease status as detailed in the source. |
5 | eid | integer | A foreign key identifier to the Person for whom the Specimen is recorded. |
6 | quantity | float | The amount of specimen collection from the person during the sampling procedure. |
7 | specimen_concept_id | integer | A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen. |
8 | specimen_date | date | The date the specimen was obtained from the Person. |
9 | specimen_datetime | timestamp | The date and time on the date when the Specimen was obtained from the person. |
10 | specimen_id | integer | A unique identifier for each specimen. |
11 | specimen_source_id | string | The Specimen identifier as it appears in the source data. |
12 | specimen_source_value | string | The Specimen value as it appears in the source data. This value is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference. |
13 | specimen_type_concept_id | integer | A foreign key referring to the Concept identifier in the Standardized Vocabularies reflecting the system of record from which the Specimen was represented in the source data. |
14 | unit_concept_id | integer | A foreign key to a Standard Concept identifier for the Unit associated with the numeric quantity of the Specimen collection. |
15 | unit_source_value | string | The information about the Unit as detailed in the source. |