Data Source Description: Profile

Table of Contents

Summary

View Type	Reporting
English Name	Profile
Description	List of all member records with extended data on primary contact information from the PERSON and related tables.

Data Fields

Field Name	English Name	Description
MemberId	Member ID
Title	Title
FirstName	First Name
MiddleName	Middle Name
LastName	Last Name
MemberName	Member Name
MemberType	Member Type
WebSite	Web Site
MemberDescription	Member Description
Suffix	Suffix
Fein	FEIN
Email	Email
AlternateName	Alternate Name
OptOutOfDirectory	Opt Out of Directory
MakeContactInfoAvailable	Make Contact Info Available
RecordStatus	Record Status
RecordStatusId	Record Status ID
PhoneType	Phone Type	Primary Phone Type (if any)
PhoneTypeId	Phone Type ID	Primary Phone Type ID (if any)
PhoneNumber	Phone Number	Primary Phone Number (if any)
AddressType	Address Type	Primary Address Type (if any)
AddressTypeId	Address Type ID	Primary Address Type ID (if any)
AddressName	Address Name	Primary Address Name (if any)
AddressLine1	Address Line 1	From Primary Address (if any)
AddressLine2	Address Line 2	From Primary Address (if any)
AddressLine3	Address Line 3	From Primary Address (if any)
AddressCity	Address City	From Primary Address (if any)
AddressState	Address State	From Primary Address (if any)
AddressCounty	Address Country	From Primary Address (if any)
AddressMailCode	Address Mail Code	From Primary Address (if any)
AddressProvince	Address Province	From Primary Address (if any)
CachedParentChain	Cached Parent Chain
MemberAncestorNames	Member Ancestor Names
MemberHierarchyIds	Member Hierarchy IDs
RecordLastSuccessfulLogin	Record Last Successful Login
RecordLastFailedLogin	Record Last Failed Login
RecordFailedLoginCount	Record Failed Login Count
SmsNumberEnabledCount	SMS Number Enabled Count