...

Common Fields

All data tables (survey and attachment) include the following fields, plus additional fields specific to the data table:

...

healthCode - De-identified identifier for the individual represted represented by this record.

externalId - External ID, a unique ID for each individual, defined and set by the apps and managed outside of Sage. This field is app-specific and may not be filled out in each table.

...

createdOn - Time instant when this data was measured, as reported by the app. This is stored in Synapse as milliseconds since the start of the epoch (1970-01-01T00:00:00.000Z), but is displayed in tge the Synapse Web UI in Pacific Local Time.

...

phoneInfo - Phone info, example: "iPhone 5s (GSM)" (NOTE: This data is ResearchKit-specific and may or may not apply to non-ResearchKit uploads. Additionally, this data is self-reported by the apps.)

NOTE: appVersion and phoneInfo have a max length of 48 characters. Submitting appVersion or phoneInfo longer than 48 characters will be truncated.

appVersion Table

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.

Demographics

TODO: Not yet implemented

Surveys

TODO

Non-Surveys

TODO

Attachment

...

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.