Is there a table that indicates if an address (or phone) is inherited?
Sorry if this is a restatement of the obvious. The business rule is pretty simple: Only primary addresses can be inherited, always from the household to a primary affiliate. A primary affiliate’s address cannot be used to inherit to another affiliate or the household itself.
Bearing that in mind, it’s simply a matter of finding where the primary address’s owner (customer_no) doesn’t match the current customer_no. Something like this:
Select c.lname, c.fname, a.*
From dbo.FT_GET_PRIMARY_ADDRESS() a
JOIN dbo.T_CUSTOMER c on a.customer_no = c.customer_no
Where Not Exists (Select * From T_ADDRESS x Where x.address_no = a.address_no and x.customer_no = a.customer_no)
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby Sent: Wednesday, March 13, 2013 3:32 PM To: Ryan Creps Subject: [Tessitura Technical Forum] Table that shows an address is inherited
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!