CData Python Connector for SugarCRM

Build 25.0.9454

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.

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

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454