Preferred Language Status - Participant Update Needed

episphere / connect

Connect API for DCEG's Cohort Study

10 stars 5 forks source link

Preferred Language Status - Participant Update Needed #1085

Open sonyekere opened 3 months ago

sonyekere commented 3 months ago

Team Discussion Summary – August 1, 2024

Attendees: @brotzmanmj , @robertsamm , @Davinkjohnson , MJ, Stephanie, Madhuri, Sandra

Topic: Following the Spanish launch in the July release, the operations team has requested a backfill of language preferences (e.g., English) for participants based on their consent forms. The DevOps team will not be backfilling this data. Please see the guidance decided below.

Action Items:

@KELSEYDOWLING7 will seek guidance on updating her code/the metrics to handle and process null values for language preferences of the verified participants.
@Davinkjohnson and @we-ai will discuss future planning for defaulting null language preferences to English for new logins (PWA update).

KELSEYDOWLING7 commented 3 months ago

Every survey table has been backfilled to have English selected for the survey language flag, unless Spanish was chosen. (SrvBOH_Language_v1r0, SrvMRE_Language_v1r0, ect.)

There is only one instance per table of a participant with a null survey language flag response in select tables.

The SSN survey language flag in the participants table has not yet been generated

KELSEYDOWLING7 commented 3 months ago

Update: The SSN survey language flag is still missing but that may be more complex. The SSN survey is the only survey that does not have its own table. Instead we only have a few variables for that survey in the participants table (completion flag, and portion of SSN completed). In stage, we had one survey language flag in the participants table, and I thought it was a safe assumption that that was the flag for the SSN survey. That variable is not in the prod raw or flattened participants table. Do we anticipate that being added as it was in stage? We've had many SSN surveys completed since the launch

brotzmanmj commented 3 months ago

Adding @FrogGirl1123 to this issue as we were just discussing it on the leads call today

Davinkjohnson commented 3 months ago

@KELSEYDOWLING7 Can you provide the language flag from stage, which You were thinking would end up in Prod? This way we can determine whether the same assumption was made on our end.

KELSEYDOWLING7 commented 3 months ago

@Davinkjohnson My mistake, it was DEV not stage that the survey language flag (d_784119588) was in the participants table