Ask Jackie to add to query list (ongoing)

[dcarsey]

Bimonthly - ask Jackie to create a few new queries for us to determine if TIN and CTMD remain in synch, consider new features, make sure we are pulling over all relevant data.

Over time, we'd like to see if any of these queries are extremely useful / frequently needed, and consider them as a visualization available on the CTMD.

1. Receive a set of queries (at some interval defined by Theresa) [PM]
2. Write SQL to answer queries, identify missing fields [Data Modeler]
3. Write script to answer queries with CTMD, identify missing proposal_table fields, and if join is needed, missing tools[Data Modeler]
4. Add missing fields to dashboard proposal table [Developer]
5. Review/compare answers with expected [PM/Data Modeller/Vandy/Duke]
6. Write tickets for any new Features/Tools requested from above [PM]
7. Add SQL and dashboard tests to automated tests, update expected output of existing tests with cut-off submission date as current date [Developer]
8. Triage and roadmap feature requests [PI]

[dcarsey]

In order to close this ticket:

• [ ] Write SQL to answer queries, identify missing fields [Data Modeler]
• [ ] Write script to answer queries with CTMD, identify missing proposal_table fields, and if join is needed, missing tools[Data Modeler]
• [ ] Add missing fields to dashboard proposal table [Developer]
• [ ] Review/compare answers with expected [PM/Data Modeller/Vandy/Duke]
• [ ] Write tickets for any new Features/Tools requested from above [PM]
• [ ] Add SQL and dashboard tests to automated tests, update expected output of existing tests with cut-off submission date as current date [Developer]

[krobasky]

If you add a new feature/tool request ticket to meet requirements of a query, please reference this ticket (#242)