Leave a comment at the end of this page or email contact@krishagni.com
Specimens CSV
Steps to Import CSV
Sample CSV
Moving Form Data while Moving Specimens
Data Dictionary
Column Name | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
---|---|---|---|---|---|---|
Identifier | Number | No | Depends | System auto-generated unique number for every specimen. | Mandatory while updating specimen label | |
CP Short Title | String | Yes | Yes | The collection protocol short title under which specimen is collected | Mandatory while updating SR of a specimen. | |
Visit Name | String | Yes | No | The name of the visit under which the specimen has to be created. | It should be an existing visit name. It can be blank if it is a specimen centric CP. | |
Specimen Requirement Code | String | No | No | Code defined in collection protocol for the corresponding specimen requirement. If not specified, specimens are created as unplanned specimens. For enabling CP encoding, please refer to the wiki page. | It should be a valid code defined in the CP. If blank, the specimen will be collected as unplanned. | |
Specimen Label | String | Depends | Yes | It should be unique within the system or CP, depending on the system setting. Mandatory when the auto-label generation is OFF OR 'Manual Input' is set to 'Yes'. Note: For manual Input = Yes, make sure the label format matches with what is mentioned at CP/System level | ||
Additional Label(V9.1.RC2) | String | Depends | Yes | It should be unique within the system or CP, depending on the system setting. Mandatory when the auto-label generation is OFF OR 'Manual Input' is set to 'Yes.' | ||
Barcode | String | No | No | It should be unique within the system. | ||
Class | String | No | No |
| ||
Type | String | Depends | No |
| ||
Lineage | String | No | No |
|
| |
Parent Specimen Label | String | No | No | Should exist within the same CP → Participant→Visit. Mandatory in the case of derivatives and aliquots. | ||
Anatomic Site | String | No | No | Default value: 'Not Specified' | ||
Laterality | String | No | No |
| Default value: 'Not Specified' | |
Collection Status | String | No | No |
| Default value: 'Collected' | |
Pathological Status | String | No | No |
| Default value: 'Not Specified' | |
Initial Quantity | Double | Depends | No | Quantities are required when creating aliquot specimens. Can be kept blank if “Mandatory Aliquot Quantity” is disabled in the system settings. | ||
Available Quantity | Double | No | No | If not specified, it takes the same value as 'Initial Quantity.' | ||
Concentration | Double | No | No | |||
Quantity unit (v11.x) | - | No | No | Value will be auto-computed based on ‘Specimen type’ |
|
|
Concentration unit (v11.x) | - | No | No | Value will be auto-computed based on ‘Specimen type’ |
|
|
Biohazard | String | No | No | Multiple values can be specified as: Biohazard#1, Biohazard#2, Biohazard#3 and so on |
| |
Freeze/Thaw Cycles | Integer | No | No | Number of freeze-thaw cycles | ||
Created On | Date & Time | Depends | No | Needs to be entered for child specimens. | It takes the current date if left blank. Mandatory if creating child specimens Note: Created On date for child specimens is the processing date for parent specimens. | |
Comments | String | No | No | |||
Location#Container | String | No | No | Name of the container. It needs to be specified if the specimen is not virtually located. |
| |
Location#Row | String | No | No | Position within the container in which the specimen is to be stored. If left blank, the system will allocate the next available position. | ||
Location#Column | String | No | No | |||
Location#Position | Integer | No | No | Linear position in its parent container | ||
Collection Event#Date and Time | Date & Time | No | No | If left blank, it will take the current date and time. | ||
Collection Event#Comments | String | No | No | |||
Collection Event#Procedure | String | No | No | The procedure used during specimen collection |
| |
Collection Event#Container | String | No | No | Type of container used for specimen collection |
| |
Collection Event#User#Email Address | Email Address | No | No | Should be an existing user | ||
Received Event#Date and Time | Date & Time | No | No | Select the correct date and time format from UI based on the data in the file. If left blank, it will take the current date and time. | ||
Received Event#Comments | String | No | No | |||
Received Event#Quality | String | No | No |
| ||
Received Event#User#Email Address | Email Address | No | No | Should be an existing user | ||
Activity status | String | No | No | Used to close or reopen the specimens in bulk |
|
|
Checkout |
| No | No | Used to checkout the specimens in bulk. Refer to wiki page for more details. |
|
|
Reason | String | No | No | Reason for closing the specimen | ||
Created By#Email Address | String | No | No | Email address of the user who processed the sample | Should be an existing user | |
External IDs#1#Name | String | No | No | Additional Identifiers source | ||
External IDs#1#Value | String | No | No | Additional IDs for specimen |
Important points to remember about auto-generated formats (specimen label)
Label formats take precedence where they are defined, in order: Specimen requirement > Collection Protocol > System
If label format is left blank at SR/ CP level, it will still be validated against format defined in global 'Settings’
User Inputs Allowed = Yes (for specimen labels) in CP settings does not bypass the validation if format is defined at any level.
Leave a comment at the end of this page or email contact@krishagni.com