JDBC Driver for SugarCRM

Build 22.0.8462

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.

Email 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462