Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleExpand...
  1. Log in and go to the CP overview page.

  2. Click on the 'More' button and select 'Import Specimen Requirements' from the dropdown.

Image RemovedImage Added

3. Click on 'Download Template File' to download the template file from the 'Import Specimen Requirements' page.

Image RemovedImage Added

4. Enter all valid data in the template file as mentioned in the 'Data Dictionary' table.

5. Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update events.

6. Click on the 'Validate and Import' button.

7. Refer to 'Import status' to check the status of the import job.

...

Column Name

Data type

Mandatory? (Create)

Mandatory? (Update)

Description

Permissible Values

Validations

Identifier

Number

DependsNo

Yes

System auto-generated unique number for every specimen requirement. This field used

to update the specimen requirementMandatory while updating specimen requirements.

CP Short Title

String

Yes

Yes

CP Short Title, in which the specimen requirement needs to be added.

Should It should be unique within the system.

Event Label

String

Yes

No

Event Name.

 

Parent Code

String

YesDepends

No

Parent Specimen Code: Mandatory for creating the child specimens. It is used to link the child specimens Derived/Aliquots to its parent specimen.

Mandatory for creating the child specimens.

Name

String

No

No

Specimen Name

Code

String

May beDepends

No

 

Mandatory only when you create the child specimen under the parent.

 

 

Lineage

String

No

No

The lineage of the specimen.

  • New

  • Derived

  • Aliquot

If left blank, the system will add lineage as 'New' by default

Specimen Class

String

Yes

Yes

  • Tissue

  • Molecular

  • Cell

  • Fluid

 

Specimen Type

String

Yes

Yes

 

Permissible values for specimen class-type

Should be a valid value from the list

Anatomic Site

 String

Yes

Yes

Permissible values for anatomic siteSite

Anatomic Site is mandatory only for the primary specimens.

Should It should be a valid value from the list.

Default value: 'Not Specified.'

Laterality

 String

Yes

Yes

 

  •  Left

  • Right

  • Not Applicable

  • Not Specified

Laterality is mandatory only for the primary specimens.

Default value: 'Not Specified.'

Pathology

 String

Yes

Yes

  • Non-Malignant

  • Non-Malignant, Diseased

  • Pre-Malignant

  • Malignant, Pre-Invasive

  • Malignant, Invasive

  • Malignant

  • Metastatic

  • Not Specified

Pathology is mandatory only for the primary specimens.

Should It should be the valid value from the list.

Default value: 'Not Specified.'

Storage Type

String

Yes

Yes

  • Virtual (if the specimen is not stored in the repository)

  • Manual (if the specimen is stored in the repository)

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 OSOpenSpecimen.

Collection Container

String

Yes

Yes

Type of container used for specimen collection

  • ACD Vacutainer

  • Citrate Vacutainer

  • CPT

  • EDTA Vacutainer

  • Heparin Vacutainer

  • No Additive Vacutainer

  • Paxgene

  • Serum Separator Vacutainer

  • Sterile Specimen Container

  • Streck

  • Not Specified

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.

  • Lavage Needle

  • Aspirate

  • Needle Core Biopsy

  • Venipuncture

  • Indwelling Catheter

  • Surgical Resection

  • Not Specified

Collection Procedure is mandatory only for the primary specimens.

Should It should be a valid value from the list.

Receiver#Email Address

String

No

No

The user should exist within OSOpenSpecimen.

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.

  • Active

  • Closed

  • Disabled

The value should be 'Disabled' to delete the specimens.

Values are case-sensitive.

...