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 (using Pacific Local Time), in YYYY-MM-DD format. TODO: Synapse may be treating this field differently than Bridge. 

createdOn - Time instant when this data was measured, as reported by the app. This is in ISO 8601 format (http://en.wikipedia.org/wiki/ISO_8601) and is generally normalized to Pacific Local Time. TODO: Synapse may be treating this field differently than Bridge.metadata - Link to metadata JSON blob, as reported by the app. TODO:remove this, as this is redundant with phone and app info

userSharingScope - TODO: remove this

taskRunId - TODO: remove this

Phone and App Info

TODO: Not yet implemented

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

appVersion - App version, example: "version 1.0, build 7"

...

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

...