Employees
Stores employee profile and account identity records used for authentication and internal user management. This table supports organizational structure representation and access control.
Columns
| Name | Type | ReadOnly | Description |
| Accept_Status_Calls | String | False |
The current user's acceptance status for call invitations. This value indicates whether the user automatically accepts, declines, or requires confirmation before joining scheduled calls. |
| Accept_Status_Id | String | False |
The unique identifier (Id) that represents the user's overall communication acceptance status. This Id is used by SugarCRM to determine how the user's availability is handled. |
| Accept_Status_Meetings | String | False |
The user's acceptance status for meeting invitations. This value influences how the system displays the user's calendar availability and incoming meeting requests. |
| Accept_Status_Messages | String | False |
The user's acceptance status for administrative or workflow-related system messages. This value determines whether certain notifications are delivered or suppressed. |
| Accept_Status_Name | String | False |
The descriptive name that is associated with the user's acceptance status. This name is displayed in user preferences and system configuration panels. |
| Acl_Role_Set_Id | String | False |
The unique Id of the access-control role set that applies to this employee. The role set defines the permissions and security policies available to the user. |
| Acl_Team_Set_Id | String | False |
The unique Id of the team set that is assigned to this employee. The team set determines which teams the user can collaborate with and what records they may access. |
| Address_City | String | False |
The city portion of the employee's primary business address. |
| Address_Country | String | False |
The country that is associated with the employee's primary business address. |
| Address_Postalcode | String | False |
The postal code or ZIP code that is associated with the employee's primary business address. |
| Address_State | String | False |
The state or province that is associated with the employee's primary business address. |
| Address_Street | String | False |
The street address or street line that is associated with the employee's primary business location. |
| Authenticate_Id | String | False |
The unique Id that is used for authentication integration or external identity management systems. This Id links the SugarCRM user to third-party authentication providers where applicable. |
| Business_Center_Id | String | False |
The unique Id of the business center that is associated with this employee. Business centers represent organizational branches, service hubs, or operational locations. |
| Business_Center_Name | String | True |
The display name of the business center that is associated with this employee. This value is used in dashboards, reporting, and team assignment contexts. |
| C_Accept_Status_Fields | String | True |
The collection of communication types for which the user has defined acceptance preferences. This field helps centralize call, meeting, and message acceptance logic. |
| Cookie_Consent | Bool | False |
A Boolean field that returns a value of 'true' when the employee has granted consent for cookie usage. It returns a value of 'false' when consent has not been granted. |
| Cookie_Consent_Received_On | Datetime | False |
The date and time when the employee granted cookie consent. This timestamp is used for privacy compliance and consent tracking. |
| Created_By | String | True |
The unique Id of the user who created this employee record. This value provides historical origin tracking. |
| Created_By_Name | String | True |
The display name of the user who created this employee record. This value is commonly shown in administrative record views. |
| Customer_Journey_Access | Bool | True |
A Boolean field that returns a value of 'true' when the employee has permission to access Customer Journey modules and visual process maps. It returns a value of 'false' when access is restricted. |
| Customer_Journey_Last_Active | Datetime | True |
The date and time when the employee last interacted with Customer Journey features. This value is useful for activity monitoring and adoption tracking. |
| Date_Entered | Datetime | True |
The date and time when this employee record was created. This timestamp is used for auditing and chronological sorting. |
| Date_Modified | Datetime | True |
The date and time when this employee record was last updated. This timestamp supports change tracking and administrative oversight. |
| Default_Team | String | False |
The unique Id of the default team that is assigned to this employee. The default team determines the primary access and visibility context for the user's records. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the employee record is marked as deleted within SugarCRM. It returns a value of 'false' when the record is active. |
| Department | String | False |
The name of the employee's department or business unit. This value is commonly used for reporting and organizational grouping. |
| Description | String | False |
A detailed narrative or informational note about the employee. This field often includes role context, functional responsibilities, or internal notes. |
| String | False |
The primary email address that is associated with this employee. This address is used for notifications, system communication, and workflow messaging. | |
| Email_Link_Type | String | False |
The method used to link email messages to this employee's record. This value determines how email interactions are associated for display, filtering, and audit history. |
| Email1 | String | False |
The primary email address that is associated with this employee. This address is used for system notifications, workflow messages, and direct communication. |
| Employee_Status | String | False |
The employment status for this employee (for example, 'Active', 'Inactive', or 'Terminated'). This value influences visibility in directories and workflow eligibility. |
| External_Auth_Only | Bool | False |
A Boolean field that returns a value of 'true' when this employee is required to authenticate through an external identity provider. It returns a value of 'false' when authentication is handled directly within SugarCRM. |
| First_Name | String | False |
The employee's first name. This value is used in display names, email signatures, and record headers. |
| Full_Name | String | True |
The combined full name of the employee. This value is typically formatted as First Name Last Name and is used in UI lists and communication contexts. |
| Id [KEY] | String | True |
The unique Id)for this employee record. The system uses this Id to reference the employee internally across modules and workflows. |
| Is_Admin | Bool | False |
A Boolean field that returns a value of 'true' when the employee has administrative privileges. It returns a value of 'false' when standard user permissions apply. |
| Is_Group | Bool | False |
A Boolean field that returns a value of 'true' when the record represents a group or shared inbox account rather than an individual user. It returns a value of 'false' when the record represents a person. |
| Last_Login | Datetime | True |
The date and time when the employee last logged into SugarCRM. This value is used for usage monitoring and access auditing. |
| Last_Name | String | False |
The employee's last name. This value is used for display, search, reporting, and directory listing. |
| License_Type | String | False |
The license type that is assigned to this employee. License types determine feature access, module eligibility, and system entitlements. |
| M_Accept_Status_Fields | String | True |
The collection of meeting-related acceptance preferences that apply to this employee. This field aligns with user availability and scheduling rules. |
| Messenger_Id | String | False |
The handle or Id that is used by the employee in third-party instant messaging applications. This value supports integrated communication workflows. |
| Messenger_Type | String | False |
The messaging platform that is associated with the messenger_id value (for example, 'Slack', 'Teams', or 'Skype'). |
| Modified_By_Name | String | True |
The display name of the user who last modified this employee record. This value is used for administrative review. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this employee record. This value supports change tracking and record audit history. |
| Name | String | True |
The formatted display name of the employee. This value is used in record headers, assignment fields, and directory listings. |
| Phone_Fax | String | False |
The fax number that is associated with the employee. This value is included for organizations that use fax communication in support or administrative workflows. |
| Phone_Home | String | False |
The employee's home phone number, if it is provided. This field is typically used only in internal directories with restricted visibility. |
| Phone_Mobile | String | False |
The employee's mobile phone number. This value is commonly used for Short Message Service (SMS) notifications and two-factor authentication. |
| Phone_Other | String | False |
An additional phone number for the employee that does not fit into primary categories. This field allows alternative communication channels to be recorded. |
| Phone_Work | String | False |
The employee's primary business or work phone number. This value is used in contact directories and communication workflows. |
| Picture | String | False |
The reference to the employee's profile image. This value typically represents a stored file Id or path used for UI display. |
| Portal_Only | Bool | False |
A Boolean field that returns a value of 'true' when the employee account is restricted to portal access only. It returns a value of 'false' when full SugarCRM access is available. |
| Preferred_Language | String | False |
The language that the employee selects for system display. This value affects UI text, emails, and localized formatting. |
| Pwd_Last_Changed | Datetime | False |
The date and time when the employee last changed their password. This value is used for security and compliance monitoring. |
| Receive_Notifications | Bool | False |
A Boolean field that returns a value of 'true' when the employee has enabled notifications for activity updates and record changes. It returns a value of 'false' when notifications are disabled. |
| Reports_To_Id | String | False |
The Id of the manager or supervisor to whom this employee reports. This value helps define reporting structures and workflow escalations. |
| Reports_To_Name | String | True |
The name of the manager or supervisor who oversees this employee. This value is used in user interfaces and organizational charts. |
| Send_Email_On_Mention | Bool | False |
A Boolean field that returns a value of 'true' when the employee receives email notifications after being mentioned in comments or activity streams. 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 employee should be visible in employee directories. It returns a value of 'false' when the employee should not appear in public listings. |
| Site_User_Id | String | True |
The external site user Id that is linked to this employee for integrated systems. This Id is used in portal access, SSO workflows, or customer-facing logins. |
| Status | String | False |
The active or inactive status of the employee within the system. This value influences login access and visibility. |
| Sugar_Login | Bool | False |
A Boolean field that returns a value of 'true' when SugarCRM login is permitted for this employee. It returns a value of 'false' when login access is disabled or externally controlled. |
| Sync_Key | String | True |
The synchronization key that is used to align this employee record with external systems or integration endpoints. This key supports cross-system identity matching. |
| System_Generated_Password | Bool | False |
A Boolean field that returns a value of 'true' when the employee's current password is generated automatically by the system. It returns a value of 'false' when the password is set manually by the user. |
| Team_Count | String | False |
The number of teams that are currently associated with this employee. This value supports permission and collaboration analysis. |
| Team_Id | String | False |
The Id of the primary team that is associated with this employee. This team defines the employee's default access context. |
| Team_Name | String | False |
The display name of the primary team that is associated with this employee. This value is used in selectors and UI displays. |
| Team_Set_Id | String | False |
The Id of the team set that is assigned to this employee. The team set lists all teams that grant the employee record access privileges. |
| Title | String | False |
The job title or role designation of the employee. This value is often displayed in directories, profile pages, and reporting tools. |
| User_Hash | String | True |
The hashed representation of the employee's current password. This value is stored for authentication and security verification. |
| User_Name | String | False |
The login user name for this employee. This value is used for authentication and identity recognition. |
| Usertype | String | False |
The classification of the user account (for example, 'Regular User', 'System Administrator', or 'Group Account'). This value influences feature access and behavior settings. |