VenueOps Database Specifics

Best Practices

• Make sure each report is parameterized, so it avoids reading all of the records in the database.
• Only reference the columns you need, avoid selecting * (All Columns)
• Avoid Excessive joins
• Currency - use C2 formatting

Events

• Whenever possible, use vw_events_lite instead of vw_events 
• Use vw_events when you need any of the following: 
  • number_of_event_days
    room_ids
    room_names
    venue_ids
    venue_names

---

Status (will be one of these)

• is_prospect (some views have event_is_prospect)
• is_tentative (some views have event_is_tentative)
• is_definite (some views have event_is_definite)

---

booked_status_id:

• 0 - Tentative
• 1 - Definite
• 2 - Prospect

---

is_active

Generally use is_active = true (which is equivalent to not cancelled and not lost) for filtering reports