| Expand | ||
|---|---|---|
| ||
|
...
Summary
| Page Properties | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
...
|
...
|
Usage
Suggested uses for this view include:
Creating a contact information report that includes only primary contact information
Viewing user login trends over time
Joining to a report that uses https://heuristicsolutions.atlassian.net/wiki/pages/resumedraft.action?draftId=2808283384 view to quickly add primary contact information.
Data Fields
Field Name | English Name | Description | Notes | Available in LearningBuilder Version |
|---|---|---|---|---|
MemberId | Member |
ID | |||
Title | Title |
p.TITLE
FirstName | First Name |
MiddleName | Middle Name |
LastName | Last Name |
p.LAST_NAME
MemberName | Member Name |
MemberType | Member Type |
WebSite | Web Site |
MemberDescription | Member Description |
Suffix | Suffix |
p.SUFFIX
Fein |
FEIN | |||
p.EMAIL
AlternateName | Alternate Name |
p.ALTERNATE_NAME
OptOutOfDirectory | Opt Out of Directory |
p.OPT_OUT_OF_DIRECTORY
MakeContactInfoAvailable | Make Contact Info Available |
RecordStatus | Record Status |
ps.[NAME] PERSON_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) |
n.PHONE_NUMBER
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) |
a.STATE
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) |
a.PROVINCE
CachedParentChain | Cached Parent Chain |
MemberAncestorNames | Member Ancestor Names |
dbo.F_MEMBER_ANCESTOR_NAMES(p.CACHED_PARENT_CHAIN) AS MEMBER_ANCESTOR_NAMES
MemberHierarchyIds | Member Hierarchy IDs |
CreatedOn | Created On | Future | ||
ModifiedOn | Modified On | This is not often updated. | Future | |
RecordLastSuccessfulLogin | Record Last Successful Login |
On creation, equals Created On Date | ||
RecordLastFailedLogin | Record Last Failed Login |
RecordFailedLoginCount | Record Failed Login Count |
SmsNumberEnabledCount | SMS Number Enabled Count |