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 |