Case File View: Case File
View name: rpt.case_file
Type: Record
Description: Case File Core Information
Field | Data Type |
case_file_id | integer |
case_file_name | character varying (35) |
Case File View: Case File Profile
View name: rpt.case_file_profile
Type: Profile
Description: Case File Information
Field | Data Type | Notes |
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 |
|
case_file_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_intake_note | text |
|
Case File View: Case File Documents
View name: rpt.case_file_documents
Type: Cross Reference
Description: Case File Documents
Field | Data Type | Notes |
case_file_id | integer | References case_file_id in rpt.case_file |
document_id | integer | References document_id in rpt.document |
Case File View: Case File Presenting Issues
View name: rpt.case_file_presenting_issues
Type: Cross Reference
Description: Case File Presenting Issues
Field | Data Type | Notes |
case_file_id | integer | References case_file_id in rpt.case_file |
presenting_issue_id | integer | References presenting_issue_id in rpt.presenting_issue |
Case File View: Case File Individuals
View name: rpt.case_file_individuals
Type: Cross Reference
Description: Case File Individuals
Field | Data Type | Notes |
case_file_id | integer | References case_file_id in rpt.case_file |
individual_id | integer | References individual_id in rpt.individual |
case_file_individual_relationship_id | integer |
|
case_file_individual_relationship | character varying (20) |
|
case_file_individual_is_safety_concern | boolean |
|
case_file_individual_is_primary | boolean |
|
Case File View: Case File Referrals
View name: rpt.case_file_referrals
Type: Cross Reference
Description: Case File Referrals
Field | Data Type | Notes |
case_file_id | integer | References case_file_id in rpt.case_file |
referral_id | integer | References referral_id in rpt.referral |