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

Timesheet Detail inquiry

Use this inquiry to see detailed information for your timesheets.

At a glance, you can see the project and phase, activity, employee type, and total hours associated with each timesheet detail.

If needed, you can add predefined columns and view supplemental information such as the utilization type associated with a timesheet detail.

Using the inquiry

From the Inquiry menu, click Employee > Timesheet Detail.

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

 

Project ID & Description

Project

The ID and description of the project associated with the timesheet detail

 

Phase ID & Description

Phase

The ID and description of the phase associated with the timesheet detail

 

Activity Description

Activity

The description of the activity associated with the timesheet detail

Examples: Administration, Billable Time, Meetings, Vacation

 

Employee Type Description

Employee Type

The employee type of the employee associated with the timesheet detail

Example: Architect, Project Manager, Principal

 

Total Hours Row

 

The total number of hours for the timesheet detail

 

Day 1

 

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

 

Day 2

 

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

 

Day 3

 

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

 

Day 4

 

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

 

Day 5

 

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

 

Day 6

 

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

 

Day 7

 

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

 

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

The database identifier of the timesheet

 

Timesheet Row

 

The row where this detail appears in the timesheet

 

Employee Key

Employee

The database identifier of the employee associated with the timesheet detail

 

Employee Department Key

Department

unavailable in ajeraCore unless you have the Departments add-on

The database identifier of the department associated with the employee

 

Employee Department

Department

unavailable in ajeraCore unless you have the Departments add-on

The name of the department associated with the employee

 

Employee Company Key

 

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

 

Employee Company Name

 

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

 

Project Key

Project

The database identifier of the project associated with the timesheet detail

 

Project ID

Project

The ID of the project associated with the timesheet detail

 

Project Description

Project

The description of the project associated with the timesheet detail

(If Overhead Group, it is Overhead Group Item Description.)

 

Project Company Key

 

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

 

Project Company Name

 

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

 

Phase Key

Phase

The database identifier of the phase associated with the timesheet detail

 

Phase ID

Phase

The ID of the phase associated with the timesheet detail

 

Phase Description

Phase

The description of the phase associated with the timesheet detail

 

Phase Department Key

Department

unavailable in ajeraCore unless you have the Departments add-on

The database identifier of the department associated with the phase

 

Phase Department

Department

unavailable in ajeraCore unless you have the Departments add-on

The name of the department associated with the phase

 

Is Department Different

 

unavailable in ajeraCore unless you have the Departments add-on

Indicates if the phase department is different from the employee department

 

Is Company Different

 

Multi-company only. Indicates if the phase company is different from the employee company

 

Activity Key

Activity

The database identifier of the activity associated with the timesheet detail

 

Employee Type Key

Employee Type

The database identifier of the employee type associated with the timesheet detail

 

Utilization Key

 

The database identifier of the utilization type associated with the timesheet detail

 

Overhead Group Description

 

The name of the overhead group associated with the timesheet detail

 

Supervisor Key

Employee

The database identifier of the supervisor associated with the timesheet detail

 

Supervisor

Employee

The name of the supervisor associated with the timesheet detail

 

Defined links:

Link - Transaction - Labor

Transaction - Labor

A link to the Transaction - Labor inquiry

 

Link - Employee

Employee

A link to the Employee inquiry

 

Link - Project

Project

A link to the Project inquiry

 

Link - Phase

Phase

A link to the Phase inquiry

 

Link - Activity

Activity

A link to the Activity inquiry

 

Link - Employee Type

Employee Type

A link to the Employee Type inquiry

 

Link - Timesheet

Timesheet

A link to the Timesheet inquiry

 

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.