• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 41 views
  • Users 0 members are here
Related

where to find facility IDs

Robert Martin
$organization

Does anyone know what table contains the Facility id’s ?

 

  • $organization

    T_Facility

     

    facil_no

     

    Marty Jones

    Director of Information Services

     

    Omaha Performing Arts
    1200 Douglas Street

    Omaha, Nebraska 68102

    P 402.661.8469

    Marty.Jones@omahaperformingarts.org

    www.omahaperformingarts.org

    For tickets, call Ticket Omaha at 402.345.0606

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Robert Martin
    Sent: Thursday, November 03, 2011 8:05 AM
    To: Martin A. Jones
    Subject: [Tessitura Technical Forum] where to find facility IDs

     

    Does anyone know what table contains the Facility id’s ?

     




    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!

  • Former Member
    Former Member $organization

    The table is T_FACILITY and the column for the facility ID is facil_no.

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Robert Martin
    Sent: Thursday, November 03, 2011 9:05 AM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] where to find facility IDs

     

    Does anyone know what table contains the Facility id’s ?

     




    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!

  • $organization

    I believe it’s the t_facility table.

     

    Teresa

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Robert Martin
    Sent: Thursday, November 03, 2011 8:05 AM
    To: Teresa Dean
    Subject: [Tessitura Technical Forum] where to find facility IDs

     

    Does anyone know what table contains the Facility id’s ?

     




    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!

  • $organization

    Thanks J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Teresa Dean
    Sent: den 3 november 2011 08:21
    To: Robert Martin
    Subject: RE: [Tessitura Technical Forum] where to find facility IDs

     

    I believe it’s the t_facility table.

     

    Teresa

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Robert Martin
    Sent: Thursday, November 03, 2011 8:05 AM
    To: Teresa Dean
    Subject: [Tessitura Technical Forum] where to find facility IDs

     

    Does anyone know what table contains the Facility id’s ?

     




    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!

  • $organization in reply to Marty Jones

    Did this table move with v.12? I don't seem to have a T_facility table.

     

    Thanks,

    Lauren

  • $organization in reply to Lauren Kelly

    I've never seen this table in Tessitura out of the box. I've only found it by finding it in SQL Server Management Studio and writing a new query to get that data.

     

    Tiffany

  • Former Member
    Former Member $organization

    The T_FACILITY table is not accessible via Tessitura "System Tables" but is an integral table in the Impresario database. The contents of the table are associated with a Housemap and can be viewed in Ticketing Setup > Facility Manager > Facility tab and as Tiffany noted, the contents of the table can be queried in SQL Server Management Studio but should be created and edited if necessary within Facility Manger.

     

    Bob

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Thursday, January 8, 2015 12:29 PM
    To: Robert Bell
    Subject: RE: [Tessitura Technical Forum] where to find facility IDs

     

    I've never seen this table in Tessitura out of the box. I've only found it by finding it in SQL Server Management Studio and writing a new query to get that data.

     

    Tiffany

    From: Lauren Kelly <bounce-laurenkelly5154@tessituranetwork.com>
    Sent: 1/8/2015 10:47:44 AM

    Did this table move with v.12? I don't seem to have a T_facility table.

     

    Thanks,

    Lauren




    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!