Power BI Connector for ServiceNow

Build 25.0.9454

change_request

Tracks change requests, including their approval workflows, implementation details, and completion status.

Columns

Name Type ReadOnly References Description
outside_maintenance_schedule String False

Indicates whether the change is scheduled outside of approved maintenance windows.

on_hold_reason String False

Specifies the reason why the change request is placed on hold, such as pending approval or awaiting input.

start_date Datetime False

Lists the date and time when the implementation of the change is scheduled to begin.

cab_date Datetime False

Defines the scheduled date for the Change Advisory Board (CAB) review meeting.

close_code String False

Specifies the closure code categorizing how the change was resolved, such as successful or canceled.

requested_by String False

Identifies the user who submitted or initiated the change request.

backout_plan String False

Provides details of the backout plan to restore service if the change implementation fails.

change_plan String False

Lists the step-by-step plan outlining how the change will be executed.

implementation_plan String False

Describes the implementation procedure for executing the approved change request.

sys_id [KEY] String False

Defines the system identifier (sys_id) that uniquely identifies the change request record in ServiceNow.

phase String False

Specifies the current phase of the change process, such as planning, testing, or review.

review_status String False

Indicates the current review status of the change request, such as pending or completed.

conflict_status String False

Displays whether the change request conflicts with other scheduled changes or maintenance tasks.

phase_state String False

Lists the detailed state of the current change phase, such as waiting for approval or in progress.

production_system String False

Specifies whether the change affects a production system or environment.

type String False

Defines the type of change, such as normal, emergency, or standard.

on_hold String False

Indicates whether the change request is currently on hold.

end_date Datetime False

Lists the date and time when the change is scheduled to end.

requested_by_date Datetime False

Displays the date and time when the change was originally requested.

risk_impact_analysis String False

Contains the documented risk and impact analysis outlining potential consequences of the change.

test_plan String False

Provides the testing plan used to validate the change before implementation.

justification String False

Explains the reason for submitting the change request and the expected outcome.

scope String False

Defines the scope of the change, including affected services, systems, or users.

review_comments String False

Lists comments from reviewers or approvers regarding the change.

std_change_producer_version String False

Specifies the version of the standard change template or producer used to create the change.

category String False

Classifies the change by category, such as infrastructure, software, or hardware.

review_date Datetime False

Lists the date when the change was last reviewed by approvers or reviewers.

conflict_last_run Datetime False

Displays the timestamp of the most recent conflict detection check for overlapping changes.

risk String False

Indicates the assessed risk level of the change, such as low, medium, or high.

reason String False

Provides the business or technical justification explaining why the change is necessary.

cab_recommendation String False

Lists recommendations made by the CAB following their review of the change request.

delivery_task String False

References the associated delivery task or project phase linked to the change request.

upon_approval String False

Defines the action to perform automatically when the change request is approved, such as moving to implementation.

work_start Datetime False

Lists the date and time when work on the change implementation begins.

delivery_plan String False

Specifies the delivery plan associated with the change, outlining phases, deliverables, and milestones.

rejection_goto String False

Identifies the workflow state to transition to when the change request is rejected.

work_end Datetime False

Lists the date and time when work related to the change implementation ends.

upon_reject String False

Defines the automated action to perform when the change request is rejected.

business_service String False

Specifies the business service impacted or improved by the change request.

sys_domain String False

Identifies the domain associated with the change request record, used in multi-domain configurations.

sys_created_on Datetime False

Displays the date and time when the change request record was created in ServiceNow.

sys_updated_on Datetime False

Displays the date and time when the change request record was last modified.

expected_start Datetime False

Lists the expected start date and time for implementing the change.

variables String False

Stores any custom variables or data fields captured in the change request form.

number String False

Displays the unique identification number automatically assigned to the change request.

comments String False

Contains user comments or notes related to the change request's progress or decisions.

urgency String False

Indicates the urgency level of the change, such as high, medium, or low.

opened_at Datetime False

Displays the date and time when the change request was opened.

watch_list String False

Lists users or groups subscribed to receive notifications about the change request.

sla_due Datetime False

Specifies the date and time when the Service Level Agreement (SLA) for the change must be met.

active String False

Indicates whether the change request record is currently active in the workflow.

state String False

Displays the current workflow state of the change request, such as new, approved, or closed.

work_notes String False

Contains work notes added by implementers or analysts documenting progress on the change.

closed_by String False

Lists the user who closed the change request after completion.

follow_up Datetime False

Specifies the follow-up date and time for post-implementation review or verification.

work_notes_list String False

Lists all historical work notes associated with the change request for auditing purposes.

cmdb_ci String False

References the Configuration Item (CI) from the Configuration Management Database (CMDB) affected by the change.

approval_history String False

Provides a record of all approval actions taken during the change lifecycle.

business_duration Datetime False

Displays the duration of the change process, calculated based on business hours.

location String False

Specifies the physical or organizational location related to the change request.

user_input String False

Stores user-provided input or custom responses submitted as part of the change workflow.

assigned_to String False

Lists the user assigned responsibility for managing or implementing the change.

escalation String False

Indicates whether the change request has been escalated due to priority, delay, or business impact.

time_worked String False

Tracks the total time spent working on the change request.

additional_assignee_list String False

Lists additional users or groups assisting with the change implementation.

correlation_id String False

Stores a correlation identifier linking the change request to related incidents or problems.

comments_and_work_notes String False

Combines user comments and work notes into a single field for unified tracking.

order String False

Specifies the execution order of the change within a sequence of related tasks or activities.

made_sla String False

Indicates whether the SLA targets for the change request were successfully met.

sys_mod_count String False

Tracks the total number of modifications made to the change request record since creation.

sys_created_by String False

Shows the user or system process that originally created the change request record.

sys_updated_by String False

Shows the user or system process that last modified the change request record.

sys_domain_path String False

Defines the hierarchical domain path representing the record's placement in a multi-domain environment.

sys_class_name String False

Identifies the system class name of the change request record within the ServiceNow data model.

parent String False

Lists the parent change request or task to which the current record is related.

priority String False

Displays the priority level of the change request, typically calculated from impact and urgency.

close_notes String False

Contains detailed notes added when closing the change request, describing resolution steps or outcomes.

reassignment_count String False

Tracks how many times the change request has been reassigned to different users or groups.

due_date Datetime False

Lists the date and time when the change is expected to be completed.

short_description String False

Provides a concise summary of the purpose or scope of the change request.

company String False

Specifies the company or customer associated with the change request, if applicable.

approval_set Datetime False

Displays the date and time when approval was granted or updated for the change request.

opened_by String False

Identifies the user who opened or submitted the change request for review.

contact_type String False

Specifies how the change request was initiated, such as by phone, email, or portal submission.

assignment_group String False

Lists the group responsible for handling or approving the change request.

approval String False

Indicates the current approval state of the change request, such as requested, approved, or rejected.

calendar_duration Datetime False

Displays the total duration of the change request from creation to closure, including non-business hours.

knowledge String False

Specifies whether the change is linked to a Knowledge Base article for reference or documentation.

correlation_display String False

Shows a display value linking this change to related records such as incidents or problems.

wf_activity String False

References the workflow activity associated with the change for process automation tracking.

description String False

Provides a detailed explanation of the change, including scope, implementation steps, and expected results.

impact String False

Indicates the impact level of the change on users, services, or systems, such as low, medium, or high.

closed_at Datetime False

Displays the date and time when the change request was officially closed.

group_list String False

Lists the groups associated with or notified about the change during its lifecycle.

activity_due Datetime False

Specifies the date and time by which the next activity in the change workflow must be completed.

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