Time Sheet Status, by Week Report

This section describes the fields and descriptions on the Time Sheet Status, by Week report.

Time Sheet Status, by Week

This report is similar to the Time Sheet Status, by Week, but instead of displaying hours per week, it displays hours per day from the daily time sheets.

The report consists of two tabs, which have the same structure as the corresponding tabs in the Time Sheet Status, by Week report. On the first tab, this report displays hours entered by day instead of by week. The second tab displays the difference between entered hours and fixed hours by day instead of by week.

There are no drill-down levels for this report.

This report displays the hours of employee time sheets and indicates the workflow status of the time sheet, on a weekly basis. You can enter a week number range or a date range for restricting which weeks-and thus which days-are included.

The report consists of two tabs:

  • Time Sheet Status, by Week - This tab displays the employee number and name, and the hours by week. The number of columns that display the hours is dynamic and updates based on how many weeks match the selected week range/date range. Colors indicate the status of the time sheet.
  • Time Sheet Status, by Week vs. Fixed Hours -This tab displays a similar layout except that the measures are the differences between hours entered and fixed hours. The selection criteria do not include the prompt for only including invoiceable hours because all hours should be included in this tab. Colors indicate whether the entered hours are below, above, or equal to the fixed hours.

Data on both tabs is grouped first by company and then by entity.

There are no drill-down levels for this report.

The week number links to the Time Sheet Status, by Day report, which displays the events behind the workflow of an opportunity.

Time Sheet Status, by Week Tab

Column Description
Employee No. This column displays the employee's number.
Employee Name This column displays the employee's name.
Weekly columns The column headers display the week number and the first date of each week. If the week is a split week, it is suffixed with A and B , respectively. The columns display the number of hours entered in total for that week, unless the time sheet has not been submitted. In this case, the number of hours is the difference between the fixed hours and the hours that have been entered. If the report is restricted to invoiceable hours, only invoiceable hours are displayed; otherwise, all hours are displayed. Hours are invoiceable if both the job and the activity are invoiceable. The column colors are described below:
  • Red - The time sheet has not been created (nor submitted).
  • Orange - The time sheet has been rejected; the project manager has rejected some of the hours on the timesheet.
  • Green - The time sheet has been submitted.
  • Blue - The time sheet has been approved.

Time Sheet Status, by Week vs. Fixed Hours Tab

Column Description
Employee No. This column displays the number of the employee.
Employee Name This column displays the name of the employee.
Weekly columns On this tab, the measures are the differences between all hours entered and fixed hours; even though a restriction to invoiceable hours was made. The value should be negative if the number of hours entered is less than the fixed hours of the employee.
Color Meaning
Blue The hours exceed the fixed hours.
Black The hours are equal to the fixed hours.
Red The hours fall below the fixed hours.