Power BI Connector for ServiceNow

Build 25.0.9454

sc_req_item_sla

Displays Service Level Agreement (SLA) compliance details for request items in the Service Catalog (SC).

Columns

Name Type References Description
taskslatable_sys_id String Provides the system identifier (sys_id) for the SLA task record that tracks service-level compliance for each requested item.
taskslatable_active Bool Indicates whether the SLA record is currently active and being measured against defined service targets.
taskslatable_business_duration Long Captures the total business time spent toward fulfilling the SLA, excluding non-working hours such as weekends or holidays.
taskslatable_business_pause_duration Long Records the total business time during which the SLA countdown was paused, such as when the item was on hold.
taskslatable_business_percentage Decimal Shows the percentage of business time elapsed relative to the SLA target.
taskslatable_business_time_left Long Represents the remaining business time available before the SLA breach occurs.
taskslatable_duration Long Displays the total elapsed time, including both working and non-working hours, for the SLA tracking period.
taskslatable_end_time Datetime Specifies when the SLA measurement ended, typically when the request was completed or closed.
taskslatable_has_breached Bool Indicates whether the SLA target was breached, meaning the defined time limit was exceeded.
taskslatable_original_breach_time Datetime Stores the initially calculated breach time for the SLA before any adjustments or pauses.
taskslatable_pause_duration Long Captures the total amount of time the SLA was paused, regardless of business hours.
taskslatable_pause_time Datetime Indicates when the SLA was last paused, typically due to a status change or dependency.
taskslatable_percentage Decimal Displays the total progress toward the SLA target as a percentage, combining both business and calendar time.
taskslatable_planned_end_time Datetime Specifies the planned or target end time for the SLA based on its definition.
taskslatable_schedule String References the schedule used to calculate business hours for SLA measurement.
taskslatable_schedule_link String Provides a link to the schedule record defining working hours for the SLA.
taskslatable_sla String References the specific SLA definition applied to this requested item.
taskslatable_sla_link String Provides a link to the SLA definition record used for performance tracking.
taskslatable_stage String Indicates the current stage of the SLA, such as in progress, paused, or completed.
taskslatable_start_time Datetime Records when SLA tracking began for this requested item.
taskslatable_sys_created_by String Indicates the user who created the SLA task record.
taskslatable_sys_created_on Datetime Records when the SLA task record was first created.
taskslatable_sys_mod_count Int Tracks how many times the SLA record has been modified.
taskslatable_sys_tags String Stores tags or metadata for organizing and filtering SLA records.
taskslatable_sys_updated_by String Indicates the user who last updated the SLA task record.
taskslatable_sys_updated_on Datetime Records the date and time when the SLA task record was last modified.
taskslatable_task String References the catalog item or task that this SLA record monitors.
taskslatable_task_link String Provides a link to the associated task or catalog item record.
taskslatable_time_left Long Displays the remaining total time (business and calendar) before the SLA target is breached.
taskslatable_timezone String Specifies the time zone used for SLA time calculations and timestamps.
sci_sys_id String Provides the sys_id for the requested item associated with this SLA record.
sci_active Bool Indicates whether the requested item is active and currently being fulfilled.
sci_activity_due Datetime Specifies when the next activity or workflow step related to the request is due.
sci_additional_assignee_list String Lists additional users assigned to collaborate on fulfilling the request.
sci_approval String Shows the current approval state of the requested item, such as pending, approved, or rejected.
sci_approval_history String Contains the full approval history for the request, including approvers and timestamps.
sci_approval_set Datetime Records when the approval status was most recently set or changed.
sci_assigned_to String Identifies the user responsible for fulfilling this requested item.
sci_assigned_to_link String Provides a link to the user record assigned to the request.
sci_assignment_group String References the group responsible for handling or processing the request.
sci_assignment_group_link String Provides a link to the assignment group record.
sci_backordered Bool Indicates whether the requested item has been backordered due to lack of availability.
sci_billable Bool Specifies whether the requested item is billable and contributes to financial chargeback or cost recovery.
sci_business_duration Long Captures the total business time spent on fulfilling the requested item, excluding non-working hours.
sci_business_service String References the business service that the request supports or affects.
sci_business_service_link String Provides a link to the related business service record.
sci_calendar_duration Long Shows the total elapsed time from creation to completion of the requested item, including non-business hours.
sci_cat_item String References the catalog item that was requested through the SC.
sci_cat_item_link String Provides a link to the catalog item record associated with the request.
sci_close_notes String Contains final notes or closure remarks entered when the request was completed.
sci_closed_at Datetime Records the date and time when the requested item was marked as closed.
sci_closed_by String Identifies the user who closed the requested item record.
sci_closed_by_link String Provides a link to the record of the user who closed the request.
sci_cmdb_ci String References the Configuration Item (CI) related to the requested item.
sci_cmdb_ci_link String Provides a link to the CI record associated with this request.
sci_comments String Captures user-entered comments or notes regarding the requested item.
sci_comments_and_work_notes String Stores both customer-facing comments and internal work notes for tracking fulfillment progress.
sci_company String References the company or business entity linked to the request.
sci_company_link String Provides a link to the company record associated with this request.
sci_configuration_item String Specifies the CI being requested or affected.
sci_configuration_item_link String Provides a link to the CI record.
sci_contact_type String Indicates the channel or method used to create the request, such as portal, email, or phone.
sci_context String References the workflow context managing this request's execution.
sci_context_link String Provides a link to the context record in the workflow engine.
sci_correlation_display String Displays a human-readable correlation reference used to link this request with external systems.
sci_correlation_id String Stores the correlation identifier that connects this request to an external integration or process.
sci_delivery_plan String References the delivery plan defining how the request will be fulfilled.
sci_delivery_plan_link String Provides a link to the delivery plan record.
sci_delivery_task String References the task responsible for delivering the requested item.
sci_delivery_task_link String Provides a link to the delivery task record associated with the request.
sci_description String Provides a detailed explanation of the requested item and its fulfillment requirements.
sci_due_date Datetime Indicates the date and time when the requested item is expected to be fulfilled.
sci_escalation Int Shows the escalation level of the request, determining its urgency and visibility.
sci_estimated_delivery Datetime Displays the estimated delivery date for the requested item.
sci_expected_start Datetime Specifies when fulfillment work is expected to start.
sci_flow_context String References the Flow Designer context that automates this request's actions.
sci_flow_context_link String Provides a link to the flow context record.
sci_follow_up Datetime Sets a reminder or follow-up date for the requested item.
sci_group_list String Lists all groups involved in processing or approving the request.
sci_impact Int Indicates the potential business impact level of the requested item.
sci_knowledge Bool Shows whether knowledge content was created or linked during fulfillment.
sci_location String References the location tied to the request, such as the requester's site or department.
sci_location_link String Provides a link to the associated location record.
sci_made_sla Bool Indicates whether the request met its defined SLA targets.
sci_number String Stores the automatically generated request number used for identification and tracking.
sci_opened_at Datetime Records when the requested item was created or opened.
sci_opened_by String Identifies the user who opened or submitted the request.
sci_opened_by_link String Provides a link to the user record of the requester.
sci_order Int Defines the order in which this item appears in the request or workflow sequence.
sci_order_guide String References the order guide that generated this requested item.
sci_order_guide_link String Provides a link to the order guide record.
sci_parent String References the parent record that this requested item belongs to, such as a main request.
sci_parent_link String Provides a link to the parent record.
sci_price Decimal Displays the price associated with the requested item as configured in the catalog.
sci_priority Int Indicates the request's priority level based on its impact and urgency.
sci_quantity Int Specifies how many units of the catalog item were requested.
sci_reassignment_count Int Tracks how many times the request has been reassigned between users or groups.
sci_recurring_frequency String Defines how often recurring charges or deliveries occur for this requested item.
sci_recurring_price Decimal Specifies the recurring cost associated with the item based on its frequency.
sci_rejection_goto String Defines the action or stage the workflow should move to if the request is rejected.
sci_rejection_goto_link String Provides a link to the workflow element triggered upon rejection.
sci_request String References the parent request record containing this catalog item.
sci_request_link String Provides a link to the parent request record.
sci_requested_for String Identifies the user for whom the item was requested.
sci_requested_for_link String Provides a link to the user record of the person the request was made for.
sci_route_reason Int Shows the routing reason or rule that determined how the request was assigned.
sci_sc_catalog String References the SC from which this request originated.
sci_sc_catalog_link String Provides a link to the SC record.
sci_service_offering String References the specific service offering associated with the request.
sci_service_offering_link String Provides a link to the service offering record.
sci_short_description String Provides a brief summary or title describing the requested item.
sci_sla_due Datetime Specifies the date and time by which the SLA for this request must be met.
sci_stage String Shows the current workflow or fulfillment stage for this requested item.
sci_state Int Represents the request's current state, such as open, in progress, or closed.
sci_sys_class_name String Defines the record's system class, determining its structure and behavior in the platform.
sci_sys_created_by String Indicates the user who created the requested item record.
sci_sys_created_on Datetime Records when the requested item record was first created.
sci_sys_domain String Specifies the domain to which this record belongs in multi-tenant setups.
sci_sys_domain_path String Displays the hierarchical path of the record's domain.
sci_sys_mod_count Int Tracks how many times the record has been modified.
sci_sys_tags String Stores metadata tags used for organizing and filtering the requested item.
sci_sys_updated_by String Indicates the user who last updated the requested item record.
sci_sys_updated_on Datetime Records the timestamp of the most recent update.
sci_task_effective_number String Stores the effective task number used for tracking and reporting.
sci_time_worked String Displays the total time spent working on this requested item.
sci_u_comments String Captures additional comments added by the user or fulfiller.
sci_u_some_test_field String Represents a custom test field used for configuration or internal validation.
sci_universal_request String References a universal request record that consolidates multiple catalog actions.
sci_universal_request_link String Provides a link to the universal request record.
sci_upon_approval String Specifies the action performed automatically when the request is approved.
sci_upon_reject String Specifies the action performed automatically when the request is rejected.
sci_urgency Int Indicates how urgently the requested item must be fulfilled, contributing to priority calculation.
sci_user_input String Captures values entered by the user during request submission.
sci_variables String Stores all variable data and responses associated with this request.
sci_watch_list String Lists users who receive notifications or updates about changes to the request.
sci_wf_activity String References the workflow activity currently executing for this requested item.
sci_wf_activity_link String Provides a link to the workflow activity record.
sci_work_end Datetime Records when fulfillment work on this item was completed.
sci_work_notes String Contains internal work notes added by fulfillers while processing the request.
sci_work_notes_list String Stores the list of all work notes associated with this request.
sci_work_start Datetime Records when work began on fulfilling the requested item.

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