Users
Stores user account and profile records. This table supports identity management, access control, and user authentication. The maximum page size for this table is 20.
Columns
| Name | Type | ReadOnly | Description |
| Accept_Status_Calls | String | False |
The acceptance status for call invitations that are associated with this user. This value determines whether the user accepts, declines, or tentatively responds to call scheduling requests. |
| Accept_Status_Id | String | False |
The unique identifier (Id) for the user's acceptance status record. This value is used to link the acceptance state to call, meeting, and message interactions. |
| Accept_Status_Meetings | String | False |
The acceptance status for meeting invitations associated with this user. This value reflects whether the user accepts, declines, or tentatively responds to meeting requests. |
| Accept_Status_Messages | String | False |
The acceptance status for message requests associated with this user. This value tracks how the user responds to message-based engagement prompts. |
| Accept_Status_Name | String | False |
The display name of the acceptance status. This value is shown in the user interface to represent the user's response choice. |
| Acl_Role_Set_Id | String | False |
The Id of the set of access control roles that apply to this user. This value determines permission levels and functional access throughout the system. |
| Acl_Team_Set_Id | String | False |
The Id of the set of teams to which this user is assigned. This value supports multi-team visibility and collaboration. |
| Address_City | String | False |
The city portion of the user's primary address. This value is used for contact and location reference purposes. |
| Address_Country | String | False |
The country portion of the user's primary address. This value can be used for localization and compliance context. |
| Address_Postalcode | String | False |
The postal or ZIP code that is associated with the user's primary address. This value is used for formatting and regional validation. |
| Address_State | String | False |
The state, province, or regional subdivision that is associated with the user's primary address. This value supports geographic classification. |
| Address_Street | String | False |
The street address that is associated with the user's primary address. This value is used for mailing and identification purposes. |
| Authenticate_Id | String | False |
The Id associated with the user's authentication record in external or internal identity systems. This value links login identity to user record identity. |
| Business_Center_Id | String | False |
The Id of the business center to which this user is assigned. This value determines the operational region or service center context for activities. |
| Business_Center_Name | String | True |
The display name of the business center that is associated with this user. This value is shown in interfaces that group users by location or service center. |
| C_Accept_Status_Fields | String | True |
The advanced acceptance status configuration fields for this user. This value stores internal workflow and engagement logic. |
| Cookie_Consent | Bool | False |
A Boolean field that returns a value of 'true' when the user has accepted cookie tracking. It returns a value of 'false' when cookie consent has not been granted. |
| Cookie_Consent_Received_On | Datetime | False |
The date and time when the user provided cookie-tracking consent. This value supports compliance and privacy auditing. |
| Created_By | String | True |
The Id of the user who created this user record. This value supports audit tracking and administrative oversight. |
| Created_By_Name | String | True |
The display name of the user who created this record. This value provides clarity when reviewing user creation history. |
| Customer_Journey_Access | Bool | True |
A Boolean field that returns a value of 'true' when the user has access to Customer Journey features. It returns a value of 'false' when access is restricted. |
| Customer_Journey_Last_Active | Datetime | True |
The date and time when the user last interacted with the Customer Journey module. This value supports engagement tracking. |
| Date_Entered | Datetime | True |
The date and time when this user record was initially created. This value supports lifecycle and audit logging. |
| Date_Modified | Datetime | True |
The date and time when this user record was most recently updated. This value provides change history and update traceability. |
| Default_Team | String | False |
The Id of the primary team that is assigned to this user. This value establishes default visibility and record ownership context. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this user record is marked as deleted. It returns a value of 'false' when the record is active. |
| Department | String | False |
The department with which the user is affiliated. This value is used in organizational structure and reporting segments. |
| Description | String | False |
A free-text description of the user. This field can contain role notes, responsibilities, or contextual information. |
| String | False |
The primary email address that is associated with the user. This value is used for notifications, communication, and identity recognition. | |
| Email_Link_Type | String | False |
The link behavior preference for email actions that are initiated through the system. This value determines whether external clients or in-application messaging is used. |
| Email1 | String | False |
An alternate or additional email address for the user. This value is used for communication redundancy or alternative contact channels. |
| Employee_Status | String | False |
The employment classification of the user (for example, 'active', 'terminated', or 'contract'). This value influences system visibility and workflow participation. |
| External_Auth_Only | Bool | False |
A Boolean field that returns a value of 'true' when the user is authenticated exclusively through an external identity provider. It returns a value of 'false' when internal authentication is permitted. |
| First_Name | String | False |
The given name of the user as recorded in the system. This value appears in communication and user interface display formats. |
| Full_Name | String | True |
The full name of the user as combined and formatted by the system. This value is shown in displays, reports, and communications. |
| Id [KEY] | String | True |
The Id for this user record. This value uniquely identifies the user throughout the system. |
| Is_Admin | Bool | False |
A Boolean field that returns a value of 'true' when the user holds administrative privileges. It returns a value of 'false' when the user has standard access rights. |
| Is_Group | Bool | False |
A Boolean field that returns a value of 'true' when this record represents a group or shared account rather than an individual user. It returns a value of 'false' when the record represents a single user. |
| Last_Login | Datetime | True |
The date and time when the user last logged in. This value supports security oversight and usage tracking. |
| Last_Name | String | False |
The family or surname of the user. This value is used in formal naming and directory listings. |
| License_Type | String | False |
The license classification that is assigned to the user. This value affects available system functionality and permissible usage levels. |
| M_Accept_Status_Fields | String | True |
The message-acceptance status configuration fields for this user. This value is used to manage communication workflows. |
| Messenger_Id | String | False |
The Id associated with the user's external messaging or chat platform account. This value supports integration with messaging tools. |
| Messenger_Type | String | False |
The type of messenger platform that is linked to the user (for example, 'Slack' or 'MS Teams'). This value clarifies communication channel context. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this record. This value supports review and administrative traceability. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this record. This value identifies the source of the most recent change. |
| Name | String | True |
The full name of the user as stored in the primary name field. This value can differ from auto-formatted naming conventions when customized. |
| Phone_Fax | String | False |
The fax number that is associated with the user. This value supports legacy or compliance-required communication methods. |
| Phone_Home | String | False |
The user's home phone number. This value can be used for personal or emergency contact reference. |
| Phone_Mobile | String | False |
The user's mobile phone number. This value is commonly used for direct outreach and two-factor verification. |
| Phone_Other | String | False |
Any additional phone number associated with the user. This value supports multi-contact environments. |
| Phone_Work | String | False |
The user's primary work phone number. This value is used for business communication. |
| Picture | String | False |
The file reference for the user's profile image or avatar. This value is used in interface identity visualization. |
| Portal_Only | Bool | False |
A Boolean field that returns a value of 'true' when the user can only access the customer or partner portal. It returns a value of 'false' when full application access is allowed. |
| Preferred_Language | String | False |
The language selected as the preferred display language for this user. This value affects localization and interface translation. |
| Pwd_Last_Changed | Datetime | False |
The date and time when the user's password was last updated. This value supports security compliance and password policy enforcement. |
| Receive_Notifications | Bool | False |
A Boolean field that returns a value of 'true' when the user has opted to receive notifications. It returns a value of 'false' when notifications are disabled. |
| Reports_To_Id | String | False |
The Id of the user to whom this user reports. This value defines reporting hierarchy and workflow approvals. |
| Reports_To_Name | String | True |
The display name of the person to whom the user reports. This value is shown in organizational role displays. |
| Send_Email_On_Mention | Bool | False |
A Boolean field that returns a value of 'true' when the user receives an email notification after being mentioned in a record. It returns a value of 'false' when mention notifications are disabled. |
| Show_On_Employees | Bool | False |
A Boolean field that returns a value of 'true' when the user appears in the employee directory. It returns a value of 'false' when the user is excluded from public listing. |
| Site_User_Id | String | True |
The Id that represents the user in external or integrated systems. This value supports cross-application identity matching. |
| Status | String | False |
The current status of the user account (for example, 'Active' or 'Inactive'). This value influences system access and workflow assignment. |
| Sugar_Login | Bool | False |
A Boolean field that returns a value of 'true' when the user is permitted to log in using SugarCRM authentication. It returns a value of 'false' when login is restricted. |
| Sync_Key | String | True |
The synchronization key that is used to match this user record to external systems. This value supports data integration consistency. |
| System_Generated_Password | Bool | False |
A Boolean field that returns a value of 'true' when the user's password was assigned automatically by the system. It returns a value of 'false' when the password was user-defined. |
| Team_Count | String | False |
The number of teams to which this user is assigned. This value indicates the breadth of collaboration scope. |
| Team_Id | String | False |
The Id of the user's primary assigned team. This value determines default record ownership and shared visibility. |
| Team_Name | String | False |
The display name of the user's primary team. This value is shown in team-based interface elements. |
| Team_Set_Id | String | False |
The Id of the set of teams that are associated with the user for multi-team visibility. This value drives shared access rights. |
| Title | String | False |
The job title or professional role of the user within the organization. This value is displayed in profile and directory contexts. |
| User_Hash | String | True |
The secure hashed representation of the user's password or credential token. This value is stored to meet security and compliance requirements. |
| User_Name | String | False |
The username used to authenticate and identify the user within the system. This value must be unique. |
| Usertype | String | False |
The classification of the user account (for example, 'Regular User', 'Administrator', or 'Portal User'). This value defines the user's role profile. |