Event Views

Event View: Event

View name: rpt.event

Type: Record

Description: Event Core Information

Field	Data Type
event_id	integer
event_name	text

Event View: Event Profile

View name: rpt.event_profile

Type: Profile

Description: Event Information

Field	Data Type	Notes
event_id	integer	References event_id in rpt.event
event_name	text
event_category_id	integer
event_category	character varying (25)
event_start_timestamp	timestamp without time zone
event_end_timestamp	timestamp without time zone
site_id	integer	References site_id in rpt.site
event_notes	text
event_notes_is_locked	boolean

Event View: Service File Event

View name: rpt.service_file_event

Type: Record

Description: Service File Event

Field	Data Type	Notes
event_id	integer	References event_id in rpt.event
service_file_id	integer	References service_file_id in rpt.service_file
case_service_group_event_id	integer	References case_service_group_event_id in rpt.case_service_group_event
service_file_event_type_id	integer
service_file_event_type	character varying (25)
service_file_event_is_call_to_confirm	boolean
service_file_event_status_id	integer	References service_file_event_status_id in rpt.service_file_event_status
service_file_event_is_follow_up_required	boolean
service_file_event_text_1	text
service_file_event_text_2	text
service_file_event_drop_down_1_id	integer
service_file_event_drop_down_1	character varying (50)
service_file_event_drop_down_2_id	integer
service_file_event_drop_down_2	character varying (50)
service_file_event_checkbox_1	boolean
service_file_event_checkbox_2	boolean
service_file_event_date_1	date
service_file_event_date_2	date
service_file_event_memo_1	text
service_file_event_memo_2	text
service_file_event_cancellation_policy_is_accepted	boolean
service_file_event_is_review_completed	boolean

Event View: Service File Event Status

View name: rpt.service_file_event_status

Type: List

Description: Service File Event Status

Field	Data Type
service_file_event_status_id	integer
service_file_event_status	character varying (25)
case_service_event_status_group	character varying

Event View: Indirect Event

View name: rpt.indirect_event

Type: Record

Description: Indirect Event

Field	Data Type	Notes
event_id	integer	References event_id in rpt.event
indirect_event_type_id	integer
indirect_event_type	character varying (15)

Event View: Informal Series Event

View name: rpt.informal_series_event

Type: Record

Description: Informal Series Event

Field	Data Type	Notes
event_id	integer	References event_id in rpt.event
informal_series_id	integer	References informal_series_id in rpt.informal_series

Event View: Event Attendees

View name: rpt.event_attendees

Type: Cross Reference

Description: Event Attendees

Field	Data Type	Notes
event_id	integer	References event_id in rpt.event
entity_id	integer	References entity_id in rpt.entity
event_attendee_is_show	boolean
event_attendee_is_primary_worker	boolean

Event View: Event Documents

View name: rpt.event_documents

Type: Cross Reference

Description: Event Documents

Field	Data Type	Notes
event_id	integer	References event_id in rpt.event
document_id	integer	References document_id in rpt.document

Event View: Event Service Item

View name: rpt.event_service_item

Type: Record

Description: Service Item Core Information

Field	Data Type	Notes
event_service_item_id	integer
event_service_item_name	character varying (40)
event_id	integer	References event_id in rpt.event
service_unit_id	integer	References service_unit_id in rpt.service_unit
unit_of_measure_id	integer	References unit_of_measure_id in rpt.unit_of_measure
event_service_item_qty	numeric (10, 2)

Event View: Event Service Item Profile

View name: rpt.event_service_item_profile

Type: Profile

Description: Service Item Information

Field	Data Type	Notes
event_service_item_id	integer	References event_service_item_id in rpt.event_service_item
event_service_item_name	character varying (40)
event_id	integer	References event_id in rpt.event
service_unit_id	integer	References service_unit_id in rpt.service_unit
unit_of_measure_id	integer	References unit_of_measure_id in rpt.unit_of_measure
event_service_item_qty	numeric (10, 2)
event_service_item_amt	numeric (10, 2)
event_service_item_total	numeric (10, 2)
event_service_item_is_group_registration	boolean
event_service_item_is_group_service_unit	boolean
return_of_event_service_item_id	integer	References event_service_item_id in rpt.event_service_item

Views and Standard Views