EPIC - NIH specific tables exporting

[leandroradusky]

Is the awardee who will export these files from the system, there will be a new button next to the actual Download charts as SVG & Download PDF on the reports page, named Download NIH tables or similar. They will have to upload them afterwards in a place that is out of our reach.

There will be three tables (csv format) to be exported:

1. One with one row per sample, aggregating data from the sample, it's batch etc;
2. One with one row per sample, containing information about the results obtained by the awardee on their machines;
3. One with general results of the whole panel's test (sensitivity, specificity, LOD, etc.)

Some data we don't have it within CDx, especially on table 2) (name of the protocol, units of the readout, technology used, etc.) and we will just have to warn the awardee before downloading that some data needs to be manually fulfilled by them.

The batches entity within CDx is missing some data for these tables to be complete, if we're implementing this feature, this columns will need to be added to batches (PANGO_lineage, WHO_label, etc). This missing info differs from the last bullet point since this is data not available for the awardee: the batches info belongs to the University.

They have all the batches information on a spreadsheet: if we add these columns, when we implement the data migration we will have to map these columns for the existing batches taking this spreadsheet as reference for the first time (or alternatively, they will have to go batch by batch defining it for the existent batches, but I mentioned that this one-time migration can be done). For new batches they will define the full information.

[diegoliberman]

They have all the batches information on a spreadsheet: if we add these columns, when we implement the data migration we will have to map these columns for the existing batches taking this spreadsheet as reference for the first time (or alternatively, they will have to go batch by batch defining it for the existent batches, but I mentioned that this one-time migration can be done). For new batches they will define the full information.

@leandroradusky did you ask how many batches they have today? If there are just a few, I think I'd suggest for them to manually update them.

[leandroradusky]

I didn't ask, but when I had the call with them I briefly saw the spreadsheet and it is in the order of ~25-30.