As an Org Host user, I want to discover, review, clean, and approve uploaded data.

[theecrit]

Description

One of the long-term use cases for the database is to store data that's been collected according to WOEIP's specific data collection requirements. For example, they may conduct a formal, grant-funded study in which certain collection requirements must be met to ensure clean data.

Per the data flow diagram, any uploaded data will be moved from a staging table into the permanent database when a user confirms their session details. However, this data may not be "clean" in the sense that it doesn't conform to WOEIP collection requirements. Therefore, WOEIP admin users need a way to review and approve any uploaded data.

Proposed solution

This approach has been discussed with both developers and WOEIP, and was met with general consensus at the time (approx. Jan 2020?).

1. Project Collaborator user uploads their data to the staging table, confirms their details, and saves the session (covered in 132).
2. System flushes staging table, moving data into permanent table and flagging data as unvalidated. 3. System simultaneously emails Org Host` users that data is available for review (this would be a post-MVP component).
3. Org Host can then sign in, view unvalidated data, clean it, and approve it for unflagging (all post-MVP).
4. On the front-end, default map views would omit unvalidated data, with a toggle option to include it in displayed maps (also post-MVP).

Acceptance criteria

• [ ] Proposed solution has been reviewed by team and finalized.
• [ ] Relevant flows have been documented and wireframed.
• [ ] Flows and wireframes have been reviewed by team.
• [ ] Errors/edge cases have been adequately addressed and documented.
• [ ] Related issues have been created as needed.
• [ ] All open questions have been resolved.

Dependencies and assumptions

• Issue #2 has been implemented per #209

Related documentation

• Roles & Permissions Grid (9/6/19)
• Account Requirements doc (in progress)