• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 47 views
  • Users 0 members are here
Related

T_PERF.sales_version

Former Member
Former Member $organization

I can't find any reference to this in documentation.  Can anyone tell me what logic populates T_PERF.sales_version?

I had never really noticed the column before, but in V12 testing, a user noted that the Ticket Sales by Period report will not run in Price Type Category mode if the report includes sales_version values < 12.

Looking at all of our  T_PERF records, I can't find anything obvious for when this value gets populated. I seek enlightenment oh wise message board!

- Levi

Parents
  • $organization

    Another note here that the same restriction exists in Performance Transaction Detail as well.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Paul Kappel
    Sent: Tuesday, June 3, 2014 2:02 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] T_PERF.sales_version

     

    Hi Levi,

    I believe that the sales_version column is populated during data migration to indicate what version of Tess was used to set up the performance originally to indicate if you can continue to join on TX_PERF_PMAP

    From: Levi Sauerbrei <bounce-levisauerbrei7046@tessituranetwork.com>
    Sent: 6/3/2014 12:46:54 PM

    I can't find any reference to this in documentation.  Can anyone tell me what logic populates T_PERF.sales_version?

    I had never really noticed the column before, but in V12 testing, a user noted that the Ticket Sales by Period report will not run in Price Type Category mode if the report includes sales_version values < 12.

    Looking at all of our  T_PERF records, I can't find anything obvious for when this value gets populated. I seek enlightenment oh wise message board!

    - Levi




    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
  • $organization

    Another note here that the same restriction exists in Performance Transaction Detail as well.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Paul Kappel
    Sent: Tuesday, June 3, 2014 2:02 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] T_PERF.sales_version

     

    Hi Levi,

    I believe that the sales_version column is populated during data migration to indicate what version of Tess was used to set up the performance originally to indicate if you can continue to join on TX_PERF_PMAP

    From: Levi Sauerbrei <bounce-levisauerbrei7046@tessituranetwork.com>
    Sent: 6/3/2014 12:46:54 PM

    I can't find any reference to this in documentation.  Can anyone tell me what logic populates T_PERF.sales_version?

    I had never really noticed the column before, but in V12 testing, a user noted that the Ticket Sales by Period report will not run in Price Type Category mode if the report includes sales_version values < 12.

    Looking at all of our  T_PERF records, I can't find anything obvious for when this value gets populated. I seek enlightenment oh wise message board!

    - Levi




    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