You are here: Ajera Help (A-Z) > Inquiries > Inquiry descriptions > Timesheet inquiry

Timesheet inquiry

This inquiry allows you to easily keep track of your company's timesheets. You can see who submitted the timesheet and the total number of hours on each timesheet.

If needed, you can add predefined columns and view supplemental information such as who approved the timesheet, the date of the approval, and any notes.

Using the inquiry

From the Inquiry menu, click Employee > Timesheet.

Audience

Accounting staff

Standard columns

Column Links to this inquiry Description Date range available

Timesheet Date

Timesheet Detail

The last date of the timesheet period

 

Employee

Employee

The name of the employee associated with the timesheet

 

Timesheet Total

 

The total number of hours for the timesheet

 

Defined links:

Transaction - Labor

Transaction - Labor

A link to the Transaction - Labor inquiry

 

Predefined columns

You can add predefined columns to this inquiry. These columns are available:

Column Links to this inquiry Description Date range available

Timesheet Key

Timesheet Detail

The database identifier of the timesheet

 

Timesheet Company Key

 

Multi-company only. The database identifier of the company associated with the timesheet

 

Timesheet Company Name

 

Multi-company only. The name of the company associated with the timesheet

 

Employee Key

 

The database identifier of the employee associated with the timesheet

 

Submitted By Key

 

The database identifier of the employee who submitted the timesheet for processing

 

Submitted By

Employee

The name of the employee who submitted the timesheet for processing

 

Submitted Date

 

The date the timesheet was submitted

x

Supervisor Approved By Key

 

The database identifier of the supervisor who approved the timesheet

Approval requirements depend on your settings in Company Preferences.

 

Supervisor Approved By

 

The name of the supervisor who approved the timesheet

Approval requirements depend on your settings in Company Preferences.

 

Supervisor Approved Date

 

The date the supervisor approved the timesheet

Approval requirements depend on your settings in Company Preferences.

x

Accounting Approved By Key

 

The database identifier of the accounting staff who approved the timesheet

Approval requirements depend on your settings in Company Preferences.

 

Accounting Approved Date

 

The date the accounting staff approved the timesheet

Approval requirements depend on your settings in Company Preferences.

x

Day 1

 

The total number of hours for the first day on the timesheet

 

Day 2

 

The total number of hours for the second day on the timesheet

 

Day 3

 

The total number of hours for the third day on the timesheet

 

Day 4

 

The total number of hours for the fourth day on the timesheet

 

Day 5

 

The total number of hours for the fifth day on the timesheet

 

Day 6

 

The total number of hours for the sixth day on the timesheet

 

Day 7

 

The total number of hours for the seventh day on the timesheet

 

See also

About key fields

About standard inquiries

Adding a predefined inquiry column

Creating a new inquiry column

Displaying inquiry data for a specific time period

 

 

© 2015 Deltek Inc. All rights reserved.