• Replies 23 replies
  • Subscribers 231 subscribers
  • Views 266 views
  • Users 0 members are here
Options
Related

Performance Verification Report

Mark Levine
$organization

I posted this in a different group here but someone suggested I post it in this discussion group too.

Does anyone out there have a good VERIFICATION report for checking your performances? I've used a variety of ticketing systems in the past and always had to struggle with checking that I got everything just right. I've built this in sql and reporting clients in the past for other systems, but I'm new to being a Tessitura client.

Parents
  • $organization

    I got this from someone in the forums years ago.  See if it helps.  I drop it into Excel and sort away.

    ---- To give you a list of performances in a certain season, the p. types attached
    ---- GL code, campaign and ticket design on a price zone level
    ---- very detailed. Replace ### with season ID.

    select c.perf_code,
    f.description as title,
    c.perf_dt,
    d.description as pt_desc,
    b.description as pmap_desc,
    h.description as zone_desc,
    g.price,
    k.description as tkt_design,
    b.gl_hold_no,
    e.description as campaign
    from VXB_PERF_PMAP a
    join t_design k on a.design_no=k.design_no
    join VB_PMAP b on a.pmap_no=b.pmap_no
    join t_perf c on a.perf_no=c.perf_no
    join tr_price_type d on a.price_type=d.id
    join FT_GET_PRICES (getdate()) g on d.id = g.perf_price_type
    join t_zone h on g.zone_no=h.zone_no
    join t_campaign e on c.campaign_no=e.campaign_no
    join t_inventory f on c.perf_no=f.inv_no
    where c.season = ###

Reply
  • $organization

    I got this from someone in the forums years ago.  See if it helps.  I drop it into Excel and sort away.

    ---- To give you a list of performances in a certain season, the p. types attached
    ---- GL code, campaign and ticket design on a price zone level
    ---- very detailed. Replace ### with season ID.

    select c.perf_code,
    f.description as title,
    c.perf_dt,
    d.description as pt_desc,
    b.description as pmap_desc,
    h.description as zone_desc,
    g.price,
    k.description as tkt_design,
    b.gl_hold_no,
    e.description as campaign
    from VXB_PERF_PMAP a
    join t_design k on a.design_no=k.design_no
    join VB_PMAP b on a.pmap_no=b.pmap_no
    join t_perf c on a.perf_no=c.perf_no
    join tr_price_type d on a.price_type=d.id
    join FT_GET_PRICES (getdate()) g on d.id = g.perf_price_type
    join t_zone h on g.zone_no=h.zone_no
    join t_campaign e on c.campaign_no=e.campaign_no
    join t_inventory f on c.perf_no=f.inv_no
    where c.season = ###

Children