biosamplehistory
The biosamplehistory table describes the historical statuses of laboratory evaluated specimens such as salivary kits that may be collected from a participant.
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR |
Internal identifier to specify a unique instance of a person. This column is used to partition data tables in the Bulk Data API and should be included on all table joins. Use personid to join to tables in other models within the Bulk Data API. |
| biosamplekey | VARCHAR |
Internal identifier to specify a unique instance of a biosample. Key relationship with the biosample table. |
| biosamplehistorykey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of a message. |
| name | VARCHAR |
An historical status of the biosample. For example: Eligible or Complete. |
| rank | INTEGER |
The status of the biosample’s group as a ranked order of progression through the biosample history. If multiple statuses are contained in this group, this is the lowest rank. |
| date | TIMESTAMP |
The first time that this biosample arrived at this status. If multiple statuses are contained in a group, the first time of all statuses. |
| previousdate | TIMESTAMP |
The time of the last status change for this biosample status. When the status is the first status in the biosample process, this is the participant’s registration date in the study. |
