Case File Views

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

Views and Standard Views