Skip to main content
Individual Views

Individual View, Standard Views

Updated over 3 years ago

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

Did this answer your question?