Which proc/trigger inserts the dates into tx_cust_membership? I have the values in place within t_memb_level to manage the desired date functions for lapsed, suspended, etc. but when we add a gift in our TEST server, I am only seeing the expiration date and initiated date populated. Lapsed, cancel, suspend, etc are not getting populated.
I can verify that but I thought that utility was used to manage the transition from status to status not to actually insert the dates. I will have a look, thanks.
Matt Winchester Database Administrator Dallas Symphony Orchestra Morton H. Meyerson Symphony Center Schlegel Administrative Suites 2301 Flora Street Dallas, Texas 75201 214-871-4028 - phone 214-953-1218 - fax m.winchester@DalSym.com www.dallassymphony.com
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Steve Carlock Sent: Tuesday, March 22, 2011 12:12 PM To: Matt Winchester Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
Matt,
Are you running the Membership Update Utility? I think that’s the one that maintains that information.
-steve
Information Technology Manager
Santa Barbara Center for the Performing Arts
1330 State Street, Suite 101
Santa Barbara, CA 93101
(805) 899-3000 x 111 (phone)
(805) 899-3081 (fax)
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Winchester Sent: Tuesday, March 22, 2011 8:17 AM To: Steve Carlock Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
Yes, I have those in place. These are the values that are in t_memb_level.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kendra Struthers Sent: Tuesday, March 22, 2011 9:32 AM To: Matt Winchester Subject: Re: [Tessitura Technical Forum] How do membership dates get inserted
Do you have the rules for lapsed, cancel, suspended, etc. set up for each associated membership level in Test? This can be found under Campaigns/Memberships.
From: Matt Winchester <bounce-matthewwinchester1652@tessituranetwork.com> Sent: 3/22/2011 9:12:06 AM
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!
Your inquiry made me curious so I had a look in tx_cust_membership. We have ALL nulls in the following fields: susp_dt, cancel_dt, renew_dt, lapse_dt, rein_dt. We have been using memberships here for 5 years and I have never used these dates. I'm wondering if they are extinct fields.
The view v_membership_current shows current memberships based on the rules you set up in Campaigns-Memberships.
Pretty sure the Membership Update Utility doesn't mess with dates but rather just updates status based on the rules in Campaigns-Memberships. This is from the documentation:
The Membership Update Utility assesses and updates membership statuses and may update constituency values on a global basis based on the selection criteria.