sc_task_metric
Provides task performance metrics for Service Catalog (SC) requests, highlighting efficiency and workload.
Columns
| Name | Type | References | Description |
| sct_sys_id | String | Provides the system identifier (sys_id) for the SC task record, used for tracking and reporting. | |
| sct_active | Bool | Indicates whether the task is currently active and being worked on. | |
| sct_activity_due | Datetime | Specifies the date and time when the next activity related to the task is due. | |
| sct_additional_assignee_list | String | Lists additional users assigned to assist in completing the task. | |
| sct_approval | String | Shows the current approval status of the task, such as pending, approved, or rejected. | |
| sct_approval_history | String | Contains the complete approval history, including approvers, actions, and timestamps. | |
| sct_approval_set | Datetime | Records when the approval status was last set or updated. | |
| sct_assigned_to | String | Identifies the user currently responsible for completing the task. | |
| sct_assigned_to_link | String | Provides a link to the user record assigned to the task. | |
| sct_assignment_group | String | References the group responsible for managing or resolving the task. | |
| sct_assignment_group_link | String | Provides a link to the assignment group record. | |
| sct_business_duration | Long | Captures the total business time spent on the task, excluding weekends and holidays. | |
| sct_business_service | String | References the business service associated with the task or impacted by it. | |
| sct_business_service_link | String | Provides a link to the business service record connected to the task. | |
| sct_calendar_duration | Long | Shows the total elapsed time from task creation to completion, including non-working hours. | |
| sct_calendar_stc | Int | Represents the elapsed calendar time in seconds for analysis and reporting. | |
| sct_close_notes | String | Contains final notes or remarks added when the task was closed. | |
| sct_closed_at | Datetime | Records when the task was completed or marked as closed. | |
| sct_closed_by | String | Identifies the user who closed the task record. | |
| sct_closed_by_link | String | Provides a link to the record of the user who closed the task. | |
| sct_cmdb_ci | String | References the Configuration Item (CI) linked to the task. | |
| sct_cmdb_ci_link | String | Provides a link to the CI record associated with the task. | |
| sct_comments | String | Captures user-entered comments related to the task. | |
| sct_comments_and_work_notes | String | Stores both customer-facing comments and internal work notes used for progress tracking. | |
| sct_company | String | References the company or organization associated with the task. | |
| sct_company_link | String | Provides a link to the company record. | |
| sct_contact_type | String | Indicates how the task was created, such as through the portal, email, or workflow automation. | |
| sct_correlation_display | String | Displays a readable correlation reference linking the task to external systems. | |
| sct_correlation_id | String | Stores a correlation identifier used to associate the task with integrations or processes outside the platform. | |
| sct_delivery_plan | String | References the delivery plan that outlines how the task will be fulfilled. | |
| sct_delivery_plan_link | String | Provides a link to the delivery plan record. | |
| sct_delivery_task | String | References the fulfillment task responsible for executing the related service request. | |
| sct_delivery_task_link | String | Provides a link to the delivery task record. | |
| sct_description | String | Provides a detailed explanation of the task and its purpose. | |
| sct_due_date | Datetime | Indicates when the task is expected to be completed. | |
| sct_escalation | Int | Represents the escalation level applied to the task, affecting priority or routing. | |
| sct_expected_start | Datetime | Specifies when work on the task is scheduled to begin. | |
| sct_follow_up | Datetime | Defines a date and time for a follow-up action or review of the task. | |
| sct_group_list | String | Lists all groups involved in processing or approving the task. | |
| sct_impact | Int | Indicates the business impact level associated with the task. | |
| sct_knowledge | Bool | Shows whether the task resulted in creating or referencing a Knowledge Base (KB) article. | |
| sct_location | String | References the location associated with the task, such as where the service is delivered. | |
| sct_location_link | String | Provides a link to the location record. | |
| sct_made_sla | Bool | Indicates whether the task met its Service Level Agreement (SLA) targets. | |
| sct_number | String | Stores the unique task number automatically generated for tracking and identification. | |
| sct_opened_at | Datetime | Records the timestamp when the task was created or opened. | |
| sct_opened_by | String | Identifies the user who created or initiated the task. | |
| sct_opened_by_link | String | Provides a link to the user record of the person who opened the task. | |
| sct_order | Int | Defines the sequence or display order of this task in workflows or reports. | |
| sct_parent | String | References the parent record, such as the associated service request or project. | |
| sct_parent_link | String | Provides a link to the parent record associated with this task. | |
| sct_priority | Int | Represents the task's priority level, determined by its impact and urgency. | |
| sct_reassignment_count | Int | Tracks how many times the task has been reassigned to different users or groups. | |
| sct_rejection_goto | String | Specifies the workflow stage or action triggered when the task is rejected. | |
| sct_rejection_goto_link | String | Provides a link to the workflow element that handles rejections. | |
| sct_request | String | References the service request associated with this task. | |
| sct_request_item | String | References the specific catalog item or request item related to this task. | |
| sct_request_item_link | String | Provides a link to the catalog item record associated with the task. | |
| sct_request_link | String | Provides a link to the parent service request record. | |
| sct_route_reason | Int | Indicates the routing reason or rule applied to determine task assignment. | |
| sct_sc_catalog | String | References the SC associated with the task. | |
| sct_sc_catalog_link | String | Provides a link to the SC record related to the task. | |
| sct_service_offering | String | References the service offering that defines the type of service delivered through the task. | |
| sct_service_offering_link | String | Provides a link to the related service offering record. | |
| sct_short_description | String | Provides a concise summary or title describing the task. | |
| sct_sla_due | Datetime | Specifies the date and time by which the SLA target must be met for this task. | |
| sct_state | Int | Represents the current workflow state of the task, such as open, in progress, or closed. | |
| sct_sys_class_name | String | Defines the record's system class, determining its behavior and form layout. | |
| sct_sys_created_by | String | Identifies the user who created the task record. | |
| sct_sys_created_on | Datetime | Records when the task record was first created. | |
| sct_sys_domain | String | Specifies the domain the task belongs to, relevant in domain-separated environments. | |
| sct_sys_domain_path | String | Displays the full hierarchical domain path for the record. | |
| sct_sys_mod_count | Int | Tracks the number of times the task record has been modified. | |
| sct_sys_tags | String | Stores tags or metadata used to organize or filter tasks. | |
| sct_sys_updated_by | String | Identifies the user who last updated the task record. | |
| sct_sys_updated_on | Datetime | Records the timestamp of the most recent update to the task record. | |
| sct_task_effective_number | String | Stores the effective task number used in reporting or integration contexts. | |
| sct_time_worked | String | Displays the total amount of time spent working on the task. | |
| sct_u_comments | String | Captures user comments or additional context added during task processing. | |
| sct_u_some_test_field | String | Represents a custom test field used for configuration or validation purposes. | |
| sct_universal_request | String | References a universal request record grouping multiple catalog actions. | |
| sct_universal_request_link | String | Provides a link to the universal request record. | |
| sct_upon_approval | String | Specifies the automatic action performed when the task is approved. | |
| sct_upon_reject | String | Specifies the automatic action performed when the task is rejected. | |
| sct_urgency | Int | Indicates how urgently the task needs to be completed, used in priority calculation. | |
| sct_user_input | String | Captures any user-provided input or selections made during task submission. | |
| sct_variables | String | Stores variable data or responses associated with the task. | |
| sct_watch_list | String | Lists users who receive notifications about task updates or changes. | |
| sct_wf_activity | String | References the workflow activity currently being executed for this task. | |
| sct_wf_activity_link | String | Provides a link to the workflow activity record. | |
| sct_work_end | Datetime | Records when work on the task was completed. | |
| sct_work_notes | String | Contains internal work notes added by fulfillers while processing the task. | |
| sct_work_notes_list | String | Stores all work notes related to the task for auditing and tracking. | |
| sct_work_start | Datetime | Records when work on the task began. | |
| mi_sys_id | String | Provides the sys_id of the metric instance associated with this task's performance measurement. | |
| mi_business_duration | Long | Captures the total business time measured for the task, excluding non-working hours. | |
| mi_calculation_complete | Bool | Indicates whether the metric instance has finished calculating results for the task. | |
| mi_definition | String | References the metric definition that determines how task performance is measured. | |
| mi_definition_link | String | Provides a link to the metric definition record. | |
| mi_duration | Long | Shows the total elapsed time tracked by the metric instance, including all hours. | |
| mi_end | Datetime | Records the timestamp when the metric measurement ended. | |
| mi_field | String | Specifies the field monitored by the metric instance on the task record. | |
| mi_field_value | String | Displays the field's value captured during metric evaluation. | |
| mi_id | String | Stores the identifier for the metric instance, used for auditing and correlation. | |
| mi_start | Datetime | Records when the metric instance began measuring the task's progress. | |
| mi_sys_created_by | String | Identifies the user who created the metric instance record. | |
| mi_sys_created_on | Datetime | Records when the metric instance was first created. | |
| mi_sys_mod_count | Int | Tracks how many times the metric instance has been modified. | |
| mi_sys_tags | String | Stores tags or metadata used to organize metric instance records. | |
| mi_sys_updated_by | String | Identifies the user who last updated the metric instance record. | |
| mi_sys_updated_on | Datetime | Records the timestamp of the most recent update to the metric instance. | |
| mi_table | String | Specifies the table on which the metric instance was calculated. | |
| mi_value | String | Stores the computed value or result of the metric for this task. | |
| md_sys_id | String | Provides the sys_id of the metric definition that specifies what is being measured. | |
| md_active | Bool | Indicates whether the metric definition is active and currently in use. | |
| md_description | String | Describes the purpose and logic behind the metric definition. | |
| md_field | String | Specifies the field being evaluated by the metric definition. | |
| md_name | String | Stores the display name of the metric definition. | |
| md_number | String | Stores the unique number assigned to the metric definition. | |
| md_order | Int | Determines the execution or display order of this metric definition. | |
| md_script | String | Contains the script logic used to evaluate or compute the metric. | |
| md_sys_class_name | String | Defines the record's system class for the metric definition. | |
| md_sys_created_by | String | Identifies the user who created the metric definition. | |
| md_sys_created_on | Datetime | Records when the metric definition was created. | |
| md_sys_mod_count | Int | Tracks how many times the metric definition has been modified. | |
| md_sys_name | String | Stores the internal system name of the metric definition record. | |
| md_sys_package | String | References the application package that contains the metric definition. | |
| md_sys_package_link | String | Provides a link to the application package record. | |
| md_sys_policy | String | Specifies the update or protection policy applied to the metric definition. | |
| md_sys_scope | String | References the application scope that owns the metric definition. | |
| md_sys_scope_link | String | Provides a link to the scope record associated with the metric definition. | |
| md_sys_tags | String | Stores tags or metadata used for organizing metric definitions. | |
| md_sys_update_name | String | Stores the unique update name used for version control and upgrades. | |
| md_sys_updated_by | String | Identifies the user who last modified the metric definition. | |
| md_sys_updated_on | Datetime | Records when the metric definition was last updated. | |
| md_table | String | Specifies the table to which the metric definition applies. | |
| md_timeline | Bool | Indicates whether the metric should appear on timelines or performance dashboards. | |
| md_type | String | Defines the metric type, such as duration, count, or state change. |