Service View: Service
View name: rpt.service
Type: Record
Description: Service Core Information
Field | Data Type |
service_id | integer |
service_name | character varying(80) |
service_type_id | integer |
service_type | character varying(20) |
Service View: Service Profile
View name: rpt.service_profile
Type: Profile
Description: Service Detail Information
Field | Data Type | Notes |
service_id | integer | References service_id in rpt.service |
service_name | character varying(80) |
|
service_type_id | integer |
|
service_type | character varying(20) |
|
service_start_date | date |
|
service_end_date | date |
|
service_is_active | boolean |
|
service_notes | text |
|
agency_service_type_1_id | integer |
|
agency_service_type_1 | character varying(70) |
|
agency_service_type_2_id | integer |
|
agency_service_type_2 | character varying(70) |
|
agency_service_type_3_id | integer |
|
agency_service_type_3 | character varying(70) |
|
agency_service_type_4_id | integer |
|
agency_service_type_4 | character varying(70) |
|
Service View: Case Service Profile
View name: rpt.case_service_profile
Type: Profile
Description: Case Service Detail Information
Field | Data Type | Notes |
service_id | integer | References service_id in rpt.service |
case_service_is_eap | boolean |
|
case_service_class_id | integer |
|
case_service_class | character varying |
|
Service View: Service Documents
View name: rpt.service_documents
Type: Cross Reference
Description: Service Documents
Field | Data Type | Notes |
service_id | integer | References service_id in rpt.service |
document_id | integer | References document_id in rpt.document |