Group Views

Group View: Case Service Group

View name: rpt.case_service_group

Type: Record

Description: Group Core Information

Field	Data Type	Notes
case_service_group_id	integer
case_service_group_name	character varying (50)

Group View: Case Service Group Profile

View name: rpt.case_service_group_profile

Type: Profile

Description: Group Information

Field	Data Type	Notes
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group
case_service_group_name	character varying (50)
service_id	integer	References service_id in rpt.service
site_id	integer	References site_id in rpt.site
case_service_group_status_id	integer
case_service_group_status	character varying (30)
case_service_group_type_is_continuous	boolean
case_service_group_notes	text

Group View: Case Service Group Documents

View name: rpt.case_service_group_documents

Type: Cross Reference

Description: Group Documents

Field	Data Type	Notes
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group
document_id	integer	References document_id in rpt.document

Group View: Case Service Group Workers

View name: rpt.case_service_group_workers

Type: Cross Reference

Description: Group Workers

Field	Data Type	Notes
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group
worker_id	integer	References worker_id in rpt.worker
case_service_group_worker_is_active	boolean
case_service_group_worker_start_date	date
case_service_group_worker_end_date	date
case_service_group_worker_is_primary	boolean

Group View: Case Service Group Event

View name: rpt.case_service_group_event

Type: Record

Description: Group Event

Field	Data Type	Notes
case_service_group_event_id	integer
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group
case_service_group_event_start_timestamp	timestamp without time zone
case_service_group_event_end_timestamp	timestamp without time zone
site_id	integer
attendance_limit	integer
case_service_group_event_notes	text

Group View: Case Service Group Event Workers

View name: rpt.case_service_group_event_workers

Type: Cross Reference

Description: Group Event Workers

Field	Data Type	Notes
case_service_group_event_id	integer	References case_service_group_event_id in rpt.case_service_group_event
worker_id	integer	References worker_id in rpt.worker
case_service_group_event_worker_is_primary	boolean
case_service_group_event_worker_is_attending	boolean

Group View: Case Service Group Event Documents

View name: rpt.case_service_group_event_documents

Type: Cross Reference

Description: Group Event Documents

Field	Data Type	Notes
case_service_group_event_id	integer	References case_service_group_event_id in rpt.case_service_group_event
document_id	integer	References document_id in rpt.document

Views and Standard Views