How Hours Are Gathered

Hours that display on the results tab are gathered based on selections made on the Utilization Inquiry screen. Deltek Time & Expense can gather hours by group or by employee.

By Group

If you selected the By Group radio button, the system will sum the hours for each employee in the group that meets the following criteria:

  1. The hours fall within the start date and end date range selected on the Utilization Inquiry screen.
  2. The UDT01 has a UDT01 type code that is linked to the utilization code selected (if the UDT01 is NOT linked to the UDT01 type code, those hours will be placed in the Other column).
  3. Cost-only hours are not included.

By Employee

If you select the By Employee radio button, the system will sum the hours for each employee that meets the following criteria:

  1. The hours fall within the start date and end date range as selected on the Utilization Inquiry screen.
  2. The UDT01 has a UDT01 type code that is linked to the utilization code selected (if the UDT01 is NOT linked to the UDT01 type code, those hours are placed in the Other column).
  3. Cost-only hours are not included.
  4. If the employee's hire date is later than the start date selected, Time & Expense uses the employee's hire date as the start date for that employee only. If the employee has been terminated and the termination date is before the end date selected, the system will use the termination date as the end date for that employee only.

Gathering Standard Hours

If you are running a Standard Hours Utilization report, the system accumulates the total standard hours by reading through the Work Schedule table for the time frame specified in the Start/End Date fields on the Utilization Inquiry screen or the hire/termination dates for the selected employees or group's employees. Deltek Time determines the standard hours using the following criteria:

  1. The system determines the employee's work schedule for the date.
  2. The system looks for a date-specific record for the employee. If it finds one, it accumulates the standard hours for that employee.
  3. If Step 2 yields no results, the system looks for a date-specific record for the company. If it finds one, the system accumulates the standard hours for the employee.
  4. If Step 3 yields no results, the system looks for a specific day-of-the-week record for the employee. If it finds one, the system accumulates the hours for the employee.
  5. If Step 4 yields no results, the system looks for a specific day-of-the-week record for the company. If it finds one, the system accumulates the hours for the employee.
  6. If Step 5 yields no results, there are no hours for employee for the utilization selected.