Steps to Import CSV
Sample CSV
Data Directory
Column Name | Data type | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
---|---|---|---|---|---|---|
Identifier | Number | Depends | Yes | System auto-generated unique number for every specimen requirement. | This field used to update the specimen requirement. | |
CP Short Title | String | Yes | Yes | CP Short Title, in which the specimen requirement needs to be added | Should be unique within the system | |
Event Label | String | Yes | No | Event Name |
| |
Parent Code | String | Yes | No | Parent Specimen Code: Mandatory for creating the child specimens. It used to link the child specimens Derived/Aliquots to its parent specimen. | ||
Name | String | No | No | Specimen Name | ||
Code | String | May be | No | Mandatory only when you create the child specimen under the parent. |
|
|
Lineage | String | No | No |
| If left blank, the system will add lineage as 'New' by default | |
Specimen Class | String | Yes | Yes |
|
| |
Specimen Type | String | Yes | Yes |
| Should be a valid value from the list | |
Anatomic Site | String | Yes | Yes | Anatomic Site is mandatory only for the primary specimens. Should be a valid value from the list. Default value: 'Not Specified' | ||
Laterality | String | Yes | Yes |
|
| Laterality is mandatory only for the primary specimens. Default value: 'Not Specified' |
Pathology | String | Yes | Yes |
| Pathology is mandatory only for the primary specimens. Should be the valid value from the list. Default value: 'Not Specified' | |
Storage Type | String | Yes | Yes |
| ||
Initial Quantity | Double | No | No | If the left blank system will add 'Not Specified' by default | ||
Concentration | Double | No | No | |||
Collector#Email Address | String | No | No | The user should exist within OS | ||
Collection Container | String | Yes | Yes | Type of container used for specimen collection |
| Collection Container is mandatory only for the primary specimens. Should be a valid value from the list |
Collection Procedure | String | Yes | Yes | The procedure used during specimen collection |
| Collection Procedure is mandatory only for the primary specimens. Should be a valid value from the list |
Receiver#Email Address | String | No | No | The user should exist within OS | ||
Label Format | String | No | No | |||
Label Auto Print Mode | String | No | No | |||
Label Print Copies | Integer | No | No | |||
Sort Order | Integer | No | No | |||
Activity Status | String | No | No | Used to Disable the requirements of the specimen in bulk |
| The value should be 'Disabled' to delete the specimens Values are case-sensitive. |