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 
> Reports menu, click Standard Inquiries > 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 |
|
|
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 |
|
