Multiple zips in extractions

Hi Joe,

FT_GET_ADDRESS should get rid of inactive addresses, as should using primary_ind = 'Y' and/or inactive = ‘N’ when referencing VS_ADDRESS. FYI, FT_GET_ADDRESS will pull addresses for affiliates of households based on the household record if the affiliates themselves don’t have an address record (via the inheritance concept). Referencing VS_ADDRESS will not pull affiliates of households unless the affiliates themselves have qualifying criteria.

Matt

You can get really fancy when pulling addresses.

Here’s a query from an extraction segment that looks for people who have tickets in a few seasons, and who are on a particular list, and who have an address that’s valid for mailing on a particular date, where that address is located in one of the counties near or next to the theaters where we perform:

Select Distinct a.customer_no

 From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)

JOIN VS_TCK_HIST e (Nolock) ON e.customer_no = a.customer_no

JOIN T_LIST_CONTENTS f (Nolock) ON f.customer_no = a.customer_no

cross apply FT_GET_ADDRESS('5/13/2015',null,null,a.customer_no) b

Where IsNull(a.inactive, 1) = 1

 AND e.season in (67,75,82)

AND f.list_no = 46084

AND b.address_no in (select address_no from VS_ADDRESS where inactive = 'N' and geo_area in (7,8,9,10))

The FT_GET_ADDRESS() function is great when you’re trying to limit list pulls to certain locations or purposes. It pulls address based on four parameters—mailing date, mail purpose, label, and customer_no. (We’re still on Tess version 11. This would have to have been updated for version 12 to account for expanded mail purposes.)

Lucie

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!

Hi Joe,

FT_GET_ADDRESS should get rid of inactive addresses, as should using primary_ind = 'Y' and/or inactive = ‘N’ when referencing VS_ADDRESS. FYI, FT_GET_ADDRESS will pull addresses for affiliates of households based on the household record if the affiliates themselves don’t have an address record (via the inheritance concept). Referencing VS_ADDRESS will not pull affiliates of households unless the affiliates themselves have qualifying criteria.

Matt

You can get really fancy when pulling addresses.

Here’s a query from an extraction segment that looks for people who have tickets in a few seasons, and who are on a particular list, and who have an address that’s valid for mailing on a particular date, where that address is located in one of the counties near or next to the theaters where we perform:

Select Distinct a.customer_no

 From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)

JOIN VS_TCK_HIST e (Nolock) ON e.customer_no = a.customer_no

JOIN T_LIST_CONTENTS f (Nolock) ON f.customer_no = a.customer_no

cross apply FT_GET_ADDRESS('5/13/2015',null,null,a.customer_no) b

Where IsNull(a.inactive, 1) = 1

 AND e.season in (67,75,82)

AND f.list_no = 46084

AND b.address_no in (select address_no from VS_ADDRESS where inactive = 'N' and geo_area in (7,8,9,10))

The FT_GET_ADDRESS() function is great when you’re trying to limit list pulls to certain locations or purposes. It pulls address based on four parameters—mailing date, mail purpose, label, and customer_no. (We’re still on Tess version 11. This would have to have been updated for version 12 to account for expanded mail purposes.)

Lucie

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!