Employee Labor Audit Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

Contents

Field Description
Timesheet Date This column displays the labor transaction date.
Project This column displays the project associated with the labor transaction.
Phase This column displays the phase associated with the labor transaction.
Task This column displays the task associated with the labor transaction.
Labor Code/Unit This column displays the labor code or unit associated with the labor transaction.
Labor Category This column displays the employee labor category (for example, Principal, Project Manager, or Architect) associated with the labor transaction.
Regular Hours This column displays the number of regular hours.
Overtime Hours This column displays the number of overtime hours.
Secondary Overtime Hours This column displays the number of secondary overtime hours.
Timesheet Comments This column displays any timesheet comments associated with the labor transaction.
Period This column displays the accounting period associated with the labor transaction.
Total Overtime Hours This column displays the total of all overtime hours: Overtime hours + Secondary overtime hours.
Total Hours This column displays the total number of hours: Regular hours + Overtime hours + Secondary overtime hours.
Regular Amount This column displays the billing, cost, or burdened cost amount for regular hours. Your entries in Report at and Report Cost in on the General tab control which of these amounts displays.
Overtime Amount This column displays the billing, cost, or burdened cost amount for the overtime hours. Your entries in Report at and Report Cost in on the General tab control which of these amounts displays.
Secondary Overtime Amount This column displays the billing, cost, or burdened cost amount for the secondary overtime hours. Your entries in Report at and Report Cost in on the General tab control which of these amounts displays.
Total Overtime Amount This column displays the billing, cost, or burdened cost amount for all overtime hours: Overtime amount + Secondary overtime amount. Your entries in Report at and Report Cost in on the General tab control which of these amounts displays.
Total Amount This column displays the billing, cost, or burdened cost amount for all hours: Regular amount + Overtime amount + Secondary overtime amount. Your entries in Report at and Report Cost in on the General tab control which of these amounts displays.
Realization Amount

If you use the Employee Realization Reporting feature, this column displays an employee's posted realization amount. The realization amounts that display on this report include the potential realization from posted timesheets, labor adjustments, and employee-specific units, as well as the true realization from posted invoices.

Realization always displays as a billing value, regardless of what you select in the Report at field on the General tab.

Employees' time records that were posted before the Employee Realization Reporting feature was turned on have a 0 realization amount associated with them. These records are assigned a realization amount when you allocate realization in Interactive Billing, Batch Billing, or Employee Realization.

If you use multiple currencies, the currency in which realization amounts display depends on the report options and configuration options selected.

Provisional Billing Rate This column displays an employee's provisional billing rate from the Accounting tab of the Employees hub.
Provisional Cost Rate This column displays an employee's provisional cost rate from the Accounting tab in the Employees hub.
Employee This column displays an employee's identification number.
Employee Name This column displays an employee's full name: first, middle, and last name, with prefix and suffix.
Employee Status This column displays an employee's status: Active, Inactive, or Terminated.
Organization Name If your enterprise uses organizations, this column displays the name of the organization to which an employee is assigned.
Posting Sequence This column displays the posting sequence number for the transaction. DPS assigns the sequence numbers during the posting process: 1 to the first group of transactions posted during an accounting period, 2 to the second group, and so on. To see a numbered list of all of the postings for the current accounting period, select Posting Review Report from the Transaction Center menu.
Transaction Type This column displays the type of transaction: timesheet, labor adjustment, or billing labor transfer.
Billing Status This column displays the billing status of the labor hours. The following are the possible status settings:
  • B: Billable: The transaction is released and available for billing to the client.
  • D: To Be Deleted: The transaction is marked for deletion.
  • F: Final Billed: The transaction has been billed to the client.
  • H: Held: The transaction is being held temporarily to prevent billing to the client.
  • M: Modified: The transaction has been modified in some way from its original form.
  • N: Not Billable: The transaction is not billable.
  • O: Deleted: The transaction was marked for deletion, included in a billing run, and deleted.
  • R: Partial Hold/Released: Part of the transaction has been held or released.
  • T: Transferred: The transaction was moved from one project, phase, or task to another.
  • W: To Be Written Off: The transaction has been written off, but the invoice has not been posted.
  • X: Written Off: The transaction has been written off, and the invoice has been posted.
Transfer Project If the transaction is for a labor transfer, this column displays the project from which the labor transaction was transferred.
Project Name This column displays the name of the project associated with the labor transaction.
Phase Name This column displays the name of the phase associated with the labor transaction.
Task Name This column displays the name of the task associated with the labor transaction.
Debit Account When you post employee timesheets, DPS automatically posts the labor charges to the general ledger. This column displays the debit account currently specified on the Time Analysis and Absence Accrual form (Settings > Advanced Accounting > Time Analysis). If that account changes between the time at which the timesheet was posted and the time when you generate this report, the account in this column will not be the same account used to post the labor charges.
Transfer Details

If the transaction is a billing labor transfer, this column indicates where the transaction was transferred from (for example, "Transferred from project 2013002.00") or where it was transferred to, depending on whether the report row is for the origin or the destination of the transfer.

This column is only available if Enable Billing Transfer Audit is selected on the Timesheet Audit tab of Time Settings.

Transfer Reason

If the transaction is a billing labor transfer, this column displays the reason for the transfer that was entered in Interactive Billing or Interactive Approvals.

This column is only available if Enable Billing Transfer Audit is selected on the Timesheet Audit tab of Time Settings.

Reviewed By

If the transaction is a billing labor transfer and if the employee has acknowledged that he or she has been informed of the transfer, this column displays the employee's name.

This column is only available if Enable Billing Transfer Audit is selected on the Timesheet Audit tab of Time Settings.

Reviewed Date

If the transaction is a billing labor transfer and the employee has acknowledged being informed about the transfer, this column displays the date on which the acknowledgment occurred.

This column is only available if Enable Billing Transfer Audit is selected on the Timesheet Audit tab of Time Settings.