[Support Request] Investigate duplicate result submissions

[DanielSass]

Report stream has been investigating duplicate submissions coming from SR bulk upload users (CDCgov/prime-reportstream#17232).

One of the things they noticed is that it seems as though a SR user is submitting the same Test_Performed_Code (for covid) on all the test results for a given multiplex test. Per Victor the rows appear to be identical with the exception of the description.

We would like to:
a) Verify that this field is not being populated by the application in a way that would cause these errors (Are we defaulting this code in an invalid way? Looking it up in our database and filling in bad data? Does our device lookup tool mislead users?)
b) Evaluate if it would be possible to validate these codes further to be able to catch these issues sooner

[mpbrown]

This issue might be caused by unvalidated user-provided test_ordered_code values. Awaiting response from ReportStream on this Slack thread

[mehansen]

Looked at this with Dan and I think that what happened here is a user is trying to upload multiplex results using device data for a Covid-only device. Essentially they are using the same device manufacturer/model info and test performed LOINC but adding different disease names in a test name column. The test name column is not part of our schema, so we just pass the rows through to the Covid pipeline because the test_performed_code is a Covid LOINC.
Next steps are to:

• @DanielSass to work with leads to notify user that the data they are uploading is incorrect
• @mehansen to notify RS that the duplicates are due to user error and not a processing issue on our side
• (potentially) SR team to add validation to bulk upload tool to disallow columns not in our schema

[mehansen]

Notified RS via Slack thread here