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 |