Power BI Connector for ServiceNow

Build 25.0.9454

sc_task_sla

Tracks Service Level Agreement (SLA) adherence for Service Catalog (SC) tasks to ensure timely completion and quality.

Columns

Name Type References Description
taskslatable_sys_id String Provides the system identifier (sys_id) for the SLA record associated with this SC task.
taskslatable_active Bool Indicates whether the SLA record is currently active and being tracked against service targets.
taskslatable_business_duration Long Captures the total business time spent on the task in compliance with business hours, excluding weekends and holidays.
taskslatable_business_pause_duration Long Records the amount of business time during which the SLA countdown was paused, such as when the task was on hold.
taskslatable_business_percentage Decimal Displays the percentage of business time elapsed relative to the SLA target.
taskslatable_business_time_left Long Shows the remaining business time before the SLA breach threshold is reached.
taskslatable_duration Long Represents the total elapsed time for SLA tracking, including both business and non-business hours.
taskslatable_end_time Datetime Specifies when SLA measurement ended, typically when the task was closed.
taskslatable_has_breached Bool Indicates whether the SLA target was breached, meaning the defined completion time was exceeded.
taskslatable_original_breach_time Datetime Stores the original projected breach time before any SLA recalculations or pauses.
taskslatable_pause_duration Long Captures the total time, in milliseconds, for which the SLA countdown was paused.
taskslatable_pause_time Datetime Records the last time the SLA was paused for this task.
taskslatable_percentage Decimal Shows the overall progress toward SLA completion as a percentage of total time.
taskslatable_planned_end_time Datetime Specifies the planned or expected end time defined in the SLA agreement.
taskslatable_schedule String References the work schedule that determines the business hours used for SLA calculations.
taskslatable_schedule_link String Provides a link to the schedule record defining the business hours and time zone used in SLA evaluation.
taskslatable_sla String References the SLA definition applied to this task.
taskslatable_sla_link String Provides a link to the SLA definition record used for tracking performance.
taskslatable_stage String Indicates the current SLA stage, such as in progress, paused, or completed.
taskslatable_start_time Datetime Records when SLA tracking began for the task.
taskslatable_sys_created_by String Identifies the user who created the SLA record.
taskslatable_sys_created_on Datetime Records when the SLA record was first created.
taskslatable_sys_mod_count Int Tracks the number of times the SLA record has been modified.
taskslatable_sys_tags String Stores tags or metadata used to categorize and filter SLA records.
taskslatable_sys_updated_by String Identifies the user who last updated the SLA record.
taskslatable_sys_updated_on Datetime Records the date and time when the SLA record was last updated.
taskslatable_task String References the SC task linked to this SLA record.
taskslatable_task_link String Provides a link to the task record monitored by the SLA.
taskslatable_time_left Long Displays the remaining time, in business hours, before the SLA is breached.
taskslatable_timezone String Specifies the time zone used for SLA calculations and timestamps.
sct_sys_id String Provides the sys_id for the SC task record used to track fulfillment progress.
sct_active Bool Indicates whether the task is currently active and in progress.
sct_activity_due Datetime Specifies when the next scheduled activity or workflow step for the task is due.
sct_additional_assignee_list String Lists additional users assigned to collaborate on completing the task.
sct_approval String Shows the task's current approval status, such as requested, approved, or rejected.
sct_approval_history String Stores the complete history of approvals, including approvers, decisions, and timestamps.
sct_approval_set Datetime Records the date and time when the approval status was last updated.
sct_assigned_to String Identifies the user currently responsible for fulfilling the task.
sct_assigned_to_link String Provides a link to the user record assigned to the task.
sct_assignment_group String References the group responsible for managing or resolving the task.
sct_assignment_group_link String Provides a link to the assignment group record.
sct_business_duration Long Captures the total business time spent on the task, excluding non-working hours.
sct_business_service String References the business service associated with the task.
sct_business_service_link String Provides a link to the business service record connected to the task.
sct_calendar_duration Long Shows the total elapsed time from task creation to completion, including weekends and holidays.
sct_calendar_stc Int Represents the total calendar duration in seconds, used for analytics and reporting.
sct_close_notes String Contains closure notes or remarks entered when the task was completed.
sct_closed_at Datetime Records the date and time when the task was closed.
sct_closed_by String Identifies the user who closed the task.
sct_closed_by_link String Provides a link to the record of the user who closed the task.
sct_cmdb_ci String References the Configuration Item (CI) associated with the task.
sct_cmdb_ci_link String Provides a link to the CI record related to the task.
sct_comments String Captures user-entered comments related to the task.
sct_comments_and_work_notes String Stores both customer-facing comments and internal work notes used by fulfillers.
sct_company String References the company or organizational entity associated with the task.
sct_company_link String Provides a link to the company record related to the task.
sct_contact_type String Indicates how the task was initiated, such as through the service portal, email, or workflow automation.
sct_correlation_display String Displays a readable reference for correlating the task with external systems or processes.
sct_correlation_id String Stores a unique identifier linking the task to integrations or external records.
sct_delivery_plan String References the delivery plan that outlines fulfillment steps for the task.
sct_delivery_plan_link String Provides a link to the delivery plan record.
sct_delivery_task String References the related delivery task responsible for executing a service component.
sct_delivery_task_link String Provides a link to the delivery task record.
sct_description String Provides a detailed description of the task and its purpose.
sct_due_date Datetime Indicates the date and time when the task is expected to be completed.
sct_escalation Int Shows the escalation level, indicating whether the task has been elevated for faster resolution.
sct_expected_start Datetime Specifies when the task is expected to begin based on scheduling or workflow conditions.
sct_follow_up Datetime Defines a date for follow-up actions or reviews related to the task.
sct_group_list String Lists all groups that have participated in processing or approving the task.
sct_impact Int Represents the level of business impact if the task is delayed or unresolved.
sct_knowledge Bool Indicates whether the task resulted in creating or referencing a knowledge article.
sct_location String References the location associated with the task, such as the requester's site.
sct_location_link String Provides a link to the location record.
sct_made_sla Bool Indicates whether the task met its SLA targets.
sct_number String Stores the unique task number automatically generated for tracking purposes.
sct_opened_at Datetime Records the timestamp when the task was created or opened.
sct_opened_by String Identifies the user who created or initiated the task.
sct_opened_by_link String Provides a link to the user record of the person who opened the task.
sct_order Int Specifies the order in which this task appears or is processed in workflows.
sct_parent String References the parent record associated with the task, such as the service request.
sct_parent_link String Provides a link to the parent record in the hierarchy.
sct_priority Int Represents the task's priority, based on its urgency and impact.
sct_reassignment_count Int Tracks how many times the task has been reassigned between users or groups.
sct_rejection_goto String Specifies the workflow stage the process moves to when the task is rejected.
sct_rejection_goto_link String Provides a link to the workflow element triggered upon rejection.
sct_request String References the overall service request associated with this task.
sct_request_item String References the specific catalog item linked to the task.
sct_request_item_link String Provides a link to the catalog item record.
sct_request_link String Provides a link to the parent service request record.
sct_route_reason Int Displays the reason or rule used for routing the task to its assigned group.
sct_sc_catalog String References the SC associated with this task.
sct_sc_catalog_link String Provides a link to the SC record.
sct_service_offering String References the service offering that defines the type of service fulfilled through this task.
sct_service_offering_link String Provides a link to the related service offering record.
sct_short_description String Provides a concise summary describing the purpose of the task.
sct_sla_due Datetime Specifies the date and time by which the SLA target must be achieved for this task.
sct_state Int Represents the current workflow state, such as open, in progress, or closed.
sct_sys_class_name String Defines the system class for the record, determining its form and workflow behavior.
sct_sys_created_by String Identifies the user who created the task record.
sct_sys_created_on Datetime Records when the task record was created.
sct_sys_domain String Specifies the domain associated with this task record in domain-separated instances.
sct_sys_domain_path String Displays the hierarchical domain path for the record.
sct_sys_mod_count Int Tracks how many times the task record has been modified.
sct_sys_tags String Stores metadata tags used to organize or filter task records.
sct_sys_updated_by String Identifies the user who last updated the task record.
sct_sys_updated_on Datetime Records when the task record was last updated.
sct_task_effective_number String Stores the effective task number used for tracking and reporting.
sct_time_worked String Displays the total amount of time logged as work on the task.
sct_u_comments String Captures additional comments or notes added by users or fulfillers.
sct_u_some_test_field String Represents a custom test field used for configuration or internal validation.
sct_universal_request String References a universal request record grouping related catalog or workflow activities.
sct_universal_request_link String Provides a link to the universal request record.
sct_upon_approval String Defines the automatic action performed when the task is approved.
sct_upon_reject String Defines the automatic action performed when the task is rejected.
sct_urgency Int Indicates how urgently the task must be fulfilled, contributing to the priority calculation.
sct_user_input String Captures data entered by the user during task submission or updates.
sct_variables String Stores variable data or dynamic form inputs associated with the task.
sct_watch_list String Lists users who receive notifications about updates to this task.
sct_wf_activity String References the workflow activity currently executing for the task.
sct_wf_activity_link String Provides a link to the workflow activity record.
sct_work_end Datetime Records when work on the task was completed.
sct_work_notes String Contains internal work notes added by fulfillers during the task lifecycle.
sct_work_notes_list String Stores all work notes associated with the task for auditing and visibility.
sct_work_start Datetime Records when work on the task began.

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