Let's start adding questions the ETL should address and what we consider a valid response. This might help us decide on which piece of software to use/modify.
| Use Case | Test Case | Valid Result |
|---|---|---|
| Submitter provides single data file for a particular test for all participants in the study | The system should parse that file and create records for each participant for that test and link them to the correct participant, study arm, treatment, etc. | |
| Submitter provides an archive of data files, one per participant (e.g. DNA sequences) | The system should process these files and link them to each participant. | |
| Submitter provides a single data file of multiple participants with multiple sampling points (days and hours per day) with study/cohort/drug information in header/filename | COTC007b NSC705744 50 mb cohort plasma PK.xlsx | The system should process this file, with aid from the curator, and link the data to each participant/test/etc. |
