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.
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.
Yes, I have those in place. These are the values that are in t_memb_level.
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 Kendra Struthers Sent: Tuesday, March 22, 2011 9:32 AM To: Matt Winchester Subject: Re: [Tessitura Technical Forum] How do membership dates get inserted
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!
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 WinchesterSent: Tuesday, March 22, 2011 8:17 AMTo: Steve CarlockSubject: RE: [Tessitura Technical Forum] How do membership dates get inserted
Matt Winchester Database AdministratorDallas Symphony Orchestra Morton H. Meyerson Symphony CenterSchlegel Administrative Suites2301 Flora Street Dallas, Texas 75201 214-871-4028 - phone214-953-1218 - faxm.winchester@DalSym.comwww.dallassymphony.com
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kendra StruthersSent: Tuesday, March 22, 2011 9:32 AMTo: Matt WinchesterSubject: Re: [Tessitura Technical Forum] How do membership dates get inserted
From: Matt Winchester <bounce-matthewwinchester1652@tessituranetwork.com>Sent: 3/22/2011 9:12:06 AM
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.
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
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
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.
If you are not running the Membership Update Utility you need to get it setup for each membership orginization. We have found that it works best if run at about 11:50pm. Your milage may vary.
That said the columns cancel_dt, susp_dt, are completely empty in our system as well. I do not know if these columns are used. I’d check with support on this issue.
--Tom
Understood, but when I actually look at the code for the membership update (AP_MEMBERSHIP_UPDATE), I am not seeing any reference to inserting dates, unless I am looking at the wrong procedure. Yes, you are correct about susp_dt and cancel_dt being null but lapsed, renewal, and reinstate should not be.
Thanks.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tom Brown Sent: Tuesday, March 22, 2011 1:27 PM To: Matt Winchester Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
From: Matt Winchester <bounce-matthewwinchester1652@tessituranetwork.com> Sent: 3/22/2011 12:52:37 PM
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 Error! Filename not specified.
Error! Filename not specified.
Well, I know for sure this did work in Version 9 because I had code using the membership expiration date to manage my constituency dates that were based off of memberships. You may be right, this may be deprecated but I hope not because I thought that the membership renewal functionality used these dates but maybe instead of housing the dates, they have just moved to a function using date manipulation via SQL (honestly, that’s what I would do).
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin Sent: Tuesday, March 22, 2011 1:22 PM To: Matt Winchester Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
The only date columns in the membership table that are maintained are inception_dt, init_dt and expr_dt. This is explained further in the Table Structures document.
John, see the answer below so this means we have our own backend code handling this.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chuck Reif Sent: Friday, March 25, 2011 5:39 PM To: Matt Winchester Subject: Re: [Tessitura Technical Forum] How do membership dates get inserted