...
Field Name | English Name | Description | Notes | Available in LearningBuilder Version | |
|---|---|---|---|---|---|
MemberId | Member ID | p.PERSON_ID | |||
Title | Title | p.TITLE | |||
FirstName | First Namep.FIRST_NAME | ||||
MiddleName | Middle Namep.MIDDLE_NAME | ||||
LastName | Last Name | p.LAST_NAME | |||
MemberName | Member Namep.MEMBER_NAME | ||||
MemberType | Member Type | p.MEMBER_TYPE_ID | |||
WebSite | Web Site | p.WEB_SITE | |||
MemberDescription | Member Description | p.DESCRIPTION | |||
Suffix | Suffixp.SUFFIX | ||||
FeinFEIN | p.FEIN | ||||
Emailp.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 Statusps.[NAME] PERSON_STATUS | ||||
RecordStatusId | Record Status IDPERSON_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)a.NAME | |||
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 CountISNULL(smsCount.SMS_COUNT, 0) |