Service Views
Updated over a week ago

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

Did this answer your question?