JDBC Driver for SugarCRM

Build 24.0.9062

Employees

The Employees table.

Columns

Name Type ReadOnly Description
Accept_Status_Calls String False

Accept_Status_Id String False

Accept_Status_Meetings String False

Accept_Status_Messages String False

Accept_Status_Name String False

Acl_Role_Set_Id String False

Acl_Team_Set_Id String False

Address_City String False

Address_Country String False

Address_Postalcode String False

Address_State String False

Address_Street String False

Authenticate_Id String False

Business_Center_Id String False

The business center to which the case is associated

Business_Center_Name String True

The name of the business center represented by the business_center_id field

C_Accept_Status_Fields String True

Cookie_Consent Bool False

Indicator whether this user accepts cookies

Cookie_Consent_Received_On Datetime False

Date cookie consent received on

Created_By String True

Created_By_Name String True

Customer_Journey_Access Bool True

Customer_Journey_Last_Active Datetime True

Date_Entered Datetime True

Date_Modified Datetime True

Default_Team String False

Deleted Bool False

Department String False

Description String False

Email String False

Email_Link_Type String False

Email1 String False

Employee_Status String False

External_Auth_Only Bool False

First_Name String False

Full_Name String True

Id [KEY] String True

Is_Admin Bool False

Is_Group Bool False

Last_Login Datetime True

Last_Name String False

License_Type String False

M_Accept_Status_Fields String True

Messenger_Id String False

Messenger_Type String False

Modified_By_Name String True

Modified_User_Id String True

Name String True

Phone_Fax String False

Phone_Home String False

Phone_Mobile String False

Phone_Other String False

Phone_Work String False

Picture String False

Portal_Only Bool False

Preferred_Language String False

Pwd_Last_Changed Datetime False

Receive_Notifications Bool False

Reports_To_Id String False

Reports_To_Name String True

Send_Email_On_Mention Bool False

Show_On_Employees Bool False

Site_User_Id String True

Status String False

Sugar_Login Bool False

Sync_Key String True

System_Generated_Password Bool False

Team_Count String False

Team_Id String False

Team_Name String False

Team_Set_Id String False

Title String False

User_Hash String True

User_Name String False

Usertype String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062