Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

DP Requirements CSV

From v5.0, you can create distribution protocols requirements in bulk via CSV import.

Steps to import CSV

 Expand...
  1. Go to home page and click on 'Distribution Protocols' card
  2. Click on 'Import' button and select option 'Requirements' from the distribution protocols list page
  3. Click on 'Download Template File' to download the template file
  4. Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
  5. Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update requirements
  6. Click on 'Validate and Import' button
  7. Refer 'Import status' to check the status of import job


Sample CSV

Download

Data Dictionary

Column NameData Type

Mandatory?

(Create)

Mandatory?

(Update)

DescriptionPermissible ValuesValidations
IdentifierStringNoYes

The system generated a unique identifier for the requirement


This is used only during edit to update other fields of specimen requirements
Specimen TypeStringNoNo
Permissible values for specimen class-typeShould be a valid value from the list
Anatomic SiteStringNoNo
Permissible values for anatomic siteShould be a valid value from the list
Pathology Status#1StringNoNo
  • Non-Malignant
  • Non-Malignant, Diseased
  • Pre-Malignant
  • Malignant, Pre-Invasive
  • Malignant, Invasive
  • Malignant
  • Metastatic
  • Not Specified
  • Clinically normal
Should be a valid value from the list
Pathology Status#2StringNoNo
  • Non-Malignant
  • Non-Malignant, Diseased
  • Pre-Malignant
  • Malignant, Pre-Invasive
  • Malignant, Invasive
  • Malignant
  • Metastatic
  • Not Specified
  • Clinically normal
Should be a valid value from the list
Clinical DiagnosisStringNoNo

Permissible Values File - SNOMED

Permissible Values File - ICD 10

Should be a valid value from the list
Specimen CountIntegerYesNoNumber of specimens 

Quantity Per SpecimenDoubleYesNo


CostIntegerNoNoCost of the specimen

CommentsStringNoNo


Activity Status(Added in v7.0)StringNoNoActivity status of DP requirementsActive/DisabledValue "Disabled" is used to delete the DP requirements.
Distribution Protocol#Short TitleStringYesNoThe short title of the DP under which the specimen requirements has to be created
Should be existing within the system
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com