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 |