submission_id

The ID in way to health of the data submission

188273672

participant_id

The Way to Health ID of the participant this incident is related to

608274

status

Participant status

“Enrolled”/”Ready”/”Started” etc

arm

The name of the arm that the participant is in

account_created

The date and time the participants account was created in Way to Health

2021-08-30 15:02:53

start_date

The date and time the participant started in their arm

2021-09-02 10:23:14

timestamp

The date and time the data was valid for. This is the “as of” field in Way to Health.

2021-09-02 17:23:14

received_in_w2h

The date and time the data was entered into Way to Health

2021-09-02 17:24:28

event_name

The name of the event this data is attached to (if it is attached to an event)

Fitbit Data Collection

event_sequence

The event in a repeating event series that the data is attached to (if it is attached to an event)

20

event_type

The type of the event the data is attached to (if it is attached to an event)

Conversation, Survey, Device

source_version

Version information for the source at the time this data was provided to Way to Health

3 (2022-01-20)

[Data columns]

There will be an additional column for every question/field on the source. If there is no data for the column, then it will not be included.

This holds the value for a given field within the data source.

This will hold a few things:

1. Data: This would be the text submitted, or the step count, or what you would expect

2. “-”: This means that the participant never saw the question (it may have been on a page that was hidden to them)

3. “.”: We don’t have data but it was not marked as skipped. The field might not have existed when the data came in

How often does this run?

For daily: Around 2-4 AM

For weekly: Around 2 AM on Sunday

Can it be run per-study?

No

Incremental?

No. Rebuilds tables and data every time

Updates existing rows?

Yes, not that they ever do