Activity Results Audit

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

Data Granularity

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

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Activity Segment ID Segment ID of the parent of the activity result segment. WORK_ACTIVITY_AUDIT_RESULT_ACTIVITY_SEGMENT_ID String No
Audit User Name User who made the activity edit. WORK_ACTIVITY_AUDIT_RESULT_USER_NAME String No
Child Index Order of the result children within the group index. WORK_ACTIVITY_AUDIT_RESULT_CHILD_INDEX Number No
Created Date Time Created date/time of the activity result segment. WORK_ACTIVITY_AUDIT_RESULT_CREATED_DATETIME DateTime No
Data Source Where the modification was made. For example, timecard, clock, etc. WORK_ACTIVITY_AUDIT_RESULT_DATASOURCE_REST String No
Date Time Result Value Date/time result type. WORK_ACTIVITY_AUDIT_RESULT_DATETIME_RESULT DateTime No
Decimal Result Value Floating decimal result type. WORK_ACTIVITY_AUDIT_RESULT_FLOATING_DECIMAL_RESULT Number No
Field Definition Name Definition name of the result field of the audit activity result segment. WORK_ACTIVITY_AUDIT_RESULT_FIELD_DEFINITION String No
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 String No
IP Address IP address of the audit activity result segment. WORK_ACTIVITY_AUDIT_RESULT_IP_ADDRESS String No
Numeric Result Value Numeric result type. WORK_ACTIVITY_AUDIT_RESULT_NUMERIC_RESULT Number No
Revision Datetime Date and time when the activity result segment was modified. WORK_ACTIVITY_AUDIT_RESULT_REVISION_DTM DateTime No
Revision Type Type of revision, such as: Add, Delete, Modify. WORK_ACTIVITY_AUDIT_RESULT_REVISION_TYPE Enum No
Text Result Value Text type result for the activity segment. WORK_ACTIVITY_AUDIT_RESULT_TEXT_RESULT String No
Time Result Value Time result type. WORK_ACTIVITY_AUDIT_RESULT_TIME_RESULT DateTime No
Updated Date Time Updated date/time of the activity result. WORK_ACTIVITY_AUDIT_RESULT_UPDATED_DATETIME DateTime No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

Core Entity Relationship
Activity One to One
Employee One to Many