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.
John, see the answer below so this means we have our own backend code handling this.
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 Chuck Reif Sent: Friday, March 25, 2011 5:39 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.
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!