Common Fields

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

recordId - Unique identifier for this survey run or activity run.

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

externalId - External ID defined and set by the apps. This field is app-specific and may not be filled out in each table.

uploadDate - Calendar date this data was uploaded to Synapse (using Pacific Local Time), in YYYY-MM-DD format. 

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 Synapse Web UI in Pacific Local Time.

appVersion - App version, example: "version 1.0, build 7" (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.)

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.)

Phone and App Info

This is an aggregated table with phone and app info for all tables. It includes the following fields:

recordId - Record ID that this entry was generated from.

healthCode - same as Common Fields

externalId - same as Common Fields

uploadDate - same as Common Fields

originalTable - The table containing the original record.

appVersion - same as Common Fields

phoneInfo - same as Common Fields

Demographics

TODO: Not yet implemented

Surveys

TODO

Non-Surveys

TODO

Attachment

TODO