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

Field Description
Transaction Date This column displays the date on which the transaction was posted. There is one exception: If the detail is from the History Loading utility, this column displays the accounting period.
Regular Hours This column displays the number of regular hours.
Total Overtime Hours This column displays the total number of standard and secondary overtime hours.
Total Hours This column displays the total number of hours (regular and overtime).
Regular Amount This column displays the cost amount for regular hours.

This amount is calculated as follows: Regular hours * Labor cost rate.

Total Overtime Amount

This column displays the cost amount for all overtime hours (standard and secondary overtime hours).

DPS calculates overtime costs differently for hourly and salaried employees.

  • For hourly employees, DPS calculates the overtime amount as follows:

    Overtime hours * Hourly labor cost rate * Overtime percentage

  • For salaried employees, DPS first calculates the employee’s annualized hourly rate, using this equation:

    Annual salary / Estimated annual regular hours

    (The estimated annual regular hours are the hours per week multiplied by 52.)

    DPS then calculates the overtime amount as follows:

    Overtime hours * Annualized hourly rate * Overtime percentage

Total Amount This column displays the total labor cost amount: Regular Amount + Total Overtime Amount
Overtime Hours This column displays the number of standard overtime hours.
Overtime Amount This column displays the cost amount for the standard overtime hours.
Employee Organization This column displays the organization to which the employee is assigned. If your firm is not using organizations, this column is not available.
Labor Type This column displays the labor type for the employee at the time the transaction was posted (for example, Principal or Management).
Project Currency Code This column displays the three-character code for the project currency.
Billing Currency Code This column displays the three-character code for the billing currency.
Functional Currency Code If you use multiple currencies, this column displays the three-character code for the functional currency.
Charge Type

This column displays one of the following charge types for the project:

  • R:Regular projects are revenue-producing. Costs charged to regular projects include direct labor, direct expense, and reimbursable expense. DPS retains the detail for a regular project for the life of the project.
  • H:Overhead projects are not revenue-producing. Costs charged to overhead projects include indirect labor and indirect expense. DPS distributes the total cost of these projects to regular projects during overhead allocation. Typical overhead projects can include General Overhead, Vacation, Sick Leave, Holiday, and Civic Duty. DPS resets job-to-date costs to zero for overhead projects when you initialize for a new fiscal year.
  • P: Promotional projects track the cost to acquire a job. If you obtain the contract, you can create a new regular project and transfer the detail to it to be billed or tracked. A promotional project is similar to an overhead project. However, DPS does not zero out job-to-date costs at the start of each fiscal year for promotional projects.
Revenue Type

This column displays the revenue type. The revenue type is a code to identify how DPS calculates revenue for the task, phase, or project. There are six standard revenue types:

  • B: Job-to-date billing
  • M: (Job-to-date direct labor * Multiplier) + Job-to-date reimbursable expenses @ cost rates
  • N: No revenue generation
  • P: Percent complete + Job-to-date reimbursable expenses @ cost rates
  • R: Job-to-date receipts
  • W: Job-to-date billing + Work-in-progress @ billing rates
Rate This column displays the employee's job cost rate. This is the rate at which DPS applies the employee’s hours as costs to a project.
Overtime Rate

This column displays the rate used to calculate the standard overtime amount. DPS calculates the overtime rate as follows:

Employee’s hourly rate * Employee's overtime percentage

Overtime Percentage

This column displays the employee's overtime percentage that DPS uses to calculate the employee's overtime rate. DPS calculates the overtime rate as follows:

Employee’s hourly rate * Employee's overtime percentage

Special Overtime Hours This column displays the number of secondary overtime hours. Secondary overtime is overtime for which the cost amount is calculated at a different rate than standard overtime.
Special Overtime Amount This column displays the cost amount for secondary overtime hours.
Special Overtime Rate

This column displays the rate used to calculate the secondary overtime amount. DPS calculates the overtime rate as follows:

Employee’s hourly rate * Employee's secondary overtime percentage

Special Overtime Percentage

This column displays the secondary overtime percentage that DPS uses to calculate the employee's secondary overtime rate. DPS calculates the overtime rate as follows:

Employee’s hourly rate * Employee's secondary overtime percentage

Fiscal Period This column displays the accounting period in which the transaction was posted.
Posting Sequence

This column displays the posting sequence number for the transaction. DPS assigns the sequence numbers during the posting process. DPS assigns 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, click Transaction Center > Posting Review Report on the Navigation menu.

Transaction Type

This column displays the type of transaction:

  • TS: Timesheet transaction
  • LA: Labor adjustment transaction
Labor Code This column displays the employee's labor code. An employee can be assigned different labor codes on different projects, based on the work he or she performs.
Labor Category This column displays the employee's labor category (for example, Principal, Project Manager. or Engineer).
Billing Status This column displays the billing status of the transaction. The following are the possible statuses:
  • 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 For a labor adjustment, this column displays the project from which the labor adjustment transaction was transferred.
Transfer Phase For a labor adjustment, this column displays the phase from which the labor adjustment transaction was transferred.
Transfer Task For a labor adjustment, this column displays the task from which the labor adjustment transaction was transferred.
Transfer Labor Code For a labor adjustment, this column displays the labor code from which the labor adjustment transaction was transferred.
Transfer Category For a labor adjustment, this column displays the labor category (such as Architect or Project Manager) from which the labor adjustment transaction was transferred.
Project This column displays the project number for the transaction.
Phase This column displays the phase number for the transaction.
Task This column displays the task number for the transaction.