vw_event_instructions

A row per instruction on the event.

Column	Type	Description
event_details_instruction_id	varchar(64)	Primary Key: System Id of the event instruction
function_id	varchar(64)	Id of the function
event_id	varchar(64)	Id of the event
start_date_time	datetime	Start date/time
end_date_time	datetime	End date/time
title	varchar(1024)	Job title of the contact
description	text	Description of the event
instruction_set_id	varchar(64)	Id of the instruction set
instruction_set_name	varchar(1024)	Name of the instruction set
instruction_set_sort_order	int	Used to sort
event_details_id	varchar(64)	Id of the event detail record
event_details_is_rental_outdated	tinyint	Is the rental information out of date?
event_details_rental_price_schedule_id	varchar(64)	Id of the rental price schedule
category_id	varchar(64)	Id of the category
category_name	varchar(1024)	Name of the category
category_type	int	Id of the category type
category_revenue_stream_id	varchar(64)	Id of the revenue stream assigned to the category
category_revenue_stream_name	varchar(1024)	Name of the revenue stream assigned to the category
category_revenue_stream_revenue_type	int	Type of the revenue stream assigned to the category
category_is_active	tinyint	Is the category active? (Not archived)
department_id	varchar(64)	Id of the department associated with this category
department_name	varchar(1024)	Name of the department
department_is_active	tinyint	Is the department active?
function_name	varchar(1024)	Name of the function
function_start_date_time	datetime	Start of the function
function_end_date_time	datetime	End of the function
function_is_all_day	tinyint	Is the function all day?
function_number_of_hours	decimal	Length (in hours) of the function
function_room_setup	varchar(1024)	Room setup of the function (In the Round, etc.)
function_agreed_attendance	int	Agreed attendance of the function
function_guaranteed_attendance	int	Guaranteed attendance of the function
function_expected_attendance	int	Expected attendance of the function
function_show_on_calendar	tinyint	Show the function on the calendar?
function_is_performance	tinyint	Is this a live entertainment performance function?
function_is_invoiced	tinyint	Has this function been invoiced?
function_status_id	int	Id of the function status
function_status_name	varchar(255)	Name of the function status
function_type_id	varchar(64)	Id of the type for this function
function_type_name	varchar(512)	Name of the type for this function
event_name	varchar(1024)	Name of the event
is_event_wide	tinyint	Is this an event-wide function?
is_general_instruction	int	Is this a general instruction?
start_time	datetime	Start time of the booked space
end_time	datetime	End time of the booked space