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.

Employee Dataview Business Structure Dataview
X  

One row per employee per audited transaction.

 

 

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

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

Employee Organization Day Organizational Job Paycode Labor Category
X          
One-to-One One-to-Many
  X