change_task_metric
Provides statistics for change tasks, including completion times and workflow efficiency indicators.
Columns
| Name | Type | References | Description |
| cht_sys_id | String | Lists the system identifier (sys_id) that uniquely identifies each change task record in ServiceNow. | |
| cht_active | Bool | Indicates whether the change task record is currently active. | |
| cht_activity_due | Datetime | Specifies the date and time when the next workflow activity for the change task is due. | |
| cht_additional_assignee_list | String | Lists additional users or groups assigned to assist with completing the change task. | |
| cht_approval | String | Shows the approval status of the change task, such as requested, approved, or rejected. | |
| cht_approval_history | String | Displays the history of approval actions taken for the change task. | |
| cht_approval_set | Datetime | Specifies the date and time when the approval status of the change task was last updated. | |
| cht_assigned_to | String | Identifies the user assigned to execute the change task. | |
| cht_assigned_to_link | String | Provides the hyperlink reference to the user record assigned to the change task. | |
| cht_assignment_group | String | Lists the group responsible for executing or overseeing the change task. | |
| cht_assignment_group_link | String | Provides the hyperlink reference to the group record associated with the change task. | |
| cht_business_duration | Long | Tracks the total business duration of the change task, excluding non-working hours. | |
| cht_business_service | String | Lists the business service impacted or supported by the change task. | |
| cht_business_service_link | String | Provides the hyperlink reference to the business service record in ServiceNow. | |
| cht_calendar_duration | Long | Records the total calendar duration of the change task, including both business and non-business hours. | |
| cht_change_request | String | References the parent change request associated with the change task. | |
| cht_change_request_link | String | Provides the hyperlink reference to the parent change request record in ServiceNow. | |
| cht_change_task_type | String | Specifies the type of change task, such as implementation, review, or testing. | |
| cht_close_code | String | Lists the closure code describing how the change task was completed, such as successful or canceled. | |
| cht_close_notes | String | Provides notes entered upon closing the change task, summarizing actions taken and outcomes. | |
| cht_closed_at | Datetime | Displays the date and time when the change task was officially closed. | |
| cht_closed_by | String | Identifies the user who closed the change task after completion. | |
| cht_closed_by_link | String | Provides the hyperlink reference to the user record who performed the task closure. | |
| cht_cmdb_ci | String | References the Configuration Item (CI) from the Configuration Management Database (CMDB) affected by the change task. | |
| cht_cmdb_ci_link | String | Provides the hyperlink reference to the CMDB record representing the affected Configuration Item. | |
| cht_comments | String | Stores comments entered by users to describe updates, observations, or issues related to the change task. | |
| cht_comments_and_work_notes | String | Combines user comments and work notes into a unified record for auditing and traceability. | |
| cht_company | String | Lists the company or organization associated with the change task. | |
| cht_company_link | String | Provides the hyperlink reference to the company record in ServiceNow. | |
| cht_contact_type | String | Specifies how the change task was created or communicated, such as by phone, portal, or email. | |
| cht_correlation_display | String | Displays a readable reference linking the change task to related records such as incidents or problems. | |
| cht_correlation_id | String | Stores the correlation identifier that connects the change task to related records in other systems. | |
| cht_created_from | String | Identifies the record or source from which the change task was created. | |
| cht_delivery_plan | String | Specifies the delivery plan that guides the scheduling and execution of the change task. | |
| cht_delivery_plan_link | String | Provides the hyperlink reference to the delivery plan record associated with the change task. | |
| cht_delivery_task | String | References the delivery task linked to the change task in ServiceNow. | |
| cht_delivery_task_link | String | Provides the hyperlink reference to the delivery task record. | |
| cht_description | String | Provides a detailed explanation of the change task, including objectives, actions, and dependencies. | |
| cht_due_date | Datetime | Lists the date and time when the change task is due for completion. | |
| cht_escalation | Int | Specifies the escalation level of the change task, typically based on urgency or business impact. | |
| cht_expected_start | Datetime | Lists the date and time when the change task is expected to begin. | |
| cht_follow_up | Datetime | Displays the date and time scheduled for post-task review or follow-up actions. | |
| cht_group_list | String | Lists all user groups involved in reviewing, approving, or executing the change task. | |
| cht_impact | Int | Represents the numeric value for the impact level of the change task, where a higher number indicates greater business impact. | |
| cht_knowledge | Bool | Indicates whether the change task is linked to a Knowledge Base article for reference or documentation. | |
| cht_location | String | Lists the physical or organizational location associated with the change task. | |
| cht_location_link | String | Provides the hyperlink reference to the location record in ServiceNow. | |
| cht_made_sla | Bool | Indicates whether the Service Level Agreement (SLA) objectives for the change task were met. | |
| cht_number | String | Displays the unique identification number assigned to the change task. | |
| cht_on_hold | Bool | Indicates whether the change task is currently on hold and awaiting action or additional information. | |
| cht_on_hold_reason | String | Specifies the reason the change task was placed on hold, such as dependency or approval delay. | |
| cht_opened_at | Datetime | Displays the date and time when the change task was created or first opened. | |
| cht_opened_by | String | Identifies the user who created or submitted the change task. | |
| cht_opened_by_link | String | Provides the hyperlink reference to the user record who opened the change task. | |
| cht_order | Int | Specifies the sequence order of the change task within the workflow or project. | |
| cht_parent | String | References the parent record or process associated with the change task. | |
| cht_parent_link | String | Provides the hyperlink reference to the parent record in ServiceNow. | |
| cht_planned_end_date | Datetime | Lists the planned end date and time for the change task based on project scheduling. | |
| cht_planned_start_date | Datetime | Lists the planned start date and time for the change task. | |
| cht_priority | Int | Specifies the priority level of the change task, generally derived from its impact and urgency values. | |
| cht_reassignment_count | Int | Tracks the number of times the change task has been reassigned to different users or groups. | |
| cht_rejection_goto | String | Specifies the workflow state to which the change task transitions automatically upon rejection. | |
| cht_rejection_goto_link | String | Provides the hyperlink reference to the rejection state record or transition rule. | |
| cht_route_reason | Int | Specifies the routing reason code used to direct the change task within workflows. | |
| cht_service_offering | String | Lists the specific service offering impacted by the change task. | |
| cht_service_offering_link | String | Provides the hyperlink reference to the service offering record in ServiceNow. | |
| cht_short_description | String | Provides a concise summary of the change task, describing its purpose or action to be taken. | |
| cht_sla_due | Datetime | Displays the date and time by which the SLA objectives must be fulfilled for the change task. | |
| cht_state | Int | Represents the numeric code indicating the current state of the change task, such as 1 = New or 3 = Approved. | |
| cht_sys_class_name | String | Specifies the system class name of the change task record within the ServiceNow schema. | |
| cht_sys_created_by | String | Shows the user or system process that originally created the change task record. | |
| cht_sys_created_on | Datetime | Displays the date and time when the change task record was created. | |
| cht_sys_domain | String | Specifies the domain associated with the change task in a multi-domain configuration. | |
| cht_sys_domain_path | String | Defines the hierarchical domain path representing the organizational placement of the change task. | |
| cht_sys_mod_count | Int | Tracks how many times the change task record has been modified since its creation. | |
| cht_sys_tags | String | Lists system tags applied to the change task record for categorization or reporting. | |
| cht_sys_updated_by | String | Shows the user or process that last updated the change task record. | |
| cht_sys_updated_on | Datetime | Displays the date and time when the change task record was last updated. | |
| cht_task_effective_number | String | Lists the effective task number associated with the change task for consistency in tracking and reporting. | |
| cht_time_worked | String | Tracks the total amount of time spent working on the change task. | |
| cht_u_comments | String | Stores additional user-provided comments or notes for the change task. | |
| cht_u_some_test_field | String | Holds data for a custom field used for testing or internal validation purposes. | |
| cht_universal_request | String | References a universal request record related to or triggering the change task. | |
| cht_universal_request_link | String | Provides the hyperlink reference to the universal request record in ServiceNow. | |
| cht_upon_approval | String | Specifies the automated workflow action executed when the change task is approved. | |
| cht_upon_reject | String | Defines the automated workflow action triggered when the change task is rejected. | |
| cht_urgency | Int | Represents the numeric urgency level of the change task, where a lower number means higher urgency. | |
| cht_user_input | String | Stores any additional user input or form data submitted with the change task. | |
| cht_variables | String | Lists variable values captured through dynamic forms associated with the change task. | |
| cht_watch_list | String | Lists the users or groups subscribed to receive notifications and updates about the change task. | |
| cht_wf_activity | String | References the workflow activity record associated with the automation of the change task. | |
| cht_wf_activity_link | String | Provides the hyperlink reference to the workflow activity record managing the automation of the change task. | |
| cht_work_end | Datetime | Lists the date and time when work on the change task was completed. | |
| cht_work_notes | String | Stores work notes entered by users to document actions, progress, and decisions related to the change task. | |
| cht_work_notes_list | String | Displays the complete list of historical work notes recorded for the change task. | |
| cht_work_start | Datetime | Lists the date and time when work on the change task began. | |
| mi_sys_id | String | Lists the sys_id that uniquely identifies each metric instance record in ServiceNow. | |
| mi_business_duration | Long | Tracks the business duration measured by the metric, excluding non-working hours. | |
| mi_calculation_complete | Bool | Indicates whether the metric calculation has been completed successfully. | |
| mi_definition | String | References the metric definition that determines how the metric instance is calculated. | |
| mi_definition_link | String | Provides the hyperlink reference to the metric definition record associated with the instance. | |
| mi_duration | Long | Records the total elapsed duration of the metric instance, including business and non-business hours. | |
| mi_end | Datetime | Lists the date and time when the metric measurement period ended. | |
| mi_field | String | Specifies the database field that the metric monitors for performance or compliance tracking. | |
| mi_field_value | String | Displays the value of the monitored field captured at the time the metric was recorded. | |
| mi_id | String | Stores a unique identifier assigned to the metric instance for internal tracking. | |
| mi_start | Datetime | Lists the date and time when the metric measurement period began. | |
| mi_sys_created_by | String | Shows the user or process that created the metric instance record. | |
| mi_sys_created_on | Datetime | Displays the date and time when the metric instance record was created in ServiceNow. | |
| mi_sys_mod_count | Int | Tracks how many times the metric instance record has been updated since creation. | |
| mi_sys_tags | String | Lists any system tags assigned to the metric instance for classification or analysis. | |
| mi_sys_updated_by | String | Shows the user or process that last modified the metric instance record. | |
| mi_sys_updated_on | Datetime | Displays the date and time when the metric instance record was last updated. | |
| mi_table | String | Specifies the database table in which the metric instance resides. | |
| mi_value | String | Lists the final calculated value of the metric instance based on the monitored field. | |
| md_sys_id | String | Lists the sys_id that uniquely identifies each metric definition record in ServiceNow. | |
| md_active | Bool | Indicates whether the metric definition is currently active and collecting data. | |
| md_description | String | Provides a detailed description of what the metric measures and its purpose. | |
| md_field | String | Specifies the database field that the metric definition monitors for changes or performance tracking. | |
| md_name | String | Lists the name assigned to the metric definition for identification within ServiceNow. | |
| md_number | String | Displays the unique number associated with the metric definition record. | |
| md_order | Int | Specifies the order in which the metric definition is evaluated or processed. | |
| md_script | String | Contains the script logic used to define custom calculations for the metric definition. | |
| md_sys_class_name | String | Specifies the system class name of the metric definition record in the ServiceNow schema. | |
| md_sys_created_by | String | Shows the user or process that created the metric definition record. | |
| md_sys_created_on | Datetime | Displays the date and time when the metric definition record was created in ServiceNow. | |
| md_sys_mod_count | Int | Tracks how many times the metric definition record has been modified since creation. | |
| md_sys_name | String | Lists the internal system name assigned to the metric definition for reference and updates. | |
| md_sys_package | String | Specifies the package or application bundle that includes the metric definition. | |
| md_sys_package_link | String | Provides the hyperlink reference to the package record associated with the metric definition. | |
| md_sys_policy | String | References the policy or rule that governs the metric definition's behavior or access permissions. | |
| md_sys_scope | String | Specifies the application scope to which the metric definition belongs. | |
| md_sys_scope_link | String | Provides the hyperlink reference to the application scope record. | |
| md_sys_tags | String | Lists any system tags applied to the metric definition for classification or organization. | |
| md_sys_update_name | String | Displays the name of the update set or version that last modified the metric definition. | |
| md_sys_updated_by | String | Shows the user or process that last updated the metric definition record. | |
| md_sys_updated_on | Datetime | Displays the date and time when the metric definition record was last modified in ServiceNow. | |
| md_table | String | Specifies the table associated with the metric definition that determines where metrics are applied. | |
| md_timeline | Bool | Indicates whether the metric definition includes a timeline for tracking historical performance data. | |
| md_type | String | Specifies the type of metric definition, such as duration-based or event-based. |