Service Views

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

Views and Standard Views