Has anyone created an output element for membership original expiration date? Or does anyone know where the standard membership elements pull from? I'm hoping to create an element to pull this information but I want it to function like the regular membership elements in that I only want the info for current active membership records.
Thanks!
Hi Anne
The standard Membership elements in Tessitura reference a Virtual table to create the data - not a table/view that exists in the database.
However, there are two views that might be of use to you VS_ELEMENTS_MEMBERSHIP_MOST_RECENT and VS_ELEMENTS_MEMBERSHIPBoth views include pretty much everything you'd want to output for Memberships. As you will be creating custom Elements, you have the ability to create Filters for Elements so you can output the data for specific Memberships.
Hope that helps.
CheersSandra
Thanks, Sandra! This is helpful, I think I can get what I need from VS_ELEMENTS_MEMBERSHIP_MOST_RECENT.