vw_events_by_room
Each row is a room that an event is in.
| Column | Type | Description |
|---|---|---|
| event_id | varchar(64) | System id of the event (in the form event-999-A) |
| is_active | tinyint | Is it active? (That is, not canceled or lost) |
| name | varchar(1024) | Name of the event type |
| start_date | datetime | Start date of the allocation |
| end_date | datetime | End date of the allocation |
| room_id | varchar(64) | Id of the room |
| room_name | varchar(1024) | Name of the room |
| venue_id | varchar(64) | Id of the venue |
| venue_name | varchar(1024) | Name of the venue |
| room_group_name | varchar(1024) | Name of the group that the room is in |
| room_max_capacity | int | Maximum capacity of the room |
| room_square_footage | int | Square footage of the room |
| room_revenue_stream_id | varchar(64) | Id of the revenue stream for the room rental |
| room_revenue_stream_name | varchar(1024) | Name of the revenue stream for the room rental |
| room_revenue_stream_revenue_type | int | Type of the revenue stream for the room rental |
| room_is_active | tinyint | Is the room active? |
| room_is_combo_room | tinyint | Is it a combo room? |
| start_date_time | datetime | Start date/time |
| end_date_time | datetime | End date/time |
| number_of_event_days | bigint | Length of the event in calendar days |
| entire_event_start_date_time | datetime | Start of the entire event |
| entire_event_end_date_time | datetime | End of the entire event |
| event_is_tentative | tinyint | Is the event tentative? |
| event_is_definite | tinyint | Is the event definite? |
| event_is_prospect | tinyint | Is the event a prospect? |
| event_status_name | text | Name of the event status |
| description | text | Description of the event |
| website | varchar(1024) | URL of the event web site |
| event_type_name | varchar(1024) | Type of event |
| business_classification_name | varchar(512) | Business classification |
| event_genre_name | varchar(512) | Name of the event genre |
| unique_number | varchar(1024) | Unique identifier generated by the system for the event. Can be edited by the user. |
| is_internal | tinyint | Is it internal? |
| is_blackout | tinyint | Is it a blackout? |
| decision_date | date | Date that a decision is expected |
| probability_of_closing | int | Percentage chance (1-100) that the sale will close |
| is_canceled | tinyint | Is it canceled? |
| is_lost | tinyint | Is it lost? |
| reason_lost | varchar(1024) | If lost, this is the reason |
| contracting_status_id | int | Contracting status code |
| contracting_status_name | varchar(255) | Contracting status name |
| approved_proposal_id | varchar(64) | Id of the approved proposal |
| active_contract_id | varchar(64) | Id of the active contract |
| estimated_total_attendance | int | Estimated total attendance |
| actual_total_attendance | int | Actual total attendance |
| total_room_nights | int | Total room nights |
| peak_room_nights | int | Peak room nights |
| estimated_rental_revenue | decimal | Estimated revenue from space rental |
| estimated_food_and_beverage_revenue | decimal | Estimated revenue from food and beverage |
| estimated_ancillary_revenue | decimal | Estimated revenue from ancillary services |
| estimated_total_revenue | decimal | Estimated total revenue |
| estimated_rental_cost | decimal | Estimated cost related to space rental |
| estimated_food_and_beverage_cost | decimal | Estimated cost related F&B |
| estimated_ancillary_cost | decimal | Estimated cost related to ancillary services |
| estimated_total_cost | decimal | Estimated total cost |
| economic_impact | decimal | Economic impact (typically for CVB or city) |
| is_finalized | tinyint | Is finalized? |
| actual_rental_revenue | decimal | Actual revenue from space rental |
| actual_food_and_beverage_revenue | decimal | Actual revenue from food and beverage |
| actual_ancillary_revenue | decimal | Actual revenue from ancillary services |
| actual_total_revenue | decimal | Actual total revenue |
| actual_rental_cost | decimal | Actual cost related to space rental |
| actual_food_and_beverage_cost | decimal | Actual cost related to F&B |
| actual_ancillary_cost | decimal | Actual cost related to ancillary services |
| actual_total_cost | decimal | Actual total cost |
| show_name_on_avails | tinyint | Show the event name on avails views? |
| is_hidden | tinyint | Is this event hidden? |
| created_by_id | varchar(64) | Id of the staff member who created it |
| created_by_name | varchar(512) | Name of the staff member who created it |
| created_by_email | varchar(512) | Email address of the staff member who created it |
| booked_by_id | varchar(64) | Id of the staff member who booked it |
| booked_by_name | varchar(512) | Name of the staff member who booked it |
| booked_by_email | varchar(512) | Email address of the staff member who booked it |
| booked_tentative_by_id | varchar(64) | Id of the staff member who booked it as tentative |
| booked_tentative_by_name | varchar(512) | Name of the staff member who booked it as tentative |
| booked_tentative_by_email | varchar(512) | Email address of the staff member who booked it as tentative |
| booked_definite_by_id | varchar(64) | Id of the staff member who booked it as definite |
| booked_definite_by_name | varchar(512) | Name of the staff member who booked it as definite |
| booked_definite_by_email | varchar(512) | Email address of the staff member who booked it as definite |
| lost_by_id | varchar(64) | Id of the staff member who marked it as lost |
| lost_by_name | varchar(512) | Name of the staff member who marked it as lost |
| lost_by_email | varchar(512) | Email address of the staff member who marked it as lost |
| canceled_by_id | varchar(64) | Id of the staff member who canceled it |
| canceled_by_name | varchar(512) | Name of the staff member who canceled it |
| canceled_by_email | varchar(512) | Email address of the staff member who canceled it |
| contract_signed_by_id | varchar(64) | Id of the staff member who changed the contract status to signed |
| contract_signed_by_name | varchar(512) | Name of the staff member who changed the contract status to signed |
| contract_signed_by_email | varchar(512) | Email address of the staff member who changed the contract status to signed |
| created_on | datetime | When it was created |
| booked_on | datetime | When it was booked |
| booked_tentative_on | datetime | When it was booked tentative |
| booked_definite_on | datetime | When it was booked as definite |
| lost_on | datetime | When it was lost |
| canceled_on | datetime | When it was canceled |
| contract_signed_on | datetime | When it was marked as signed |
| account_id | varchar(64) | Id of the account that it belongs to |
| account_name | varchar(1024) | Name of the account that it belongs to |
| account_lead_source | varchar(1024) | Lead source of the account |
| account_market_segment | varchar(1024) | Market segment of the account |
| account_email | varchar(512) | Primary email address of the account |
| account_email_type | varchar(512) | Type of email address |
| account_phone | varchar(512) | Primary phone number of the account |
| account_phone_type | varchar(512) | Type of phone number |
| account_address_street | varchar(1024) | Street address (line 1) of the account |
| account_address_unit | varchar(1024) | Unit address (line 2) of the account |
| account_address_locality | varchar(1024) | Locality (city) of the account |
| account_address_region | varchar(1024) | Region (state/province) of the account |
| account_address_postal_code | varchar(1024) | Postal/zip code of the account |
| account_address_country | varchar(1024) | Country of the account |
| account_description | text | Description of the account |
| account_manager_id | varchar(64) | Id of the staff member who manages the account |
| account_manager_name | varchar(512) | Name of the staff member who manages the account |
| account_manager_email | varchar(512) | Email address of the staff member who manages the account |
| account_created_on | datetime | When the account was created |
| account_is_tax_exempt | tinyint | Is the account tax exempt? |
| account_is_active | tinyint | Is the account active? |
| account_unique_number | varchar(1024) | Unique identifier generated by the system for the credit. Can be edited by the user. |
| account_tax_id | varchar(512) | Tax Id of the account |
| account_secondary_tax_id | varchar(512) | Secondary tax Id of the account |
| account_website | varchar(1024) | Website URL of the account |
| account_parent_id | varchar(64) | Id of this account's parent account |
| account_hierarchy_id | varchar(64) | Id of this hierarchy that t his account belongs to |
| announce_date_time | datetime | When it will be (or was) announced |
| on_sale_date_time | datetime | When tickets go on (or went on) sale |
| live_details_note | text | Note about live performance |
| artist_id | mediumtext | Id of the artist performing |
| artist_name | mediumtext | Name of the artist performing |
| is_rental_outdated | tinyint | Is the rental information outdated? |
| rental_price_schedule_id | varchar(64) | Id of the rental price schedule |
| series_id | varchar(64) | Id of the series that it is part of |
| series_name | varchar(1024) | Name of the series that it is part of |