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 |