...

This table (named appVersion for legacy reasons) is an aggregate of all data collected so far, used for querying study-wide stats. It contains all the common fields as described above, as well as the "originalTable" field, which refers to the table containing the original record.

Status Table

At the end of each Exporter run, the Exporter will write an entry to this table containing today's date. Example: The Exporter runs on 2016-03-08 at 2am. It processes and exports yesterday's data (2016-03-07). It then writes 2016-03-08 to the Status table.

This table can be used to query if the Exporter has finished running for the day and can be used to schedule automated post-processing jobs.

Demographics

TODO: Not yet implemented

...