Employee Labor Detail 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

Your selection in Transaction on the General tab determines which columns are included on the report. However, you can add other columns or remove columns on the Columns tab.

Field Description
Labor Code This column displays the labor code for which the hours were entered.
Transaction Date This column displays the date on which the transaction was posted.
Period This column displays the accounting period during which the posting was made.
Regular Hours This column displays the number of regular hours.
Total Overtime Hours This column displays the total of all overtime hours.
Total Hours This column displays the total number of hours. This number is the sum of regular hours and overtime hours.
Regular Amount This column displays the cost amount for regular hours. This amount is calculated as follows: Regular hours x Labor cost rate.
Total Amount This column displays the total cost of all regular and overtime hours. This amount is calculated as follows: (Regular hours x Labor cost rate) + Overtime amount.
Overtime Hours This column displays the number of overtime hours.
Secondary Overtime Hours This column displays the number of secondary overtime hours.
Overtime Amount

This column displays the cost of overtime hours. Overtime costs are calculated as follows:

  • For hourly employees: Overtime hours x Hourly labor cost rate x Overtime percentage.
  • For salaried employees: Overtime hours x Annualized hourly rate x Overtime percentage. (Annualized hourly rate = Annual salary / Estimated annual regular hours. Estimated annual regular hours = Hours per week x 52.)
Secondary Overtime Amount This column displays the cost of secondary overtime hours.
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 in 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 If your enterprise uses organizations, this column displays the organization to which an employee is assigned.
Home Company Name If you use multiple companies, the name in this column represents the employee's home company. The home company is the company that manages the employee's current timesheet and expense report processes and that pays the employee. You associate each employee with a home company in the Employees hub.
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 one of the following types of transaction:
  • TS: Timesheet transaction
  • LA: Labor adjustment transaction
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 a labor adjustment, this column displays the project from which the labor adjustment transaction was transferred.
Labor Category This column displays the employee's labor category (for example, Principal, Project Manager, or Architect).
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.