August 2021 Insights Release Notes

Breaking changes

  • vw_event_rental_allocations - these fields are unused within VenueOps and have been removed:
    • expense_gl_code_id
    • expense_gl_code_name
    • expense_gl_code

Feature-related changes

  • Item-related views have been updated for the new time-bound feature:

    • is_time_bound / time_unit_id / time_unit_name / time_quantity added
    • unit_name is now a "legacy" column
      • if item is time-bound, "Hour" or "Day" will be returned, else unit_name will be returned
      • unit_of_measure column added to always return unit_name
    • has_unit_count now maps to is_time_bound
    • unit_count now maps to time_quantity
  • Many views have columns impacted by the referential data issue:

    • revenue_stream_id
    • revenue_stream_name
    • revenue_stream_type
    • item_name
    • item_code
    • unit_name
    • is_hidden_from_client
    • gl_code_name (rev/exp)
    • gl_code (rev/exp)
    • category_name
    • category_type
    • department_id
    • department_name

New columns

  • vw_packages
    • is_active
  • vw_function_types
    • name
    • room_setup
    • show_on_calendar
    • is_performance
  • vw_inventory_items
    • round_up_quantity
    • round_up_time_quantity
    • is_active
    • default_time_quantity
    • default_unit_count => default_time_quantity
  • vw_event_item_and_rental_allocations
    • function_status_id (for filtering out cancelled functions)
    • function_status_name

New views

  • vw_function_external_ids - one row per function external id (Tessitura performance ids are stored here)
  • vw_event_item_allocation_taxes - one row per item tax
  • vw_event_item_allocation_service_charges - one row per item service charge
  • vw_event_item_allocation_discounts - one row per item discount
  • vw_event_rental_allocation_taxes - one row per rental tax
  • vw_event_rental_allocation_service_charges - one row per rental service charge
  • vw_event_rental_allocation_discounts - one row per rental discount