Audit

The Audit entity provides data related to timecard transactions, including the addition, edit, or removal of punches, paycode edits, comments, and leave edits. The data columns allow for the creation of Dataviews and reports that provide the data available through the Audit add-on that is visible in the timecard.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

One row per employee per audited transaction.

Columns

Label

Description

Key

Data Type

Timecard Change Request Status

Status of the Timecard Change Request

AUDIT_STATUS_NAME

Duration (Days)

The number of days. This will populate from either paycode edits or days generated from historical corrections.

AUDIT_AMOUNT_DAYS

NUMBER

Duration (Hours)

The number of hours. This will populate from either paycode edits or hours generated from historical corrections.

AUDIT_AMOUNT_HOURS

NUMBER

Duration (Money)

The amount of money. This will populate from either paycode edits or money amounts generated from historical corrections.

AUDIT_AMOUNT_MONEY

NUMBER

AppId

A unique identifier of the system app on the device.

AUDIT_APP_ID

STRING

Application

The application (ex: browser, mobile app) and the device used when connecting with the system.

AUDIT_APPLICATION

STRING

Approval Job

The full path of the job approved. Leveraged for multiple approvers.

AUDIT_APPROVAL_JOB

STRING

Approval Job ID

ID of the approved worked job

AUDIT_APPROVAL_JOB_ID

Canceled Deduction Name

The name of the deduction that has been canceled.

AUDIT_CANCELED_DEDUCTION_NAME

STRING

Comment Text

The text of the comment.

AUDIT_COMMENT_TEXT

STRING

Datasource

The datasource for the edit. Ex: Timecard Editor

AUDIT_DATASOURCE

STRING

Datasource - IP Address

The IP address of the client used for a transaction.

AUDIT_DATASOURCE_IP_ADDRESS

STRING

Delegator

The name of the person who delegated authority

AUDIT_DELEGATOR

Employee ID

This is the employee ID from the database. This is NOT the employee ID as seen in the application.

AUDIT_EMPLOYEE_ID

STRING

Employee Number

This is the employee ID as seen throughout the application.

AUDIT_EMPLOYEE_NUMBER

STRING

Entity Event Date

The date and time the revision was made on in the timecard. Ex: Today, May 18th, a manager adds a punch in an associate's timecard on 5/16. 5/16 will populate.

AUDIT_ENTITY_EVENT_DATE

DATETIME

Audit ID

Audit ID

AUDIT_ENTITY_ID

STRING

Entity Type

The type of entity upon which an edit was done. Ex: Punch, Pay Code Edit.

AUDIT_ENTITY_TYPE

STRING

Entity Type

AUDIT_ENTITY_TYPE_DISPLAY

Note Text

The text of the note.

AUDIT_NOTE_TEXT

STRING

Behalf of User ID

Employee ID of the Delegator or Proxied User

AUDIT_ONBEHALFOF_USER_ID

Behalf of User

When timecard edits are performed while user A is impersonating person B, this will populate with user A's user name.

AUDIT_ONBEHALFOF_USERNAME

STRING

Historical Correction Date

Returns the historical date on which a correction was performed.

AUDIT_ORIGINAL_DATE

DATE

Pay Rule on Historical Correction Date

The employee’s assigned pay rule on the date to which a historical correction was made.

AUDIT_PAY_RULE_HISTORICAL_DATE

STRING

Paycode ID

ID of the paycode edit

AUDIT_PAYCODE_ID

Paycode Name

The name of the paycode. This will populate for pay code edits.

AUDIT_PAYCODE_NAME

STRING

Revision Date

The date and time the revision was made on. Ex: Today, May 18th, a manager adds a punch in an associate's timecard on 5/16. 5/18 will populate.

AUDIT_REVISION_DATETIME

DATETIME

Revision ID

Revision ID

AUDIT_REVISION_ID

NUMBER

Revision Type

The type of revision performed. Ex: Add, Delete.

AUDIT_REVISION_TYPE

STRING

Revision User

Returns the Employee ID (Employee Number in this entity) of the user who made the edit.

AUDIT_REVISION_USER

STRING

Revision User Function Access Profile

The Function Access Profile assigned to the Revision User at the time of the edit.

AUDIT_REVISION_USER_FAP

STRING

Revision User Employee ID

The Revision User’s alphanumeric employee identifier (Employee ID).

AUDIT_REVISION_USER_PERSONNUM

STRING

Transfer Cost Center Name

The name of the transferred Cost Center. Note that this will only populate for transfers made explicitly in the timecard and will not include scheduled transfers.

AUDIT_TRANSFER_COST_CENTER

STRING

Cost Center Transfer ID

Cost Center Transfer ID of the transfer

AUDIT_TRANSFER_COST_CENTER_ID

Transfer Job Name

The name of the transferred Job. Note that this will only populate for transfers made explicitly in the timecard and will not include scheduled transfers.

AUDIT_TRANSFER_JOB

STRING

Transfer Job ID

Job ID of the transfer

AUDIT_TRANSFER_JOB_ID

Transfer Labor Category Name

The name of the transferred Labor Category. Note that this will only populate for transfers made explicitly in the timecard and will not include scheduled transfers.

AUDIT_TRANSFER_LABORCATEGORIES

STRING

Transfer Labor Category ID

Labor Category ID of the transfer

AUDIT_TRANSFER_LABORCATEGORIES_ID

Transfer Work Rule Name

The name of the transferred Work Rule. Note that this will only populate for transfers made explicitly in the timecard and will not include scheduled transfers.

AUDIT_TRANSFER_WORKRULE

STRING

Transfer Work Rule ID

Work Rule ID of the transfer

AUDIT_TRANSFER_WORKRULE_ID

Punch Override

The punch override type. Ex: In Punch, Out Punch.

TKAUDIT_PUNCH_OVERRIDE

STRING

Punch Time

Returns the date and time of the punch.

TKAUDIT_PUNCH_TIME

DATETIME

Related entities

Additional information

The Duration data columns included in the Audit entity only provide values when the audited transaction is a paycode edit.

Core entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many
X