Constituent Relationship Join Views

Impresario provides four views for joining on customer_no to return various related constituents as expanded_customer_no.

V_CUSTOMER_EXPAND_HOUSEHOLD:

customer_no expanded_customer_no
Individual with no household Individual
Individual with household Individual
Household All primary affiliates

V_CUSTOMER_WITH_HOUSEHOLD:

customer_no expanded_customer_no
Individual with no household Individual
Individual with household Individual, household, and household's primary affiliates
Household Household and primary affiliates

V_CUSTOMER_WITH_PRIMARY_AFFILIATES:

customer_no expanded_customer_no
Individual with no household Individual
Individual with household Individual and household
Household Household and primary affiliates

V_CUSTOMER_WITH_PRIMARY_GROUP:

customer_no expanded_customer_no
Individual with no household Individual
Individual with household Individual and household
Household Household

The reader may find a view for replacing individual customers with their household (if present) to be useful. The following local view is available from Bitbucket as a snippet:

https://bitbucket.org/snippets/TN_WebShare/aeXzdj

LV_CUSTOMER_SUBSTITUTE_HOUSEHOLD:

customer_no expanded_customer_no
Individual with no household Individual
Individual with household Household
Household Household
Related
Recommended