...

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

...

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