Change validation logic for fields: “drug_name” and “drug_rxnormcui”

[lindaxiang]

Context

1. Current data model only accept and validate the “drug_name” and “drug_id” using RxNorm database
2. RxNorm only includes drugs that are approved in the USA.
3. Drugs for clinical trials normally do not have RxNorm ID.
4. International programs could use a different drug database other than RxNorm.

Use cases

• POG-CA has 65 Drugs without RxNormIDs, which will affect about 50 records among ~3500 treatment records.
• MONSTAR-JP has 30% donors (~600 donors) who were treated with drugs (12 different drugs) which do not have RxNormID. Instead they have KEGG Ids.

Proposal

1. Data model changes: ticket
2. Clinical validation changes: change the current validation logic to either validate the “drug_name” and “drug_rxnormcui” against the RxNorm database, or check if the new conditional fields “drug_database”, “drug_id” and “drug_term” are populated.

• If both drug_rxnormid & drug_name are submitted, then check that they are a valid id/name pair in the RxNorm Data Source
• If drug_rxnormid & drug_name are not submitted, then check if fields drug_database, drug_id and drug_term are submitted. No validations are needed for these 3 fields atm.
• If both sets of data fields are not submitted, a validation error will appear like this:
  Please provide the missing drug information.

3. Three tables are affected: chemotherapy, hormone_therapy and immunotherapy

[demariadaniel]

Test files used for PR #1195

chemotherapy-test-dn49-invalid3-drugDb.txt
chemotherapy-test-dn49-invalid2-drugDb.txt
chemotherapy-test-dn49-invalid1-drugDb.txt
chemotherapy-test-dn49-valid-drugDb.txt

[demariadaniel]

PR currently adds an error for every field that is missing. This can be changed to only add error if all 3 are missing.

[lindaxiang]

1. Test the above files in QA for program DATA-CA

• Pass: chemotherapy-test-dn49-invalid3-drugDb.txt gives error messages as expected
• Pass: chemotherapy-test-dn49-invalid2-drugDb.txt gives error messages as expected
• Pass: chemotherapy-test-dn49-invalid1-drugDb.txt gives error messages as expected
• Fail: chemotherapy-test-dn49-valid-drugDb.txt does NOT work as expected and gives the following error:

2. Test the following clinical files in QA for program MONSTAR-JP

• treatment.txt
• Pass: chemotherapy_invalid.txt gives error messages as expected
• Pass: immunotherapy_valid_rxnorm_drug.txt works as expected
• Fail: hormone_therapy_valid_non-rxnorm_drug.txt does NOT work as expected and gives the following error: