Service File Views

Service File View: Service File

View name: rpt.service_file

Type: Record

Description: Service File Core Information

Field	Data Type	Notes
service_file_id	integer
service_id	integer	References service_id in rpt.service
case_file_id	integer	References case_file_id in rpt.case_file
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group

Service File View: Service File Profile

View name: rpt.service_file_profile

Type: Profile

Description: Service File Information

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
service_id	integer	References service_id in rpt.service
case_file_id	integer	References case_file_id in rpt.case_file
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group
service_file_status_id	integer
service_file_status	character varying (20)
service_file_start_date	date
service_file_end_date	date
service_file_estimated_sessions	integer
service_file_text_1	text
service_file_text_2	text
service_file_drop_down_1_id	integer
service_file_drop_down_1	character varying (50)
service_file_drop_down_2_id	integer
service_file_drop_down_2	character varying (50)
service_file_checkbox_1	boolean
service_file_checkbox_2	boolean
service_file_date_1	date
service_file_date_2	date
service_file_memo_1	text
service_file_memo_2	text
service_file_close_reason_id	integer
service_file_close_reason	text
service_file_close_notes	text

Service File View: Service File Note

View name: rpt.service_file_note

Type: Record

Description: Service File Note Information

Field	Data Type	Notes
service_file_note_id	integer
service_file_id	integer	References service_file_id in rpt.service_file
service_file_note_title	text
service_file_note_is_locked	boolean
service_file_note_date	date
worker_id	integer	References worker_id in rpt.worker
service_file_note	text

Service File View: Service File Workers

View name: rpt.service_file_workers

Type: Cross Reference

Description: Service File Workers

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
worker_id	integer	References worker_id in rpt.worker
service_file_worker_is_primary	boolean
service_file_worker_is_attending	boolean

Service File View: Service File Individuals

View name: rpt.service_file_individuals

Type: Cross Reference

Description: Service File Individuals

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
individual_id	integer	References individual_id in rpt.individual
service_file_individual_is_presenting	boolean
service_file_individual_drop_down_1_id	integer
asservice_file_individual_drop_down_1	text
service_file_individual_drop_down_2_id	integer
asservice_file_individual_drop_down_2	text
service_file_individual_checkbox_1	boolean
service_file_individual_checkbox_2	boolean

Service File View: Service File Individual Presenting Issues

View name: rpt.service_file_individual_presenting_issues

Type: List

Description: Service File Individual Presenting Issues

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
individual_id	integer	References individual_id in rpt.individual
presenting_issue_id	integer	References presenting_issue_id in rpt.presenting_issues

Service File View: Service File Bluebooks

View name: rpt.service_file_bluebooks

Type: Cross Reference

Description: Service File Collateral Contacts

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
bluebook_id	integer	References bluebook_id in rpt.bluebook

Service File View: Service File Documents

View name: rpt.service_file_documents

Type: Cross Reference

Description: Service File Documents

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
document_id	integer	References document_id in rpt.document

Service File View: Service File Referrals

View name: rpt.service_file_referrals

Type: Cross Reference

Description: Service File Referrals

Field	Data Type	Notes
service_file_id	integer	References service_file_id in rpt.service_file
referral_id	integer	References referral_id in rpt.referral

Views and Standard Views