sc_req_item_metric
Tracks metrics for individual request items, such as processing duration and approval time.
Columns
| Name | Type | References | Description |
| sci_sys_id | String | Provides the system identifier (sys_id) for the requested item, ensuring that each request record in the Service Catalog (SC) can be uniquely referenced. | |
| sci_active | Bool | Indicates whether the requested item record is currently active and being processed. | |
| sci_activity_due | Datetime | Specifies the date and time by which the next activity or task related to the request is due. | |
| sci_additional_assignee_list | String | Lists additional users who have been assigned to assist with the requested item. | |
| sci_approval | String | Displays the current approval status of the requested item, such as requested, approved, or rejected. | |
| sci_approval_history | String | Stores a log of previous approvals, rejections, and related workflow actions for this requested item. | |
| sci_approval_set | Datetime | Records when the approval status for the request was last set or modified. | |
| sci_assigned_to | String | Identifies the user currently responsible for fulfilling or managing this requested item. | |
| sci_assigned_to_link | String | Provides a link to the user record assigned to the requested item. | |
| sci_assignment_group | String | Specifies the group responsible for handling or fulfilling the requested item. | |
| sci_assignment_group_link | String | Provides a link to the group record associated with the requested item. | |
| sci_backordered | Bool | Indicates whether the requested item has been backordered, typically due to unavailability or delayed provisioning. | |
| sci_billable | Bool | Marks the item as billable, meaning costs will be allocated or invoiced to the requester or department. | |
| sci_business_duration | Long | Shows the total business time spent on processing this requested item, excluding non-working hours. | |
| sci_business_service | String | References the business service that this requested item supports or impacts. | |
| sci_business_service_link | String | Provides a link to the business service record related to this request. | |
| sci_calendar_duration | Long | Captures the total elapsed time, including non-business hours, between the request's start and completion. | |
| sci_cat_item | String | References the catalog item from which this request was generated. | |
| sci_cat_item_link | String | Provides a link to the catalog item record associated with the requested item. | |
| sci_close_notes | String | Contains notes or comments added by the fulfiller at the time the request was closed. | |
| sci_closed_at | Datetime | Records the date and time when the requested item was closed. | |
| sci_closed_by | String | Indicates the user who closed the requested item record. | |
| sci_closed_by_link | String | Provides a link to the user record of the person who closed the request. | |
| sci_cmdb_ci | String | References the Configuration Item (CI) associated with this requested item. | |
| sci_cmdb_ci_link | String | Provides a link to the CI record related to the request. | |
| sci_comments | String | Captures general comments added to the requested item record. | |
| sci_comments_and_work_notes | String | Stores both user comments and internal work notes related to the requested item's progress. | |
| sci_company | String | References the company or organizational entity associated with this requested item. | |
| sci_company_link | String | Provides a link to the company record tied to the request. | |
| sci_configuration_item | String | Specifies the CI directly affected or provisioned by this request. | |
| sci_configuration_item_link | String | Provides a link to the CI record referenced by this request. | |
| sci_contact_type | String | Indicates the type of contact method used to initiate the request, such as email, phone, or portal. | |
| sci_context | String | References the workflow or execution context associated with this requested item. | |
| sci_context_link | String | Provides a link to the context record that tracks the item's workflow execution. | |
| sci_correlation_display | String | Stores an external reference display name for correlating the request with other systems or integrations. | |
| sci_correlation_id | String | Stores an external correlation identifier used to link this request to external systems or processes. | |
| sci_delivery_plan | String | References the delivery plan defining the fulfillment sequence for this requested item. | |
| sci_delivery_plan_link | String | Provides a link to the delivery plan record associated with the request. | |
| sci_delivery_task | String | References the task that manages the delivery or provisioning of the item. | |
| sci_delivery_task_link | String | Provides a link to the delivery task record. | |
| sci_description | String | Contains a detailed description of the requested item, its purpose, or its specific requirements. | |
| sci_due_date | Datetime | Specifies the date and time by which the requested item is expected to be completed. | |
| sci_escalation | Int | Represents the current escalation level of the request, indicating its urgency or management attention. | |
| sci_estimated_delivery | Datetime | Indicates the estimated delivery or completion date for the requested item. | |
| sci_expected_start | Datetime | Specifies when work on this requested item is expected to begin. | |
| sci_flow_context | String | References the Flow Designer context used to automate actions related to the request. | |
| sci_flow_context_link | String | Provides a link to the flow context record that manages automation for this item. | |
| sci_follow_up | Datetime | Specifies a date for follow-up actions or reminders related to the requested item. | |
| sci_group_list | String | Lists all groups involved in processing or approving the requested item. | |
| sci_impact | Int | Indicates the level of business impact if the requested item is delayed or not fulfilled. | |
| sci_knowledge | Bool | Specifies whether knowledge content was created or linked as part of fulfilling this requested item. | |
| sci_location | String | References the location associated with the request, such as the requester's site or department. | |
| sci_location_link | String | Provides a link to the location record associated with the requested item. | |
| sci_made_sla | Bool | Indicates whether the requested item met its defined Service Level Agreement (SLA) targets. | |
| sci_number | String | Stores the unique request number automatically generated for this item. | |
| sci_opened_at | Datetime | Records the date and time when the requested item was created or opened. | |
| sci_opened_by | String | Indicates the user who initially opened or submitted the request. | |
| sci_opened_by_link | String | Provides a link to the user record of the requester or submitter. | |
| sci_order | Int | Defines the display order or sequence of this item relative to others in the request. | |
| sci_order_guide | String | References the order guide that generated this request, if applicable. | |
| sci_order_guide_link | String | Provides a link to the order guide record used to create the requested item. | |
| sci_parent | String | References the parent record, such as a request or task, from which this item originates. | |
| sci_parent_link | String | Provides a link to the parent record. | |
| sci_price | Decimal | Indicates the price of the requested item as defined in the catalog configuration. | |
| sci_priority | Int | Represents the priority of the request, usually derived from impact and urgency. | |
| sci_quantity | Int | Specifies the number of units requested for this catalog item. | |
| sci_reassignment_count | Int | Tracks how many times the requested item has been reassigned to different users or groups. | |
| sci_recurring_frequency | String | Specifies the frequency of recurring charges or deliveries for the requested item. | |
| sci_recurring_price | Decimal | Defines the recurring price that applies based on the set frequency. | |
| sci_rejection_goto | String | Specifies the next step or handler when the request is rejected. | |
| sci_rejection_goto_link | String | Provides a link to the rejection handling record or workflow stage. | |
| sci_request | String | References the parent request record that contains this catalog item. | |
| sci_request_link | String | Provides a link to the main request associated with this item. | |
| sci_requested_for | String | Identifies the user for whom the item was requested. | |
| sci_requested_for_link | String | Provides a link to the user record of the person for whom the item was requested. | |
| sci_route_reason | Int | Indicates the routing reason or path used to direct the request through workflow stages. | |
| sci_sc_catalog | String | References the SC that this requested item originates from. | |
| sci_sc_catalog_link | String | Provides a link to the SC record. | |
| sci_service_offering | String | References the specific service offering associated with this requested item. | |
| sci_service_offering_link | String | Provides a link to the service offering record. | |
| sci_short_description | String | Provides a concise summary of the requested item, displayed in lists and overviews. | |
| sci_sla_due | Datetime | Indicates the due date and time for SLA compliance for this requested item. | |
| sci_stage | String | Shows the current fulfillment or workflow stage of the requested item. | |
| sci_state | Int | Represents the current state of the request, such as open, work in progress, or closed. | |
| sci_sys_class_name | String | Defines the system class of the record, determining its structure and behavior in the platform. | |
| sci_sys_created_by | String | Indicates the user who created the requested item record. | |
| sci_sys_created_on | Datetime | Records the date and time when the requested item record was created. | |
| sci_sys_domain | String | Specifies the domain the record belongs to, used for domain separation in multi-tenant setups. | |
| sci_sys_domain_path | String | Provides the hierarchical path of the domain for the record. | |
| sci_sys_mod_count | Int | Tracks the number of times the record has been modified. | |
| sci_sys_tags | String | Stores metadata tags associated with the record for filtering or reporting. | |
| sci_sys_updated_by | String | Indicates the user who last updated the requested item record. | |
| sci_sys_updated_on | Datetime | Records the timestamp of the most recent update to the record. | |
| sci_task_effective_number | String | Stores the effective task number used to reference this requested item in workflow or reporting. | |
| sci_time_worked | String | Captures the total amount of time spent working on the requested item. | |
| sci_u_comments | String | Stores additional user comments or internal notes related to the request. | |
| sci_u_some_test_field | String | Represents a custom test or placeholder field used for internal configuration or testing. | |
| sci_universal_request | String | References a universal request record that consolidates multiple catalog items or actions. | |
| sci_universal_request_link | String | Provides a link to the universal request record. | |
| sci_upon_approval | String | Specifies the action that occurs automatically when the requested item is approved. | |
| sci_upon_reject | String | Specifies the action that occurs automatically when the requested item is rejected. | |
| sci_urgency | Int | Indicates the urgency level of the requested item, influencing its overall priority. | |
| sci_user_input | String | Captures user-provided input or answers to variables during submission. | |
| sci_variables | String | Stores the variables and their values associated with this catalog request. | |
| sci_watch_list | String | Lists users who receive updates or notifications about changes to this requested item. | |
| sci_wf_activity | String | References the current workflow activity managing the requested item. | |
| sci_wf_activity_link | String | Provides a link to the workflow activity record. | |
| sci_work_end | Datetime | Records when work on the requested item was completed. | |
| sci_work_notes | String | Contains internal work notes entered by fulfillers during request processing. | |
| sci_work_notes_list | String | Stores the list of all work notes associated with the requested item. | |
| sci_work_start | Datetime | Records when work on the requested item began. | |
| mi_sys_id | String | References the sys_id for the metric instance related to this requested item. | |
| mi_business_duration | Long | Measures the total business time taken to complete the request, excluding weekends and holidays. | |
| mi_calculation_complete | Bool | Indicates whether metric calculation for this record has been completed. | |
| mi_definition | String | References the metric definition used to evaluate this request's performance. | |
| mi_definition_link | String | Provides a link to the metric definition record. | |
| mi_duration | Long | Captures the total elapsed time, in milliseconds, between the start and end of the metric. | |
| mi_end | Datetime | Specifies when metric measurement ended for this requested item. | |
| mi_field | String | Indicates the specific field being tracked by the metric definition. | |
| mi_field_value | String | Displays the current value of the field being measured. | |
| mi_id | String | Represents a unique internal identifier for the metric instance. | |
| mi_start | Datetime | Specifies when metric measurement began for this requested item. | |
| mi_sys_created_by | String | Indicates the user who created the metric record. | |
| mi_sys_created_on | Datetime | Records when the metric instance was first generated. | |
| mi_sys_mod_count | Int | Tracks how many times the metric record has been modified. | |
| mi_sys_tags | String | Stores tags or labels used for organizing or filtering metric data. | |
| mi_sys_updated_by | String | Identifies the user who last modified the metric record. | |
| mi_sys_updated_on | Datetime | Records when the metric record was last updated. | |
| mi_table | String | Specifies the database table to which this metric instance applies. | |
| mi_value | String | Displays the measured value captured for this metric instance. | |
| md_sys_id | String | References the sys_id for the metric definition associated with this requested item. | |
| md_active | Bool | Indicates whether the metric definition is active and in use. | |
| md_description | String | Provides a description of the metric definition, explaining what it measures and why. | |
| md_field | String | Identifies the field in the target table that this metric tracks. | |
| md_name | String | Specifies the display name of the metric definition. | |
| md_number | String | Represents the system-generated identifier number for the metric definition. | |
| md_order | Int | Determines the order in which metrics are processed or displayed. | |
| md_script | String | Contains the script logic used to calculate or validate the metric's results. | |
| md_sys_class_name | String | Defines the system class for the metric definition record. | |
| md_sys_created_by | String | Indicates 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 the number of times the metric definition record has been modified. | |
| md_sys_name | String | Stores the internal system name for the metric definition. | |
| md_sys_package | String | References the application package that delivers the metric definition. | |
| md_sys_package_link | String | Provides a link to the package record associated with the metric definition. | |
| md_sys_policy | String | Specifies any system policies applied to the metric definition record. | |
| md_sys_scope | String | Identifies the application scope that owns the metric definition. | |
| md_sys_scope_link | String | Provides a link to the scope record. | |
| md_sys_tags | String | Stores metadata tags used for organizing or searching metric definitions. | |
| md_sys_update_name | String | Records the update set name that includes this metric definition change. | |
| md_sys_updated_by | String | Indicates 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 database table associated with this metric definition. | |
| md_timeline | Bool | Indicates whether the metric should be displayed on performance analytics timelines. | |
| md_type | String | Defines the metric type, such as duration-based or state-based measurement. |