TM_... Tables

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!

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!

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!

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!