Saved and Merged Data

At the end of the data mapping process each table is stored to a separate .csv file, and named with the report, page, table number, and table type. These can be viewed in the Test Data page. These files will be uploaded to the backend data model api via a separate utility, and are the last change for the subject matter experts to make changes to the data.

The SME (subject matter expert) can:

• Edit the file in place

• Download the file

• Upload the file, including edits

• Return to the mapping process for that table

Edits made directly to the file via the UI or in downloaded copies give the SME final control over what will be loaded to the database, but they do not update the stored digitization mapping data so will be lost if the table is re-mapped in the mapping process.

In Test Data the user can initiate the merging of files for one or more test types, which concatenates the all output files of each type into a single file per type. It also merges data from multiple tables for the same report, sample ID, and type into the same records. For example, data for the same sample is often spread across multiple tables.