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.