Aurora: User fields synced between Community and Salesforce
This article lists the user fields that are synced between the community and Salesforce.
Note: "Data type" defines the type of data a field can hold and its specific constraints. For instance, number(5,0) accepts whole numbers up to five digits, with no decimal places (e.g. 99,999).
|
Data Element |
Data Type |
Description |
Saved in Salesforce? |
|
Members’ Basic Details |
|||
|
First name |
Text (50) |
User's first name |
Yes |
|
Last name |
Text (50) |
User's last name |
Yes |
|
Email address |
Text (50) |
User's email id |
Yes |
|
Members’ Community Details |
|||
|
Khoros User ID |
Number (7, 0) |
Khoros' internal user ID |
Yes |
|
isUserDeleted |
Text (50) |
Whether the user is deleted or not |
Yes |
|
Rank |
Text (50) |
Rank assigned to the user in Khoros |
Yes |
|
Roles |
Text (50) |
Roles assigned to the user in Khoros |
Yes |
|
Registration Time |
Text (50) |
Time stamp when the user registered on the community |
Yes |
|
Last Visit Time |
Text (50) |
Time stamp when the user last visited the community |
Yes |
|
Biography |
Text (50) |
User's self composed profile description |
Yes |
|
Administrative Notes |
Text (50) |
Additional notes by administrator |
Yes |
|
Location |
Text (50) |
Geographic location of the user |
Yes |
|
Khoros SSOID |
Text (50) (External ID) (Unique Case Insensitive) |
Khoros community user SSO ID |
Yes |
|
User Profile Avatar URL |
Text Area (255) |
The user avatar URL |
Yes |
|
Community User URL |
URL (255) |
Community user URL |
Yes |
|
Community ID |
Text (50) |
Khoros community ID (member username) |
Yes |
|
User's Community Statistics / Metrics |
|||
|
Metric Logins |
Number (5, 0) |
Number of times the user has logged in on the Khoros community |
Yes |
|
Metric Minutes Online |
Number (10, 0) |
Total duration, in minutes, the user has been online |
Yes |
|
Metric Page Views |
Number (10, 0) |
Count of pages the user has viewed on community |
Yes |
|
Metric Posts |
Number (6, 0) |
No. of posts the user has authored on the Khoros community |
Yes |
|
Metric Messages Read |
Number (6, 0) |
No. of messages user has read the Khoros community |
Yes |
|
Metric Private Messages Sent |
Number (5, 0) |
No. of private messages user has sent to other community users |
Yes |
|
Metric Private Messages Received |
Number (5, 0) |
No. of private messages user has received from other community |
Yes |
|
Metric Average Message Rating |
Number (4, 4) |
Average of the rating (Kudos) given by other users, to the messages posted by the user |
Yes |
|
Kudos Count |
Number (18, 0) |
No. of Kudos received by the community user |
No, fetched from Community |
|
No of Accepted Solutions |
Number (18, 0) |
No. of solutions accepted by the community user |
No, fetched from Community |
|
Members’ Other Details |
|||
|
REST URL |
Text (255) |
REST URL for the user's account profile on the community |
Yes |
|
Contact |
Lookup (Contact) |
Lookup reference to the Salesforce Contact record mapped to email ID of the community user record |
Yes |
|
Other details displayed on Community User Page |
|||
|
Recent User Messages Posted |
|
Messages recently posted by user |
Fetched by Community |
|
Recently Read Messages |
|
Messages recently read by user |
Fetched by Community |