Agenda

ES: tweaking mapping for X gender marker (I originally had it as intersex/indeterminate, but realistically our population will mostly be Non-Binary) Sex and Gender
ES: review DRAFT/DEVELOPMENT/PRODUCTION labelling Documentation Standards
HW: questions about inquiry details standardization across instances
- Why do they have to be able to select more than one program of interest again?
HW: Nutrition lead/inquiry audit
- Issue with missing records in NUTR Attribution: https://gradhlthsci.admissions.tufts.edu/manage/query/query?id=ef887f42-f6dc-4382-926e-b165ec5ac482
  - Always count if came through Hubspot Source Format?
- Issue with source format mapping for NUTR Hubspot, program of interest
HW: TUH person query update discussion… flags or no flags?
HW: Brainstorm questions for TUSMGP slate position
ES: Tristan’s comments on schools cleanup
ES: Prereqs, or ‘is there any reason not to handle them by an app-scoped entity like in DPT?’

Meeting Notes

Helen is using PowerShell to combine multiple HubSpot files!
latest campaign source, first source, and all source data --should these be person scoped fields, rather than inquiry details entity? Yep!
standardization of Inq Detail fields across all instances
NUTR attribution rule has a bad join that only pulls one source format--missing 1K NUTR records
create person-scoped flags as much as possible for Denodo

@Helen Williams create and map person-scoped fields for Hubspot source original/most recent/all campaigns in all four instances.

@Helen Williams set up a meeting to discuss standard nomenclature/organization/cleanup for queries/reports in TUH & TUSMGP

@Helen Williams update NUTR and GSBS attribution rules and retro refresh

@Elizabeth Storrs update mapping for gender marker X to be Non-binary in TUV, TUF, and TUH

@Elizabeth Storrs review prereq test files--find student who Patty made updates to