Activity Results Audit

The Activity Results Audit entity records when a result was reported and when it was modified by a user.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides multiple rows for each result and each result edit per Activity Segment and Employee for the defined time period.

Columns

Label

Description

Key

Activity Segment ID

Segment ID of the parent of the activity result segment.

WORK_ACTIVITY_AUDIT_RESULT_ACTIVITY_SEGMENT_ID

Audit User Name

User who made the activity edit.

WORK_ACTIVITY_AUDIT_RESULT_USER_NAME

Child Index

Order of the result children within the group index.

WORK_ACTIVITY_AUDIT_RESULT_CHILD_INDEX

Created Date Time

Created date/time of the activity result segment.

WORK_ACTIVITY_AUDIT_RESULT_CREATED_DATETIME

Data Source

Where the modification was made: for example, timecard, clock.

WORK_ACTIVITY_AUDIT_RESULT_DATASOURCE_REST

Date Time Result Value

Date/time result type.

WORK_ACTIVITY_AUDIT_RESULT_DATETIME_RESULT

Decimal Result Value

Floating decimal result type.

WORK_ACTIVITY_AUDIT_RESULT_FLOATING_DECIMAL_RESULT

Field Definition Name

Definition name of the result field of the audit activity result segment.

WORK_ACTIVITY_AUDIT_RESULT_FIELD_DEFINITION

Group Index

Group ID of the result. This result is grouped together with other results for this segment and group index

WORK_ACTIVITY_AUDIT_RESULT_GROUP_INDEX

IP Address

IP address of the audit activity result segment.

WORK_ACTIVITY_AUDIT_RESULT_IP_ADDRESS

Numeric Result Value

Numeric result type.

WORK_ACTIVITY_AUDIT_RESULT_NUMERIC_RESULT

Revision Datetime

Date and time when the activity result segment was modified.

WORK_ACTIVITY_AUDIT_RESULT_REVISION_DTM

Revision Type

Type of revision, such as: Add, Delete, Modify.

WORK_ACTIVITY_AUDIT_RESULT_REVISION_TYPE

Text Result Value

Text type result for the activity segment.

WORK_ACTIVITY_AUDIT_RESULT_TEXT_RESULT

Time Result Value

Time result type.

WORK_ACTIVITY_AUDIT_RESULT_TIME_RESULT

Updated Date Time

Updated date/time of the activity result.

WORK_ACTIVITY_AUDIT_RESULT_UPDATED_DATETIME

Related entities

Core entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many

Activity

Employee