Power BI Connector for ServiceNow

Build 25.0.9454

sc_request_metric

Aggregates metrics for service requests, including completion rates and fulfillment times.

Columns

Name Type References Description
scr_sys_id String Provides the system identifier (sys_id) for the service request record used for tracking and reporting.
scr_active Bool Indicates whether the service request is currently active and being worked on.
scr_activity_due Datetime Specifies when the next activity or workflow step for the request is due.
scr_additional_assignee_list String Lists additional users assigned to collaborate on fulfilling the request.
scr_approval String Shows the current approval state of the service request, such as pending, approved, or rejected.
scr_approval_history String Captures the full approval trail for the request, including approvers and timestamps.
scr_approval_set Datetime Records when the approval state was most recently set or changed.
scr_assigned_to String Identifies the primary user responsible for fulfilling this service request.
scr_assigned_to_link String Provides a link to the user record assigned to the request.
scr_assignment_group String References the group responsible for processing or fulfilling the request.
scr_assignment_group_link String Provides a link to the assignment group record.
scr_business_duration Long Captures the total business time spent on the request, excluding non-working hours.
scr_business_service String References the business service that the request supports or affects.
scr_business_service_link String Provides a link to the related business service record.
scr_calendar_duration Long Shows the total elapsed time from creation to completion, including non-business hours.
scr_calendar_stc Int Stores the elapsed calendar time in seconds for analytics and reporting.
scr_close_notes String Contains final notes or closure remarks entered when the request was completed.
scr_closed_at Datetime Records the date and time when the service request was closed.
scr_closed_by String Identifies the user who closed the service request.
scr_closed_by_link String Provides a link to the record of the user who closed the request.
scr_cmdb_ci String References the Configuration Item (CI) related to this service request.
scr_cmdb_ci_link String Provides a link to the CI record associated with the request.
scr_comments String Captures user-entered comments or notes regarding the request.
scr_comments_and_work_notes String Stores both customer-visible comments and internal work notes for fulfillment tracking.
scr_company String References the company or business entity associated with the request.
scr_company_link String Provides a link to the associated company record.
scr_contact_type String Indicates the channel used to create the request, such as portal, email, or phone.
scr_correlation_display String Displays a human-readable correlation reference used to link the request with external systems.
scr_correlation_id String Stores the correlation identifier that connects the request to an external integration or process.
scr_delivery_address String Specifies the delivery address or location for items or services requested.
scr_delivery_plan String References the delivery plan that defines how the request will be fulfilled.
scr_delivery_plan_link String Provides a link to the delivery plan record.
scr_delivery_task String References the task responsible for delivering the requested item or service.
scr_delivery_task_link String Provides a link to the delivery task record.
scr_description String Provides a detailed explanation of the service request and its requirements.
scr_due_date Datetime Indicates the date and time by which the request is expected to be fulfilled.
scr_escalation Int Shows the escalation level of the request, influencing urgency and visibility.
scr_expected_start Datetime Specifies when work on the request is expected to begin.
scr_follow_up Datetime Sets a reminder or follow-up date to review or update the request.
scr_group_list String Lists all groups involved in processing or approving the request.
scr_impact Int Indicates the potential business impact level of the request.
scr_knowledge Bool Shows whether knowledge content was created or linked during fulfillment.
scr_location String References the location associated with the request, such as the requester's site or department.
scr_location_link String Provides a link to the associated location record.
scr_made_sla Bool Indicates whether the request met its defined Service Level Agreement (SLA) targets.
scr_number String Stores the automatically generated request number used for identification and tracking.
scr_opened_at Datetime Records when the service request was created or opened.
scr_opened_by String Identifies the user who created or submitted the request.
scr_opened_by_link String Provides a link to the user record of the requester.
scr_order Int Defines the display or processing order of this request in lists and workflows.
scr_parent String References the parent record to which this request is related.
scr_parent_interaction String References the originating interaction or contact that led to the request.
scr_parent_interaction_link String Provides a link to the parent interaction record.
scr_parent_link String Provides a link to the parent record.
scr_price Decimal Displays the price or cost associated with the requested items or services.
scr_priority Int Represents the request's priority level based on impact and urgency.
scr_reassignment_count Int Tracks how many times the request has been reassigned between users or groups.
scr_rejection_goto String Defines the action or stage the workflow should move to if the request is rejected.
scr_rejection_goto_link String Provides a link to the workflow element triggered upon rejection.
scr_request_state String Shows the high-level state of the request, such as requested, approved, or closed.
scr_requested_date Date Records the date when the service request was submitted.
scr_requested_for String Identifies the user for whom the service request was made.
scr_requested_for_link String Provides a link to the user record of the person the request was made for.
scr_route_reason Int Shows the routing reason or rule that determined how the request was assigned.
scr_service_offering String References the specific service offering associated with the request.
scr_service_offering_link String Provides a link to the service offering record.
scr_short_description String Provides a brief summary or title describing the service request.
scr_sla_due Datetime Specifies the date and time by which the SLA for this request must be met.
scr_special_instructions String Captures any special instructions or handling notes for fulfilling the request.
scr_stage String Shows the current workflow or fulfillment stage for the request.
scr_state Int Represents the current state, such as open, in progress, or closed.
scr_sys_class_name String Defines the record's system class, which controls behavior and form layout.
scr_sys_created_by String Indicates the user who created the service request record.
scr_sys_created_on Datetime Records when the service request record was first created.
scr_sys_domain String Specifies the domain to which this record belongs in multi-tenant deployments.
scr_sys_domain_path String Displays the hierarchical path of the record's domain.
scr_sys_mod_count Int Tracks how many times the request record has been modified.
scr_sys_tags String Stores metadata tags used for organizing and filtering the request.
scr_sys_updated_by String Indicates the user who last updated the service request record.
scr_sys_updated_on Datetime Records the timestamp of the most recent update.
scr_task_effective_number String Stores the effective task number used for tracking and reporting.
scr_time_worked String Displays the total time spent working on the service request.
scr_u_comments String Captures additional user comments related to the request.
scr_u_some_test_field String Represents a custom test field used for configuration or internal validation.
scr_universal_request String References a universal request record that consolidates multiple catalog or task actions.
scr_universal_request_link String Provides a link to the universal request record.
scr_upon_approval String Specifies the automated action performed when the request is approved.
scr_upon_reject String Specifies the automated action performed when the request is rejected.
scr_urgency Int Indicates how urgently the request must be fulfilled, contributing to priority calculation.
scr_user_input String Captures values entered by the user during request submission.
scr_variables String Stores all variable data and responses associated with the service request.
scr_watch_list String Lists users who receive notifications and updates about changes to the request.
scr_wf_activity String References the workflow activity currently executing for this request.
scr_wf_activity_link String Provides a link to the workflow activity record.
scr_work_end Datetime Records when fulfillment work on the request was completed.
scr_work_notes String Contains internal work notes added by fulfillers while processing the request.
scr_work_notes_list String Stores the list of all work notes associated with the request.
scr_work_start Datetime Records when work began on fulfilling the service request.
mi_sys_id String Stores the sys_id of the associated metric instance that measures timing and progress for this request.
mi_business_duration Long Captures the business time measured by the metric instance, excluding non-working hours.
mi_calculation_complete Bool Indicates whether the metric instance has finished calculating results.
mi_definition String References the metric definition that governs how this request is measured.
mi_definition_link String Provides a link to the metric definition record.
mi_duration Long Shows the total elapsed time measured by the metric instance, including non-business hours.
mi_end Datetime Records when the metric measurement ended for this request.
mi_field String Identifies the field the metric tracks on the request record.
mi_field_value String Displays the value of the tracked field at measurement time.
mi_id String Stores the identifier of the metric instance for auditing and correlation.
mi_start Datetime Records when the metric measurement began for this request.
mi_sys_created_by String Indicates the user who created the metric instance record.
mi_sys_created_on Datetime Records when the metric instance record was created.
mi_sys_mod_count Int Tracks how many times the metric instance record has been modified.
mi_sys_tags String Stores tags or metadata used to organize metric instance records.
mi_sys_updated_by String Indicates the user who last updated the metric instance record.
mi_sys_updated_on Datetime Records the timestamp of the most recent update to the metric instance.
mi_table String Specifies the table on which the metric instance was calculated.
mi_value String Stores the computed value or outcome of the metric for this request.
md_sys_id String Stores the sys_id of the metric definition that defines what is measured and how.
md_active Bool Indicates whether the metric definition is active and available for use.
md_description String Provides a human-readable description of the metric definition's purpose.
md_field String Identifies the field that the metric definition evaluates.
md_name String Stores the display name of the metric definition.
md_number String Stores the unique number assigned to the metric definition.
md_order Int Determines the execution or display order for metric definitions.
md_script String Contains script logic used to evaluate or calculate the metric.
md_sys_class_name String Defines the record's system class for the metric definition.
md_sys_created_by String Indicates the user who created the metric definition.
md_sys_created_on Datetime Records when the metric definition was first created.
md_sys_mod_count Int Tracks how many times the metric definition has been modified.
md_sys_name String Stores the internal name of the metric definition record.
md_sys_package String References the application package that delivers the metric definition.
md_sys_package_link String Provides a link to the application package record.
md_sys_policy String Indicates update or protection policy applied to the metric definition.
md_sys_scope String References the application scope that owns the metric definition.
md_sys_scope_link String Provides a link to the application scope record.
md_sys_tags String Stores tags or metadata for organizing metric definitions.
md_sys_update_name String Stores the unique update name used for source control and upgrades.
md_sys_updated_by String Indicates the user who last updated the metric definition.
md_sys_updated_on Datetime Records when the metric definition was most recently updated.
md_table String Specifies the table the metric definition applies to.
md_timeline Bool Indicates whether the metric should be displayed on timelines or visual progress views.
md_type String Specifies the type of metric, such as duration, state change, or custom calculation.

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