For fundraising, events, and general "good to know numbers" - I would like to be able to pull the number of households we have in the school. Ex. 250 students, 160 households.
As of November 2021, there is now the ability to mark a household and enter a household salutation, but there is no way to pull that household field in a list or report. I've seen a couple of forum posts where users are generating a list and then manually grouping by address in Excel, but what is also needed here is simple way to pull households and the associated salutations for mailing purposes of one mailing per household.
Hi folks! Doing a last call for schools that would like to participate in our Household EAP starting up. If you haven't already reached out to me and would like to get in on this please send me a direct message on the forum or to my email - angela.addison@blackbaud.com. Thanks! I will be finalizing the list and sending out instructions in the next week or so.
Hello all, we are actively working on a household list feature and would love it if folks interested in household capabilities would take a short survey to help us hone in (and also at the end let us know if you'd like to participate in reviewing our in progress work and/or sign up to be part of an EAP!) https://app.handrailux.com/#/surveys/k9yyjk
I would use household to mean an address where a custodial parent/grandparent/guardian lives. I'm not sure how best to determine that based on what we have available in contact cards. Maybe using the resides with check box? I would love to be able to pull a list of household addresses so we could send one mailing to each household.
I also use "household" or "family unit" for various metrics. My default terminology is "family unit" since a family can be composed of different households/addresses. The definition I use consistently is based on the fact that a student can only belong to one. The "family unit" may have more than one address and more than two parents/guardians. I use this measure for assessing participation. I do wish we had a a "family unit" (or some other name) designation/id per student so that we could quickly pull this group at the moment it is a bit of a work around to get the number.
Thank you Jeff and Charlie; we need to count households in the same way. That is, how many different parental households exist in our student body. Each household may have more than one child, in the case of siblings, AND the same household could be part of two separate family records, in the case of mixed families.
What would be useful to us is a count of the number of address records that are attached to a student's parent relationships. In most cases, this would be one, but there could be multiple households in case of divorce and/or remarriage. Hopefully I explained that clearly. Let me know if not. Thank you.
I would say a household is an address where at least one student either 1) shares an address or 2) has a 'parent' relationship with a resident that has the address. There could be filters for all of the parent qualifiers (signs contract/lives with student/list as parent/parental access).
The Households & addresses list in Core now meets this need, along with columns for each salutation type on the address that was marked a household!
As of November 2021, there is now the ability to mark a household and enter a household salutation, but there is no way to pull that household field in a list or report. I've seen a couple of forum posts where users are generating a list and then manually grouping by address in Excel, but what is also needed here is simple way to pull households and the associated salutations for mailing purposes of one mailing per household.
Hi folks! Doing a last call for schools that would like to participate in our Household EAP starting up. If you haven't already reached out to me and would like to get in on this please send me a direct message on the forum or to my email - angela.addison@blackbaud.com. Thanks! I will be finalizing the list and sending out instructions in the next week or so.
Hello all, we are actively working on a household list feature and would love it if folks interested in household capabilities would take a short survey to help us hone in (and also at the end let us know if you'd like to participate in reviewing our in progress work and/or sign up to be part of an EAP!) https://app.handrailux.com/#/surveys/k9yyjk
I would use household to mean an address where a custodial parent/grandparent/guardian lives. I'm not sure how best to determine that based on what we have available in contact cards. Maybe using the resides with check box? I would love to be able to pull a list of household addresses so we could send one mailing to each household.
I also use "household" or "family unit" for various metrics. My default terminology is "family unit" since a family can be composed of different households/addresses. The definition I use consistently is based on the fact that a student can only belong to one. The "family unit" may have more than one address and more than two parents/guardians. I use this measure for assessing participation. I do wish we had a a "family unit" (or some other name) designation/id per student so that we could quickly pull this group at the moment it is a bit of a work around to get the number.
Thank you Jeff and Charlie; we need to count households in the same way. That is, how many different parental households exist in our student body. Each household may have more than one child, in the case of siblings, AND the same household could be part of two separate family records, in the case of mixed families.
What would be useful to us is a count of the number of address records that are attached to a student's parent relationships. In most cases, this would be one, but there could be multiple households in case of divorce and/or remarriage. Hopefully I explained that clearly. Let me know if not. Thank you.
I would say a household is an address where at least one student either 1) shares an address or 2) has a 'parent' relationship with a resident that has the address. There could be filters for all of the parent qualifiers (signs contract/lives with student/list as parent/parental access).
Can you describe here how you would define a household? Based on shared addresses? How many households can one student be a part of?
This seems like a really basic piece of information that a database should be able to provide.