CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Representation of 'family' - organization or household?
Pages: [1]

Author Topic: Representation of 'family' - organization or household?  (Read 4476 times)

nickholden

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 1
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5.32
  • PHP version: 5.4
Representation of 'family' - organization or household?
September 04, 2013, 02:39:42 am
Just wondering what structures people use to represent the concept of a family (i.e. a group of people who are related to each other) as distinct from a group of people who choose to live together. We're setting up for a research study which will involve families that include grown-up children, who often don't live at the same address as their parents. So this seems to point us towards creating an organization sub-type of 'family' which people can have various relationshsips with: father in family, mother in family, eldest child in family, etc., as well as relationships between the individuals themselves, so that we can address the family as a unit, as well as individual volunteers.

Anyone done anything similar? Or used household to achieve the same effect?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Representation of 'family' - organization or household?
September 04, 2013, 04:09:53 am
I doubt you would want to track both households and families, because that would be a massive amount of stuff to keep track of. E.g. when creating a contact you would need to enter:
Bob Smith
Member of Smith Household
Member of Smith Family
(and repeat for each family member)
So if I were you I wouldn't do both. Why not just rename "Household" to "Family".
But if you really want both, you could create "Family" as an Household contact-sub-type.
Either way, I think household is a more appropriate entity than Organization.
« Last Edit: September 04, 2013, 06:42:31 am by Coleman Watts »
Try asking your question on the new CiviCRM help site.

nickholden

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 1
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5.32
  • PHP version: 5.4
Re: Representation of 'family' - organization or household?
September 19, 2013, 06:29:52 am
I think that's true, and for our purposes I think we'd want to track family relationships more than household ones - who people are related to matters more to us than where they live - but I can easily imagine scenarios where we would need to know details of both. My problem with household as a concept is that it implies a common address, whereas families with adult children rarely all live together.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Representation of 'family' - organization or household?
September 19, 2013, 09:09:55 am
Just to throw in another perspective, one org I work with does not use the household contact type at all. Rationale: it's twice as much work to enter a person+hh into the database as just entering the person. And all the relational data can just be stored as relationships between individuals. So a typical family might be entered as:
Bob -> relationship-type-spouse -> Kathy
Kathy -> share address with -> Bob
Sam -> relationship-type-child -> Kathy
Sam -> relationship-type-child -> Bob

If sam still lives at home, he can also share an address with bob & kathy. If not, he can have a different address.
Try asking your question on the new CiviCRM help site.

nickholden

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 1
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5.32
  • PHP version: 5.4
Re: Representation of 'family' - organization or household?
September 20, 2013, 07:31:18 am
That's true. Maybe we don't need to define the family unit, but just imply it as the sum of all the relationships. Each person already has a 'family id' recorded as custom data, so we can find all the people in a particular family just by referencing that field. Will consider this some more before making a final decision...

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Representation of 'family' - organization or household?
October 01, 2013, 04:24:38 am
If you're at Civicon I'd be interested to chat more about this as I'm thinking about doing a Birds of a Feather session on households. It'd be helpful to explore good practice using households and the opportunities/limitation of the current set up. We found that we can't use 'share address with' because we have several large community houses where you might have a mixture of single people, couples and families living. 'Share address with' means any labels generated might have 20 occupants on one label!

We've set up family relationships - spouse, child of - and then used households as well. If mum and dad a child, at 18 the child would then be removed from the household (so they receive their own mailings as an adult) but they're still clearly marked relationally as a 'child of' as that hasn't changed.

I'd be interested to know what conclusion you came to Nick.

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Representation of 'family' - organization or household?
March 09, 2014, 02:24:05 pm
Realize this is an old thread but wondered if there was some outcome on this topic.  We have individuals and couples and households seems like way too much work.  Looking for some best practices.

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Representation of 'family' - organization or household?
May 19, 2014, 08:58:06 am
It's a tricky one... households have significant limitations and challenges so I'd avoid them if you can. We had no other choice as we need to group families but we have some very large shared houses which include both families and singles so we couldn't just use 'share address'... or we'd potentially have 25 people sharing one address which is something of a labelling challenge!

If you just have a simple scenario I'd probably just use 'share address' to group family units living in the same house and record relationships too - parent of, spouse of etc.

One challenge will be if you also have lots of single people (eg 8 students) living in shared accommodation. The use of 'merge by address' when you're dealing with these people along with the families will give you one label for all 8 students for example. If you want labels for them separately you'll have to ensure everyone's address is slightly different which is a pain. We did things like 25 Stanley Road (a), 25 Stanley Road (b) to get round it as we had to use 'merge by address' for several years while 'merge by household' wasn't working for labels. Fortunately it now is!


SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Representation of 'family' - organization or household?
May 30, 2014, 03:01:59 am
What I normally do with the data for congregations I work with. Households are an important "logical" entity for the staff of the congregation when they are working with their congregants.

What I do if there is a family that includes a combination of adults and minor children:

Jane Smith has a "spouse of" relationship with John Doe
Jane Smith and John Doe have "parent of" relationships with their 2 minor children(Nathan and Maddie)  who live at home.
Jane Smith and John Doe have a "parent of independent child" relationship with their oldest child (Julie), who lives on their own.
Jane, John and the 2 minor children are all household members of the "Doe/Smith Household" AND have a "shares address with"
Jane has a "head of household" relationship to the "Doe/Smith Household"
all three children (Nathan, Maddie and Julie) have sibling relationships with each other.

If a person is single, or its just 2 adults living as a couple then I do not bother with households.

Membership types that are configured to cover relatives, are set to cover "parent of". It does NOT cover "parent of independent child"
When producing mailing labels, I do one of the following

a) Use "Merge labels for contacts belonging to the same household" option. 

b) (most common) Search on "primary member only" so that I only get at most one person per household ( and it doesn't matter if the person is not part of any household)  then use a custom token on the top line of the label that shows "Jane Smith and John Doe" or "Sam and Rebecca Jones" for any married/partnered people.


What is currently a hassle is when a new family that includes 2 adults and minor children needs to be added to the database. I am thinking of using Drupal WebForms with the CiviCRM integration to create a "new household" form that creates all the typical relationships under the hood.  (Handling blended families is always a challenge: ie Each adult has minor children (living at home) from a previous relationship, and they also have young children together.)

For people living at a common residence ( eg a dorm, co-op house, community house, etc) I do NOT use the "shares address with".

I never use the mailing label option "Merge labels for contacts with the same address" as it is dangerous for reasons mentioned above.









Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Representation of 'family' - organization or household?

This forum was archived on 2017-11-26.