change_task_time_worked
Logs the amount of time spent by technicians or teams on change tasks for performance tracking.
Columns
| Name | Type | References | Description |
| twtable_sys_id | String | Lists the system identifier (sys_id) that uniquely identifies each time worked record in ServiceNow. | |
| twtable_comments | String | Stores comments or notes describing the context or details of the recorded work time. | |
| twtable_sys_created_by | String | Shows the user or system process that created the time worked record. | |
| twtable_sys_created_on | Datetime | Displays the date and time when the time worked record was created. | |
| twtable_sys_mod_count | Int | Tracks how many times the time worked record has been modified since creation. | |
| twtable_sys_tags | String | Lists any system tags applied to the time worked record for reporting or categorization. | |
| twtable_sys_updated_by | String | Shows the user or process that last updated the time worked record. | |
| twtable_sys_updated_on | Datetime | Displays the date and time when the time worked record was last updated. | |
| twtable_task | String | References the task to which the recorded work time is associated, such as a change task. | |
| twtable_task_link | String | Provides the hyperlink reference to the related task record in ServiceNow. | |
| twtable_time_in_seconds | Int | Records the total time worked expressed in seconds. | |
| twtable_time_worked | Long | Tracks the total work duration logged for the associated task, typically measured in seconds or minutes. | |
| twtable_user | String | Identifies the user who performed the work or logged the time entry. | |
| twtable_user_link | String | Provides the hyperlink reference to the user record in ServiceNow. | |
| cht_sys_id | String | Lists the sys_id that uniquely identifies each change task linked to the time worked record. | |
| cht_active | Bool | Indicates whether the change task associated with the time worked 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 in completing the change task. | |
| cht_approval | String | Shows the current approval status of the change task, such as requested, approved, or rejected. | |
| cht_approval_history | String | Displays the approval history for the change task, showing previous actions and decision timestamps. | |
| cht_approval_set | Datetime | Lists the date and time when the approval status of the change task was last updated. | |
| cht_assigned_to | String | Identifies the user currently responsible for executing 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 performing 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 | Tracks 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 the result of the change task, such as successful or canceled. | |
| cht_close_notes | String | Provides closure notes summarizing the outcome and key details of the completed change task. | |
| 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 upon completion. | |
| cht_closed_by_link | String | Provides the hyperlink reference to the user record who closed the task. | |
| cht_cmdb_ci | String | References the Configuration Item (CI) from the Configuration Management Database (CMDB) that is impacted by the change task. | |
| cht_cmdb_ci_link | String | Provides the hyperlink reference to the CI record in the CMDB. | |
| cht_comments | String | Stores user comments describing progress, actions, or issues related to the change task. | |
| cht_comments_and_work_notes | String | Combines comments and work notes into a unified record for activity tracking and auditing. | |
| cht_company | String | Lists the company or business entity 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 initiated, such as via phone, email, or self-service portal. | |
| cht_correlation_display | String | Displays a readable reference linking the change task to a related external or internal record. | |
| cht_correlation_id | String | Stores a unique identifier used to correlate the change task with related processes or systems. | |
| cht_created_from | String | Identifies the source record or process that generated the change task. | |
| cht_delivery_plan | String | Specifies the delivery plan outlining steps, milestones, or dependencies for the change task. | |
| cht_delivery_plan_link | String | Provides the hyperlink reference to the delivery plan record in ServiceNow. | |
| cht_delivery_task | String | References a related delivery task connected to the change task. | |
| cht_delivery_task_link | String | Provides the hyperlink reference to the delivery task record in ServiceNow. | |
| cht_description | String | Provides a detailed description of the change task, including objectives and execution steps. | |
| cht_due_date | Datetime | Lists the date and time by which the change task should be completed. | |
| cht_escalation | Int | Specifies the escalation level of the change task, indicating its urgency or priority in workflows. | |
| cht_expected_start | Datetime | Lists the expected start date and time for the change task. | |
| cht_follow_up | Datetime | Displays the date and time when a follow-up review or action is scheduled for the change task. | |
| cht_group_list | String | Lists all user groups involved in managing, reviewing, or performing the change task. | |
| cht_impact | Int | Represents the numerical impact level of the change task on services or business operations. | |
| cht_knowledge | Bool | Indicates whether the change task is linked to a Knowledge Base article. | |
| 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 were met for the change task. | |
| cht_number | String | Displays the unique identifier or number assigned to the change task. | |
| cht_on_hold | Bool | Indicates whether the change task is currently on hold. | |
| cht_on_hold_reason | String | Specifies the reason the change task was placed on hold, such as pending approval or dependency. | |
| cht_opened_at | Datetime | Displays the date and time when the change task was created or opened. | |
| cht_opened_by | String | Identifies the user who created or opened the change task. | |
| cht_opened_by_link | String | Provides the hyperlink reference to the record of the user who opened the change task. | |
| cht_order | Int | Specifies the order in which the change task is executed within its workflow or change request. | |
| cht_parent | String | References the parent record or process to which the change task belongs. | |
| cht_parent_link | String | Provides the hyperlink reference to the parent record in ServiceNow. | |
| cht_planned_end_date | Datetime | Lists the planned date and time for completing the change task. | |
| cht_planned_start_date | Datetime | Lists the planned date and time for starting the change task. | |
| cht_priority | Int | Specifies the priority level of the change task, determined by its impact and urgency. | |
| cht_reassignment_count | Int | Tracks how many times the change task has been reassigned to different users or groups. | |
| cht_rejection_goto | String | Defines the workflow state the change task transitions to when it is rejected. | |
| cht_rejection_goto_link | String | Provides the hyperlink reference to the rejection workflow state or rule record. | |
| cht_route_reason | Int | Lists the numeric routing reason code used for workflow transitions in the change task. | |
| cht_service_offering | String | Lists the service offering affected 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 describing the main purpose or action of the change task. | |
| cht_sla_due | Datetime | Lists the date and time by which the SLA requirements for the change task must be met. | |
| cht_state | Int | Represents the numerical value corresponding to the current workflow state of the change task, such as new, in progress, or closed. | |
| cht_sys_class_name | String | Specifies the system class name of the change task within the ServiceNow schema. | |
| cht_sys_created_by | String | Shows the user or process that 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 to which the change task belongs in multi-domain ServiceNow environments. | |
| cht_sys_domain_path | String | Defines the hierarchical domain path representing where the change task resides within the domain structure. | |
| cht_sys_mod_count | Int | Tracks the total number of times the change task record has been modified since its creation. | |
| cht_sys_tags | String | Lists any system tags assigned to the change task record for filtering, 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 most recently updated. | |
| cht_task_effective_number | String | Lists the effective task number used to ensure consistent tracking across related records and workflows. | |
| cht_time_worked | String | Tracks the total time spent working on the change task, typically measured in minutes or hours. | |
| cht_u_comments | String | Stores any additional user comments or notes relevant to the change task's progress or outcome. | |
| cht_u_some_test_field | String | Holds the value of a custom field used for testing or internal validation purposes. | |
| cht_universal_request | String | References a universal request that is linked to or originated the change task. | |
| cht_universal_request_link | String | Provides the hyperlink reference to the related universal request record in ServiceNow. | |
| cht_upon_approval | String | Defines the automated workflow action that occurs when the change task is approved. | |
| cht_upon_reject | String | Defines the automated workflow action that occurs when the change task is rejected. | |
| cht_urgency | Int | Represents the numeric urgency value of the change task, where lower numbers indicate higher urgency. | |
| cht_user_input | String | Stores user-provided input data or form values captured during the change task's execution. | |
| cht_variables | String | Lists variable values or dynamic field data defined for the change task. | |
| cht_watch_list | String | Lists users or groups subscribed to notifications and updates related to the change task. | |
| cht_wf_activity | String | References the workflow activity record associated with the automated flow controlling the change task. | |
| cht_wf_activity_link | String | Provides the hyperlink reference to the workflow activity record in ServiceNow. | |
| cht_work_end | Datetime | Lists the date and time when work on the change task was completed. | |
| cht_work_notes | String | Stores detailed work notes describing actions taken, troubleshooting performed, or observations made during the change task. | |
| cht_work_notes_list | String | Displays the full history of work notes recorded for the change task. | |
| cht_work_start | Datetime | Lists the date and time when work on the change task began. |