Standard Views | Individual

View name: rpt.std_individual

Description: Individual Profile information with Site and Tax Schedule Names.

Field	Data Type	Notes
individual_id	integer	References individual_id in rpt.individual
individual_entity_id	integer	References entity_id in rpt.entity
individual_name	text
individual_site_id	integer	Refences site_id in rpt.site
individual_site_name	character varying
individual_title_id	integer
individual_title	character varying
individual_gender_id	integer
individual_gender	character varying
individual_year_of_birth	integer
individual_language_id	integer
individual_language	character varying
individual_record_drop_down_id	integer
individual_record_drop_down	character varying
individual_notes	text
individual_partner_is_aware	boolean
individual_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
individual_tax_schedule_id	integer	References tax_schedule_id in rpt.tax_schedule
indivdual_tax_schedule_name	character varying
individual_tax_schedule_short_name	character varying
individual_user_defined_country_id	integer
individual_user_defined_country	character varying
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
individual_drop_down_2_id	integer
individual_drop_down_2	character varying
individual_drop_down_3_id	integer
individual_drop_down_3	character varying
individual_drop_down_4_id	integer
individual_drop_down_4	character varying
individual_drop_down_5_id	integer
individual_drop_down_5	character varying
individual_drop_down_6_id	integer
individual_drop_down_6	character varying
individual_drop_down_7_id	integer
individual_drop_down_7	character varying
individual_drop_down_8_id	integer
individual_drop_down_8	character varying
individual_drop_down_9_id	integer
individual_drop_down_9	character varying
individual_drop_down_10_id	integer
individual_drop_down_10	character varying
individual_drop_down_11_id	integer
individual_drop_down_11	character varying
individual_drop_down_12_id	integer
individual_drop_down_12	character varying
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

Views and Standard Views