Overview
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 | Notes | Available in LearningBuilder Version |
|---|---|---|---|---|
MemberId | Member ID | p.PERSON_ID | ||
Title | Title | p.TITLE | ||
FirstName | First Name | p.FIRST_NAME | ||
MiddleName | Middle Name | p.MIDDLE_NAME | ||
LastName | Last Name | p.LAST_NAME | ||
MemberName | Member Name | p.MEMBER_NAME | ||
MemberType | Member Type | p.MEMBER_TYPE_ID | ||
WebSite | Web Site | p.WEB_SITE | ||
MemberDescription | Member Description | p.DESCRIPTION | ||
Suffix | Suffix | p.SUFFIX | ||
Fein | FEIN | p.FEIN | ||
p.EMAIL | ||||
AlternateName | Alternate Name | p.ALTERNATE_NAME | ||
OptOutOfDirectory | Opt Out of Directory | p.OPT_OUT_OF_DIRECTORY | ||
MakeContactInfoAvailable | Make Contact Info Available | p.MAKE_CONTACT_INFO_AVAILABLE | ||
RecordStatus | Record Status | ps.[NAME] PERSON_STATUS | ||
RecordStatusId | Record Status ID | PERSON_STATUS_ID | ||
PhoneType | Phone Type | Primary Phone Type (if any) | PHONE TYPE | |
PhoneTypeId | Phone Type ID | Primary Phone Type ID (if any) | n.PHONE_TYPE_ID | |
PhoneNumber | Phone Number | Primary Phone Number (if any) | n.PHONE_NUMBER | |
AddressType | Address Type | Primary Address Type (if any) | TITLE | |
AddressTypeId | Address Type ID | Primary Address Type ID (if any) | ADDRESS_TYPE_ID | |
AddressName | Address Name | Primary Address Name (if any) | ||
AddressLine1 | Address Line 1 | From Primary Address (if any) | a.STREET1 | |
AddressLine2 | Address Line 2 | From Primary Address (if any) | a.STREET2 | |
AddressLine3 | Address Line 3 | From Primary Address (if any) | a.STREET3 | |
AddressCity | Address City | From Primary Address (if any) | a.CITY | |
AddressState | Address State | From Primary Address (if any) | a.STATE | |
AddressCounty | Address Country | From Primary Address (if any) | a.COUNTRY | |
AddressMailCode | Address Mail Code | From Primary Address (if any) | a.MAIL_CODE | |
AddressProvince | Address Province | From Primary Address (if any) | a.PROVINCE | |
CachedParentChain | Cached Parent Chain | p.CACHED_PARENT_CHAIN | ||
MemberAncestorNames | Member Ancestor Names | dbo.F_MEMBER_ANCESTOR_NAMES(p.CACHED_PARENT_CHAIN) AS MEMBER_ANCESTOR_NAMES | ||
MemberHierarchyIds | Member Hierarchy IDs | MEMBER_HIERARCHY_IDS = dbo.F_MEMBER_HIERARCHY_IDS(P.CACHED_PARENT_CHAIN, P.PERSON_ID) | ||
RecordLastSuccessfulLogin | Record Last Successful Login | [LAST_SUCCESSFUL_LOGIN] | ||
RecordLastFailedLogin | Record Last Failed Login | [LAST_FAILED_LOGIN] | ||
RecordFailedLoginCount | Record Failed Login Count | [FAILED_LOGIN_COUNT] | ||
SmsNumberEnabledCount | SMS Number Enabled Count | ISNULL(smsCount.SMS_COUNT, 0) |