...

• 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

Assigned Tasks

•  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