Power BI Connector for ServiceNow

Build 25.0.9454

problem_sla

Tracks Service Level Agreement (SLA) compliance for problem records to ensure service-level targets are achieved.

Columns

Name Type References Description
taskslatable_sys_id String Provides the system identifier (sys_id) for the problem SLA task record.
taskslatable_active Bool Indicates whether the problem SLA task record is currently active.
taskslatable_business_duration Long Shows the total business duration tracked for the SLA task, excluding non-working hours.
taskslatable_business_pause_duration Long Displays the total time the SLA task was paused during business hours.
taskslatable_business_percentage Decimal Indicates the percentage of the SLA elapsed within business hours.
taskslatable_business_time_left Long Shows the remaining business time before the SLA breach, expressed in milliseconds.
taskslatable_duration Long Displays the total elapsed time of the SLA task, including non-business hours.
taskslatable_end_time Datetime Specifies the date and time when the SLA task ended.
taskslatable_has_breached Bool Indicates whether the SLA task has breached its defined target.
taskslatable_original_breach_time Datetime Shows the initially calculated breach time for the SLA task.
taskslatable_pause_duration Long Displays the total duration for which the SLA task was paused.
taskslatable_pause_time Datetime Specifies when the SLA task was last paused.
taskslatable_percentage Decimal Indicates the overall SLA completion percentage based on elapsed time.
taskslatable_planned_end_time Datetime Shows the planned completion time for the SLA task.
taskslatable_schedule String References the schedule used to calculate SLA timelines for the task.
taskslatable_schedule_link String Provides a link to the related schedule record used by the SLA.
taskslatable_sla String Specifies the service level agreement definition applied to the problem.
taskslatable_sla_link String Provides a link to the related SLA definition record.
taskslatable_stage String Indicates the current stage of the SLA task, such as in progress or completed.
taskslatable_start_time Datetime Shows when the SLA tracking began for the problem record.
taskslatable_sys_created_by String Identifies the user who created the SLA task record.
taskslatable_sys_created_on Datetime Displays the date and time when the SLA task record was created.
taskslatable_sys_mod_count Int Tracks how many times the SLA task record has been modified.
taskslatable_sys_tags String Lists tags associated with the SLA task record for tracking or reporting.
taskslatable_sys_updated_by String Indicates the user who last updated the SLA task record.
taskslatable_sys_updated_on Datetime Shows the date and time when the SLA task record was last updated.
taskslatable_task String References the problem task associated with this SLA record.
taskslatable_task_link String Provides a link to the related problem task record.
taskslatable_time_left Long Displays the remaining time before the SLA target is breached, in milliseconds.
taskslatable_timezone String Specifies the time zone used for calculating the SLA times.
prb_sys_id String Provides the sys_id for the problem record linked to the SLA.
prb_active Bool Indicates whether the problem record is active or resolved.
prb_activity_due Datetime Shows the date and time when the next action or activity is due for the problem.
prb_additional_assignee_list String Lists additional users assigned to the problem for collaboration.
prb_approval String Specifies the current approval status of the problem record.
prb_approval_history String Displays a log of previous approvals associated with the problem.
prb_approval_set Datetime Indicates when the approval status was last updated.
prb_assigned_to String Identifies the user currently assigned to the problem.
prb_assigned_to_link String Provides a link to the user record of the assigned individual.
prb_assignment_group String Specifies the group responsible for managing the problem.
prb_assignment_group_link String Provides a link to the related assignment group record.
prb_business_duration Long Shows the total business duration from the problem's creation to its resolution.
prb_business_service String References the business service affected by the problem.
prb_business_service_link String Provides a link to the related business service record.
prb_calendar_duration Long Displays the total calendar time between problem creation and resolution.
prb_close_notes String Contains closure notes added when resolving the problem.
prb_closed_at Datetime Indicates the date and time when the problem was closed.
prb_closed_by String Identifies the user who closed the problem.
prb_closed_by_link String Provides a link to the user record of the person who closed the problem.
prb_cmdb_ci String References the Configuration Item (CI) associated with the problem.
prb_cmdb_ci_link String Provides a link to the related configuration item record.
prb_comments String Contains user comments added to the problem record.
prb_comments_and_work_notes String Combines user comments and work notes for a full activity history.
prb_company String Specifies the company associated with the problem record.
prb_company_link String Provides a link to the related company record.
prb_contact_type String Indicates how the problem was reported, such as by phone or portal.
prb_correlation_display String Displays correlation data linking the problem to other records.
prb_correlation_id String Contains a unique correlation identifier for tracking related problems.
prb_delivery_plan String References the delivery plan associated with the problem's resolution process.
prb_delivery_plan_link String Provides a link to the related delivery plan record.
prb_delivery_task String Specifies the delivery task associated with the problem.
prb_delivery_task_link String Provides a link to the related delivery task record.
prb_description String Describes the details, symptoms, and potential impact of the problem.
prb_due_date Datetime Indicates the date and time when the problem resolution is expected.
prb_escalation Int Shows the current escalation level for the problem.
prb_expected_start Datetime Specifies when work on the problem is expected to begin.
prb_follow_up Datetime Indicates when a follow-up is scheduled to monitor progress.
prb_group_list String Lists the groups involved in resolving the problem.
prb_impact Int Represents the business impact level assigned to the problem.
prb_knowledge Bool Indicates whether the problem is marked for conversion into a knowledge article.
prb_known_error Bool Specifies whether the problem has been classified as a known error.
prb_location String Identifies the physical or organizational location associated with the problem.
prb_location_link String Provides a link to the related location record.
prb_made_sla Bool Indicates whether the problem met its SLA targets.
prb_major_problem Bool Specifies whether the problem is classified as a major problem.
prb_number String Displays the unique identifier assigned to the problem record.
prb_opened_at Datetime Shows when the problem record was created.
prb_opened_by String Identifies the user who created the problem record.
prb_opened_by_link String Provides a link to the record of the problem's creator.
prb_order Int Specifies the problem's order or display sequence within its category.
prb_parent String References the parent problem record, if this problem is related to another.
prb_parent_link String Provides a link to the related parent problem record.
prb_priority Int Indicates the priority of the problem based on impact and urgency.
prb_problem_state Int Represents the current state of the problem, such as open or resolved.
prb_reassignment_count Int Tracks how many times the problem was reassigned to another user or group.
prb_rejection_goto String Specifies the redirection path if the problem's approval is rejected.
prb_rejection_goto_link String Provides a link to the related rejection redirection record.
prb_related_incidents Int Shows the number of incidents linked to this problem record.
prb_review_outcome String Describes the outcome of the problem review process.
prb_rfc String References the Request for Change (RFC) related to this problem.
prb_rfc_link String Provides a link to the related RFC record.
prb_route_reason Int Indicates the routing reason used in problem workflows.
prb_service_offering String Specifies the service offering affected by the problem.
prb_service_offering_link String Provides a link to the related service offering record.
prb_short_description String Gives a brief summary of the problem for quick identification.
prb_sla_due Datetime Displays when the problem's SLA resolution is due.
prb_state Int Indicates the workflow state of the problem record.
prb_sys_class_name String Defines the system class name for the problem record.
prb_sys_created_by String Identifies the user who created the problem record.
prb_sys_created_on Datetime Shows the date and time when the problem record was created.
prb_sys_domain String Specifies the domain to which the problem record belongs.
prb_sys_domain_path String Displays the full domain path for the problem record.
prb_sys_mod_count Int Tracks how many times the problem record has been modified.
prb_sys_tags String Lists tags applied to the problem record for categorization or reporting.
prb_sys_updated_by String Indicates the user who last updated the problem record.
prb_sys_updated_on Datetime Shows the date and time when the problem record was last updated.
prb_task_effective_number String Specifies the effective task number used to track problem activities.
prb_time_worked String Displays the total time worked on the problem in hours or minutes.
prb_u_comments String Contains user-defined comments related to the problem.
prb_u_some_test_field String Stores custom field data used for testing or configuration purposes.
prb_universal_request String References the related universal request record, if applicable.
prb_universal_request_link String Provides a link to the associated universal request record.
prb_upon_approval String Defines the action to be taken when the problem is approved.
prb_upon_reject String Defines the action to be taken when the problem is rejected.
prb_urgency Int Indicates how quickly the problem requires attention based on its business impact.
prb_user_input String Captures additional input or notes provided by users regarding the problem.
prb_variables String Stores variable data linked to workflows or automation for the problem record.
prb_watch_list String Lists users who are notified of changes or updates to the problem.
prb_wf_activity String References the workflow activity associated with the problem.
prb_wf_activity_link String Provides a link to the related workflow activity record.
prb_work_around String Describes the temporary workaround used to mitigate the problem's impact.
prb_work_end Datetime Specifies when work on the problem was completed.
prb_work_notes String Contains notes entered by users while working on the problem.
prb_work_notes_list String Lists all work notes associated with the problem record.
prb_work_start Datetime Indicates when work on the problem began.

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