We would like to use phone contact point in our extractions to weed out people with no active phone number, but are finding that constituents get selected as having a phone number contact point any time there is a phone number anywhere in their record, even if it is linked to an inactive address.
Are others having this problem, or has anyone found a work around?
I would also be interested in knowing if this has already been reported to Tessitura, and maybe a fix is in the works already?
You might find some help starting on page 21 of this presentation from TLCC2015.
https://tlcc2015.tessituranetwork.com/meetings/281457
It talks about the new V12 Communication Management table structure.
Here is a code snippet from this presentation.
Purpose to Contact Point Purpose
§ Using mail_purpose (v11)
Select * from T_ADDRESS
Where customer_no = @customer_no
and mail_purposes like '%B%'
§ Using Contact Point Purposes (v12)
Select *
from T_ADDRESS a
join TX_CONTACT_POINT_PURPOSE cp on a.address_no = p.contact_point_id
and cp.purpose_id = @purpose_board
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jane VoytekSent: Monday, August 24, 2015 4:10 PMTo: Thomas Brown <tbrown@bam.org>Subject: [Tessitura Development Forum] Phone Contact Point
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!
Also maybe more helpful. Page 12.
FUNCTIONS: for Address, Eaddress & Phone
§ Replace direct table references with the Tessitura function references
– T_ADDRESS replace with FT_GET_ADDRESS
– T_EADDRESS replace with FT_GET_EADDRESS
– T_PHONE replace with FT_GET_PHONES (V12)
§ Functions return the BEST choice based on the parameters and default to the PRIMARY