Skip to main content
Standard Views | Individual
Updated over 3 years ago

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

Did this answer your question?