Power BI Connector for SugarCRM

Build 25.0.9454

DataPrivacy

Stores data privacy request and consent management records. This table supports compliance with privacy regulations and customer data handling preferences.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

The list of team names that are associated with the data privacy request record based on team-based access control.

Acl_Team_Set_Id String False

The identifier of the team set that is associated with the record to support shared ownership and collaboration permissions.

Assigned_User_Id String False

The identifier (Id) of the user who is currently assigned to manage the data privacy request.

Assigned_User_Name String True

The display name of the user who is currently assigned to manage the data privacy request.

Business_Hours_To_Resolution Decimal True

The total amount of business-hour time that elapsed between the request opening and its resolution. This field supports SLA tracking and compliance reporting.

Business_Purpose String True

A description of the business purpose for which the data privacy request was initiated. This field assists with regulatory justification and audit review.

Commentlog String True

A system-maintained log of comment entries that document discussion or review history for the request.

Created_By String True

The identifier of the user who created the data privacy request record, used for audit and ownership tracking.

Created_By_Name String True

The display name of the user who created the data privacy request record.

Dataprivacy_Number Int False

A sequential number that visually identifies the data privacy request in user interfaces and reporting dashboards.

Date_Closed Date False

The date when processing of the data privacy request was completed and the request was formally closed.

Date_Due Date False

The date by which the data privacy request must be completed. This field helps organizations meet regulatory timeframes such as General Data Protection Regulation (GDPR) response deadlines.

Date_Entered Datetime True

The date and time when the data privacy request record was created.

Date_Modified Datetime True

The date and time when the data privacy request record was most recently modified.

Date_Opened Date False

The date when the data privacy request was formally opened for processing.

Deleted Bool False

A Boolean field that returns a value of 'true' when the data privacy request record is marked for deletion. It returns a value of 'false' when the record remains active. This supports soft-delete lifecycle management.

Description String False

A free-form description that provides additional detail regarding the nature, scope, or intent of the data privacy request.

Fields_To_Erase String False

A list of fields that are designated to be erased or anonymized as part of fulfilling the data privacy request.

Follow_Up_Datetime Datetime False

The date and time by which follow-up communication or action must occur. This field supports SLA and workflow tracking.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following the record to receive notifications. It returns a value of 'false' when the user is not following the record.

Hours_To_Resolution Decimal True

The total amount of calendar time, in hours, that elapsed between the opening and closing of the data privacy request.

Id [KEY] String True

The unique Id for the data privacy request record.

Locked_Fields String True

A list of fields that are restricted from modification because of administrative or workflow enforcement.

Modified_By_Name String True

The display name of the user who last modified the data privacy request record.

Modified_User_Id String True

The Id of the user who last modified the data privacy request record. This field supports change tracking and accountability.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the record is marked as a favorite by the user for quick access. It returns a value of 'false' when the record is not marked as a favorite.

Name String False

A short, human-readable title that identifies the data privacy request in user interfaces and lists.

Pending_Processing Bool True

A Boolean field that returns a value of 'true' when request processing is still underway or awaiting completion. It returns a value of 'false' when no further processing remains.

Priority String False

The assigned priority level of the data privacy request, which determines response order and urgency based on internal workflow or compliance requirements.

Requested_By String False

The name of the individual who submitted the request or the stakeholder responsible for initiating it.

Resolution String False

The explanation of how the data privacy request was fulfilled, including whether data was erased, anonymized, corrected, or otherwise processed.

Resolved_Datetime Datetime False

The date and time when processing of the request was completed.

Source String False

The origin of the request, indicating how or where it was submitted (for example, customer self-service portal or internal compliance workflow).

Status String False

The current stage of the data privacy request in the review and fulfillment lifecycle.

Sync_Key String True

A synchronization key that supports matching and correlation across connected systems during data migration or API synchronization.

Tag String False

A set of user-defined keywords that support filtering, grouping, and search.

Team_Count String False

The number of teams that are associated with the record under team security configuration.

Team_Id String False

The Id of the primary team that is associated with the data privacy request for access control and reporting.

Team_Name String False

The display name of the primary team that is associated with the data privacy request.

Team_Set_Id String False

The Id of the complete team set that is assigned to the record to support collaborative ownership.

Type String False

The type of data privacy request, such as data erasure, access review, correction request, or consent withdrawal.

Widget_Follow_Up_Datetime String True

The UI widget representation of the follow-up deadline for visual dashboards or console displays.

Work_Log String False

A free-form log that is used to record actions, decisions, or processing notes associated with the request.

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