• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 86 views
  • Users 0 members are here
Related

Database documentation

Former Member
Former Member $organization

Hi,

 

I am trying to find documentation that will help me find the tables and fields I need to create reports in a timely manner.  I have tried unsuccessfully to use the Tessitura_Screens_Table_Reference.ashx document to aid me in this pursuit.  Example, on page 17 of the Tessitura_Screens_Table_Reference.ashx document, the Order Category field should be in the T_ORDER table, but it is in the TR_ORDER_CATEGORY table instead.  Then on page 18 the description field should be in the T_LINEITEM table as shown in the Tessitura_Screens_Table_Reference.ashx document, however, the description field is in the T_INVENTORY table.  There are more examples I could show, but what I really want is to find comprehensive documentation for the impresario database. 

I am sure that the Tessitura Network probably has a database.hlp file or a document that contains what I am looking for, and I am just not looking in the right place.  Also, is there a section of the site that I can search for SQL queries, example of a search: SQL, how to find fyear for ticket sales (I now know the answer), and it might return a sample query.  I have worked with several other CMS’s and some of them had this funtionality on their websites.

 

James

 

Parents
  • $organization

    Hi James,

     

    The Tessitura Screens Table Reference document tells you where constituent, order, and contribution data is stored, not where setup data is stored.  Order header data is stored in the T_ORDER table and line items are stored in the T_LINEITEM table, but if an order or a line item uses values from another table (such as when a value is selected from a dropdown) generally only the ID of the selected value is recorded.  To get the descriptions for display in report parameters and results you need to cross reference the setup tables where the values are stored.  Reference tables (prefix of TR) are used for most things selected from a dropdown (like order category) and they are listed and explained in the System Tables document.  For non-reference table setup (like performances) you’ll want to see the Tessitura Table Structures document.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

Reply
  • $organization

    Hi James,

     

    The Tessitura Screens Table Reference document tells you where constituent, order, and contribution data is stored, not where setup data is stored.  Order header data is stored in the T_ORDER table and line items are stored in the T_LINEITEM table, but if an order or a line item uses values from another table (such as when a value is selected from a dropdown) generally only the ID of the selected value is recorded.  To get the descriptions for display in report parameters and results you need to cross reference the setup tables where the values are stored.  Reference tables (prefix of TR) are used for most things selected from a dropdown (like order category) and they are listed and explained in the System Tables document.  For non-reference table setup (like performances) you’ll want to see the Tessitura Table Structures document.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

Children