• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 69 views
  • Users 0 members are here
Related

TR_BATCH_PERIOD

Matt Gonzales
$organization

I've been told that my TR_BATCH_PERIOD table doesn't have any entries for the current 2010 season and there should be.  Any idea what this table is and what stored procedure (which I assume I've neglected to update) updates it?

Thanks, Tessiturians.

BONUS TRIVIA: John Wayne once won the dog Lassie from its owner in a poker game.

Parents
  • Former Member
    Former Member $organization

    The TR_BATCH_PERIOD table holds the monthly periods that define fiscal years.  Data is required in this table for the Season Overview and some reports, such as Pledge Receivable by Period and Donor FY Giving Summary to function.  The table is populated manually from within Tessitura System Tables and is not updated via standard stored procedures.  You can read more about this table in the System_Tables.doc document.

    Bob


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
    Sent: Thursday, September 10, 2009 4:54 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] TR_BATCH_PERIOD

    I've been told that my TR_BATCH_PERIOD table doesn't have any entries for the current 2010 season and there should be.  Any idea what this table is and what stored procedure (which I assume I've neglected to update) updates it?

    Thanks, Tessiturians.

    BONUS TRIVIA: John Wayne once won the dog Lassie from its owner in a poker game.




    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 TR_BATCH_PERIOD table holds the monthly periods that define fiscal years.  Data is required in this table for the Season Overview and some reports, such as Pledge Receivable by Period and Donor FY Giving Summary to function.  The table is populated manually from within Tessitura System Tables and is not updated via standard stored procedures.  You can read more about this table in the System_Tables.doc document.

    Bob


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
    Sent: Thursday, September 10, 2009 4:54 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] TR_BATCH_PERIOD

    I've been told that my TR_BATCH_PERIOD table doesn't have any entries for the current 2010 season and there should be.  Any idea what this table is and what stored procedure (which I assume I've neglected to update) updates it?

    Thanks, Tessiturians.

    BONUS TRIVIA: John Wayne once won the dog Lassie from its owner in a poker game.




    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