ExternalUsers
Stores external portal user identities. This table supports partner, customer, or outside-user access to portal-based functionality.
Columns
| Name | Type | ReadOnly | Description |
| Salutation | String | False |
The salutation used for this external user (for example, 'Mr', 'Ms', 'Dr', or another formal greeting). This value is commonly displayed in communication and name formatting contexts. |
| First_Name | String | False |
The first name of the external user. This value is used in display formatting and communication. |
| Last_Name | String | False |
The last name of the external user. This value is used in searching, sorting, and formal reference. |
| Name | String | False |
The formatted full name of the external user. This value is typically presented as First Name Last Name and is used in list displays and record headers. |
| Full_Name | String | True |
The combined full legal name of the external user. This value is used for reporting, identity verification, and UI presentation. |
| Title | String | False |
The job title or professional designation of the external user. This value helps identify role or responsibility when interacting across systems. |
| String | False |
The external user's associated Facebook handle or profile reference. This value supports social media linkage where applicable. | |
| String | False |
The external user's associated Twitter handle. This value supports social media engagement or identity matching. | |
| Googleplus | String | False |
The external user's associated Google Plus identifier (Id). This value can be present in legacy integrations. |
| Department | String | False |
The department or organizational division that is associated with the external user. This value is used for grouping and reporting. |
| Do_Not_Call | Bool | False |
A Boolean field that returns a value of 'true' when the external user has requested not to be contacted by phone. It returns a value of 'false' when phone contact is permitted. |
| Phone_Home | String | False |
The home phone number of the external user, if it is provided. |
| Phone_Mobile | String | False |
The mobile phone number of the external user. This value is often used for direct outreach or SMS-based communication. |
| Phone_Work | String | False |
The work phone number of the external user, typically associated with their business or professional role. |
| Phone_Other | String | False |
An additional alternative phone number for the external user that does not fall under standard categories. |
| Phone_Fax | String | False |
The fax number associated with the external user, where fax communication is still in use. |
| Primary_Address_Street | String | False |
The street line of the external user's primary mailing address. |
| Primary_Address_Street_2 | String | False |
The second street line of the external user's primary mailing address, if it is required. |
| Primary_Address_Street_3 | String | False |
The third street line of the external user's primary mailing address, if it is required. |
| Primary_Address_City | String | False |
The city associated with the external user's primary address. |
| Primary_Address_State | String | False |
The state or province that is associated with the external user's primary address. |
| Primary_Address_Postalcode | String | False |
The postal code that is associated with the external user's primary address. |
| Primary_Address_Country | String | False |
The country that is associated with the external user's primary address. |
| Alt_Address_Street | String | False |
The street line of the external user's alternate mailing address. |
| Alt_Address_Street_2 | String | False |
The second street line for the external user's alternate address, if it is applicable. |
| Alt_Address_Street_3 | String | False |
The third street line for the external user's alternate address, if it is applicable. |
| Alt_Address_City | String | False |
The city that is associated with the external user's alternate address. |
| Alt_Address_State | String | False |
The state or province that is associated with the external user's alternate address. |
| Alt_Address_Postalcode | String | False |
The postal code that is associated with the external user's alternate address. |
| Alt_Address_Country | String | False |
The country that is associated with the external user's alternate address. |
| Assistant | String | False |
The name of the external user's assistant, if it is applicable. This value can be used for communication or scheduling coordination. |
| Assistant_Phone | String | False |
The phone number for the external user's assistant, when provided. |
| Picture | String | False |
The reference to the external user's profile image or avatar. This value generally points to a stored file resource. |
| Id [KEY] | String | False |
The unique Id of this external user record. The system uses this Id to reference and manage the record internally. |
| Date_Entered | Datetime | True |
The date and time when the external user record was created. This timestamp supports auditing and chronological analysis. |
| Date_Modified | Datetime | True |
The date and time when the external user record was last updated. This value supports change tracking. |
| Modified_User_Id | String | True |
The unique Id of the user who last modified this external user record. This value supports audit and ownership review. |
| Modified_By_Name | String | True |
The display name of the user who last modified this external user record. This value is shown in UI displays for context. |
| Created_By | String | True |
The unique Id of the user who created this external user record. This value documents record origin. |
| Created_By_Name | String | True |
The display name of the user who created this external user record. This value appears in administrative views. |
| Description | String | False |
A detailed narrative note or context statement about the external user. This field is often used for relationship or account history notes. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the external user record is marked as deleted. It returns a value of 'false' when the record is active. |
| User_Name | String | False |
The username that is associated with this external user. This value is used for authentication into linked portal or external systems. |
| Status | String | False |
The current status of the external user within the system (for example, 'Active' or 'Inactive'). This status influences authentication and visibility. |
| External_App | String | False |
The external application that created or manages this external user record. This value is used in integration mapping. |
| External_Id | String | False |
The Id that is assigned to the external user by the external application. This Id is used to match records across systems. |
| Contact_Name | String | True |
The display name of the related contact that is associated with this external user. This value is used for UI visibility and relationship context. |
| Contact_Id | String | False |
The unique Id of the contact that is associated with this external user. This relationship links the external user back to CRM contact records. |
| String | False |
The email address that is associated with this external user. This value is used for communication and messaging workflows. | |
| Email1 | String | False |
An additional email address that is associated with this external user. This field allows multiple communication channels to be stored. |
| Email2 | String | False |
A second supplemental email address that is associated with this external user, when needed for alternate correspondence. |
| Invalid_Email | Bool | False |
A Boolean field that returns a value of 'true' when the email address for the external user is flagged as invalid. It returns a value of 'false' when the email address is recognized as deliverable. |
| Email_Opt_Out | Bool | False |
A Boolean field that returns a value of 'true' when the external user has opted out of email communications. It returns a value of 'false' when email messaging is allowed. |
| Email_Addresses_Non_Primary | String | False |
Additional non-primary email addresses that are associated with the external user. This field stores secondary communication channels. |
| Tag | String | False |
The tags that are associated with this external user for search, classification, and filtering. |
| Source_Id | String | False |
The Id that indicates where the external user originated. This value supports data source tracking in multi-system environments. |
| Source_Type | String | False |
The type of external data source from which the external user record originated (for example, 'import', 'API', or 'portal registration'). |
| Source_Meta | String | False |
Metadata or supplemental information about the external data source. This value helps interpret how the record was created. |
| Assigned_User_Id | String | False |
The Id of the user who is responsible for managing or maintaining this external user record. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned responsibility for this external user record. |
| Team_Id | String | False |
The Id of the primary team that is associated with this external user record. The primary team defines default access controls. |
| Team_Set_Id | String | False |
The Id of the team set that is assigned to this external user record. The team set defines the full list of teams with access to view or modify the record. |
| Acl_Team_Set_Id | String | False |
The Id of the Access Control List (ACL) team set that determines which role-based permissions apply to this external user record. |
| Team_Count | String | False |
The number of teams that are associated with this external user record. This value helps evaluate collaboration scope. |
| Team_Name | String | False |
The display name of the primary team that is associated with this external user record. This value appears in assignment and filtering user interfaces. |
| Acl_Team_Names | String | True |
The list of team names that are associated with this record for access control and collaboration visibility. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this external user record. It returns a value of 'false' when the record is not followed. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the external user record has been marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Commentlog | String | True |
The log of comments and discussion history that is associated with this external user record. This field is commonly used to support collaboration and decision documentation. |
| Locked_Fields | String | True |
The list of fields on this external user record that are restricted from being edited. Locked fields are used to preserve data accuracy or compliance. |
| Sync_Key | String | True |
The synchronization key that is used to align this external user record with external systems or integration pipelines. This key supports cross-system record matching. |