...

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: This has appVersion and phoneInfo have a max length of 48 characters. Submitting a 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.

...

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

Surveys

TODO

Non-Surveys

TODO

Attachment

TODO