Status

Requirements

• The Thailand BVBD requires that all data captured in Reveal be available for ETL into their Malaria Informations System (Biophics)
• These data include all form fields and as much metadata as possible
• The requirement is for the following forms to be available in the Biophics holding database (db_mhealth)
  • Household Registration with Head of Household (HoH) details and HoH created as a Household Member as well, as per Reveal
  • Household Members (including HoH as mentioned above)
  • Blood screening (linked to household member)
  • Index Case Confirmation (linked to household member)
  • Bednet distribution (linked to household)
  • Indoor Residual Spraying (linked to household)
  • Mosquito Collection (linked to focus area/operational area)
  • Larval Dip (linked to focus area)
  • (Near future) Potential Area of Transmission (linked to focus area/operational area)
• Field testing is planned for 21st August
• Pilot in 3 provinces is scheduled for September, dependant on successful field testing
• It is more important to be able to see that a form has saved to the holding tables that to have every data exactly mirrored.
• The main priority is for CHAI and the BVBD to be able to see some data from each form saved on the mobile device showing up in Biophics within a few minutes.
• Each record should be correctly linked to other relevant records (e.g. a household member should always have a household record, a blood screening should always have a household member).
• The process can be improved going forward to ensure that all fields are captured correctly for each form
• Ideally, the holding tables should enforce referential integrity, but this can be relaxed if it will cause race conditions and insert failures
• Every record should have a timestamp for when it was created in Reveal, and when it was created in the holding tables
• Every record should include the name of the Reveal user who captured the data
• Every record should be linked to a plan and focus area
• There may be focus areas in Reveal that do not exist in Biophics - this is expected and should be dealt with (holding tables should include both the Reveal location id (not null), as well as the Biophics focus area id (nullable)
• A formal test script is being developed and will be shared iteratively over the next 2 weeks
• Historical data can be ignored and the team is only interested in seeing data going back 2 days, until the process is finalized. This needs to be done at least 2 days before field testing starts.

Testing

• Currently, CHAI and VItal Wave are testing by completing forms for a structure, logging into the Biophics database and checking to see if records appear in the relevant tables

Screenshots

Notes

Questions

Test Case