Officer reports (Last updated Aug. 16, 2017)

Governing and growing your local group is made much lighter work when you have access to the data you need, when you need it.

As an addendum to the roles-based tools and reporting we debuted with the new Association Management System, below you'll find a description of each report the National Office provides online, including the column headers and data types for CSV-formatted reports.

View Officer Reports

Note: Local Secretaries can designate the recipients of these reports by initiating an officer transition through our Local Group Services Manager or by calling the National Office.

Report definitions

Local Group Lapsed Membership

This report contains contact information for former members who have let their memberships lapse.

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • adr_carrier_route nvarchar(10)
    The USPS's carrier route identifier for the individual's primary mailing address. Carrier routes are unique identifiers for mailing routes or neighborhoods. This is used when generating mailing barcodes.
  • adr_delivery_point_code varchar(10)
    The USPS's delivery point code for the individual's primary mailing address. Delivery points are a single mailbox or other place at which mail is delivered. This is used when generating mailing barcodes.
  • adr_bar_code nvarchar(50)
    The data required to generate a USPS postnet mail barcode for the individual's primary mailing address.
  • adr_imbc_characters nvarchar(65)
    The data required to generate a USPS intelligent mail barcode for the individual's primary mailing address.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • since_date datetime
    The individual's continuous membership since date.
  • expire_date nvarchar(4)
    The individual's year of their current membership's expiration date.

Local Group Member Count by Rank

This report lists every local groups sorted by the number of active members in each.

Filetype: PDF

Local Group Member Demographics

This report lists the different generational groups for a local group and the self-reported gender statistics in each generation group.

Filetype: PDF

Local Group Members Anniversaries CSV

This report lists the members of the local group, their since date, and the number of years they have been a consecutive member. Automatically sorted to begin at the current month and wrap around.

Filetype: CSV

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • member_since_date datetime
    The individual's continuous membership since date.
  • member_since_month nvarchar(12)
    The name of the month corresponding to the individual's membership since date. Example: June
  • member_since_year_count int
    The number of years of continuous membership based on the individual's membership since date.

Local Group Members Birthdays CSV

This report lists the members of the local group and their birth month and day. Automatically sorted to begin at the current month and wrap around.

Filetype: CSV

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • birth_date nvarchar(15)
    The individual's month and day portion of their birthdate. Examples: Jun-02, Oct-17

Local Group Members Leaving Group

This report lists the members of the local group that have left the local group between the Start Date and End Date of the report. The leaving_status column indicates how they left the local group. The member_years column will be populated, if the member is deceased, with how many consecutive years they were a member.

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • adr_carrier_route nvarchar(10)
    The USPS's carrier route identifier for the individual's primary mailing address. Carrier routes are unique identifiers for mailing routes or neighborhoods. This is used when generating mailing barcodes.
  • adr_delivery_point_code varchar(10)
    The USPS's delivery point code for the individual's primary mailing address. Delivery points are a single mailbox or other place at which mail is delivered. This is used when generating mailing barcodes.
  • adr_bar_code nvarchar(50)
    The data required to generate a USPS postnet mail barcode for the individual's primary mailing address.
  • adr_imbc_characters nvarchar(65)
    The data required to generate a USPS intelligent mail barcode for the individual's primary mailing address.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • since_date datetime
    The individual's continuous membership since date.
  • expire_date nvarchar(4)
    The individual's year of their current membership's expiration date.
  • member_type nvarchar(50)
    The individual's current membership type. Examples: Annual Mensa Membership, 5 Year Membership, Life Membership
  • leaving_status nvarchar(10)
    A short description of how the individiaul left the group. Examples: MoveOut, Deceased
  • member_years int
    The number of consecutive years the individual maintained membership, if the member is deceased.

Local Group Members New To Group

This report lists the members who are new to the local group between the Start Date and End Date of the report. The new_status column indicates how they became a new member to the local group.

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • adr_carrier_route nvarchar(10)
    The USPS's carrier route identifier for the individual's primary mailing address. Carrier routes are unique identifiers for mailing routes or neighborhoods. This is used when generating mailing barcodes.
  • adr_delivery_point_code varchar(10)
    The USPS's delivery point code for the individual's primary mailing address. Delivery points are a single mailbox or other place at which mail is delivered. This is used when generating mailing barcodes.
  • adr_bar_code nvarchar(50)
    The data required to generate a USPS postnet mail barcode for the individual's primary mailing address.
  • adr_imbc_characters nvarchar(65)
    The data required to generate a USPS intelligent mail barcode for the individual's primary mailing address.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • since_date datetime
    The individual's continuous membership since date.
  • expire_date nvarchar(4)
    The individual's year of their current membership's expiration date.
  • member_type nvarchar(50)
    The individual's current membership type. Examples: Annual Mensa Membership, 5 Year Membership, Life Membership
  • new_status nvarchar(10)
    A short description of how the individiaul joined the group. Examples: MoveIn, Joined, Rejoin

Local Group Membership Roster

This report lists all of the members for a local group and their contact information.

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • adr_carrier_route nvarchar(10)
    The USPS's carrier route identifier for the individual's primary mailing address. Carrier routes are unique identifiers for mailing routes or neighborhoods. This is used when generating mailing barcodes.
  • adr_delivery_point_code varchar(10)
    The USPS's delivery point code for the individual's primary mailing address. Delivery points are a single mailbox or other place at which mail is delivered. This is used when generating mailing barcodes.
  • adr_bar_code nvarchar(50)
    The data required to generate a USPS postnet mail barcode for the individual's primary mailing address.
  • adr_imbc_characters nvarchar(65)
    The data required to generate a USPS intelligent mail barcode for the individual's primary mailing address.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • since_date datetime
    The individual's continuous membership since date.
  • expire_date nvarchar(4)
    The individual's year of their current membership's expiration date.
  • member_type nvarchar(50)
    The individual's current membership type. Examples: Annual Mensa Membership, 5 Year Membership, Life Membership

Local Group Membership Youth Members

This report lists all of the members of the local group that are under the age of 18 grouped into the following categories: '6 and under,' '7-10,' '11-14', and '15-17.'

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • adr_carrier_route nvarchar(10)
    The USPS's carrier route identifier for the individual's primary mailing address. Carrier routes are unique identifiers for mailing routes or neighborhoods. This is used when generating mailing barcodes.
  • adr_delivery_point_code varchar(10)
    The USPS's delivery point code for the individual's primary mailing address. Delivery points are a single mailbox or other place at which mail is delivered. This is used when generating mailing barcodes.
  • adr_bar_code nvarchar(50)
    The data required to generate a USPS postnet mail barcode for the individual's primary mailing address.
  • adr_imbc_characters nvarchar(65)
    The data required to generate a USPS intelligent mail barcode for the individual's primary mailing address.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • since_date datetime
    The individual's continuous membership since date.
  • expire_date nvarchar(4)
    The individual's year of their current membership's expiration date.
  • member_type nvarchar(50)
    The individual's current membership type. Examples: Annual Mensa Membership, 5 Year Membership, Life Membership
  • ind_dob datetime
    The individual's date of birth. Example: 5/15/2006
  • ind_age_string int
    The individual's age.

Local Group Newsletter Distribution

This report lists all of the members for a local group and their contact information filtered by their Distribution Preference. The Email Your Members tool uses this report as its data source.

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • adr_carrier_route nvarchar(10)
    The USPS's carrier route identifier for the individual's primary mailing address. Carrier routes are unique identifiers for mailing routes or neighborhoods. This is used when generating mailing barcodes.
  • adr_delivery_point_code varchar(10)
    The USPS's delivery point code for the individual's primary mailing address. Delivery points are a single mailbox or other place at which mail is delivered. This is used when generating mailing barcodes.
  • adr_bar_code nvarchar(50)
    The data required to generate a USPS postnet mail barcode for the individual's primary mailing address.
  • adr_imbc_characters nvarchar(65)
    The data required to generate a USPS intelligent mail barcode for the individual's primary mailing address.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • since_date datetime
    The individual's continuous membership since date.
  • expire_date nvarchar(4)
    The individual's year of their current membership's expiration date.
  • member_type nvarchar(50)
    The individual's current membership type. Examples: Annual Mensa Membership, 5 Year Membership, Life Membership
  • chapter_newsletter_preference nvarchar(10)
    The individual's local group newsletter delivery preference. Examples: Print, Electronic

Local Group Offers of Membership

This report lists the members who have been offered membership between the Start Date and End Date of the report.

Filetype: PDF, CSV, Avery Label

Local Group Officer Demographics

This report lists the different generation groups for the officers of a local group and the self-reported gender statistics in each generation group.

Filetype: PDF

Local Group Officer Listing

This report lists the different officers of a local group, their contact information, when they started the position, and if they are currently a member or not.

Filetype: PDF

Local Group Proctor Listing

This report lists the proctors, proctors in training, and past proctors of a local group; their contact information; and when they last proctored a test.

Filetype: PDF

Local Group Prospective Members

This report lists all of the prospective members for a local group, their contact information, how they became a prospect, and what tests (if any) they have taken. The Prospect Management tool uses this report as its data source.

Filetype: PDF, CSV, Avery Label

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that identifies whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • bad_address_reason nvarchar(30)
    The reason that an individual's address is marked bad. Examples: Undeliverable, Hold
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.
  • source nvarchar(50)
    A short description of how the individual became a prospect. Examples: Home Test Purchase, Supervised Testing Voucher Purchase
  • taken_mat tinyint
    A flag indicating whether or not the individual has taken the Mensa Admission Test (MAT).
  • taken_wonderlic tinyint
    A flag indicating whether or not the individual has taken the Wonderlic.
  • taken_rait tinyint
    A flag indicating whether or not the individual has taken the RAIT.
  • taken_cattell tinyint
    A flag indicating whether or not the individual has taken the Cattell.
  • taken_nvr tinyint
    A flag indicating whether or not the individual has taken the Non-Verbal Reasoning (NVR) test.
  • taken_pictoral tinyint
    A flag indicating whether or not the individual has taken the Pictoral Reasoning test.
  • add_date smalldatetime
    The date that the individual first expressed interest in joining American Mensa. Example: 3/26/2018
  • test_how_soon nvarchar(500)
    A short description of how soon the individual is looking to test. Examples: "Within next 2 weeks", "Within 1 Year", "Within 1 Month", "Not Currently Interested"

Local Group Zip Statistics

This report lists all of the Zip codes that are associated to a local group, the area for the ZIP code, and the amount of members in each ZIP code.

Filetype: CSV

CSV columns

  • zipcode nvarchar(5)
    The postal code/zip code of the local group.
  • area nvarchar(5)
    The area number within the local group to which the postal code/zip code is assigned.
  • num_of_members int
    The number of members in the postal code/zip code.

Member Directory CSV

This report lists all of the members for a local group and their contact information filtered for displaying in an online or print directory. This report is available by request only. To request the Member Directory CSV, please email our Local Groups Coordinator.

Filetype: CSV

CSV columns

  • member_number bigint
    The individual's member number. Example: 100012345
  • full_name nvarchar(60)
    The individual's full name which is a concatenation of the first and last name values.
  • title nvarchar(20)
    The individual's title. Examples: Dr, Mr, Lt
  • first_name nvarchar(30)
    The individual's first name.
  • middle_name nvarchar(30)
    The individual's middle name.
  • last_name nvarchar(30)
    The individual's last name.
  • lineage nvarchar(20)
    The individual's lineage. Examples: Jr, Sr, III
  • local_group nvarchar(10)
    The individual's currently assigned local group number. This is the three digit local group identifier. Examples: 010, 760, 900
  • local_group_area nvarchar(5)
    The individual's currently assigned area number within their current local group. Examples: 00, 01, 02
  • address_line_1 nvarchar(75)
    The individual's first line or street address portion of their primary mailing address.
  • address_line_2 nvarchar(75)
    The individual's second line portion of their primary mailing address.
  • city nvarchar(40)
    The individual's city portion of their primary mailing address.
  • state nvarchar(40)
    The individual's state portion of their primary mailing address.
  • postal_code nvarchar(20)
    The individual's postal code/zip code portion of their primary mailing address.
  • country nvarchar(60)
    The individual's country portion of their primary mailing address.
  • bad_address_flag tinyint
    A flag that indicates whether the individual's primary mailing address is marked as a bad address. 1 indicates a bad address and 0 indicates a good address.
  • preference_flag tinyint
    A flag that indicates whether the individual is preferenced into their local group. 1 identifies that they are preferenced and 0 indicates they are assigned to the group based on mailing address only.
  • phone_number nvarchar(30)
    The individual's primary phone number.
  • email nvarchar(80)
    The individual's primary email address.