CData Python Connector for SugarCRM

Build 25.0.9454

Users

Stores user account and profile records. This table supports identity management, access control, and user authentication. The maximum page size for this table is 20.

Columns

Name Type ReadOnly Description
Accept_Status_Calls String False

The acceptance status for call invitations that are associated with this user. This value determines whether the user accepts, declines, or tentatively responds to call scheduling requests.

Accept_Status_Id String False

The unique identifier (Id) for the user's acceptance status record. This value is used to link the acceptance state to call, meeting, and message interactions.

Accept_Status_Meetings String False

The acceptance status for meeting invitations associated with this user. This value reflects whether the user accepts, declines, or tentatively responds to meeting requests.

Accept_Status_Messages String False

The acceptance status for message requests associated with this user. This value tracks how the user responds to message-based engagement prompts.

Accept_Status_Name String False

The display name of the acceptance status. This value is shown in the user interface to represent the user's response choice.

Acl_Role_Set_Id String False

The Id of the set of access control roles that apply to this user. This value determines permission levels and functional access throughout the system.

Acl_Team_Set_Id String False

The Id of the set of teams to which this user is assigned. This value supports multi-team visibility and collaboration.

Address_City String False

The city portion of the user's primary address. This value is used for contact and location reference purposes.

Address_Country String False

The country portion of the user's primary address. This value can be used for localization and compliance context.

Address_Postalcode String False

The postal or ZIP code that is associated with the user's primary address. This value is used for formatting and regional validation.

Address_State String False

The state, province, or regional subdivision that is associated with the user's primary address. This value supports geographic classification.

Address_Street String False

The street address that is associated with the user's primary address. This value is used for mailing and identification purposes.

Authenticate_Id String False

The Id associated with the user's authentication record in external or internal identity systems. This value links login identity to user record identity.

Business_Center_Id String False

The Id of the business center to which this user is assigned. This value determines the operational region or service center context for activities.

Business_Center_Name String True

The display name of the business center that is associated with this user. This value is shown in interfaces that group users by location or service center.

C_Accept_Status_Fields String True

The advanced acceptance status configuration fields for this user. This value stores internal workflow and engagement logic.

Cookie_Consent Bool False

A Boolean field that returns a value of 'true' when the user has accepted cookie tracking. It returns a value of 'false' when cookie consent has not been granted.

Cookie_Consent_Received_On Datetime False

The date and time when the user provided cookie-tracking consent. This value supports compliance and privacy auditing.

Created_By String True

The Id of the user who created this user record. This value supports audit tracking and administrative oversight.

Created_By_Name String True

The display name of the user who created this record. This value provides clarity when reviewing user creation history.

Customer_Journey_Access Bool True

A Boolean field that returns a value of 'true' when the user has access to Customer Journey features. It returns a value of 'false' when access is restricted.

Customer_Journey_Last_Active Datetime True

The date and time when the user last interacted with the Customer Journey module. This value supports engagement tracking.

Date_Entered Datetime True

The date and time when this user record was initially created. This value supports lifecycle and audit logging.

Date_Modified Datetime True

The date and time when this user record was most recently updated. This value provides change history and update traceability.

Default_Team String False

The Id of the primary team that is assigned to this user. This value establishes default visibility and record ownership context.

Deleted Bool False

A Boolean field that returns a value of 'true' when this user record is marked as deleted. It returns a value of 'false' when the record is active.

Department String False

The department with which the user is affiliated. This value is used in organizational structure and reporting segments.

Description String False

A free-text description of the user. This field can contain role notes, responsibilities, or contextual information.

Email String False

The primary email address that is associated with the user. This value is used for notifications, communication, and identity recognition.

Email_Link_Type String False

The link behavior preference for email actions that are initiated through the system. This value determines whether external clients or in-application messaging is used.

Email1 String False

An alternate or additional email address for the user. This value is used for communication redundancy or alternative contact channels.

Employee_Status String False

The employment classification of the user (for example, 'active', 'terminated', or 'contract'). This value influences system visibility and workflow participation.

External_Auth_Only Bool False

A Boolean field that returns a value of 'true' when the user is authenticated exclusively through an external identity provider. It returns a value of 'false' when internal authentication is permitted.

First_Name String False

The given name of the user as recorded in the system. This value appears in communication and user interface display formats.

Full_Name String True

The full name of the user as combined and formatted by the system. This value is shown in displays, reports, and communications.

Id [KEY] String True

The Id for this user record. This value uniquely identifies the user throughout the system.

Is_Admin Bool False

A Boolean field that returns a value of 'true' when the user holds administrative privileges. It returns a value of 'false' when the user has standard access rights.

Is_Group Bool False

A Boolean field that returns a value of 'true' when this record represents a group or shared account rather than an individual user. It returns a value of 'false' when the record represents a single user.

Last_Login Datetime True

The date and time when the user last logged in. This value supports security oversight and usage tracking.

Last_Name String False

The family or surname of the user. This value is used in formal naming and directory listings.

License_Type String False

The license classification that is assigned to the user. This value affects available system functionality and permissible usage levels.

M_Accept_Status_Fields String True

The message-acceptance status configuration fields for this user. This value is used to manage communication workflows.

Messenger_Id String False

The Id associated with the user's external messaging or chat platform account. This value supports integration with messaging tools.

Messenger_Type String False

The type of messenger platform that is linked to the user (for example, 'Slack' or 'MS Teams'). This value clarifies communication channel context.

Modified_By_Name String True

The display name of the user who most recently modified this record. This value supports review and administrative traceability.

Modified_User_Id String True

The Id of the user who most recently updated this record. This value identifies the source of the most recent change.

Name String True

The full name of the user as stored in the primary name field. This value can differ from auto-formatted naming conventions when customized.

Phone_Fax String False

The fax number that is associated with the user. This value supports legacy or compliance-required communication methods.

Phone_Home String False

The user's home phone number. This value can be used for personal or emergency contact reference.

Phone_Mobile String False

The user's mobile phone number. This value is commonly used for direct outreach and two-factor verification.

Phone_Other String False

Any additional phone number associated with the user. This value supports multi-contact environments.

Phone_Work String False

The user's primary work phone number. This value is used for business communication.

Picture String False

The file reference for the user's profile image or avatar. This value is used in interface identity visualization.

Portal_Only Bool False

A Boolean field that returns a value of 'true' when the user can only access the customer or partner portal. It returns a value of 'false' when full application access is allowed.

Preferred_Language String False

The language selected as the preferred display language for this user. This value affects localization and interface translation.

Pwd_Last_Changed Datetime False

The date and time when the user's password was last updated. This value supports security compliance and password policy enforcement.

Receive_Notifications Bool False

A Boolean field that returns a value of 'true' when the user has opted to receive notifications. It returns a value of 'false' when notifications are disabled.

Reports_To_Id String False

The Id of the user to whom this user reports. This value defines reporting hierarchy and workflow approvals.

Reports_To_Name String True

The display name of the person to whom the user reports. This value is shown in organizational role displays.

Send_Email_On_Mention Bool False

A Boolean field that returns a value of 'true' when the user receives an email notification after being mentioned in a record. 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 user appears in the employee directory. It returns a value of 'false' when the user is excluded from public listing.

Site_User_Id String True

The Id that represents the user in external or integrated systems. This value supports cross-application identity matching.

Status String False

The current status of the user account (for example, 'Active' or 'Inactive'). This value influences system access and workflow assignment.

Sugar_Login Bool False

A Boolean field that returns a value of 'true' when the user is permitted to log in using SugarCRM authentication. It returns a value of 'false' when login is restricted.

Sync_Key String True

The synchronization key that is used to match this user record to external systems. This value supports data integration consistency.

System_Generated_Password Bool False

A Boolean field that returns a value of 'true' when the user's password was assigned automatically by the system. It returns a value of 'false' when the password was user-defined.

Team_Count String False

The number of teams to which this user is assigned. This value indicates the breadth of collaboration scope.

Team_Id String False

The Id of the user's primary assigned team. This value determines default record ownership and shared visibility.

Team_Name String False

The display name of the user's primary team. This value is shown in team-based interface elements.

Team_Set_Id String False

The Id of the set of teams that are associated with the user for multi-team visibility. This value drives shared access rights.

Title String False

The job title or professional role of the user within the organization. This value is displayed in profile and directory contexts.

User_Hash String True

The secure hashed representation of the user's password or credential token. This value is stored to meet security and compliance requirements.

User_Name String False

The username used to authenticate and identify the user within the system. This value must be unique.

Usertype String False

The classification of the user account (for example, 'Regular User', 'Administrator', or 'Portal User'). This value defines the user's role profile.

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