...
...
...
...
...
...
Table of Contents |
---|
...
Introduction
Specimen Aliquot CSV is used to create unplanned specimens.
Steps to import CSV
Expand | ||
---|---|---|
| ||
|
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.
| If not specified, it divides the entire parent specimen available quantity into equal amounts |
among all the aliquots
| |||||
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 |