Constituency Inactive indicator

The inactive column is based on an expression using the start and end dates.

The rule is:

Start Date < End Date or End Date < Start Date (reactivated) or the End Date is NULL

The view VX_CONST_CUST_ACTIVE uses this expression set to filter out inactives from the view itself.  You could take a look at the where clause of it if you are looking to replicate this in SQL.

There is code in the insert trigger of TX_CUST_MEMBERSHIP that takes care of the constituency during a renewal or the creation of a new membership.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Boncek
Sent: Thursday, April 21, 2011 3:48 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Constituency Inactive indicator

Hey all,

Anyone know where a contituency's Inactive Indicator is located?  It doesn't seem to be in TX_const_cust ...

Also, anyone familiar with how memberships, new renewed etc, effect constituencies?  It seems as though a renewal is triggering a new start date to an associated constituency, but not a corresponding end date.  I haven't started digging through procedures yet to figure it out...

Thanks.

James

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!

The inactive column is based on an expression using the start and end dates.

The rule is:

Start Date < End Date or End Date < Start Date (reactivated) or the End Date is NULL

The view VX_CONST_CUST_ACTIVE uses this expression set to filter out inactives from the view itself.  You could take a look at the where clause of it if you are looking to replicate this in SQL.

There is code in the insert trigger of TX_CUST_MEMBERSHIP that takes care of the constituency during a renewal or the creation of a new membership.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Boncek
Sent: Thursday, April 21, 2011 3:48 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Constituency Inactive indicator

Hey all,

Anyone know where a contituency's Inactive Indicator is located?  It doesn't seem to be in TX_const_cust ...

Also, anyone familiar with how memberships, new renewed etc, effect constituencies?  It seems as though a renewal is triggering a new start date to an associated constituency, but not a corresponding end date.  I haven't started digging through procedures yet to figure it out...

Thanks.

James

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!