biosample
The biosample table describes the current status 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. |
| participantkey | VARCHAR |
Internal identifier to specify a unique instance of a participant in an RKStudio project. Key relationship with the participant table. |
| biosamplekey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of a biosample. |
| collections | INTEGER |
The number of collections performed for the biosample. |
| status | VARCHAR |
The current status of the biosample. For example: Eligible or Complete. |
| date | TIMESTAMP |
The data of the last status change for the biosample. |
| type | VARCHAR |
The type of the biosample. For example: SalivaKit or BloodBank. |
