change_request_sla
Tracks Service Level Agreement (SLA) performance for change requests to measure timeliness and service quality.
Columns
| Name | Type | References | Description |
| taskslatable_sys_id | String | Lists the system identifier (sys_id) that uniquely identifies each record in the task SLA table. | |
| taskslatable_active | Bool | Indicates whether the SLA tracking record is currently active for the task. | |
| taskslatable_business_duration | Long | Records the total business time taken to reach the current SLA stage, excluding non-working hours. | |
| taskslatable_business_pause_duration | Long | Tracks the duration for which SLA processing was paused during business hours. | |
| taskslatable_business_percentage | Decimal | Shows the percentage of business time that has elapsed toward the SLA target. | |
| taskslatable_business_time_left | Long | Displays the amount of remaining business time before the SLA target is breached. | |
| taskslatable_duration | Long | Records the total elapsed time spent on the SLA, including both business and non-business hours. | |
| taskslatable_end_time | Datetime | Lists the date and time when the SLA instance was completed or breached. | |
| taskslatable_has_breached | Bool | Indicates whether the SLA target for the task has been breached. | |
| taskslatable_original_breach_time | Datetime | Specifies the original calculated breach time before any SLA adjustments. | |
| taskslatable_pause_duration | Long | Tracks the total time the SLA was paused, including business and non-business hours. | |
| taskslatable_pause_time | Datetime | Displays the most recent date and time when the SLA timer was paused. | |
| taskslatable_percentage | Decimal | Shows the overall completion percentage of the SLA duration. | |
| taskslatable_planned_end_time | Datetime | Specifies the expected end time of the SLA based on configured schedules. | |
| taskslatable_schedule | String | Lists the schedule applied to the SLA, determining the working hours used for time calculations. | |
| taskslatable_schedule_link | String | Provides the hyperlink reference to the schedule record associated with the SLA. | |
| taskslatable_sla | String | References the SLA definition applied to the task record. | |
| taskslatable_sla_link | String | Provides the hyperlink reference to the SLA definition record in ServiceNow. | |
| taskslatable_stage | String | Specifies the current stage of the SLA, such as in progress, paused, or completed. | |
| taskslatable_start_time | Datetime | Displays the date and time when the SLA tracking began for the task. | |
| taskslatable_sys_created_by | String | Lists the user or system process that created the task SLA record. | |
| taskslatable_sys_created_on | Datetime | Displays the date and time when the task SLA record was created. | |
| taskslatable_sys_mod_count | Int | Tracks how many times the task SLA record has been modified since its creation. | |
| taskslatable_sys_tags | String | Lists any system tags assigned to the task SLA record for categorization or reporting. | |
| taskslatable_sys_updated_by | String | Shows the user or process that last modified the task SLA record. | |
| taskslatable_sys_updated_on | Datetime | Displays the date and time when the task SLA record was last updated. | |
| taskslatable_task | String | References the task associated with the SLA record, such as a change request or incident. | |
| taskslatable_task_link | String | Provides the hyperlink reference to the related task record in ServiceNow. | |
| taskslatable_time_left | Long | Displays the total amount of time remaining before the SLA target expires. | |
| taskslatable_timezone | String | Lists the time zone used for SLA time calculations, based on the associated schedule. | |
| chg_sys_id | String | Defines the sys_id of the change request record linked to the SLA. | |
| chg_active | Bool | Indicates whether the linked change request is currently active. | |
| chg_activity_due | Datetime | Specifies the date and time when the next workflow activity in the change request is due. | |
| chg_additional_assignee_list | String | Lists additional users or groups assisting with the change request execution. | |
| chg_approval | String | Displays the current approval status of the change request, such as requested, approved, or rejected. | |
| chg_approval_history | String | Provides a historical record of all approval actions taken for the change request. | |
| chg_approval_set | Datetime | Lists the date and time when the change request's approval status was last updated. | |
| chg_assigned_to | String | Identifies the user assigned to complete or oversee the change request. | |
| chg_assigned_to_link | String | Provides the hyperlink reference to the user record assigned to the change request. | |
| chg_assignment_group | String | Specifies the group responsible for performing or reviewing the change. | |
| chg_assignment_group_link | String | Provides the hyperlink reference to the group record associated with the change request. | |
| chg_backout_plan | String | Describes the plan to revert system changes if the implementation fails or causes issues. | |
| chg_business_duration | Long | Tracks the total business duration of the change request, excluding non-working hours. | |
| chg_business_service | String | Lists the business service affected or improved by the change request. | |
| chg_business_service_link | String | Provides the hyperlink reference to the business service record in ServiceNow. | |
| chg_cab_date | Date | Specifies the scheduled date for the Change Advisory Board (CAB) review of the change. | |
| chg_cab_delegate | String | Lists the delegate assigned to represent a CAB member during review. | |
| chg_cab_delegate_link | String | Provides the hyperlink reference to the delegate record associated with the CAB review. | |
| chg_cab_recommendation | String | Captures recommendations or feedback from the CAB regarding the proposed change. | |
| chg_cab_required | Bool | Indicates whether the change requires review or approval from the CAB. | |
| chg_calendar_duration | Long | Records the total calendar duration of the change request, including both business and non-business hours. | |
| chg_category | String | Classifies the change request into a category such as software, hardware, or infrastructure. | |
| chg_change_plan | String | Outlines the steps and implementation strategy for performing the change. | |
| chg_close_code | String | Lists the closure code explaining how the change was resolved, such as successful or unsuccessful. | |
| chg_close_notes | String | Provides notes entered during the closure of the change request, summarizing outcomes and lessons learned. | |
| chg_closed_at | Datetime | Displays the date and time when the change request was officially closed. | |
| chg_closed_by | String | Identifies the user who closed the change request after its completion. | |
| chg_closed_by_link | String | Provides the hyperlink reference to the user record who performed the closure. | |
| chg_cmdb_ci | String | References the Configuration Item (CI) from the Configuration Management Database (CMDB) affected by the change. | |
| chg_cmdb_ci_link | String | Provides the hyperlink reference to the CMDB record representing the affected Configuration Item. | |
| chg_comments | String | Stores user-entered comments describing updates, issues, or collaboration notes related to the change. | |
| chg_comments_and_work_notes | String | Combines user comments and work notes into a unified history for audit tracking. | |
| chg_company | String | Lists the company or organization associated with the change request. | |
| chg_company_link | String | Provides the hyperlink reference to the company record in ServiceNow. | |
| chg_conflict_last_run | Datetime | Displays the date and time when the system last performed a conflict detection check for overlapping changes. | |
| chg_conflict_status | String | Indicates the result of the last conflict check, such as no conflicts or conflicts detected. | |
| chg_contact_type | String | Specifies how the change request was initiated, such as via email, portal, or phone. | |
| chg_correlation_display | String | Displays a human-readable reference linking the change to related records such as incidents or problems. | |
| chg_correlation_id | String | Stores the correlation identifier that connects the change request to related records in other systems. | |
| chg_delivery_plan | String | Specifies the delivery plan guiding the change's implementation and release activities. | |
| chg_delivery_plan_link | String | Provides the hyperlink reference to the delivery plan record. | |
| chg_delivery_task | String | References the delivery task associated with the change implementation. | |
| chg_delivery_task_link | String | Provides the hyperlink reference to the delivery task record linked to the change request. | |
| chg_description | String | Provides a detailed explanation of the change request, including its purpose and scope. | |
| chg_due_date | Datetime | Specifies the date and time by which the change must be completed. | |
| chg_end_date | Datetime | Lists the date and time when the change process concluded. | |
| chg_escalation | Int | Indicates the escalation level of the change request based on urgency or business impact. | |
| chg_expected_start | Datetime | Specifies the expected start date and time of the change implementation. | |
| chg_follow_up | Datetime | Lists the scheduled date for post-implementation review or verification activities. | |
| chg_group_list | String | Lists all user groups involved in reviewing, approving, or executing the change request. | |
| chg_impact | Int | Specifies the level of impact the change has on business operations, typically represented numerically (for example, 1 = high, 3 = low). | |
| chg_implementation_plan | String | Describes the plan detailing how the change will be executed, tested, and validated. | |
| chg_justification | String | Explains the business or technical justification for initiating the change. | |
| chg_knowledge | Bool | Indicates whether the change request is linked to a Knowledge Base article for reference or documentation. | |
| chg_location | String | Lists the location associated with the change request, either physical or organizational. | |
| chg_location_link | String | Provides the hyperlink reference to the location record in ServiceNow. | |
| chg_made_sla | Bool | Indicates whether the SLA objectives for the change request were met. | |
| chg_number | String | Displays the unique identification number automatically assigned to the change request. | |
| chg_on_hold | Bool | Indicates whether the change request is currently on hold and awaiting action or information. | |
| chg_on_hold_reason | String | Specifies the reason why the change request has been placed on hold, such as resource dependencies or pending approval. | |
| chg_on_hold_task | String | References the task or step that triggered the on-hold status of the change request. | |
| chg_opened_at | Datetime | Displays the date and time when the change request was created or first opened. | |
| chg_opened_by | String | Identifies the user who opened or submitted the change request. | |
| chg_opened_by_link | String | Provides the hyperlink reference to the user record who initiated the change request. | |
| chg_order | Int | Defines the sequence order of the change request in relation to other workflow items. | |
| chg_outside_maintenance_schedule | Bool | Indicates whether the change falls outside the approved maintenance window. | |
| chg_parent | String | References the parent change request or related record that this change is linked to. | |
| chg_parent_link | String | Provides the hyperlink reference to the parent change record in ServiceNow. | |
| chg_phase | String | Specifies the current phase of the change lifecycle, such as planning, testing, or implementation. | |
| chg_phase_state | String | Lists the detailed state within the current phase, such as awaiting approval or completed. | |
| chg_priority | Int | Specifies the priority level of the change request, generally derived from the impact and urgency values. | |
| chg_production_system | Bool | Indicates whether the change affects a production environment or live system. | |
| chg_reason | String | Explains the reason for initiating the change, such as compliance requirements or operational improvements. | |
| chg_reassignment_count | Int | Tracks the number of times the change request has been reassigned to different users or groups. | |
| chg_rejection_goto | String | Specifies the workflow state the system moves to automatically when the change request is rejected. | |
| chg_rejection_goto_link | String | Provides the hyperlink reference to the rejection transition record or target state. | |
| chg_requested_by | String | Identifies the user who requested or sponsored the change. | |
| chg_requested_by_date | Datetime | Displays the date and time when the change request was submitted by the requester. | |
| chg_requested_by_link | String | Provides the hyperlink reference to the requester's user record in ServiceNow. | |
| chg_review_comments | String | Lists the comments added by reviewers during the change review process. | |
| chg_review_date | Date | Displays the most recent date when the change request was reviewed by approvers or the CAB. | |
| chg_review_status | Int | Indicates the numeric code representing the current review status, such as pending, approved, or rejected. | |
| chg_risk | Int | Represents the numeric value for the risk level associated with the change request, where higher numbers indicate greater risk. | |
| chg_risk_impact_analysis | String | Documents the risk and impact analysis performed before implementing the change. | |
| chg_route_reason | Int | Specifies the routing reason code used for workflow transitions during the change lifecycle. | |
| chg_scope | Int | Defines the scope of the change numerically, indicating how broad or limited its impact is. | |
| chg_service_offering | String | Lists the specific service offering affected by the change request. | |
| chg_service_offering_link | String | Provides the hyperlink reference to the service offering record in ServiceNow. | |
| chg_short_description | String | Provides a concise summary describing the purpose and nature of the change request. | |
| chg_sla_due | Datetime | Displays the date and time by which the SLA objectives must be met. | |
| chg_start_date | Datetime | Specifies the date and time when the change implementation is scheduled to start. | |
| chg_state | Int | Represents the numeric code for the current state of the change request, such as 1 = New or 3 = Approved. | |
| chg_std_change_producer_version | String | Identifies the version of the standard change producer template used to create the change request. | |
| chg_std_change_producer_version_link | String | Provides the hyperlink reference to the standard change producer version record. | |
| chg_sys_class_name | String | Specifies the system class name of the change request record within the ServiceNow schema. | |
| chg_sys_created_by | String | Shows the user or process that originally created the change request record. | |
| chg_sys_created_on | Datetime | Displays the date and time when the change request was created in ServiceNow. | |
| chg_sys_domain | String | Specifies the domain associated with the change request in multi-domain environments. | |
| chg_sys_domain_path | String | Defines the hierarchical path representing the domain structure for the change record. | |
| chg_sys_mod_count | Int | Tracks how many times the change request record has been modified since creation. | |
| chg_sys_tags | String | Lists system tags applied to the change request for filtering, categorization, or reporting. | |
| chg_sys_updated_by | String | Displays the user or process that last modified the change request record. | |
| chg_sys_updated_on | Datetime | Shows the date and time when the change request record was last updated. | |
| chg_task_effective_number | String | Lists the effective task number associated with the change request for tracking consistency. | |
| chg_test_plan | String | Describes the plan for testing the change before it is deployed to production. | |
| chg_time_worked | String | Tracks the total time spent working on the change request, recorded across all contributors. | |
| chg_type | String | Specifies the type of change request, such as standard, normal, or emergency. | |
| chg_u_comments | String | Stores user-provided comments or notes added to the change request for internal tracking. | |
| chg_u_some_test_field | String | Holds data for a custom test field used for internal testing or development purposes. | |
| chg_unauthorized | Bool | Indicates whether the change was implemented without authorization or prior approval. | |
| chg_universal_request | String | References a universal request that triggered or is related to the current change request. | |
| chg_universal_request_link | String | Provides the hyperlink reference to the universal request record in ServiceNow. | |
| chg_upon_approval | String | Specifies the workflow action automatically executed upon approval of the change request. | |
| chg_upon_reject | String | Defines the automated workflow action triggered when the change request is rejected. | |
| chg_urgency | Int | Represents the numeric value indicating the urgency of the change request, where a lower number means higher urgency. | |
| chg_user_input | String | Stores additional user input or variable data provided during change request submission. | |
| chg_variables | String | Lists variable values captured through dynamic form fields associated with the change request. | |
| chg_watch_list | String | Lists users or groups who are notified about updates or progress on the change request. | |
| chg_wf_activity | String | References the workflow activity record linked to the change automation process. | |
| chg_wf_activity_link | String | Provides the hyperlink reference to the workflow activity record associated with the change. | |
| chg_work_end | Datetime | Displays the date and time when work on the change implementation ended. | |
| chg_work_notes | String | Stores work notes entered by users to document progress and actions during the change lifecycle. | |
| chg_work_notes_list | String | Lists all historical work notes for the change request, supporting auditing and traceability. | |
| chg_work_start | Datetime | Displays the date and time when work on the change implementation began. |