Power BI Connector for ServiceNow

Build 25.0.9454

change_task_sla

Displays Service Level Agreement (SLA) data for individual change tasks to help monitor compliance and response speed.

Columns

Name Type References Description
taskslatable_sys_id String Lists the system identifier (sys_id) that uniquely identifies each task SLA record in ServiceNow.
taskslatable_active Bool Indicates whether the task SLA record is currently active and being tracked.
taskslatable_business_duration Long Tracks the total business duration spent on the task, excluding non-working hours.
taskslatable_business_pause_duration Long Records the time the SLA was paused during business hours.
taskslatable_business_percentage Decimal Displays the percentage of business time elapsed toward the SLA target.
taskslatable_business_time_left Long Lists the amount of business time remaining before the SLA target is reached.
taskslatable_duration Long Tracks the total duration of the SLA, including business and non-business hours.
taskslatable_end_time Datetime Displays the date and time when the SLA tracking ended, either successfully or upon breach.
taskslatable_has_breached Bool Indicates whether the task SLA has breached its target.
taskslatable_original_breach_time Datetime Lists the originally calculated time when the SLA was expected to breach before any changes.
taskslatable_pause_duration Long Tracks the total duration that the SLA was paused during its lifecycle.
taskslatable_pause_time Datetime Displays the date and time when the SLA was last paused.
taskslatable_percentage Decimal Shows the percentage of total time that has elapsed for the SLA instance.
taskslatable_planned_end_time Datetime Lists the planned completion time for the SLA based on configured schedules.
taskslatable_schedule String Specifies the working schedule applied to the SLA for calculating time metrics.
taskslatable_schedule_link String Provides the hyperlink reference to the schedule record associated with the SLA.
taskslatable_sla String References the SLA definition applied to the task.
taskslatable_sla_link String Provides the hyperlink reference to the SLA definition record in ServiceNow.
taskslatable_stage String Displays the current stage of the SLA, such as In Progress, Paused, or Completed.
taskslatable_start_time Datetime Lists the date and time when SLA tracking began for the task.
taskslatable_sys_created_by String Shows the user or process that created the task SLA record.
taskslatable_sys_created_on Datetime Displays the date and time when the task SLA record was created in ServiceNow.
taskslatable_sys_mod_count Int Tracks how many times the task SLA record has been modified since creation.
taskslatable_sys_tags String Lists any system tags applied to the task SLA for classification or reporting.
taskslatable_sys_updated_by String Shows the user or process that last updated the task SLA record.
taskslatable_sys_updated_on Datetime Displays the date and time when the task SLA record was last updated.
taskslatable_task String References the task associated with the SLA tracking record, such as a change task.
taskslatable_task_link String Provides the hyperlink reference to the related task record in ServiceNow.
taskslatable_time_left Long Lists the total remaining time before the SLA is due to breach.
taskslatable_timezone String Specifies the time zone used for SLA calculations, based on the associated schedule.
cht_sys_id String Lists the sys_id that uniquely identifies each change task record linked to the SLA.
cht_active Bool Indicates whether the change task associated with the SLA is currently active.
cht_activity_due Datetime Specifies the date and time when the next workflow activity for the change task is due.
cht_additional_assignee_list String Lists additional users or groups assisting with completing the change task.
cht_approval String Shows the approval status of the change task, such as requested, approved, or rejected.
cht_approval_history String Displays the full history of approvals related to the change task.
cht_approval_set Datetime Lists the date and time when the change task approval status was last updated.
cht_assigned_to String Identifies the user currently assigned to perform the change task.
cht_assigned_to_link String Provides the hyperlink reference to the assigned user's record in ServiceNow.
cht_assignment_group String Lists the group responsible for executing or managing the change task.
cht_assignment_group_link String Provides the hyperlink reference to the group record associated with the change task.
cht_business_duration Long Tracks the total business duration of the change task, excluding non-working hours.
cht_business_service String Lists the business service affected or supported by the change task.
cht_business_service_link String Provides the hyperlink reference to the business service record in ServiceNow.
cht_calendar_duration Long Tracks the total calendar duration of the change task, including business and non-business hours.
cht_change_request String References the parent change request associated with the change task.
cht_change_request_link String Provides the hyperlink reference to the parent change request record in ServiceNow.
cht_change_task_type String Specifies the type of change task, such as implementation, review, or test.
cht_close_code String Lists the closure code describing how the change task was resolved, such as successful or canceled.
cht_close_notes String Provides notes entered at closure, summarizing task results and observations.
cht_closed_at Datetime Displays the date and time when the change task was closed.
cht_closed_by String Identifies the user who completed and closed the change task.
cht_closed_by_link String Provides the hyperlink reference to the user record who closed the task.
cht_cmdb_ci String References the Configuration Item (CI) from the Configuration Management Database (CMDB) affected by the change task.
cht_cmdb_ci_link String Provides the hyperlink reference to the CI record in the CMDB.
cht_comments String Stores user comments describing progress, updates, or issues related to the change task.
cht_comments_and_work_notes String Combines user comments and work notes to maintain a complete activity log for the change task.
cht_company String Lists the company or organization associated with the change task.
cht_company_link String Provides the hyperlink reference to the company record in ServiceNow.
cht_contact_type String Specifies how the change task was initiated, such as by phone, email, or self-service portal.
cht_correlation_display String Displays a readable reference linking the change task to other related records.
cht_correlation_id String Stores a unique correlation identifier that connects the change task with external systems or processes.
cht_created_from String Identifies the record or process from which the change task originated.
cht_delivery_plan String Specifies the delivery plan guiding the execution and timing of the change task.
cht_delivery_plan_link String Provides the hyperlink reference to the delivery plan record associated with the change task.
cht_delivery_task String References the related delivery task connected to this change task.
cht_delivery_task_link String Provides the hyperlink reference to the delivery task record in ServiceNow.
cht_description String Provides a detailed description of the change task, outlining objectives and execution steps.
cht_due_date Datetime Displays the date and time when the change task must be completed.
cht_escalation Int Specifies the escalation level of the change task, determined by urgency or impact.
cht_expected_start Datetime Lists the expected start date and time for the change task execution.
cht_follow_up Datetime Displays the date and time scheduled for reviewing or following up on the change task.
cht_group_list String Lists all user groups involved in reviewing, approving, or performing the change task.
cht_impact Int Represents the numeric code indicating the level of impact the change task has on services or systems.
cht_knowledge Bool Indicates whether the change task is linked to a Knowledge Base article.
cht_location String Lists the physical or organizational location associated with the change task.
cht_location_link String Provides the hyperlink reference to the location record in ServiceNow.
cht_made_sla Bool Indicates whether the SLA objectives for the change task were met.
cht_number String Displays the unique identification number assigned to the change task record.
cht_on_hold Bool Indicates whether the change task is currently on hold.
cht_on_hold_reason String Specifies the reason why the change task is on hold, such as dependency or pending approval.
cht_opened_at Datetime Displays the date and time when the change task was created or opened.
cht_opened_by String Identifies the user who created or opened the change task.
cht_opened_by_link String Provides the hyperlink reference to the user record who opened the task.
cht_order Int Specifies the execution order of the change task within a change request or workflow.
cht_parent String References the parent record or process linked to the change task.
cht_parent_link String Provides the hyperlink reference to the parent record in ServiceNow.
cht_planned_end_date Datetime Lists the planned end date and time for completing the change task.
cht_planned_start_date Datetime Lists the planned start date and time for beginning the change task.
cht_priority Int Specifies the priority level of the change task, calculated from impact and urgency values.
cht_reassignment_count Int Tracks the number of times the change task was reassigned to different users or groups.
cht_rejection_goto String Specifies the workflow state to which the system transitions the change task if it is rejected.
cht_rejection_goto_link String Provides the hyperlink reference to the rejection state or workflow transition record.
cht_route_reason Int Lists the routing reason code that determines workflow transitions for the change task.
cht_service_offering String Lists the service offering affected by the change task.
cht_service_offering_link String Provides the hyperlink reference to the related service offering record.
cht_short_description String Provides a concise summary of the change task, describing its main purpose or goal.
cht_sla_due Datetime Displays the date and time by which the SLA objectives for the change task must be met.
cht_state Int Represents the numeric code for the current state of the change task, such as 1 = New or 3 = Approved.
cht_sys_class_name String Specifies the system class name of the change task record in the ServiceNow schema.
cht_sys_created_by String Shows the user or system process that originally created the change task record.
cht_sys_created_on Datetime Displays the date and time when the change task record was created in ServiceNow.
cht_sys_domain String Specifies the domain to which the change task belongs in multi-domain environments.
cht_sys_domain_path String Defines the hierarchical path representing the domain structure for the change task record.
cht_sys_mod_count Int Tracks the total number of times the change task record has been modified since creation.
cht_sys_tags String Lists any system tags applied to the change task record for filtering or reporting.
cht_sys_updated_by String Shows the user or process that last modified the change task record.
cht_sys_updated_on Datetime Displays the date and time when the change task record was last updated.
cht_task_effective_number String Lists the effective task number used to maintain consistent tracking across related records.
cht_time_worked String Tracks the total time spent working on the change task.
cht_u_comments String Stores additional user comments or notes added for the change task.
cht_u_some_test_field String Holds values for a custom test field used for internal testing or validation.
cht_universal_request String References a universal request that triggered or relates to the change task.
cht_universal_request_link String Provides the hyperlink reference to the universal request record in ServiceNow.
cht_upon_approval String Specifies the automated workflow action executed when the change task is approved.
cht_upon_reject String Defines the automated workflow action triggered when the change task is rejected.
cht_urgency Int Represents the numeric urgency value of the change task, where a lower number means higher urgency.
cht_user_input String Stores user-provided input or additional form data associated with the change task.
cht_variables String Lists variable values captured through dynamic form fields for the change task.
cht_watch_list String Lists the users or groups receiving notifications and updates about the change task.
cht_wf_activity String References the workflow activity record associated with the automated flow of the change task.
cht_wf_activity_link String Provides the hyperlink reference to the workflow activity record in ServiceNow.
cht_work_end Datetime Lists the date and time when work on the change task was completed.
cht_work_notes String Stores work notes entered by users to document progress, troubleshooting, or decisions made during the change task.
cht_work_notes_list String Displays the complete list of all historical work notes for the change task.
cht_work_start Datetime Lists the date and time when work on the change task began.

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