Power BI Connector for SugarCRM

Build 25.0.9454

Calls

Stores call interaction records, including call details, participants, and status. This table supports sales communication tracking, follow-up workflows, and engagement reporting.

Columns

Name Type ReadOnly Description
Accept_Status String False

The current acceptance status of the call request for the user. This field reflects whether the user has accepted, declined, or not responded to the call invitation.

Accept_Status_Users String False

The list of users and their acceptance statuses for this call. This field supports group call coordination and attendance tracking.

Acl_Team_Names String True

The list of team names that are associated with this call record. Each name identifies a team that has visibility or management permissions for the call.

Acl_Team_Set_Id String False

The Id of the team set that controls access to this call record. The team set determines which users or groups are permitted to view and modify the call.

Assigned_User_Id String False

The unique identifier (Id) of the user that is assigned to manage or lead the call. This field supports ownership, accountability, and workload balancing.

Assigned_User_Name String True

The name of the user that is assigned to this call. This field provides a human-readable reference for the assigned_user_id field.

Auto_Invite_Parent Bool False

A Boolean field that returns a value of 'true' when the system automatically invites the parent record's related participants to the call. It returns a value of 'false' when automatic parent-based invitations are disabled.

Aws_Contact_Id String True

The Amazon Web Services (AWS) Connect contact Id that corresponds to this call. This field maps calls to AWS telephony session records for integration tracking.

Aws_Lens_Data String False

The raw analytics data that is generated by the AWS Contact Lens service for this call. This field can include sentiment scoring, topic extraction, or conversational analysis metadata.

Call_Differentiating_Value_C String False

A classification or tag that is used to differentiate this call for reporting or process routing. This field helps categorize calls beyond standard type or direction attributes.

Call_Recording String True

The display name that is used for referencing the call recording. This field provides a readable label for users reviewing recorded calls.

Call_Recording_Url String False

The URL where the call recording can be accessed or downloaded. This field enables playback for compliance review, training, and case analysis.

Cj_Activity_Tpl_Name String True

The template name that is used for representing this call within Customer Journey visualizations. This field supports consistent, styled activity rendering in guided workflows.

Cj_Actual_Sort_Order String False

The position of this call activity within the sequence of Customer Journey (CJ) steps. This field defines ordering in multi-stage journey progressions.

Cj_Allow_Activity_By String False

The user roles or conditions that determine who can perform this activity within the CJ. This field supports permission-based workflow enforcement.

Cj_Blocked_By_Stages String False

The stages or milestones that prevent this call activity from progressing until prerequisites are met. This field enforces structured CJ sequencing.

Cj_Momentum_End_Date Datetime False

The date when momentum scoring for the call or journey activity ends. This field supports engagement progress analytics.

Cj_Momentum_Points Int True

The total number of momentum points that are assigned to this call in the CJ scoring model. This field supports behavioral scoring and prioritization.

Cj_Momentum_Ratio Double True

The ratio that represents momentum change or progress relative to expected journey engagement. This field provides performance-based scoring context.

Cj_Momentum_Score Int True

The computed CJ momentum score for this call. This field reflects behavioral engagement strength during the journey stage.

Cj_Momentum_Start_Date Datetime False

The date when momentum scoring for this call begins. This field marks the start of engagement scoring analysis.

Cj_Parent_Activity_Id String False

The Id of the parent CJ activity that is associated with this call. This field establishes hierarchical workflow relationships.

Cj_Parent_Activity_Type String False

The type of parent activity within the CJ. This field clarifies how this call fits into the broader journey model.

Cj_Url String False

The URL link to the CJ visualization for this call. This field allows users to navigate directly to guided workflow context.

Commentlog String True

The list or record of comments that are associated with this call. This field supports collaboration and historical reference.

Contact_Id String True

The Id of the primary contact that is associated with this call. This field links the call to a specific person for communication or service follow-up.

Contact_Name String True

The name of the contact who is associated with this call. This field provides a readable reference for the contact_id field.

Created_By String True

The Id of the user who created this call record. This field supports auditing and origin tracking.

Created_By_Name String True

The name of the user who created this call record. This field provides a readable reference for the Created_By field.

Customer_Journey_Blocked_By String False

The Customer Journey stage or condition that prevents this call activity from progressing. This field enforces structured advancement criteria.

Customer_Journey_Points String False

The number of Customer Journey points that are earned or assigned during this call. This field supports engagement scoring and progress evaluation.

Customer_Journey_Progress Double True

The percentage of progress that is made toward completing the Customer Journey stage associated with this call. This field provides numeric progress tracking.

Customer_Journey_Score Int True

The performance or engagement score that is assigned to this call in the Customer Journey model. This field is used for prioritization and analysis.

Date_End Datetime True

The date and time when the call is scheduled to end or actually ended. This field is used for scheduling accuracy and duration tracking.

Date_Entered Datetime True

The date and time when this call record was created in the system. This field supports lifecycle auditing and chronological reporting.

Date_Modified Datetime True

The date and time when this call record was most recently modified. This field enables tracking of update history.

Date_Start Datetime False

The date and time when the call is scheduled to begin or actually began. This field is essential for scheduling and timeline-based reporting.

Deleted Bool False

A Boolean field that returns a value of 'true' when the call record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and recovery.

Description String False

A narrative or explanatory text that provides details about this call. This field supports context sharing, documentation, and review.

Direction String False

The direction of the call, indicating whether it is inbound or outbound. This field supports workflow routing and performance analysis.

Dri_Subworkflow_Id String False

The Id of the subworkflow that is associated with this call in DRI workflow processing. This field links the call to workflow automation steps.

Dri_Subworkflow_Name String True

The name of the subworkflow associated with this call. This field provides a readable reference for the Dri_Subworkflow_Id field.

Dri_Subworkflow_Template_Id String False

The Id of the subworkflow template that defines the automation structure for this call. This field supports workflow standardization.

Dri_Subworkflow_Template_Name String True

The name of the subworkflow template for this call. This field provides a readable reference for the Dri_Subworkflow_Template_Id field.

Dri_Workflow_Id String False

The Id of the primary workflow in which this call participates. This field links the call to structured process automation.

Dri_Workflow_Name String True

The name of the workflow that is associated with this call. This field provides a readable reference for the Dri_Workflow_Id field.

Dri_Workflow_Sort_Order String False

The ordering position of this call activity within a workflow sequence. This field defines execution order in workflow automation.

Dri_Workflow_Task_Template_Id String False

The Id of the workflow task template that governs automated behavior for this call. This field supports standardized task logic.

Dri_Workflow_Template_Id String False

The Id of the workflow template that defines the overarching automation structure for this call. This field supports process governance.

Dri_Workflow_Template_Name String True

The name of the workflow template that is associated with this call. This field provides a readable reference for the Dri_Workflow_Template_Id field.

Duration_Hours Int False

The hours portion of the call duration. This field supports time tracking and reporting measurements.

Duration_Minutes String False

The minutes portion of the call duration. This field refines duration calculation to minute-level precision.

Email_Reminder_Checked Bool False

A Boolean field that returns a value of 'true' when the email reminder feature is enabled for this call. It returns a value of 'false' when no reminder is configured.

Email_Reminder_Sent Bool False

A Boolean field that returns a value of 'true' when an email reminder has already been sent for this call. It returns a value of 'false' when no reminder has been dispatched.

Email_Reminder_Time String False

The number of seconds before the call start time when an email reminder should be sent. A value of '-1' indicates that no reminder is configured.

Fnf_Agencies_Calls_1_Name String True

The name of the related agency record in the Fidelity National Financial (FNF) Agencies module. This field provides relationship context for agency-linked calls.

Fnf_Agencies_Calls_1fnf_Agencies_Ida String False

The Id of the related agency record in the FNF Agencies module. This field supports cross-module association.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this call to receive updates. It returns a value of 'false' when the user is not subscribed.

Id [KEY] String True

The Id for this call record. This field ensures that the call can be referenced reliably across related modules and integrations.

Internal_Notes String False

Internal notes that are associated with the call and not intended for external visibility. This field supports internal collaboration and historical record keeping.

Invitees String True

The list of users, contacts, and leads that are invited to participate in the call. This field supports attendance planning and communication coordination.

Is_Cj_Parent_Activity Bool False

A Boolean field that returns a value of 'true' when this call serves as the parent activity in a Customer Journey structure. It returns a value of 'false' when it is not the controlling activity.

Is_Customer_Journey_Activity Bool False

A Boolean field that returns a value of 'true' when this call is part of a Customer Journey sequence. It returns a value of 'false' when the call does not belong to a journey.

Lead_Id String True

The Id of the lead associated with this call. This field supports pre-sales engagement tracking.

Lead_Name String True

The name of the lead that is associated with this call. This field provides a readable reference for the lead_id field.

Locked_Fields String True

The list of fields that are locked from modification for this call record. This field preserves data integrity when certain call attributes should not be changed.

Modified_By_Name String True

The name of the user who most recently modified this call record. This field provides a readable reference for the modified_user_id field.

Modified_User_Id String True

The Id of the user who most recently modified this call record. This field supports auditing and update tracking.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the current user marks this call record as a favorite. It returns a value of 'false' when the record is not marked as a favorite.

Name String False

The brief descriptive title of the call. This field is used for identifying the call in lists, calendars, and search results.

Outlook_Id String False

The Id of the corresponding appointment in Microsoft Outlook when the Sugar Outlook Plug-in is used for synchronization. This field links Sugar calls to Outlook calendar items.

Parent_Id String False

The Id of the parent record to which this call is related, such as an Account or Case. This field supports relationship-based call organization.

Parent_Name String True

The name of the parent record associated with this call. This field provides a readable reference for the Parent_Id field.

Parent_Type String True

The type of module or object that serves as the parent for this call. This field allows the system to interpret the meaning of the Parent_Id field.

Recurrence_Id Datetime False

The reference date that identifies the base occurrence of a recurring call series. This field is used to manage recurrence relationships.

Recurring_Source String False

The originating system or feature that creates the recurrence pattern for this call. This field is used to track recurrence source logic.

Reminder_Checked Bool False

A Boolean field that returns a value of 'true' when the reminder feature is enabled for this call. It returns a value of 'false' when no reminder is configured.

Reminder_Time String False

The number of seconds prior to the call start time when a reminder should be issued. A value of '-1' indicates that no reminder is configured.

Repeat_Count Int True

The number of occurrences that are included in the call's recurrence pattern. This field controls repetition sequencing.

Repeat_Days String False

The days of the month on which recurring calls occur. This field defines day-based repetition patterns.

Repeat_Dow String False

The days of the week on which recurring calls occur. This field defines week-based repetition patterns.

Repeat_Interval Int True

The interval between recurring call occurrences (for example, every 1 week or every 2 days). This field determines spacing between events.

Repeat_Ordinal String False

The ordinal value (for example, 'first', 'second', or 'last') that applies when repeating calls by pattern. This field refines recurrence scheduling.

Repeat_Parent_Id String False

The Id of the original call in a recurring series. This field links all recurrences back to a primary reference record.

Repeat_Selector String False

The recurrence selection rule that determines how the repeat pattern is calculated. This field supports flexible recurrence definition.

Repeat_Type String False

The classification of recurrence (for example, 'daily', 'weekly', 'monthly', or 'yearly'). This field defines the repetition structure.

Repeat_Unit String False

The unit of measure (UOM) that is used in the recurrence interval, such as days or weeks. This field works with the Repeat_Interval field to define recurrence spacing.

Repeat_Until Date False

The date on which the recurring calls should stop occurring. This field provides a natural end point for recurring call patterns.

Send_Invites Bool False

A Boolean field that returns a value of 'true' when the system should send call invitations to participants. It returns a value of 'false' when invitations are not sent.

Sentiment_Score_Agent Decimal True

The overall sentiment score for the agent during the call, ranging from -5 to 5. This field supports customer experience and performance evaluation.

Sentiment_Score_Agent_First_Quarter Decimal True

The agent sentiment score during the first quarter of the call, ranging from -5 to 5. This field enables detailed conversational sentiment analysis.

Sentiment_Score_Agent_Fourth_Quarter Decimal True

The agent sentiment score during the fourth quarter of the call, ranging from -5 to 5. This field supports intra-call sentiment trend monitoring.

Sentiment_Score_Agent_Second_Quarter Decimal True

The agent sentiment score during the second quarter of the call, ranging from -5 to 5. This field contributes to phased sentiment comparison.

Sentiment_Score_Agent_String String True

The descriptive label or text interpretation of the agent's sentiment score. This field supports non-numeric sentiment review.

Sentiment_Score_Agent_Third_Quarter Decimal True

The agent sentiment score during the third quarter of the call, ranging from -5 to 5. This field supports multi-phase emotional tone analysis.

Sentiment_Score_Customer Decimal True

The overall sentiment score for the customer during the call, ranging from -5 to 5. This field supports service satisfaction and emotional tone evaluation.

Sentiment_Score_Customer_First_Quarter Decimal True

The customer sentiment score during the first quarter of the call, ranging from -5 to 5. This field provides insight into early conversation tone.

Sentiment_Score_Customer_Fourth_Quarter Decimal True

The customer sentiment score during the fourth quarter of the call, ranging from -5 to 5. This field supports end-of-call emotional evaluation.

Sentiment_Score_Customer_Second_Quarter Decimal True

The customer sentiment score during the second quarter of the call, ranging from -5 to 5. This field enables tracking sentiment evolution during the call.

Sentiment_Score_Customer_String String True

The descriptive label or text interpretation of the customer's sentiment score. This field supports non-numeric sentiment analysis.

Sentiment_Score_Customer_Third_Quarter Decimal True

The customer sentiment score during the third quarter of the call, ranging from -5 to 5. This field supports phased emotional tone tracking.

Set_Accept_Links String False

The acceptance links that are provided to call participants for confirming attendance. This field supports invitation response workflows.

Start_Next_Journey_Id String False

The Id of the next Customer Journey that begins as a result of this call. This field supports sequenced engagement automation.

Status String False

The status of the call (for example, 'Held' or 'Not Held'). This field helps classify call outcome and follow-up needs.

Sync_Key String True

The synchronization key that links this call record to external systems or data replication processes. This field supports cross-system record consistency.

Tag String False

A tag or label that is associated with this call for categorization and search filtering. This field supports record organization.

Team_Count String False

The number of teams that have access to this call record. This field supports visibility control and team-based reporting.

Team_Id String False

The Id of the primary team that is associated with this call. This team determines the default access and ownership context for the call.

Team_Name String False

The name of the primary team that is associated with this call. This field provides a readable reference for the Team_Id field.

Team_Set_Id String False

The Id of the team set that defines combined team access for this call record. This field supports shared collaboration and multi-team visibility.

Transcript String True

The call transcript text that is generated from call recordings or speech-to-text processing. This field supports quality review, compliance analysis, and training.

Type_Of_Call_C String False

The classification of the call (for example, 'introduction', 'follow-up', 'escalation', or 'support'). This field supports call-type reporting and workflow routing.

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