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 |
Comments
0 comments
Please sign in to leave a comment.