Constituencies

Hi Penny,

It’s TX_CONST_CUST .  Or you can use the view  VX_CONST_CUST_ACTIVE  which selects only accounts with active constituencies.

Can someone tell me which table stores a customer’s constituencies?  I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no.  Which table will show me that customer_no 19996 has constituency ID of 18?

Thanks in advance!

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

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!

This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.

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!

Hi Penny,

It’s TX_CONST_CUST .  Or you can use the view  VX_CONST_CUST_ACTIVE  which selects only accounts with active constituencies.

Can someone tell me which table stores a customer’s constituencies?  I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no.  Which table will show me that customer_no 19996 has constituency ID of 18?

Thanks in advance!

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

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!

This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.

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!