The employees that display in the Results tab table depend on the criteria you selected in the Criteria tab.
Which columns are displayed is determined by options selected in the Criteria tab. If you selected the By Group radio button, the table will display the groups that fit the criteria, and each field in the Utilizations table that was selected. You can use a drill-down function to see the individual employee hours that were charged. If you selected the By Employee radio button, the table will display the employees' names along with each utilization selected.
This non-editable column displays the group and will be displayed only if you selected the By Group radio button in the Criteria tab.
This non-editable column displays the name of the employee. If the system is configured to show employee IDs, the ID, in parentheses, will follow the employee name. This column will be displayed only if you selected the By Employee radio button in the Criteria tab.
These non-editable columns display, in alphabetical order, the utilization(s) selected in the Criteria tab. If hours exist for utilizations that were not selected, they will be placed in a column called Other. Each set of utilizations is divided into two columns, and the data displayed is based on criteria selected in the Criteria tab:
Actual Hours - If you selected the Actual Hours radio button as the hours option in the Criteria tab, the following information will be displayed:
Hours - The first column displays the number of hours that each group or employee charged to the utilization for the selected time period.
Percent - The second column is a calculated value that displays the percentage of the hours that each group or employee charged in the Hours column divided by the total actual hours on the timesheet(s) for the date range selected.
Standard Hours - If you selected the Standard Hours radio button as the hours option in the Criteria tab, the following information will be displayed:
Hours - The first column displays the number of hours that each group or employee charged to the utilization for the selected time period.
Percent - The second column is a calculated value that displays the percentage of the hours that each group or employee charged in the Hours field divided by the total standard hours on the timesheet(s) for the date range selected.
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:
The hours fall within the start date and end date range selected on the Criteria tab.
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).
Cost-only hours are not included.
If you select the By Employee radio button, the system will sum the hours for each employee that meets the following criteria:
The hours fall within the start date and end date range as selected on the Criteria tab.
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).
Cost-only hours are not included.
If you are running a Standard Hours Utilization report, the system will accumulate the total standard hours by reading through the Work Schedule table for the timeframe specified in the Start/End Date fields on the Criteria tab or the hire/termination dates for the selected employees or group's employees. The system will determine the standard hours using the following criteria:
The system will determine the employee's work schedule for the date.
The system first look for a date-specific record for the employee. If it finds one, it will accumulate the standard hours for that employee.
If Step 2 yields no results, the system will then look for a date-specific record for the company. If it finds one, the system will accumulate the standard hours for the employee.
If Step 3 yields no results, the system will look for a specific day-of-the-week record for the employee. If it finds one, the system will accumulate the hours for the employee.
If Step 4 yields no results, the system will look for a specific day-of-the-week record for the company. If it finds one, the system will accumulate the hours for the employee.
If Step 5 yields no results, there are no hours for employee for the utilization selected.
Use the Preview/Print pushbutton to preview the Utilization Inquiry report in Adobe Acrobat format. The preview includes all employees listed in the Detail table of the Results tab. Select the Print pushbutton to print the report.
