Report Columns - What do the different columns mean?

A list of column headings, description, and field options in the results lists of most Membership reports are listed below. Field names that are left blank are self-explanatory.

The list is in alphabetical order.

The list is provided to provide a better understanding of the information available in the report.

Column heading	Description	Options
Ability notes	Details of Diverse Ability	open text field to enter details for member's diverse ability
Account	Company or firm name
Account Name (org)	Lookup field added to remove "Person" accounts in report results	Salesforce requires all Contact records (individuals) be connected to an Account record (company). If no Account name is entered in the Account field, Salesforce will create an Account using First Name and Last Name and adding "Person" at the end of the name. The lookup field removes Accounts ending in "Person" because these are placeholder records, not a "real" Company name.
Account Role	Member's role at their company/firm	Staff, Principal/Owner
AIA Number	Member number
Badge Name	Nickname/Preferred name member wants to use
Birth date
Career Type	Business type of Account (Organization)	Non-profit, For-profit, Education, Government, Retired, None Selected
City
Country
Designation	AIA designation	AIA, Assoc. AIA, Intl. Associate AIA, AIA Member Emeritus, FAIA Member Emeritus, Associate AIA Emeritus, FAIA
Diverse ability	Member self-identifies their diverse ability	Hard of hearing, visual, mobility, blind
Do not contact	Member has requested not to be contacted by any means.	False = Do not contact, True = Okay to contact
Do not contact by email	Member has requested not to be emailed.	False = Do not contact, True = Okay to contact
Do not contact by phone	Member has requested not to be contacted by phone.	False = Do not contact, True = Okay to contact
Do not contact by post	Member has requested not to be contacted by mail.	False = Do not contact, True = Okay to contact
Emeritus	Check box on member record in Fonteva	False = Not Emeritus True = Has Emeritus status
Ethnicity self identify	Text field for members to add their ethnicity
Fellow	Check box on member record in Fonteva	False = Not a Fellow True = Is a member of the College of Fellows
First Name
Gender	Member self-identifies their gender	Female, Male, Prefer not to say, none selected
Gender self identify	Open field for member to self identify
Interest areas	Active Knowledge Community list	Acad. of Architecture for Health, Acad. of Architecture for Justice, Academic, Building Performance, Committee on Architecture for Ed., Committee on Design, Committee on the Environment, Construction Contract Admin., Corp. Architects & Facility Mgmt., Custom Residential Arch. Network, Design for Aging, Historic Resources Committee, Housing and Community Development, Interfaith Design, Interior Arch. Knowledge Comm., Practice Mgmt. Knowledge Comm., Project Delivery Knowledge Comm., Public Architects Committee, Regional and Urban Design, Retail and Entertainment, Small Firm Exchange, Small Projects, Tech. in Architectural Practice, Young architects
Job Function		Project management, Executive, Design/planning, Educator, Specifications, None Selected
Job Title
Last Name
Last Reinstate Date		If a member has been terminated and rejoined more than once, the Last Reinstate Date will show the latest Reinstate Date. The field is overwritten at each reinstatement.
LGBTQAI	Member self-identifies they are a member of this community (new field in Fonteva)	False = Member has not checked this box True = Member has checked this box and has identified as a member of this community
Licensure status		Licensed, Not pursuing licensure, On track to licensure
Local Assignment	Local component assigned at membership using zip code.
Member status	Status of membership	Active, Lapsed, Terminated
Member type	AIA member type: Architect, Associate, Fellow, Allied, International Associate
Membership expire date	Date when the current membership subscription ends.
Middle Name
Original joined date	The date when member originally joined the AIA.
Other Credentials	Non-AIA credentials
Phone Number
Postal Code
Preferred address		Work, Personal
Preferred Address Type		Work, Personal
Preferred Email		Work, Personal
Primary Race Ethnicity		Hispanic/Latino,Caucasian, Black or African American, Indigenous American, Asian, Arabic/MENA, Other Race/Ethnicity, Prefer not to say, None Selected
Salutation	Prefix	Dr., Miss, Mrs., Ms., Mr.
Section Assignment	Section Component assigned at membership using zip code.
State
State Assignment	State component assigned at membership using zip code.
Suffix		III, IV, Jr.

Report Columns - What do the different columns mean?

Related articles