• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 68 views
  • Users 0 members are here
Related

TM_... Tables

Marty Jones
$organization

Anybody know the purpose of the TM_... Tables?

 

Thanks

Parents
  • Former Member
    Former Member $organization
    The TM_ tables are "mirror" tables that are used when processing transactions in a Controlled batch.  When a transaction is processed in a Controlled batch, the data is saved in the TM_ tables and not in the T_ tables.  When the Controlled batch is closed, the data is moved from the "mirror" tables into the T_ tables and these entries are cleared from the TM_ tables.  Before a Controlled batch is closed, the data sitting in the TM_ tables is not visible in Tessitura (for example, you will not see such a contribution in Constituents/Contributions); when the Controlled batch is closed, the moving of the entries from the TM_ to the T_ tables saves the data as "real" transactions which are visible in the application.  This process involves some complex record locking.
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Thursday, May 13, 2010 9:46 AM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] TM_... Tables

    Anybody know the purpose of the TM_... Tables?

     

    Thanks




    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!
Reply
  • Former Member
    Former Member $organization
    The TM_ tables are "mirror" tables that are used when processing transactions in a Controlled batch.  When a transaction is processed in a Controlled batch, the data is saved in the TM_ tables and not in the T_ tables.  When the Controlled batch is closed, the data is moved from the "mirror" tables into the T_ tables and these entries are cleared from the TM_ tables.  Before a Controlled batch is closed, the data sitting in the TM_ tables is not visible in Tessitura (for example, you will not see such a contribution in Constituents/Contributions); when the Controlled batch is closed, the moving of the entries from the TM_ to the T_ tables saves the data as "real" transactions which are visible in the application.  This process involves some complex record locking.
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Thursday, May 13, 2010 9:46 AM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] TM_... Tables

    Anybody know the purpose of the TM_... Tables?

     

    Thanks




    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!
Children
No Data