SampleLots
Holds metadata about each sample lot, including manufacturer, lot number, production date, and shelf life. This is used for tracking sample provenance and ensuring product integrity throughout its lifecycle.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
Unique identifier for the sample lot record within the system. |
| Sample Lot Type | String | True |
Specifies the object type classification for the sample lot, used for categorizing and processing sample inventory. |
| Global ID | String | True |
System-generated global identifier that ensures uniqueness across integrated environments. |
| Link | String | False |
System-generated hyperlink reference to access the sample lot record in the Vault UI. |
| Lot # | String | False |
Unique name or number assigned to the sample lot for tracking and identification purposes. |
| Status | String | False |
Current status of the sample lot, such as active, expired, or depleted, indicating its availability. |
| Created By | String | True |
User who initially created the sample lot record in Vault. |
| Created Date | Datetime | True |
Timestamp recording when the sample lot record was created in the system. |
| Last Modified By | String | True |
User who most recently updated the sample lot record. |
| Last Modified Date | Datetime | True |
Date and time when the sample lot record was last modified. |
| Active | Bool | False |
Boolean flag indicating whether the sample lot is currently active and usable. |
| Allocated Quantity | Decimal | False |
Total quantity of the sample lot that has already been assigned or distributed for use. |
| Batch Lot Id | String | False |
Identifier linking the sample lot to its associated batch, enabling traceability across batches. |
| Expiration Date | Date | False |
The official date after which the sample lot is considered expired and should no longer be used. |
| Sample Lot Id | String | False |
Internal identifier for referencing the specific sample lot, often used in workflows and lookups. |
| Sample | String | False |
Reference to the parent sample associated with this lot, providing context on the product or material. |
| Suppress Lot | Bool | False |
Boolean flag to suppress or hide the lot from selection or processing under specific conditions. |
| U/M | String | False |
Unit of measure used to quantify the sample lot, such as milliliters or tablets. |
| Product | String | False |
Product associated with the sample lot, typically referencing a marketed drug or investigational product. |
| Owner | String | False |
Identifier of the user or system entity that owns or manages the sample lot record. |
| Calculated Quantity | Decimal | False |
Dynamically calculated quantity of the sample lot based on system rules or usage logs. |
| Legacy CRM Id | String | False |
Identifier from the legacy Customer Relationship Management (CRM) system used for cross-reference during data migration or integration. |