Audit Schedule

The Audit Schedule entity provides data that enables you to create Dataviews and reports that can be used to examine all schedule audits for a location or a group of employees. It also provides information that can help determine how many schedule edits managers are making, which employee schedules are being edited, and which managers are making those edits.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per employee per changed schedule entity (such as shift, shift segment, schedule tag, and paycode).

Columns

Label

Description

Key

Schedule Audit Comment

Comment that was added to the schedule entity during the edit.

SCHEDULE_AUDIT_COMMENT

Schedule Audit Cost Center

Cost center that was added to schedule entity when it was edited.

SCHEDULE_AUDIT_COST_CENTER

Schedule Audit Deleted

Switch that indicates whether the schedule entity was deleted.

SCHEDULE_AUDIT_DELETED

Schedule Audit Duration (Days)

Duration associated with the edited pay code (in days).

SCHEDULE_AUDIT_DURATION_DAYS

Schedule Audit Duration (Hours)

Duration associated with the edited pay code (in hours).

SCHEDULE_AUDIT_DURATION_HOURS

Schedule Audit Duration (Money)

Duration associated with the edited pay code (in money).

SCHEDULE_AUDIT_DURATION_MONEY

Schedule Audit Edit Date

Date on which the schedule entity was edited.

SCHEDULE_AUDIT_EDIT_DATE

Schedule Audit Edit Time

Time at which the schedule entity was edited.

SCHEDULE_AUDIT_EDIT_TIME

Schedule Audit Edit Type

Type of schedule edit that was performed.

SCHEDULE_AUDIT_EDIT_TYPE

Schedule Audit Edited User Employee Id

Employee ID of the person who made the edit.

SCHEDULE_AUDIT_EDITED_USER_PERSONNUMBER

Schedule Audit Edited User Full Name

Full name of the person who made the edit.

SCHEDULE_AUDIT_EDITED_USER_FULLNAME

Schedule Audit Edited Username

User name of the person who made the edit.

SCHEDULE_AUDIT_EDITED_USERNAME

Schedule Audit Entity Date

Start date of the schedule entity that was edited.

SCHEDULE_AUDIT_ENTITY_DATE

Schedule Audit Entity Type

Type of the schedule entity that was edited.

SCHEDULE_AUDIT_ENTITY_TYPE

Schedule Audit ID

System identifier of a schedule audit entity.

SCHEDULE_AUDIT_ID

Schedule Audit Label

Label that was added to the schedule entity when it was edited.

SCHEDULE_AUDIT_LABEL

Schedule Audit Labor Category

Labor category that was added to schedule entity when it was edited.

SCHEDULE_AUDIT_LABOR_CATEGORY

Schedule Audit Leave Case Code

The leave case code of the audit that was edited

SCHEDULE_AUDIT_LEAVE_CASE_CODE

Schedule Audit Leave Time Duration (Hours)

The duration in hours of the leave time that was edited

SCHEDULE_AUDIT_LEAVE_DURATION

Schedule Audit Leave Time Tracking Duration (Hours)

The tracking duration in hours of the leave time that was edited

SCHEDULE_AUDIT_LEAVE_TRACKING_DURATION

Schedule Audit Location

Location that was added to the schedule entity when it was edited.

SCHEDULE_AUDIT_LOCATION

Schedule Audit Locked

Switch that indicates whether the shedule entity was locked at the time when the edit was made.

SCHEDULE_AUDIT_LOCKED

Schedule Audit Paycode

Name of the pay code that was used in the edit.

SCHEDULE_AUDIT_PAYCODE

Schedule Audit Posted

Indicates whether the schedule was posted.

SCHEDULE_AUDIT_POSTED

Schedule Audit Reason

Indicates segment tags and comment notes were added, updated or deleted for shift.

SCHEDULE_AUDIT_REASON

Schedule Audit Revision ID

System identifier of a schedule audit edit.

SCHEDULE_AUDIT_REVISION_ID

Schedule Audit Shift End Time

End time of the shift that was edited.

SCHEDULE_AUDIT_SHIFT_END

Schedule Audit Shift Segment End Time

End time of the shift segment that was edited.

SCHEDULE_AUDIT_SHIFT_SEGMENT_END

Schedule Audit Shift Segment Start Time

Start time of the shift segment that was edited.

SCHEDULE_AUDIT_SHIFT_SEGMENT_START

Schedule Audit Shift Start Time

Start time of the shift that was edited.

SCHEDULE_AUDIT_SHIFT_START

Schedule Audit Tag

Name of the schedule tag that was used in the edit.

SCHEDULE_AUDIT_TAG

Schedule Audit Work Rule

Work rule that was added to schedule entity when it was edited.

SCHEDULE_AUDIT_WORK_RULE

Related entities

Core entity

Employee Organization Day Organizational Job Paycode Labor Category Activity
X X X X

Relationship

Core entityOne-to-OneOne-to-Many
Employee X
Organizational JobX
PaycodeX
Labor CategoryX