There are two fields in the UNC Demographic node that provide Household ID information, Household Lookup ID and Household Dedupe ID. They are available in the query designer and they have been added to most export definitions. They both are useful in different situations.
Household Lookup ID
What is it? – If a constituent is currently part of a household (spouse or partner), this will display the lookup ID for that household. Constituents in the same household will have the same Household Lookup ID. However, if a constituent is not in a household, this field will be blank.
When is it useful? – If searching for instances where both spouses are in a file, this field can be leveraged along with the Highlight Duplicate Values feature in Excel. A common example is if you are reviewing a prospecting file and you wish to identify instances where both spouses are in the file.
Household Dedupe ID
What is it? – This field will never be blank. If a constituent is in a household (spouse or partner), the Household Lookup ID will display. However, if a constituent is not in a household, then the constituent’s individual lookup id will display.
When is it useful? – This works well when using the Remove Duplicates feature in Excel. A common example is if you need to “combine the household” for a file because it will be used to send a mail piece (acknowledgements, general correspondence or events; marketing efforts have the functionality) and you don’t want to send two pieces to a single household.