Standard Views: Service File
View name: rpt.std_case_service_file
Description: Basic information for Service Files
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 |
service_name | character varying (80) |
|
service_type_id | integer |
|
service_type | character varying (20) |
|
case_file_id | integer | References case_file_id in rpt.case_file |
case_file_name | character varying (35) |
|
case_file_status_id | integer |
|
case_file_status | character varying (10) |
|
case_file_open_date | date |
|
case_file_close_date | date |
|
case_file_annual_income_amt | numeric (7, 0) |
|
case_file_family_size | integer |
|
sliding_scale_rate | numeric |
|
case_file_no | text |
|
case_file_intake_checkbox_1 | boolean |
|
case_file_intake_checkbox_2 | boolean |
|
case_file_intake_date_1 | date |
|
case_file_intake_date_2 | date |
|
case_file_checkbox_1 | boolean |
|
case_file_checkbox_2 | boolean |
|
case_file_checkbox_3 | boolean |
|
case_file_checkbox_4 | boolean |
|
case_file_checkbox_5 | boolean |
|
case_file_checkbox_6 | boolean |
|
case_file_drop_down_1_id | integer |
|
case_file_drop_down_1 | character varying (20) |
|
case_file_drop_down_2_id | integer |
|
case_file_drop_down_2 | character varying (20) |
|
case_file_drop_down_3_id | integer |
|
case_file_drop_down_3 | character varying (20) |
|
case_file_drop_down_4_id | integer |
|
case_file_drop_down_4 | character varying (55) |
|
case_file_drop_down_5_id | integer |
|
case_file_drop_down_5 | character varying (50) |
|
case_file_drop_down_6_id | integer |
|
case_file_drop_down_6 | character varying (50) |
|
case_file_date_1 | date |
|
case_file_date_2 | date |
|
case_file_date_3 | date |
|
case_file_text_1 | text |
|
case_file_text_2 | text |
|
case_file_text_3 | text |
|
case_file_memo_1 | text |
|
case_file_memo_2 | text |
|
case_file_presenting_issue_1_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_1_name | text |
|
case_file_presenting_issue_2_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_2_name | text |
|
case_file_presenting_issue_3_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_3_name | text |
|
case_file_presenting_issue_4_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_4_name | text |
|
case_file_presenting_issue_5_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_5_name | text |
|
case_file_primary_indivdual_id | integer | References individual_id in rpt.individual |
case_file_primary_individual_entity_id | integer | References entity_id in rpt.entity |
case_file_primary_individual_name | text |
|
case_file_primary_individual_site_id | integer | References site_id in rpt.site |
case_file_primary_individual_site_name | character varying (30) |
|
case_service_group_id | integer | References case_service_group_id in rpt.case_service_group |
case_service_group_name | character varying (50) |
|
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 |
|
primary_worker_id | integer | References worker_id in rpt.worker |
primary_worker_entity_id | integer | References entity_id in rpt.entity |
primary_worker_name | text |
|
primary_worker_title | character varying (50) |
|
primary_worker_qualification_id | integer |
|
primary_worker_qualification | character varying (50) |
|
primary_worker_site_id | integer | References site_id in rpt.site |
primary_worker_site_name | character varying (30) |
|
service_file_presenting_indivdual_id | integer | References individual_id in rpt.individual |
service_file_presenting_individual_entity_id | integer | References entity_id in rpt.entity |
service_file_presenting_individual_name | text |
|
service_file_presenting_individual_site_id | integer | References site_id in rpt.site |
service_file_presenting_individual_site_name | character varying (30) |
|
service_file_presenting_individual_drop_down_1_id | integer |
|
service_file_presenting_individual_drop_down_1 | text |
|
service_file_presenting_individual_drop_down_2_id | integer |
|
service_file_presenting_individual_drop_down_2 | text |
|
service_file_presenting_individual_checkbox_1 | boolean |
|
service_file_presenting_individual_checkbox_2 | boolean |
|
service_file_presenting_individual_presenting_issues_1_id | integer |
|
service_file_presenting_individual_presenting_issues_1_name | text |
|
service_file_presenting_individual_presenting_issues_2_id | integer |
|
service_file_presenting_individual_presenting_issues_2_name | text |
|
service_file_presenting_individual_presenting_issues_3_id | integer |
|
service_file_presenting_individual_presenting_issues_3_name | text |
|
Standard Views: Service File Individuals
View name: rpt.std_case_service_file_individuals
Description: Basic information for Service File Participants
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 |
service_name | character varying (80) |
|
service_type_id | integer |
|
service_type | character varying (20) |
|
case_file_id | integer | References case_file_id in rpt.case_file |
case_file_name | character varying (35) |
|
case_file_status_id | integer |
|
case_file_status | character varying (10) |
|
case_file_open_date | date |
|
case_file_close_date | date |
|
case_file_annual_income_amt | numeric (7, 0) |
|
case_file_family_size | integer |
|
sliding_scale_rate | numeric |
|
case_file_no | text |
|
case_file_intake_checkbox_1 | boolean |
|
case_file_intake_checkbox_2 | boolean |
|
case_file_intake_date_1 | date |
|
case_file_intake_date_2 | date |
|
case_file_checkbox_1 | boolean |
|
case_file_checkbox_2 | boolean |
|
case_file_checkbox_3 | boolean |
|
case_file_checkbox_4 | boolean |
|
case_file_checkbox_5 | boolean |
|
case_file_checkbox_6 | boolean |
|
case_file_drop_down_1_id | integer |
|
case_file_drop_down_1 | character varying (20) |
|
case_file_drop_down_2_id | integer |
|
case_file_drop_down_2 | character varying (20) |
|
case_file_drop_down_3_id | integer |
|
case_file_drop_down_3 | character varying (20) |
|
case_file_drop_down_4_id | integer |
|
case_file_drop_down_4 | character varying (55) |
|
case_file_drop_down_5_id | integer |
|
case_file_drop_down_5 | character varying (50) |
|
case_file_drop_down_6_id | integer |
|
case_file_drop_down_6 | character varying (50) |
|
case_file_date_1 | date |
|
case_file_date_2 | date |
|
case_file_date_3 | date |
|
case_file_text_1 | text |
|
case_file_text_2 | text |
|
case_file_text_3 | text |
|
case_file_memo_1 | text |
|
case_file_memo_2 | text |
|
case_file_presenting_issue_1_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_1_name | text |
|
case_file_presenting_issue_2_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_2_name | text |
|
case_file_presenting_issue_3_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_3_name | text |
|
case_file_presenting_issue_4_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_4_name | text |
|
case_file_presenting_issue_5_id | integer | References presenting_issue_id in rpt.presenting_issue |
case_file_presenting_issue_5_name | text |
|
case_service_group_id | integer | References case_service_group_id in rpt.case_service_group |
case_service_group_name | character varying (50) |
|
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 |
|
primary_worker_id | integer | References worker_id in rpt.worker |
primary_worker_entity_id | integer | References entity_id in rpt.entity |
primary_worker_name | text |
|
primary_worker_title | character varying (50) |
|
primary_worker_qualification_id | integer |
|
primary_worker_qualification | character varying (50) |
|
primary_worker_site_id | integer | References site_id in rpt.site |
primary_worker_site_name | character varying (30) |
|
individual_id | integer | References individual_id in rpt.individual |
individual_entity_id | integer | References entity_id in rpt.entity |
individual_name | text |
|
individual_site_id | integer | References site_id in rpt.site |
individual_site_name | character varying (30) |
|
individual_title_id | integer |
|
individual_title | character varying (20) |
|
individual_gender_id | integer |
|
individual_gender | character varying (15) |
|
individual_year_of_birth | integer |
|
individual_language_id | integer |
|
individual_language | character varying (30) |
|
individual_record_drop_down_id | integer |
|
individual_record_drop_down | character varying (40) |
|
individual_notes | text |
|
individual_partner_is_aware | boolean |
|
individual_home_is_aware | boolean |
|
individual_is_safety_concern | boolean |
|
individual_safety_concern_text | text |
|
individual_is_financial_concern | boolean |
|
individual_financial_concern_text | text |
|
individual_speaks_english | boolean |
|
individual_tax_schedule_id | integer |
|
indivdual_tax_schedule_name | character varying (30) |
|
individual_tax_schedule_short_name | character varying (4) |
|
individual_user_defined_country_id | integer |
|
individual_user_defined_country | character varying (30) |
|
individual_text_1 | text |
|
individual_text_2 | text |
|
individual_text_3 | text |
|
individual_text_4 | text |
|
individual_text_5 | text |
|
individual_text_6 | text |
|
individual_text_7 | text |
|
individual_text_8 | text |
|
individual_drop_down_1_id | integer |
|
individual_drop_down_1 | character varying (50) |
|
individual_drop_down_2_id | integer |
|
individual_drop_down_2 | character varying (50) |
|
individual_drop_down_3_id | integer |
|
individual_drop_down_3 | character varying (50) |
|
individual_drop_down_4_id | integer |
|
individual_drop_down_4 | character varying (50) |
|
individual_drop_down_5_id | integer |
|
individual_drop_down_5 | character varying (50) |
|
individual_drop_down_6_id | integer |
|
individual_drop_down_6 | character varying (50) |
|
individual_drop_down_7_id | integer |
|
individual_drop_down_7 | character varying (25) |
|
individual_drop_down_8_id | integer |
|
individual_drop_down_8 | character varying (20) |
|
individual_drop_down_9_id | integer |
|
individual_drop_down_9 | character varying (20) |
|
individual_drop_down_10_id | integer |
|
individual_drop_down_10 | character varying (20) |
|
individual_drop_down_11_id | integer |
|
individual_drop_down_11 | character varying (30) |
|
individual_drop_down_12_id | integer |
|
individual_drop_down_12 | character varying (20) |
|
individual_checkbox_1 | boolean |
|
individual_checkbox_2 | boolean |
|
individual_checkbox_3 | boolean |
|
individual_checkbox_4 | boolean |
|
individual_checkbox_5 | boolean |
|
individual_date_1 | date |
|
individual_date_2 | date |
|
individual_date_3 | date |
|
individual_date_4 | date |
|
individual_date_5 | date |
|
individual_memo_1 | text |
|
individual_memo_2 | text |
|
case_file_individual_relationship_id | integer |
|
case_file_individual_relationship | character varying (20) |
|
case_file_individual_is_primary | boolean |
|
service_file_individual_is_presenting | boolean |
|
service_file_individual_drop_down_1_id | integer |
|
service_file_individual_drop_down_1 | text |
|
service_file_individual_drop_down_2_id | integer |
|
service_file_individual_drop_down_2 | text |
|
service_file_individual_checkbox_1 | boolean |
|
service_file_individual_checkbox_2 | boolean |
|
service_file_individual_presenting_issues_1_id | integer | References presenting_issue_id in rpt.presenting_issue |
service_file_individual_presenting_issues_1_name | text |
|
service_file_individual_presenting_issues_2_id | integer | References presenting_issue_id in rpt.presenting_issue |
service_file_individual_presenting_issues_2_name | text |
|
service_file_individual_presenting_issues_3_id | integer | References presenting_issue_id in rpt.presenting_issue |
service_file_individual_presenting_issues_3_name | text |
|