Activity Audit

The Activity Audit entity records all new activity segments in addition to any updates that were done to the segment, including who modified it and when it was modified.

Data Granularity

Provides multiple rows per Activity Segment and Employee for the defined time period. An activity segment will have one row for its creation and additional rows for any updates or deletes.

Supported Dataview/RDO Type

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

Columns


Accepted	A Boolean indicator of whether or not the activity segment was accepted.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_ACCEPTED	Boolean	No
Amount	Amount for audit activity segment calculated as difference between end and start time	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_AMOUNT	Number	No
Audit User Name	User who made the activity edit.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_USER_NAME	String	No
Comments Indicator	A Boolean indicator of whether or not the activity segment has comments.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_COMMENTS_INDICATOR	Boolean	No
Concurrent with Previous Segment	A Boolean indicator of whether or not the activity segment is concurrent with any previous segments.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_CONCURRENT_WITH_PREVIOUS	Boolean	No
Created Date Time	Date/time of activity segment creation.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_CREATED_DATETIME	DateTime	No
Data Source	Data source for the activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_DATASOURCE_REST	String	No
Direct Indicator	A Boolean indicator of whether or not the activity segment is direct.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_DIRECT	Boolean	No
End Date Time	End date/time for the activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_END_DATE_TIME	DateTime	No
End Timezone	End time zone of activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_END_TIMEZONE	String	No
Event Date Time	Activity segment event date and time.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_AUDIT_EVENT_DATETIME	DateTime	No
Event Type	Activity segment event type.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_EVENT_TYPE	String	No
Hours Allocated Type	Hours allocation type of activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_HOURS_ALLOCATED_TYPE	String	No
Inserted Date Time	Inserted date/time of audit activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_INSERTED_DATETIME	DateTime	No
IP Address	The IP address associated with the device that was used to enter the activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_IP_ADDRESS	String	No
Revision Date	Date and time at which activity segment was modified.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_REVISION_DTM	DateTime	No
Revision Type	Add, Delete, or Modify.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_REVISION_TYPE	Enum	No
Start Date Time	Start date/time of activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_START_DATE_TIME	DateTime	No
Start Timezone	Start time zone of activity segment.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_START_TIMEZONE	String	No
Updated Date Time	Date/time of activity segment modification.	WORK_ACTIVITY_AUDIT_RAW_SEGMENT_UPDATED_DATETIME	DateTime	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

Core Entity	Relationship
Activity	One to One
Employee	One to Many