CData Python Connector for SugarCRM

Build 25.0.9454

ChangeTimers

Stores timing measurements that are associated with workflow transitions. This table supports service-level agreement (SLA) tracking and process performance analysis.

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier (Id) for this change timer record. This field ensures consistent reference across reporting and workflow processing.

Name String False

The descriptive name of the change timer. This field is used to identify the timer in lists and configuration screens.

Date_Entered Datetime True

The date and time when this change timer record was created. This field supports audit trails and lifecycle tracking.

Date_Modified Datetime True

The date and time when this change timer record was most recently modified. This field supports update tracking and audit compliance.

Modified_User_Id String True

The Id of the user who most recently modified this change timer record. This field supports accountability and historical review.

Modified_By_Name String True

The name of the user who most recently modified this change timer. This field provides a readable reference for the Modified_User_Id field.

Created_By String True

The Id of the user who created this change timer record. This field supports origin tracking and audit review.

Created_By_Name String True

The name of the user who created this change timer. This field provides a readable reference for the created_by field.

Description String False

The full text description of the change timer. This field provides explanatory detail about how or why the timer is used.

Deleted Bool False

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

Parent_Type String False

The type of record to which the timer applies (for example, 'Case' or 'Opportunity'). This field defines the business context of the timing measurement.

Parent_Id String False

The Id of the record to which the timer applies. This field links the timer to the specific business object that is being tracked.

Field_Name String False

The name of the field whose value change triggers or ends the timing measurement. This field identifies the condition that is being monitored.

Value_String String False

The field value that defines the timer condition, such as a specific status. The timer measures how long the parent record remains in this value state.

From_Datetime Datetime False

The date and time when the timer starts. This field marks the beginning of the measured duration.

To_Datetime Datetime False

The date and time when the timer stops. This field marks the end of the measured duration.

Hours Decimal True

The total time elapsed between the start and stop of the timer, measured in calendar hours. This field supports performance and duration reporting.

Business_Hours Decimal True

The total time elapsed between the start and stop of the timer, measured in business hours according to applicable service schedules. This field supports reporting based on service-level agreements.

Following Bool False

A Boolean field that returns a value of 'true' when the current user follows this record for updates. It returns a value of 'false' when the user is not following the record.

My_Favorite Bool False

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

Sync_Key String True

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

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