Hi Tess network,
I wouldl like to include someone's membership information in a report. I know that the output sets which deal with Membership cover a lot of the information I need, but when i look into how they are queried I reach a dead end: in TR_QUERY_ELEMENT they are have a Data From value of "Membership" which isn't verbatim a table that I can incorporate into my report.
Does anyone know how I can figure out how to include the membership information from this psuedo table "Membership" in the TR_QUERY_ELEMENT? Any helps is appreciated.
Hi Aaron,
I find the Table Structures document to be super helpful if I can't figure out where things are coming from. Hopefully the link works:
http://www.tessituranetwork.com/~/media/Documentation/System%20Administration/Tessitura_Table_Structures_V125.ashx
But in a nutshell, the membership data is going to live mainly in TX_CUST_MEMBERSHIP. Depending on the info you are pulling, you might want to join to other tables to get descriptions instead of ID numbers such as T_MEMB_ORG or T_MEMB_LEVEL.
Hope that helps!
That did the trick! Thanks Beth!