in the From
and/or To
fields in this group box. Valid options are:Use this screen to print the Project Labor Summary report, which details labor hours and amounts incurred by project. You can group the reports using various options and, if printing by project, you can collate them for distribution. You can use secondary sorting features to organize the report to your specifications. You can print the report by General or Project Labor Category (GLC or PLC), with projects, organizations, and accounts rolled up to selected levels. In addition, you can select each of the six columns of information on the report from a range of options including hours, cost, budget, variance and allowable revenue. Each of these options is available by subperiod, period, year-to-date, and inception-to-date. The application prints the report from the RPT_ PROJ_LAB_SUM table, which is updated by the Create Project Report Tables screen.
You must execute the Create Project Report Tables screen (Projects » Inquiry and Reporting » Report Processing) before printing this report. Be sure to check the Labor Summary check box in the Create Data For group box. The Create Project Report tables process updates the RPT_PROJ_LAB_SUM table using the LAB_HS table. Rows are updated in the report table based on the criteria you selected. For example, assume the report table contains amounts from January 1, 1999 through May 31, 2002. If you update the report tables with information from FY 2002, subperiods 1 through 4 of period 5 (May 1-31, 2002), the utility will update only rows containing amounts for these subperiods. If you want to run reports including June 2002 data (period 6), you must first run the Create Project Report Tables screen to update the table with that information.
Use the fields in this group box to select options for report grouping and sorting.
Use the drop-down list to select the primary grouping for the report. Valid options are:
Project
Alternate Reporting
Owning Organization
Performing Organization
Account
Labor Category
The report will use this criterion as the primary sort; you can identify secondary sorts in the Select group box.
Use this drop-down list to select a collate option. Valid options are:
Owning Organization
Performing Organization
Project Manager
Project Type
None
Use this option to sort the report for distribution purposes. Note that this option is available only if the primary grouping selection is Project.
Use this group box to specify a number of secondary sorts and the order in which these sorts will organize information on the report. Available check boxes are Performing Organization, Account, Labor Category, and Employee/Vendor Detail. Note that the Performing Organization, Account, and Labor Category check boxes will be unavailable if you selected that same option in the Primary Grouping group box. After you have selected the check boxes, enter the sort order in the Sort Order fields.
Select this check box to produce a subtotal for each selected report item.
The fields in this group box are enabled only when you select Project (the default selection) in the Group By field of the Primary Grouping group box.
Use the drop-down list to select the range of project managers for the
selected project or range of projects to print. If you enter a project
range in the From
and/or To
fields in the Select Project
group box, the project manager(s) assigned to these project(s) will be
listed when you use in the From
and/or To
fields in this group box. Valid options are:
All
One
Range
From Beginning
To End
Enter, or use to select, the starting project manager
for the range of projects to be printed. This field is enabled if All, One,
Range, or To
End is selected in the Range
field.
Enter, or use to select, the ending project manager
for the range of projects to be printed. This field is enabled if All, Range,
or From Beginning is selected
in the Range
field.
Use the options in this group box to select various printing options.
Select this check box to include those projects that contain no activity.
Select this check box to include projects that have been set to "inactive" in the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master).
Use this group box to identify the period through which you would like to include data on the report.
Enter, or use the drop-down list to select, a valid fiscal year.
Enter, or use the drop-down list to select, a valid period.
Enter, or use the drop-down list to select, a valid subperiod. The ending date of this subperiod will display in the untitled field to the right.
Use the fields in this group box to limit the projects that will be included on the reports.
Use this drop-down list to select the range of projects to print. Valid options are:
All
One
Range
From Beginning
To End
Enter, or use to select, the beginning project for
the range you want to include on the report. If you select All
or From Beginning in the Range Option field,
this field is inactive.
Enter, or use to select, the ending project for the
range you want to include on the report. If you select All
or To End in the Range
Option field, this field is inactive.
Identify the project level that you want to summarize. All project levels at and below this level will be rolled up to this level for the report.
Use this field to select a noncontiguous range of projects to print on the report. This field, the List Mode check box, and the Apply and Remove buttons are enabled only when you have selected Project in the Group By field of the Primary Grouping group box.
Select this check box to create a customized, non-contiguous, list in the Noncontiguous Range field. The list mode function is different from using a Range because you can use the list mode for a custom selection that will include or exclude any projects of your choice.
Using the Range drop-down list, select a range. Valid options are:
One
Range
From Beginning
To End
Enter the project in the From field and/or the To field. Click the Apply button to add this project or range of projects to the Noncontiguous Range field. Once you have selected the list mode, any projects appearing in the From/To range will not be printed unless you have added them to the Noncontiguous Range field with the Apply button. To remove a selection from the Noncontiguous Range field, highlight the row and click the Remove button.
After you have selected the List Mode check box and entered a To/From project, click the Apply button to include the project, or range of projects, to be printed in the noncontiguous range.
Use this button to remove a project or a range of projects that you previously selected. Highlight the selection and click the Remove button.
This group box is available only if you selected the Labor Category check box in the Select group box. If you have selected Labor Category in the Group By field in the Primary Grouping group box, the report will be grouped by PLC.
Select this option to print the report by Project Labor Category.
Select this option to print the report by General Labor Category.
Click this button to access additional options for this report.
You can save the report parameters for future use. To save the selected report parameters, click the Save icon on the toolbar after you have entered your report selections. Enter up to 15 alphanumeric characters to name the parameter and a description of the report. Click the OK button to save.
Stored report parameters are especially useful if reports are to be run through the Batch Manager. When creating the batch job to be executed, the system uses the report stored in the report parameters to identify report criteria.
RPT_PROJ_LAB_SUM