Users
This is a table representing the Users module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifier of the user. |
| User_Name | String | False |
The user name of the user. |
| User_Hash | String | False |
The hash for the user. |
| System_Generated_Password | Bool | False |
Whether the user has a system-generated password. |
| Pwd_Last_Changed | Datetime | False |
The date and time the password was last changed. |
| Authenticate_Id | String | False |
The authentication Id. |
| Sugar_Login | Bool | False |
Whether Sugar login is enabled for the user. |
| Picture | String | False |
The picture for the user. |
| First_Name | String | False |
The first name of the user. |
| Last_Name | String | False |
The last name of the user. |
| Full_Name | String | False |
The full name of the user. |
| Name | String | False |
The name of the user. |
| Is_Admin | Bool | False |
Whether the user is an admin. |
| External_Auth_Only | Bool | False |
Whether only external authentication is enabled for the user. |
| Receive_Notifications | Bool | False |
Whether the user can receive notifications. |
| Description | String | False |
The description for the user. |
| Date_Entered | Datetime | True |
The date the record was created. |
| Date_Modified | Datetime | True |
The date the record was last modified. |
| Last_Login | Datetime | True |
The last login time of the user. |
| Modified_User_Id | String | True |
The Id of the user who last modified the record. |
| Modified_By_Name | String | True |
The name of the user who last modified the record. |
| Created_By | String | True |
The Id of the user who created the record. |
| Created_By_Name | String | True |
The name of the user who created the record. |
| Title | String | False |
The title of the user. |
| Department | String | False |
The department of the user. |
| Phone_Home | String | False |
The home phone number of the user. |
| Phone_Mobile | String | False |
The mobile phone number of the user. |
| Phone_Work | String | False |
The work phone number of the user. |
| Phone_Other | String | False |
The alternate phone number of the user. |
| Phone_Fax | String | False |
The fax of the user. |
| Status | String | False |
The status of the user. |
| Address_Street | String | False |
The street address of the user. |
| Address_City | String | False |
The city in the address. |
| Address_State | String | False |
The state in the address. |
| Address_Country | String | False |
The country in the address. |
| Address_Postalcode | String | False |
The ZIP code in the address. |
| UserType | String | False |
The type of the user. |
| Default_Team | String | False |
The default team for the user. |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| Deleted | Bool | False |
The record deletion indicator. |
| Portal_Only | Bool | False |
Whether the user is portal only. |
| Show_On_Employees | Bool | False |
Whether the user is shown on the employees tab. |
| Employee_Status | String | False |
The status of the employee. |
| Messenger_Id | String | False |
The Id of the messenger. |
| Messenger_Type | String | False |
The type of the messenger. |
| Reports_To_Id | String | False |
The Id of the manager of the user. |
| Reports_To_Name | String | False |
The name of the manager of the user. |
| Email1 | String | False |
The alternate email address of the user. |
| String | False |
The email address of the user. | |
| Email_Link_Type | String | False |
The link type of the email. |
| Is_Group | Bool | False |
Whether the user is a group. |
| C_Accept_Status_Fields | String | False |
The fields for the accept status of the call. |
| M_Accept_Status_Fields | String | False |
The fields for the accept status of the meeting. |
| Accept_Status_Id | String | False |
The Id of the accept status. |
| Accept_Status_Name | String | False |
The name of the accept status. |
| Accept_Status_Calls | String | False |
The accept status for calls. |
| Accept_Status_Meetings | String | False |
The accept status for meetings. |
| Preferred_Language | String | False |
The preferred language of the user. |