@dorner This PR is a data-migration precursor to #4254.

@dorner I'm looking at the prod data, there are a lot of cases where it is blindingly obvious to a human what the category is even though it isn't a 100% matchup to what the text in AGENCY_TYPES is (we did add some to AGENCY_TYPES this year). [For instance, "Community health program", of which we have at least 40, would come under "HEALTH", "Food pantry" would come under "FOOD", etc.

So there would be side effects here in the annual report section on the partners -- especially as we just lump all the "Others" together at this point.

Over the course of a year, as people recertify their partners (if they do), this might become less of an issue.

IMO, If we are doing this migration, we should change the partner_agency_counts in the PartnerInfoReportService to also split out the other. We could also provide some additional mapping of the agency types as in the db to the codes (which I would have to provide).

What do you think?

There's the option of manually updating the close ones ahead of the big move to Other in this migration. Like, based on the list it'd be easy to, for examples,

UPDATE partner_profiles SET agency_type = 'Food bank/pantry' WHERE agency_type = 'Food bank';
UPDATE partner_profiles SET agency_type = 'Food bank/pantry' WHERE agency_type = 'Food pantry';

and just reference as many items as we can. But that's all outside of my frame of reference and the collection of "non profit" ones would seem problematic.

@cielf I think it would be up to you to provide the mapping, and then we can incorporate that into the migration.

Nods Oh, I knew I was letting myself in for more work when I said that g. Adding it to the list for this week.

Putting this back on your radar, @cielf

Yup -- I've got a proposed mapping, and I'm checking with the NDBN folks to see if I can get a review of it before passing it on to you.

The appropriate person just got back from vacation yesterday, and this is understandably not their # 1 priority. I think we should have the review by sometime next week though.

Awesome, looking forward to it!

I just got something back from NDBN this afternoon. I've got a few other things I have to pay attention to before the Sunday meeting, so it'll probably Monday for me to review and see if there's any knock on effects (It sounded like they might want to add a couple more categories)

Ok. What I've got back from NDBN -- they are suggesting, given the full list of what we have, that we add 3 more categories:
BNB -- Basic Needs Bank,
MHEALTH -- Mental Health, and
DISTRICT -- School District.

I'll be uploading the mapping within the hour.

Here's a CSV file. The intended use of this is that if you have the "Entry" in "Other" now, it should be the Agency Type indicated in PArtner Agency Type Short. There are definitely some that are not in this list -- so if you have an entry in "Other" that is not in this list, or that is indicated as "Other" keep it as other, and keep the other text as originally entered. Hope that makes sense!

Mapping for agency type.csv