Power BI Connector for ServiceNow

Build 25.0.9454

task

Tracks generic task records used by multiple ServiceNow applications, including incidents, problems, and changes.

Columns

Name Type ReadOnly References Description
delivery_task String False

References the delivery task linked to this record as part of a broader fulfillment or implementation process.

upon_approval String False

Defines the workflow action that occurs automatically when the task is approved.

work_start Datetime False

Records the date and time when work on the task officially began.

delivery_plan String False

References the delivery plan associated with the task, outlining its scheduled execution steps.

rejection_goto String False

Specifies the next task or process flow to follow if this task is rejected.

work_end Datetime False

Captures the date and time when work on the task was completed.

upon_reject String False

Defines the workflow action that is triggered if the task is rejected.

business_service String False

References the business service impacted or supported by the task in the organization's service model.

sys_id [KEY] String False

Provides the system identifier (sys_id) for the task record.

sys_domain String False

Indicates the domain to which the task record belongs in multi-domain configurations.

sys_created_on Datetime False

Records the date and time when the task record was created.

sys_updated_on Datetime False

Specifies the date and time when the task record was last updated.

expected_start Datetime False

Indicates the planned start date and time for the task.

variables String False

Contains workflow variables or parameters relevant to task processing.

number String False

Stores the system-generated unique task number used for identification and tracking.

comments String False

Includes user-provided comments or updates about the task's progress or details.

urgency String False

Defines the urgency level of the task, influencing how it is prioritized in workflows.

opened_at Datetime False

Records the date and time when the task was first opened or initiated.

watch_list String False

Lists users who receive notifications or updates about task status changes.

sla_due Datetime False

Specifies the date and time by which the task's Service Level Agreement (SLA) must be met.

active String False

Indicates whether the task is currently active and pending resolution.

state String False

Shows the current state of the task, such as new, in progress, or closed.

work_notes String False

Contains internal notes recorded by users while performing work on the task.

closed_by String False

Identifies the user who completed or closed the task record.

follow_up Datetime False

Indicates the date and time for the next scheduled follow-up on the task.

work_notes_list String False

Displays a compiled list of all work notes entered for the task record.

cmdb_ci String False

References the Configuration Item (CI) related to the task in the Configuration Management Database (CMDB).

approval_history String False

Maintains a log of approval actions and decisions related to the task.

business_duration Datetime False

Captures the total business time elapsed on the task, excluding non-working hours.

location String False

References the location associated with the task, such as a site, office, or department.

user_input String False

Stores information or feedback entered by the user during task execution.

assigned_to String False

Identifies the user currently responsible for completing the task.

escalation String False

Specifies the escalation level or reason for increasing the task's priority.

time_worked String False

Records the total amount of time spent working on the task.

additional_assignee_list String False

Lists additional users assigned to assist in completing the task.

correlation_id String False

Stores a unique identifier linking this task to external systems or related processes.

comments_and_work_notes String False

Combines user comments and internal work notes for a complete task history.

order String False

Defines the order in which the task is processed relative to other related tasks.

made_sla String False

Indicates whether the task met its defined SLA requirements.

sys_mod_count String False

Tracks the total number of times the task record has been modified.

sys_created_by String False

Identifies the user who originally created the task record.

sys_updated_by String False

Identifies the user who most recently updated the task record.

sys_domain_path String False

Specifies the hierarchical path representing the domain structure for this task.

sys_class_name String False

Defines the system class of the task record, determining its structure and behavior.

parent String False

References the parent record or higher-level task associated with this task.

priority String False

Indicates the priority assigned to the task, determining its order of attention.

close_notes String False

Contains closure notes explaining the resolution or outcome of the task.

reassignment_count String False

Tracks the number of times the task has been reassigned to another user or group.

due_date Datetime False

Specifies the deadline by which the task must be completed.

short_description String False

Provides a concise summary or title describing the task's purpose.

company String False

References the company associated with the task, typically the customer or internal business entity.

approval_set Datetime False

Records the date and time when the current approval status was established.

opened_by String False

Identifies the user who opened or created the task.

contact_type String False

Indicates how the task was initiated, such as through email, phone, or self-service portal.

assignment_group String False

References the group responsible for handling or completing the task.

approval String False

Shows the current approval status of the task, such as requested, approved, or rejected.

calendar_duration Datetime False

Captures the total calendar time elapsed since the task was opened.

knowledge String False

Indicates whether the task information should be converted into a knowledge article after closure.

correlation_display String False

Displays an external reference or correlation label used to link related records.

wf_activity String False

References the workflow activity currently associated with the task.

description String False

Provides a detailed explanation of the task's purpose, requirements, or background.

impact String False

Represents the impact level of the task on business operations or services.

closed_at Datetime False

Records the date and time when the task was officially closed.

group_list String False

Lists all user groups associated with or notified about this task.

activity_due Datetime False

Specifies the date and time when the next action or update is due for this task.

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