Employee Export

Use the Employee Export report to export employee data directly from DPS to an Adobe Portable Document Format (PDF) file, Microsoft Excel spreadsheet file, or Rich Text Format ( RTF) file.

Contents

Column	Description
Employee Number	This column displays the employee identification number.
Full Name	This column displays the employee's last name, first name, and middle initial.
First Name	This column displays the employee's first name.
Last Name	This column displays the employee's last name.
Middle Name	This column displays the employee's middle name.
Prefix	This column displays the prefix or salutation used with the employee's name.
Suffix	This column displays the suffix used with the employee's name.
Labor Type	This column displays the labor type (for example, Principal, Manager, or Employee).
Title	This column displays the employee's job title or job function.
Organization	If your enterprise uses organizations, this column displays the organization to which the employee is assigned.
Supervisor	This column displays the name of the employee's supervisor.
EMail	This column displays the employee's email address.
Email Payroll Remittance	This Yes/No column indicates whether or not the employee receives payroll remittance information by email.
Email Expense Remittance	This Yes/No column indicates whether or not the employee receives a printed copy of payroll remittance information.
Work Phone	This column displays the employee's work telephone number.
Work Phone Ext	This column displays the extension for the employee's work telephone.
Mobile Phone	This column displays the employee's cellular phone number.
FAX	This column displays the number for the employee's home fax machine.
Years with Other Firms	This column displays the number of years the employee worked for other companies.
Is Vendor	This Yes/No column indicates whether the employee is a vendor or consultant.
Vendor Number	If the employee is a vendor or consultant, this column displays the vendor number assigned to the employee.
Vendor Name	If the employee is a vendor or consultant, this column displays the vendor name.
Address 1 - 3	These columns display the employee's street address.
City	This column displays the city from the employee's address.
State	This column displays the two-character abbreviation for the state from the employee's address.
ZIP	This column displays the ZIP code from the employee's address.
Country	This column displays the country from the employee's address.
Home Phone	This column displays the employee's home telephone number.
Hours Per Day	This column displays the number of hours per day the employee is generally expected to work.
Social Security #	This column displays the employee's Social Security number.
Termination Date	If the employee is terminated, this column displays the date on which the employee last worked for your enterprise.
Job Cost Rate	This column displays the rate at which DPS applies the employee's hours as costs to projects.
Job Cost Ovt Pct	This column displays the percentage of the employee's hourly wage that is applied as costs to projects when the employee works standard overtime hours.
Job Cost Ovt-2 Pct	This column displays the percentage of the employee's hourly wage that is applied as costs to projects when the employee works special overtime hours. This column is available only if Enable Secondary Overtime is selected on the General Tab of Accounting System Settings.
Job Cost Type	This column displays the employee's job cost type: Hourly or Salary.
Pay Rate	For salaried employees, this column displays the employee's actual pay amount for each payroll period. For hourly employees, it displays their hourly pay rate.
Pay Ovt Pct	This column displays the percentage applied to the employee's payroll rate to calculate standard overtime wages.
Pay Ovt-2 Pct	This column displays the percentage to apply to the employee's payroll rate to calculate special overtime wages. This column is available only if Enable Secondary Overtime is selected on the General Tab of Accounting System Settings.
Pay Type	This column displays the employee's pay type: Hourly or Salary.
Labor Category	This column displays the employee's labor category (for example, Principal, Project Manager, or Architect).
Target Ratio	This column displays the percentage of the employee's time that you expect to be charged to regular projects (projects that produce revenue).
Status	This column displays the employee's status: Active, Inactive, or Terminated).
Hire Date	This column displays the date on which the employee was hired.
Raise Date	This column displays the date of the employee's last pay increase.
Use Total Hrs as Std	This column indicates how DPS calculates and displays standard hours or amounts for employee on the Time Analysis report: Y (Yes) indicates that DPS uses the total hours worked to determine the standard current, month-to-date (MTD), and year-to-date (YTD) hours or amounts. N (No) indicates that DPS calculates the standard hours or amounts using a formula specified in the employee record. See the help about the Employees hub for more information.
Provisional Cost Rate	This column displays the cost rate that DPS uses to calculate labor charges at cost for unposted timesheet entries for the employee. This column is only available if your security role has access to employee cost rates.
Provisional Cost Ovt Pct	This column displays the percentage that DPS uses to calculate labor charges at cost rates for unposted overtime hours for the employee. This column is only available if your security role has access to employee cost rates.
Provisional Cost Ovt-2 Pct	This column displays the percentage that DPS uses to calculate labor charges at cost rates for unposted special overtime hours for the employee. This column is only available if Enable Secondary Overtime is selected on the General Tab of Accounting System Settings, and if your security role has access to employee cost rates.
Provisional Bill Rate	This column displays the billing rate that DPS uses to calculate labor charges at billing for unposted timesheet entries for the employee.
Provisional Bill Ovt Pct	This column displays the percentage that DPS uses to calculate labor charges at billing rates for unposted overtime hours for the employee.
Provisional Bill Ovt-2 Pct	This column displays the percentage that DPS uses to calculate labor charges at billing rates for unposted special overtime hours for the employee. This column is only available if Enable Secondary Overtime is selected on the General Tab of Accounting System Settings.
Timesheet Group	This column displays the timesheet group for which this employee has access to timesheets.
Timesheet Admin Level	This column displays the timesheet administrative level for the employee. The following are the available levels: Staff: The employee has access to timesheets for all employees at the staff level. Group: The employee has access to timesheets for all employees within a specific group. System: The employee has access to timesheets for all groups and employees. At least one employee in your firm must have system-level access.
Timesheet Admin Edit	This Yes/No column indicates whether or not the employee can edit timesheets to which he or she has access.
Timesheet Admin Approval	This Yes/No column indicates whether or not the employee can approve timesheets to which he or she has access before they are posted.
Check Hours	This Yes/No column indicates whether or not DPS automatically checks the hours entered on the employee's timesheet and compares them to the expected hours per day.
Default Service	This column displays the employee's default service code.
Default Staff	This column displays the employee's default staff code.
Allow Change Activity Code	This column contains Y or N (Yes or No) to indicate whether or not the employee can charge time to an activity code other than the default activity code.
Department	This column displays the department to which the employee is assigned (for example, A-Architectural, C-Civil, or L-Landscape Design).
Phase	This column displays the identifier of the phase for which the employee entered time.
Allow Change Labor Code	This Yes/No column indicates whether or not the employee can charge time to a labor code other than the default labor code.
Expense Report Group	This column displays the expense report group for which this employee has access to expense reports.
Expense Report Admin Level	This column displays the expense report administrative level for the employee. The following are the available levels: Staff: The employee has access to expense reports, but he or she cannot modify system-level settings, group-level settings, or options in Settings. Group: The employee has access to expense report configuration settings that are related to his or her group. The employee can do the following: View Expense Report Administrator settings. Review and change the status of expense reports for employees in his or her group. Change the passwords of employees in his or her group. System: The employee has access to all expense report configuration settings. The employee can do the following: Define expense report categories. Establish employee expense report groups. Set employee access to expense reports. Enable passwords for expense reports. Set expense report options. Monitor and change the status of expense reports. At least one employee must have system-level access.
Expense Report Admin Edit	This Yes/No column indicates whether or not the employee can edit expense report to which he or she has access.
Expense Report Admin Approval	This Yes/No column indicates whether or not the employee can approve expense reports to which he or she has access before they are posted.
Memo	This column displays the text entered about the employee in the Employees hub.
Project	This column displays the identifier of the project to which the employee charged time.
Phase	This column displays the identifier of the phase to which the employee charged time.
Task	This column displays the identifier of the task to which the employee charged time.
Project Name	This column displays the name of the project to which the employee charged time.
Phase Name	This column displays the name of the phase to which the employee charged time.
Task Name	This column displays the name of the task to which the employee charged time.
Labor Code	This column displays the labor code to which the employee charged time. An employee may be assigned different labor codes on different projects, if he or she is performing different types of work.
Transaction Type	This column displays the type of transaction: TS: Timesheet transaction LA: Labor adjustment transaction
Transaction Date	This column displays the date on which the transaction was posted.
Fiscal Period	This column displays the fiscal period for which the transaction was posted.
Posting Sequence	This column displays the posting sequence number of the transaction. DPS assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on. To generate a numbered list of all of the postings for the current accounting period, click Transaction Center > Posting Review Report.
Current Regular Hours	This column displays the number of regular hours for the task, phase, or project for the current accounting period.
Current Overtime Hours	This column displays the number of overtime hours for the task, phase, or project for the current accounting period.
Current Special Overtime Hours	This column displays the number of special overtime hours for the task, phase, or project for the current accounting period.
Current Regular Amount	This column displays the cost amount for regular hours for the task, phase, or project for the current accounting period. DPS calculates this amount as follows: the regular hours worked multiplied by the labor cost rate.
Current Overtime Amount	This column displays the cost amount for overtime hours for the task, phase, or project for the current accounting period. DPS calculates overtime costs 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.)
Current Special Overtime Amount	This column displays the cost amount for special overtime hours for the task, phase, or project for the current accounting period.
Current Billing Extension	This column displays the extended amount (hours x rate) based on the current billing terms.
JTD Regular Hours	This column displays the number of job-to-date regular hours.
JTD Overtime Hours	This column displays the number of job-to-date overtime hours.
JTD Special Overtime Hours	This column displays the number of job-to-date special overtime hours.
JTD Regular Amount	This column displays the job-to-date cost amount for regular hours.
JTD Overtime Amount	This column displays the job-to-date cost amount for overtime hours.
JTD Special Overtime Amount	This column displays the job-to-date cost amount for special overtime hours.
JTD Billing Extension	This column displays the job-to-date extended amount (hours x rate) based on the current billing terms.
YTD Regular Hours	This column displays the number of year-to-date regular hours.
YTD Overtime Hours	This column displays the number of year-to-date overtime hours.
YTD Special Overtime Hours	This column displays the number of year-to-date special overtime hours.
YTD Regular Amount	This column displays the year-to-date cost amount for regular hours.
YTD Overtime Amount	This column displays the year-to-date cost amount for overtime hours.
YTD Special Overtime Amount	This column displays the year-to-date cost amount for special overtime hours.
YTD Billing Extension	This column displays the year-to-date extended amount (hours x rate) based on the current billing terms.
Special Overtime Rate	This column displays the rate applied to special overtime hours to calculate the special overtime amount for the transaction. DPS calculates the special overtime rate as follows: Employee's hourly rate x Employee's secondary overtime percentage.
Special Overtime Percentage	This column displays the employee's special overtime percentage. DPS uses the special overtime percentage to calculate the special overtime rates for transactions: Special overtime rate = Employee's hourly rate x Employee's special overtime percentage.
Billing Status	This column displays the status of the transaction. The following are the possible statuses: Code Label Description B Billable The transaction is released and available for billing to the client. D To Be Deleted F Final Billed The transaction has been billed to the client. H Held The transaction is held to prevent billing to the client temporarily . M Modified The transaction is modified in some way from its original form. N Not Billable O Deleted R Partial Hold/Released A part of the transaction is held or released. T Transferred The transaction has been moved from one project, phase, task, or labor code 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.
Create User	This column displays the user ID of the person who created the record.
Create Date	This column displays the date on which the employee record was created.
Modify User	This column displays the user ID of the person who most recently modified the employee record.
Modify Date	This column displays the date on which the employee record was most recently modified.