Leave a comment at the end of this page or email contact@krishagni.com
Specimen Aliquots CSV
Introduction
Specimen Aliquot CSV is used to create unplanned specimens.
Steps to import CSV
Sample CSV
Data Dictionary
Column Name | Datatype | Mandatory? (Create) | Description | Permissible Values | Validations |
---|---|---|---|---|---|
CP Short Title | String | Depends | The collection protocol is a short title under which specimens must be created. |
| This is mandatory only if specimen labels are not unique across collection protocols i.e. if 'Unique Specimen Label per CP' system setting is enabled. |
Parent Specimen Label | String | Yes | The specimen label of the parent specimen under which the aliquot is to be created. |
| The specimen should exist within the system |
Specimen Labels | String | Depends | The labels of each aliquot of the parent specimen. |
| It should be unique within the system or CP, depending on the system setting. When Auto-label generation is off:
|
Specimen Barcodes | String | Depends | The barcodes of each aliquot of the parent specimen. |
| It should be unique within the system. Depending on the CP settings. If the barcode is enabled, auto-label generation for aliquots is mandatory. In the case of manual input, the barcode field is disabled. |
Quantity per Aliquot | Double | Yes, if the parent quantity is not specified or the number of aliquots is not specified. | Quantity of the sample in each aliquot. Required even if “Mandatory Aliquot Quantity” is already disabled in the system settings. |
| If not specified, it divides the entire parent specimen available quantity into equal amounts among all the aliquots The value for this cannot be set to 0. |
Number of Aliquots | Integer | Yes, if parent quantity is not specified or quantity per aliquot is not specified. | The number of aliquots to be created. |
| When left blank, the number of aliquots=(parent quantity/quantity per aliquot) If the manual input is set to yes for specimen labels, then this field is disabled. The number of rows with data equals the number of aliquots generated. |
Container | String | No | It needs to be specified if the specimen is not virtually located Note: If the container has few empty spaces left and aliquots are more in number. Then, create two separate rows with each container name and the number of aliquots to be stored. |
|
|
Start Row | String or Integer | No | Datatype depending on the row labeling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case) |
| Position within the container at which the specimen is to be stored. If left blank, the system will allocate the next available position. |
Start Column | String or Integer | No | Datatype depending on the column labeling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case) |
| |
Start Position | Number | No | The single number or linear position labels to identify slots within the container for storing specimen |
| |
Created On | Date | No |
|
| Select the correct date format from UI based on the data in the file |
Freeze/Thaw Cycles | Number | No | Freeze/Thaw Cycle of the aliquot |
|
|
Increment Parent Freeze/Thaw Cycles | Number | No | Number by which parent freeze/thaw cycle is to be incremented |
|
|
Close Parent | String | No | Options - Yes/No or true/false |
| Parent specimen should be in collected- collection status |
Specimen Additional Fields#Media Volume | Number | No | Custom Field |
|
|
Specimen Additional Fields#Cell Viability (%) | Number | No | Custom Field |
|
|
Leave a comment at the end of this page or email contact@krishagni.com