Use this screen to print timesheet reports based on the timesheet cycle and timesheet dates you specify in this application. This report is sorted by employee name.
The purpose of this screen is to allow you to review timesheet information before you process this data. After you print timesheet reports, for example, you can validate the report content by comparing it to the original timesheet information. If you identify erroneous data or inconsistencies, you can correct these timesheets before you post them.
There are several sort options available, allowing you to group the report output by "Home Organization," Employee Name," and "Employee ID." However, despite your sort selections in the 1st Sort and 2nd Sort fields, this report is always first sorted by employee. It is then sorted by your first and second sort specifications.
This application allows you to print timesheet data for the cycle and dates you select. You should print this report after entering timesheets in order to compare these data to the original documents.
You can click the Preview Default Report icon to print the report output to your screen, or you can click the Print Default Report icon to send the report to a printer.
Use this screen after you enter timesheets using the Enter Timesheets program (People\Transactions\Timesheets). You should print this report after entering all timesheets for a given cycle.
You can print this report for previously posted timesheets.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to specify the users, timesheet cycle, home organization, and timesheet dates that will be included in the report. You can include this data for a specific user or for all users who have entered timesheets.
Use the drop-down box to make a selection. Your choices are "All" or "One."
All - Select this option to include all available records. The Start field is disabled for this option.
One - One - Select this option to include only one record. You must enter data value in the Start field.
Enter, or use Lookup to select, the user ID.
This option includes only one record. This field is non-editable.
Enter, or use Lookup to select, up to four alphanumeric characters to identify the timesheet cycle.
Use this drop-down box to select the range option for your report. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting home organization for the range you want to include in the report.
Enter, or use Lookup to select, the ending home organization for the range you want to include in the report.
Use this drop-down box to select the range option for your report. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting timesheet date for the range you want to include in the report.
Enter, or use Lookup to select, the ending timesheet date for the range you want to include in the report.
Use the drop-down box to make a selection. Your choices are "All" or "One."
All - Select this option to include all available records. The Start field is disabled for this option.
Range - Select this option to include a record range.
Enter, or use Lookup to select, the fiscal year from which to start.
Enter, or use Lookup to select, the period from which to start.
Enter, or use Lookup to select, the subperiod.
Enter, or use Lookup to select the subperiod from which to end.
Use this drop-down box to select the range option for your report. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the employee ID from which to start.
Enter, or use Lookup to select, the employee ID from which to end.
Use the fields in this block to determine the sort order of the report.
1st Sort *
Use the drop-down box to make a selection. Your choices are "Home Organization," Employee Name," and "Employee ID."
Home Organization - Select this option to sort the report by the employee home organization.
Employee Name - Select this option to sort the report by the employee name, as entered in the Employee User Flow screen.
Employee ID - Select this option to sort the report by employee ID. Both the employee name and ID will appear on the report.
2nd Sort *
Use options in this drop-down box to choose the report's secondary sort.
The options in this drop-down box are enabled based on your selection in the 1st Sort field. For example, if you choose "Home Organization" as the first sort option, the "Employee ID" and "Employee Name" will be available for selection.
If you select the "Employee Name" or "Employee ID" options in the 1st Sort drop-down box, "None" will default in this field and display as the second sort option.
Employee Name - Select this option to sort the report by the employee name, as defined in the Employee User Flow screen. This name will also appear on the report. This is one of two options available when the first sort is by "Home Organization."
Employee ID - Select this option to sort the report by employee ID. Both the employee name and ID will display on the report. This is one of two options available when the first sort is by "Home Organization."
None - Select this option to disallow a secondary sort. This is the default when the first sort is "Employee Name" or "Employee ID."
Use the fields in this block to include and display additional report data.
Use the fields in this group box to designate the timesheet type. You can use the selections in this group box to include part-time and temporary employees; in addition, you can include timesheets that were posted when you executed the Post Labor program.
Select one of the following timesheet types: "All," "Bonus," "Correcting," "D-Correcting," "Labor Only," "LV-Payout," "M-Labor Susp," "N-Reversing," and "Regular."
"All" is the default timesheet type.
Select this checkbox to include timesheets that have already been posted using the Post Labor program.
Select this checkbox to include part-time employees in the report.
Select this checkbox to include temporary employees in the report.
Use the radio buttons in this group box to print summary or detail reports.
Select this radio button to print the report excluding the posting data, reference numbers, post flag, and user ID.
If you select this radio button, you cannot view employee pay type totals.
Select this radio button to print the report inclusive of the posting data, reference numbers, post flag, user ID, and timesheet notes.
Select this radio button to view employee pay type totals.
Use the checkboxes in this group box to specify additional detail that you want included in the report.
Select this checkbox to print a code on the report that will alert you to potential issues.
The codes are as follows:
"A" - The labor cost does not equal the hours times the hourly rate.
"B" - The timesheet date is included after the contract end date.
"C" - The account is not a labor account.
"D" - Wage determination rate was used.
"E" - Employee has exceeded budgeted hours for the project.
The codes will display in a specific column within the body of the report. An explanation of these codes will display at the end of the report.
Select this checkbox to view the total hours charged and labor cost for each individual pay type.
These totals appear on the final page of the report.
Select this checkbox to show the total hours charged and labor cost for the pay types used by each employee.
These totals appear after all hours are printed for each employee.
This checkbox is enabled when you select the Summary radio button in the Report Format group box.
* A red asterisk denotes a required field.
The TS_HDR (Timesheet Header) and TS_LN (Timesheet Line) are source tables whose data is evaluated after you enter your selection criteria.