Column name

Definition

Type

Used by Workforce Intelligence

object _key

A client-generated ID that is assigned to the Robot Runtime event payload.

String

time_stamp

A timestamp that indicates when the even occurred, in UTC format.

Bigint

True

time_zone_name

The time zone in which the event occurred.

String

time_bucket

Events grouped in 12-second intervals.

Bigint

event_sequence_number

Internal sequence number that can be used to distinguish events that occur at the same time.

Bigint

event_name

The name of the event as reported by the Robot Runtime event notification service.

String

True

event_source

An internal event source name.

String

operation_id

A system-generated globally unique identifier (GUID).

String

True

parent_operation_id

A system-generated globally unique identifier (GUID).

String

True

process_id

The number used by the computer's operating system to uniquely identify the process for which the event was reported.

String

process_state

This value is not collected.

String

session_id

String

tenant_key

This value is not collected.

String

user_id

If a client has a standalone Workforce Intelligence deployment, then this field is empty.

If a client uses Pega Robot Manager and Workforce Intelligence, then the value is generated based on the Robot Manager authentication method.

String

md_adapter_name

String

md_app_name

The name of the Windows executable program.

String

True

md_cell_column
md_cell_name
md_cell_row
md_cell_value
md_container
md_control
md_direct
md_document_html

The domain of the machine where Robot Runtime is running.

String

md_duration

The amount of time between this event and its starting pair, in milliseconds. Idle events are recorded in seconds.

Bigint

True

md_executable_path

The full installation path of the Windows executable program.

String

md_hwnd

The window handle of the application object for which the event was reported.

Integer

The time at which the system entered the idle state. The idle state follows a period of keyboard or mouse inactivity. You specify the amount of time that passes with no user interface activity before a system is considered idle using the HighLevelEvents keys in the DesktopAnalyticsConfig.xml file.

Timestamp

The MAC address of the machine where Robot Runtime is installed.

String

The machine name of the machine where Robot Runtime is installed.

String

md_metadata_version
md_name
md_native_type
md_normal_target_type
md_object_id
md_parent_object_id

These values are not collected and will always be null.

md_process_id

Integer

md_process_object_id

This value is not collected.

md_process_start_args

The command line arguments that are used to start an executable.

String

md_rectangle
md_root_process_object_id
md_root_window_object_id

md_session_id

The session identifier for the process that is running under Terminal Services, if used, for the event that was reported.

Integer

md_snapshot
md_source
md_tab_hwnd
md_target
md_target_type
md_text

These values are not collected and will always be null.

md_user_name

The Windows user name (network ID) of the user where Robot Runtime is running.

String

True

These values are not collected and will always be null.

md_url

The full URL of the website from which the event was reported.

String

True

md_url_path

The path part of the URL for the website from which the event was reported.

String

True

md_url_title

The text that displays for the website in the Microsoft Internet Explorer window, excluding Windows Internet Explorer.

md_url_query_string

The query part of the URL for the website from which the event was reported.

String

True

md_web_domain_name

The Internet identification (Domain Name or Hostname) label for the application from which the event was reported.

String

True

md_window_text

The text appearing in the Window title for the window for which the event was reported. For web applications, the text includes the URL title and the Internet Explorer text.

String

True

phrases

This value is not collected.

metadata

Contains additional metadata for the events in an array of nested JSON objects. The JSON object contains the metadata_name and metadata_value properties in the following array format. Note that the properties are separated by the pipe ( | ) symbol:

[{"metadata_name":"<name_of_metadata>" | "metadata_value":"<value_of_metadata_name>"}…]

String

True

The following items are the possible metadata_names:

UserEmail

The email address of the user.

String

ProductVersion

The version number of the Robot Runtime on the user's desktop.

String

SourceEvent

Values that represent Robot Runtime's raw event signature, which generally indicates the lower-level signal that caused Robot Runtime to generate the high-level event. This field is used for diagnosing and troubleshooting Robot Runtime events.

String

BaseUrl

For web applications, this field is the URL minus the query string. This field only appears for web applications.

String

ProcessTotalWaitTime

A value, in milliseconds, that represents the total time that an application was waiting, regardless of whether the application was in focus on the user's desktop.

Integer

True

KeyPressCount

A value that represents the number of keyboard keys that are pressed (as opposed to keys released) for that particular AppLostFocus, FormLostFocus, or PageLostFocus event.  

The following are some examples:

• When the A key is pressed and held down, like the user typed aaaaaaaaaaaaaaaaaaaa, this field registers a count of 20 even though the A key is pressed and released once.
• For key combinations like Ctrl+V, where the Ctrl key is held down while the V key is pressed, this field registers a count of 2.  
• If the Ctrl key is pressed and held, while the C key is pressed and released and then the V key is pressed and released, this field registers a count of 3.
• If the Ctrl key is pressed and held while the V key is pressed and held for a period of time, like the user was pasting repeatedly, this field registers a count of 1+N where the 1 is for the Ctrl key and N is for the repetition caused by pressing the V key.
• If the Ctrl key is pressed and held for a period of time and then the V key is pressed and released, this field registers a count of N + 1, where N represents the repetition from pressing and holding the Ctrl key until the V key is pressed and released.

To get an accurate representation of the number of characters a user may have actually typed, it is best to subtract ErrorKeyPressCount, CtrlC_Count, CtrlX_Count, and CtrlV_Count.

Integer

True

ErroKeyPressCount

A value that represents the number of times the Backspace or Delete key was pressed for that particular AppLostFocus, FormLostFocus, or PageLostFocus event. A press and hold of the Backspace or Delete key registers a count that represents the repetition from holding the keys down for a period of time.

Integer

True

CtrlC_Count

A value that represents the number of times the Ctrl+C key combination was pressed for that particular AppLostFocus, FormLostFocus, or PageLostFocus event. See the description of KeyPressCount for additional information.

Integer

True

CrtlV_Count

A value that represents the number of times the Ctrl+V key combination was pressed for that particular AppLostFocus, FormLostFocus, or PageLostFocus event. See the description of KeyPressCount for additional information.

Integer

True

CrtlX_Count

A value that represents the number of times the Ctrl+X key combination was pressed for that particular AppLostFocus, FormLostFocus, or PageLostFocus event. See the description of KeyPressCount for additional information.

Integer

True

MouseClickCount

A value that represents the number of clicks from a pointing device (typically a mouse) during an AppLostFocus, FormLostFocus, or PageLostFocus event. If a mouse has left button, right, and clickable wheel buttons, all buttons register click counts.

Integer

True

MouseWheelCount

Integer

True

WindowMoveSizeCount

A value that represents the number of times an application window is resized or moved for that particular AppLostFocus, FormLostFocus, or PageLostFocus event.

Integer

True

ScrollCount

A value representing the number of window scrolls that occurred during that AppLostFocus, FormLostFocus, or PageLostFocus event.

The following are examples:

• When a window is scrolled using the mouse wheel, the wheel activity is recorded in MouseWheelCount and the scroll is recorded in ScrollCount.
• When a window is scrolled using the keyboard (PgDn, PgUp, or arrow keys), the key press is counted in KeyPressCount and the scroll is counted in ScrollCount.
• When a window is scrolled by a mouse click and drag of the elevator bar, the click is captured in MouseClickCount and the scroll is captured in ScrollCount.

Integer

True

HasScreenMapping

Represents whether an application has screen capture enabled.

Boolean

True

IsTestScreenMapping

True indicates that the screen was captured from a test application by a user who is designated as a test user. When an application is flagged with TestScreenMapping, only test users can capture FormLostFocus and PageLostFocus events from the application.

Boolean

True

IsTestUser

Boolean

True

Type

This field is only available for Cut/Copy/Paste (CCP) events. It is used to distinguish between a CCP done by the keyboard, using key combinations like Ctrl+C, instead of a Cut/Copy/Paste operation performed using the application's menus or context menu.

OriginalParentOperationID

Wait events captured for application screens which have screen capture disabled, and have the parentoperationid set to the application's OperationID as opposed to the screen's OperationId. This field contains the original screen's operation_id value captured by Robot Runtime.

String

ReasonCode

Robot Runtime users select the Off Computer Code upon return to their machine when the machine wakes from an idle state. This field is available when Off Computer Codes are enabled in the system to allow users to specify what they did while they were away from their computer.

String

True

Reason

The description associated with the ReasonCode.

String

True

day

The day the event payload was sent by Robot Runtime.

String