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 |