You are here: Ajera Help (A-Z) > dashboards > Widget Bases > Timesheet Base

Timesheet Base

This base allows you to easily keep track of your company's timesheets.

Available Columns Description Date Range Available Chartable Links to Page
General Information
Accounting Approved Indicates if the timesheet has been approved by accounting      
Billed Indicates if the timesheet has been billed      
Company Name The name of the company associated with the timesheet     Company
Employee Department Name The name of the department the employee associated with the timesheet belongs to     Department
Employee Status The status of the employee associated with the timesheet      
Paid Indicates if the timesheet has been paid      
Project Manager Approved Indicates if the timesheet has been approved by all project managers      
Rejected Indicates if there is time rejected associated with the timesheet      
Submitted Indicates that the timesheet has been submitted      

Supervisor Approved

Indicates that the timesheet has been approved by the supervisor      
People
Accounting Approved By The name of the employee who approved the timesheet for accounting X   Employee
Employee The name of the employee associated with the timesheet     Employee
Submitted By The name of the employee who submitted the timesheet for processing     Employee
Supervisor Approved By

The name of the supervisor who approved the timesheet

Approval requirements depend on your settings in Company Preferences.

    Employee
Supervisor The name of the supervisor of the employee associated with the timesheet     Employee
Dates
Accounting Approved By Date

The date the supervisor approved the timesheet

Approval requirements depend on your settings in Company Preferences.

     
Submitted By Date The date the timesheet was submitted      
Supervisor Approved By Date The date the timesheet was approved by the supervisor      
Timesheet Date The last date of the timesheet period     Timesheet
Hours/Units
Day 1 Premium 1 The total number of premium 1 hours for the first day on the timesheet   X  
Day 1 Premium 2 The total number of premium 2 hours for the first day on the timesheet   X  
Day 1 Premium 3 The total number of premium 3 hours for the first day on the timesheet   X  
Day 1 Regular The total number of regular hours for the first day on the timesheet   X  
Day 1 The total number of hours for the first day on the timesheet   X  
Day 2 Premium 1 The total number of premium 1 hours for the second day on the timesheet   X  
Day 2 Premium 2 The total number of premium 2 hours for the second day on the timesheet   X  
Day 2 Premium 3 The total number of premium 3 hours for the second day on the timesheet   X  
Day 2 Regular The total number of regular hours for the second day on the timesheet   X  
Day 2 The total number of hours for the second day on the timesheet   X  
Day 3 Premium 1 The total number of premium 1 hours for the third day on the timesheet   X  
Day 3 Premium 2 The total number of premium 2 hours for the third day on the timesheet   X  
Day 3 Premium 3 The total number of premium 3 hours for the third day on the timesheet   X  
Day 3 Regular The total number of regular hours for the third day on the timesheet   X  
Day 3 The total number of hours for the third day on the timesheet   X  
Day 4 Premium 1 The total number of premium 1 hours for the fourth day on the timesheet   X  
Day 4 Premium 2 The total number of premium 2 hours for the fourth day on the timesheet   X  
Day 4 Premium 3 The total number of premium 3 hours for the fourth day on the timesheet   X  
Day 4 Regular The total number of regular hours for the fourth day on the timesheet   X  
Day 4 The total number of hours for the fourth day on the timesheet   X  
Day 5 Premium 1 The total number of premium 1 hours for the fifth day on the timesheet   X  
Day 5 Premium 2 The total number of premium 2 hours for the fifth day on the timesheet   X  
Day 5 Premium 3 The total number of premium 3 hours for the fifth day on the timesheet   X  
Day 5 Regular The total number of regular hours for the fifth day on the timesheet   X  
Day 5 The total number of hours for the fifth day on the timesheet   X  
Day 6 Premium 1 The total number of premium 1 hours for the sixth day on the timesheet   X  
Day 6 Premium 2 The total number of premium 2 hours for the sixth day on the timesheet   X  
Day 6 Premium 3 The total number of premium 3 hours for the sixth day on the timesheet   X  
Day 6 Regular The total number of regular hours for the sixth day on the timesheet   X  
Day 6 The total number of hours for the sixth day on the timesheet   X  
Day 7 Premium 1 The total number of premium 1 hours for the seventh day on the timesheet   X  
Day 7 Premium 2 The total number of premium 2 hours for the seventh day on the timesheet   X  
Day 7 Premium 3 The total number of premium 3 hours for the seventh day on the timesheet   X  
Day 7 Regular The total number of regular hours for the seventh day on the timesheet   X  
Day 7 The total number of hours for the seventh day on the timesheet   X  
Timesheet Total The total number of hours for the timesheet   X  
Dollars
Actual Billable Percent The percent of dollars on the timesheet that can be billed to the client      
Target Billable Percent The target billable percentage on the General tab in Setup > Employees      
Keys
Accounting Approved By Key The database identifier of the accounting staff who approved the timesheet     Employee
Company Key The database identifier of the company associated with the timesheet     Company
Employee Department Key The database identifier of the department of the employee associated with the timesheet     Department
Employee Key The database identifier of the employee associated with the timesheet     Employee
Submitted By Key The database identifier of the employee who submitted the timesheet for processing     Employee
Supervisor Approved By Key The database identifier of the supervisor who approved the timesheet     Employee
Supervisor Key The database identifier of the supervisor of the employee associated with the timesheet     Employee
Timesheet Key The database identifier of the timesheet     Timesheet
Action
Open Timesheet

Opens the timesheet for editing

If you have access to Timesheets in the browser, this will open the timesheet in Manage > Timesheets. Otherwise it opens the timesheet in Manage > Time & Expense.

     
Gantt

unavailable in ajeraCore Select to add the Gantt chart to your table widget.

     

 

 

 

© 2024 Deltek Inc. All rights reserved.