Individual Views

Individual View: Individual

View name: rpt.individual

Type: Record

Description: Individual Core Information

Field	Data Type	Notes
individual_id	integer
entity_id	integer	References entity_id in rpt.entity
individual_name	text
site_id	integer	References site_id in rpt.site

Individual View: Individual Profile

View name: rpt.individual_profile

Type: Profile

Description: Individual Detail Information

Field	Data Type	Notes
individual_id	integer	References individual_id in rpt.individual
entity_id	integer	References entity_id in rpt.entity
individual_name	text
site_id	integer	References site_id in rpt.site
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
partner_is_aware	boolean
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
tax_schedule_id	integer	References tax_schedule_id on rpt.tax_schedule
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
individual_date_of_birth	date
individual_first_name	text
individual_last_name	text
individual_middle_initial	text

Individual View: Individual Documents

View name: rpt.individual_documents

Type: Cross Reference

Description: Links Individuals with their completed documents

Field	Data Type	Notes
individual_id	integer	References individual_id in rpt.individual
document_id	integer	References document_id in rpt.document

Individual View: Individual Bluebooks

View name: rpt.individual_bluebooks

Type: Cross Reference

Description: Links Individuals to their Bluebooks

Field	Data Type	Notes
individual_id	integer	References individual_id in rpt.individual
bluebook_id	integer	References bluebook_id in rpt.bluebook

Individual View: Individual Profile

View name: rpt.individual_dss

Type: Record

Description: Individual DSS Information

Field	Data Type	Notes
individual_id	integer	References individual_id in rpt.individual
individual_dss_is_using_pseudonym	boolean
individual_dss_is_birth_date_an_estimate	boolean
individual_dss_consent_to_providing_details	boolean
individual_dss_consent_to_future_contact	boolean
individual_dss_country_of_birth_id	integer
individual_dss_country_of_birth	text
individual_dss_origin_id	integer
individual_dss_origin	text
individual_dss_language_id	integer
individual_dss_language	text
individual_dss_household_composition_id	integer
individual_dss_household_composition	text
individual_dss_main_source_of_income_id	integer
individual_dss_main_source_of_income	text
individual_dss_income_frequency_id	integer
individual_dss_income_frequency	text
individual_dss_approx_income_per_period	integer
individual_dss_homeless_indicator_id	integer
individual_dss_homeless_indicator	text
individual_dss_first_arrival_in_australia	date
individual_dss_migration_visa_category_id	integer
individual_dss_migration_visa_category	text
individual_dss_ancestry_ethnicity_id	integer
individual_dss_ancestry_ethnicity	text
individual_dss_education_level_id	integer
individual_dss_education_level	text
individual_dss_dva_card_status_id	integer
individual_dss_dva_card_status	text
individual_dss_accomodation_type_id	integer
individual_dss_accomodation_type	text
individual_dss_employment_status_id	integer
individual_dss_employment_status	text
individual_dss_ndis_eligibility_id	integer
individual_dss_ndis_eligibility	text
individual_dss_has_carer	boolean
individual_dss_is_client_a_carer	boolean

Individual View: Individual Profile

View name: rpt.individual_dss_disabilities

Type: Record

Description: Individual DSS Disabilities Information

Field	Data Type	Notes
individual_id	integer	References individual_id in rpt.individual
individual_dss_disabilities_id	integer
individual_dss_disabilities	text

Views and Standard Views