Power BI Connector for ServiceNow

Build 25.0.9454

task_assessment_detail

Displays details for task assessments, including evaluator feedback and scoring criteria.

Columns

Name Type References Description
asmtins_sys_id String Provides the system identifier (sys_id) for the assessment instance record.
asmtins_assessment_group String References the assessment group associated with this instance, grouping related assessments together.
asmtins_assessment_group_link String Provides a link to the record of the related assessment group.
asmtins_due_date Date Specifies the date by which the assessment must be completed.
asmtins_expiration_date Date Indicates the date when the assessment expires and can no longer be submitted.
asmtins_metric_type String References the type of metric used to evaluate this assessment instance.
asmtins_metric_type_link String Provides a link to the record of the metric type associated with this assessment.
asmtins_number String Stores the unique number assigned to this assessment instance for tracking purposes.
asmtins_percent_answered Decimal Shows the percentage of questions that have been answered in the assessment.
asmtins_preview Bool Indicates whether this assessment instance is in preview mode rather than live use.
asmtins_related_id_1 String Stores the sys_id of the first related record associated with this assessment instance.
asmtins_related_id_2 String Stores the sys_id of the second related record associated with this assessment instance.
asmtins_related_id_3 String Stores the sys_id of the third related record associated with this assessment instance.
asmtins_related_id_4 String Stores the sys_id of the fourth related record associated with this assessment instance.
asmtins_related_table_1 String Specifies the name of the table for the first related record linked to this assessment.
asmtins_related_table_2 String Specifies the name of the table for the second related record linked to this assessment.
asmtins_related_table_3 String Specifies the name of the table for the third related record linked to this assessment.
asmtins_related_table_4 String Specifies the name of the table for the fourth related record linked to this assessment.
asmtins_signature String References the digital signature or authentication associated with the assessment instance.
asmtins_signature_link String Provides a link to the record containing the related signature details.
asmtins_signature_result String Captures the result or validation status of the assessment's signature.
asmtins_state String Indicates the current state or progress of the assessment instance, such as in progress or complete.
asmtins_sys_created_by String Identifies the user who created the assessment instance record.
asmtins_sys_created_on Datetime Records the date and time when the assessment instance was created.
asmtins_sys_domain String Indicates the domain to which the assessment instance belongs in a multi-domain environment.
asmtins_sys_domain_path String Specifies the hierarchical domain path for the assessment instance record.
asmtins_sys_mod_count Int Tracks the number of times the assessment instance record has been modified.
asmtins_sys_tags String Lists tags associated with the assessment instance for categorization or filtering.
asmtins_sys_updated_by String Identifies the user who last modified the assessment instance record.
asmtins_sys_updated_on Datetime Records the date and time when the assessment instance record was last updated.
asmtins_taken_on Datetime Indicates the date and time when the assessment was taken by the user.
asmtins_task_id String References the task record linked to this assessment instance.
asmtins_task_id_link String Provides a link to the related task record associated with the assessment.
asmtins_trigger_condition String Defines the condition that triggered this assessment instance.
asmtins_trigger_condition_link String Provides a link to the record of the trigger condition associated with the assessment.
asmtins_trigger_id String Stores the sys_id of the specific trigger that initiated the assessment instance.
asmtins_trigger_table String Specifies the table from which the assessment trigger originated.
asmtins_user String References the user assigned to complete this assessment.
asmtins_user_link String Provides a link to the record of the user associated with this assessment instance.
asmttype_sys_id String Provides the sys_id for the assessment type record defining the structure of this assessment.
asmttype_active Bool Indicates whether the assessment type is currently active and available for use.
asmttype_allow_public Bool Specifies whether the assessment can be accessed publicly without authentication.
asmttype_allow_retake Bool Determines whether users can retake the same assessment after submission.
asmttype_anonymize Bool Indicates whether responses to the assessment are anonymized.
asmttype_business_rule String References the business rule that governs how this assessment type operates.
asmttype_business_rule_link String Provides a link to the business rule record associated with this assessment type.
asmttype_condition String Defines the logical condition that determines when the assessment should be triggered.
asmttype_default_filter String Specifies the default filter applied to responses or records related to this assessment type.
asmttype_delete_business_rule String References the business rule that applies when this assessment type is deleted.
asmttype_delete_business_rule_link String Provides a link to the business rule executed on deletion of this assessment type.
asmttype_description String Provides a detailed description of the assessment type and its purpose.
asmttype_disable_ui_action String References a user interface (UI) action that is disabled for this assessment type.
asmttype_disable_ui_action_link String Provides a link to the disabled UI action record associated with this assessment type.
asmttype_display_all_filters Bool Indicates whether all filters should be displayed when reviewing assessments of this type.
asmttype_display_field String Specifies which field is displayed as the primary label for this assessment type.
asmttype_duration Long Defines the time allowed to complete the assessment, expressed in milliseconds.
asmttype_enable_ui_action String References a UI action that is enabled for this assessment type.
asmttype_enable_ui_action_link String Provides a link to the record of the enabled UI action.
asmttype_end_note String Contains a closing note or message shown when an assessment is completed.
asmttype_enforce_condition Bool Indicates whether the trigger condition for this assessment type must always be enforced.
asmttype_evaluation_method String Defines the evaluation method used for the assessment, such as scoring or ranking.
asmttype_filter_condition String Specifies the filtering condition applied to determine which records are assessed.
asmttype_filter_table String Indicates the table used to apply filter conditions for this assessment type.
asmttype_introduction String Provides an introductory note or instructions shown at the start of the assessment.
asmttype_job String References the scheduled job responsible for managing or running this assessment type.
asmttype_job_link String Provides a link to the job record associated with the assessment type.
asmttype_live_feed Bool Indicates whether assessment activity is posted to the system's live feed.
asmttype_name String Stores the name of the assessment type as displayed in the system.
asmttype_not_show_intro_note Bool Specifies whether to hide the introductory note when displaying the assessment.
asmttype_notify_if_overdue Bool Indicates whether a notification should be sent if an assessment becomes overdue.
asmttype_notify_user Bool Determines whether the assessed user should be notified about the assessment.
asmttype_one_click_survey Bool Indicates whether this assessment can be submitted with a single click, such as in quick surveys.
asmttype_overdue_notify_user String References the user who receives notifications when an assessment becomes overdue.
asmttype_overdue_notify_user_link String Provides a link to the user record designated for overdue notifications.
asmttype_portal_pagination String Specifies how pages of the assessment appear in the user portal interface.
asmttype_publish_state String Indicates the publication state of the assessment type, such as draft or published.
asmttype_roles String Lists the roles required to access or respond to assessments of this type.
asmttype_sample_metric String References a sample metric used to illustrate the assessment type's scoring model.
asmttype_sample_metric_link String Provides a link to the record of the sample metric.
asmttype_scale_factor Int Defines the scaling factor used to normalize assessment results.
asmttype_schedule_period String Specifies the recurrence period for scheduled assessments.
asmttype_schedule_type String Indicates the scheduling model, such as ad hoc or recurring.
asmttype_scoring_type String Defines how the assessment responses are scored, such as weighted or average scoring.
asmttype_signature String References the digital signature setup for this assessment type.
asmttype_signature_link String Provides a link to the record of the related signature configuration.
asmttype_source_table String Identifies the source table from which data for the assessment is derived.
asmttype_survey_owners String Lists the users responsible for maintaining or overseeing the survey.
asmttype_sys_class_name String Defines the system class for this assessment type record.
asmttype_sys_created_by String Identifies the user who created this assessment type record.
asmttype_sys_created_on Datetime Records the date and time when this assessment type was created.
asmttype_sys_domain String Indicates the domain to which this assessment type belongs in multi-domain environments.
asmttype_sys_domain_path String Specifies the hierarchical domain path for this assessment type.
asmttype_sys_mod_count Int Tracks the number of updates made to this assessment type record.
asmttype_sys_name String Stores the internal system name of the assessment type record.
asmttype_sys_package String References the application package that contains this assessment type.
asmttype_sys_package_link String Provides a link to the record of the related application package.
asmttype_sys_policy String Specifies the system policy associated with this assessment type.
asmttype_sys_scope String Identifies the application scope that owns this assessment type record.
asmttype_sys_scope_link String Provides a link to the scope record associated with the assessment type.
asmttype_sys_tags String Lists tags associated with the assessment type for classification or filtering.
asmttype_sys_update_name String Contains the unique update name used to track this assessment type in update sets.
asmttype_sys_updated_by String Identifies the user who last modified this assessment type record.
asmttype_sys_updated_on Datetime Records the date and time when the assessment type record was last updated.
asmttype_table String Specifies the table where the results or instances of this assessment are stored.
asmttype_url String Stores the URL used to access the assessment form or portal page.
asmttype_user_field String Defines the user field that identifies who should complete the assessment.
task_sys_id String Provides the system identifier (sys_id) for the related task record.
task_active Bool Indicates whether the task is currently active and being worked on.
task_activity_due Datetime Specifies the date and time when the next activity or action for the task is due.
task_additional_assignee_list String Lists additional users assigned to work on or review the task.
task_approval String Shows the current approval status of the task, such as requested, approved, or rejected.
task_approval_history String Contains the history of all approvals or rejections related to the task.
task_approval_set Datetime Records the date and time when the approval status for the task was last updated.
task_assigned_to String References the user currently assigned to complete the task.
task_assigned_to_link String Provides a link to the user record associated with the task assignee.
task_assignment_group String References the group responsible for handling or resolving the task.
task_assignment_group_link String Provides a link to the assignment group record related to the task.
task_business_duration Long Represents the total business time spent on the task, excluding non-working hours.
task_business_service String References the business service impacted or supported by the task.
task_business_service_link String Provides a link to the business service record associated with the task.
task_calendar_duration Long Captures the total elapsed time spent on the task, including non-business hours.
task_close_notes String Contains notes or explanations entered when the task was closed.
task_closed_at Datetime Records the date and time when the task was marked as closed.
task_closed_by String Identifies the user who closed the task record.
task_closed_by_link String Provides a link to the user record of the person who closed the task.
task_cmdb_ci String References the Configuration Item (CI) linked to this task in the Configuration Management Database (CMDB).
task_cmdb_ci_link String Provides a link to the CMDB record of the associated CI.
task_comments String Includes any general comments added to the task by users or approvers.
task_comments_and_work_notes String Combines all comments and work notes entered for the task.
task_company String References the company associated with the task, typically the customer or internal business unit.
task_company_link String Provides a link to the company record associated with the task.
task_contact_type String Indicates how the task was initiated, such as by phone, email, or self-service portal.
task_correlation_display String Shows an external identifier used to correlate this task with other systems or records.
task_correlation_id String Stores a unique correlation ID that links this task to external integrations or systems.
task_delivery_plan String References the delivery plan associated with the task, if applicable.
task_delivery_plan_link String Provides a link to the related delivery plan record.
task_delivery_task String References a delivery task linked to this record as part of a broader process.
task_delivery_task_link String Provides a link to the record of the associated delivery task.
task_description String Contains a detailed description of the task and its requirements.
task_due_date Datetime Specifies the date and time when the task is due for completion.
task_escalation Int Indicates the escalation level assigned to the task for prioritization or management purposes.
task_expected_start Datetime Specifies the expected start date and time for the task.
task_follow_up Datetime Indicates the date and time when follow-up action is required for the task.
task_group_list String Lists all groups associated with the task through assignments or notifications.
task_impact Int Represents the impact level of the task on business operations or services.
task_knowledge Bool Indicates whether this task should be converted into a knowledge base article after completion.
task_location String Specifies the location related to the task, such as a user site or office.
task_location_link String Provides a link to the location record associated with the task.
task_made_sla Bool Indicates whether the task met its Service Level Agreement (SLA) targets.
task_number String Stores the unique task number automatically generated by the system.
task_opened_at Datetime Records the date and time when the task was first opened.
task_opened_by String Identifies the user who created or opened the task record.
task_opened_by_link String Provides a link to the record of the user who opened the task.
task_order Int Defines the order in which the task should be executed relative to other tasks in a process.
task_parent String References the parent task or record to which this task is related.
task_parent_link String Provides a link to the record of the parent task.
task_priority Int Indicates the urgency or priority level assigned to the task.
task_reassignment_count Int Tracks how many times the task has been reassigned to different users or groups.
task_rejection_goto String Specifies the next action or task to transition to if this task is rejected.
task_rejection_goto_link String Provides a link to the record defining the rejection transition.
task_route_reason Int Captures the reason code explaining why the task was routed or reassigned.
task_service_offering String References the specific service offering associated with this task.
task_service_offering_link String Provides a link to the record of the related service offering.
task_short_description String Contains a brief summary or title describing the purpose of the task.
task_sla_due Datetime Specifies the date and time when the task's Service Level Agreement (SLA) is due.
task_state Int Indicates the current state of the task, such as new, in Progress, or closed.
task_sys_class_name String Defines the system class for the task record, indicating its structure and behavior.
task_sys_created_by String Identifies the user who created the task record.
task_sys_created_on Datetime Records the date and time when the task record was created.
task_sys_domain String Indicates the domain to which this task record belongs in multi-domain environments.
task_sys_domain_path String Specifies the hierarchical domain path for this task record.
task_sys_mod_count Int Tracks the number of updates made to the task record since creation.
task_sys_tags String Lists any tags associated with the task for search or classification.
task_sys_updated_by String Identifies the user who last modified this task record.
task_sys_updated_on Datetime Records the date and time when the task record was last updated.
task_task_effective_number String Stores the effective task number for tracking within workflows or reporting.
task_time_worked String Captures the total amount of time spent working on the task.
task_u_comments String Includes user-defined comments or additional notes about the task.
task_u_some_test_field String Stores data for a custom field used for testing or experimental purposes.
task_universal_request String References the universal request record linked to this task, if applicable.
task_universal_request_link String Provides a link to the universal request record associated with this task.
task_upon_approval String Defines the workflow action to be executed if the task is approved.
task_upon_reject String Defines the workflow action to be executed if the task is rejected.
task_urgency Int Indicates how urgently the task must be addressed relative to other tasks.
task_user_input String Captures input or responses provided by the user during task processing.
task_variables String Contains variables or parameters used within the task workflow.
task_watch_list String Lists users who receive notifications or updates about this task.
task_wf_activity String References the workflow activity record currently associated with the task.
task_wf_activity_link String Provides a link to the related workflow activity record.
task_work_end Datetime Records the date and time when work on the task was completed.
task_work_notes String Contains internal notes or updates added by users while working on the task.
task_work_notes_list String Displays a consolidated list of all work notes associated with the task.
task_work_start Datetime Records the date and time when work on the task began.
metricres_sys_id String Provides the sys_id for the metric result record associated with the assessment.
metricres_actual_value Decimal Represents the actual measured value captured during the assessment.
metricres_add_info String Contains additional information or context related to the metric result.
metricres_assessment_group String References the assessment group linked to this metric result.
metricres_assessment_group_link String Provides a link to the assessment group record associated with this metric result.
metricres_assign_to_order String Specifies the sequence or order in which this metric was assigned for evaluation.
metricres_duration_value Long Captures the duration value measured by this metric in milliseconds.
metricres_instance String References the assessment instance associated with this metric result.
metricres_instance_link String Provides a link to the record of the related assessment instance.
metricres_instance_question String References the specific assessment question tied to this metric result.
metricres_instance_question_link String Provides a link to the record of the associated assessment question.
metricres_is_default Bool Indicates whether this metric result is set as the default for its category.
metricres_metric String References the metric definition used to calculate or record this result.
metricres_metric_definition String Specifies the detailed definition used to compute the metric value.
metricres_metric_definition_link String Provides a link to the record of the metric definition.
metricres_metric_link String Provides a link to the record of the metric associated with this result.
metricres_normalized_value Decimal Represents the normalized score derived from the raw metric value.
metricres_nps_value Int Captures the Net Promoter Score (NPS) or similar rating derived from the assessment.
metricres_passed String Indicates whether the metric result met the defined success criteria.
metricres_reference_table String Specifies the table containing the record that this metric result references.
metricres_reference_value String Stores the value or identifier of the record referenced by the metric.
metricres_scaled_value Decimal Represents the scaled or weighted value used in aggregate assessment scoring.
metricres_source_id String Stores the sys_id of the source record from which this metric result originated.
metricres_source_table String Identifies the source table that provided the data for the metric result.
metricres_string_value String Stores the raw text or string representation of the metric result.
metricres_sys_created_by String Identifies the user who created this metric result record.
metricres_sys_created_on Datetime Records the date and time when the metric result record was created.
metricres_sys_domain String Indicates the domain to which this metric result belongs in multi-domain configurations.
metricres_sys_domain_path String Specifies the hierarchical domain path for this metric result record.
metricres_sys_mod_count Int Tracks how many times the metric result record has been updated.
metricres_sys_tags String Lists tags used to categorize or label this metric result record.
metricres_sys_updated_by String Identifies the user who last updated this metric result record.
metricres_sys_updated_on Datetime Records the date and time when the metric result record was last modified.
metricres_template_definition String References the metric template definition applied to this result.
metricres_template_definition_link String Provides a link to the record of the associated metric template definition.
metricres_user String References the user whose responses generated this metric result.
metricres_user_link String Provides a link to the record of the user associated with the metric result.
metricres_weighted_value Decimal Represents the weighted score of the metric, used in overall assessment calculations.

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