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 Update Other Project Report Tables screen (Projects\Process\Project).
This screen includes one block, two tabs and one subtask. They can be used as follows:
Use the Identification block to enter the parameter ID and description.
Use the Options tab to enter selection ranges, primary grouping, project ranges, project manager ranges, accounting period, sorting order, and various printing options.
Use the Next tab to enter organization ranges, account ranges, labor category ranges, report columns, and organization and account roll-up levels.
Use the Project Non-Contiguous Ranges subtask to enter project non-contiguous ranges.
You must execute the Update Other Project Report Tables screen (Projects\Process\Project) before printing this report. Be sure to check the Labor Summary checkbox in the Create Data For group box. The Update Other Project Report Tables screen updates the RPT_PROJ_LAB_SUM table using the LAB_HS table. Rows are updated in the report table based on your criteria selection. 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 Update Other Project Report Tables screen to update the table with that information.
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.
* A red asterisk denotes a required field.
The source for the data in this report is the RPT_PROJ_LAB_SUM (Report Project Labor Summary) table.