Contents of the View Project Activity By Level Screen
Use the fields and options to configure the View Project Activity By Level screen.
Selection Criteria
Field | Description |
---|---|
Fiscal Year |
To narrow the rows shown in the table window to a specific fiscal year, select that fiscal year before executing the inquiry. Keep in mind that the only fiscal years shown are those that have activity in the report tables. If you do not select a fiscal year, all fiscal years with rows in the report table are shown. Normally only one fiscal year is available at a time unless the report tables were created for a previous fiscal year. If you purge your data on a weekly basis, you do not need to select a fiscal year because only one exists in the report table. |
Period |
To narrow the rows shown in the table window to a specific period, select that period before executing the inquiry. Keep in mind that the only periods shown are those that have activity in the report tables. If you do not select a period, all periods that have rows in the report table are shown. If you purge your data on a weekly basis, you do not need to select any period because only one exists in the report table. |
Subperiod |
To narrow the rows shown in the table window to a specific subperiod, select that subperiod before executing the inquiry. Keep in mind that the only subperiods shown are those with activity in the report tables. If you do not select a subperiod, all subperiods with rows in the report table are shown. If you purge your data on a weekly basis, you do not need to select a subperiod because only one exists in the report table. |
Project |
To inquire on a specific project, select that project by clicking , or enter the project. To inquire on a range of projects, click to select them. If you select a single project, its description displays next to the project. |
Organization |
To inquire on a specific organization, select that organization by clicking , or enter the organization. To inquire on a range of organizations, click to select them. If you select a single organization, its description displays next to the organization. |
Rate Type
Select the rate type you want to use for your inquiry.
Field | Description |
---|---|
Target |
Select this option to display targeted burden amounts in the table. |
Actual |
Select this option to display actual rates in the table. If you select this option and the rates have not been calculated yet for the accounting period, the costs do not reflect any indirect burden. This may cause the cost and revenue values to be incorrect. |
Use
Select the organization type that you want to use for your inquiry.
Field | Description |
---|---|
Owning Org |
Use this option to execute the inquiry based on the owning organization of the project. |
Performing Org |
Select this option to execute the inquiry based on the performing organization of the project. |
Project Level |
Identify the highest project level that you want to display in the inquiry. Balances are rolled up to this project level. |
Organization Level |
Identify the highest organization level that you want to display in the inquiry. Balances are rolled up to this organization level. |
Account Level |
Identify the highest account level that you want to display in the inquiry. Balances are rolled up to this account level. |
Table Window
Information in the table window defaults from the Revenue Report table. The number of rows or projects shown in the table window is based on your selection criteria. You can modify and save the size and order of the columns to meet your requirements.
The column information contains cost, revenue, and net inventory information for the subperiod, period, Year-to-Date (YTD), and Inception-to-Date (ITD) for the project(s) selected, as well as the ITD billed, open receivable, and retainage amounts, and the project manager's name. If you did not narrow your inquiry to a specific fiscal year, period, subperiod, project, and organization, columns also display for each item for which you did not select a specific value before executing your inquiry.
Information displays in the table window when you click .
Field | Description |
---|---|
Fiscal Year |
This non-editable field displays the fiscal year associated with the data on this row of the table. |
Period |
This non-editable field displays the period associated with the data on this row in the table window. |
Subperiod |
This non-editable field displays the subperiod associated with the data on this row of the table window. |
Project |
This non-editable field displays the project associated with the data on this row of the table window. |
Project Name |
This non-editable field displays the project name. |
Organization |
This non-editable field displays the organization associated with the data on this row of the table window. |
Organization Name |
This non-editable field displays the organization name. |
Prior Year Net Inventory |
This non-editable field displays the prior year net inventory for the project on this row of the table window. |
Target Subperiod Cost |
This non-editable field displays the target subperiod cost for the project and subperiod on this row of the table window. |
Target Subperiod Revenue |
This non-editable field displays the target subperiod revenue for the project and subperiod on this row of the table window. |
Target Subperiod Net Inventory |
This non-editable field displays the target subperiod net inventory for the project and subperiod on this row of the table window. |
Target Period Cost |
This non-editable field displays the target period cost for the project and period on this row of the table window. |
Target Period Revenue |
This non-editable field displays the target period revenue for the project and period on this row of the table window. |
Target Period Net Inventory |
This non-editable field displays the target period net inventory for the project and period on this row of the table window. |
Target YTD Cost |
This non-editable field displays the target year-to-date cost for the project and fiscal year displayed on this row of the table window. |
Target YTD Revenue |
This non-editable field displays the target year-to-date revenue for the project and fiscal year displayed on this row of the table window. |
Target YTD Net Inventory |
This non-editable field displays the target year-to-date net inventory for the project and fiscal year displayed on this row of the table window. |
Target ITD Cost |
This non-editable field displays the target inception-to-date cost for the project and fiscal year displayed on this row of the table window. |
Target ITD Revenue |
This non-editable field displays the target inception-to-date revenue for the project and fiscal year displayed on this row of the table window. |
Target ITD Net Inventory |
This non-editable field displays the target inception-to-date net inventory for the project and fiscal year displayed on this row of the table window. |
ITD Billed Amount |
This non-editable field displays the inception-to-date amount billed for this project. |
Open Receivable Amount |
This non-editable field displays the open receivable amount for the project. |
Retainage Amount |
This non-editable field displays the retainage amount for this project. |
Net Withholding Amount |
This column displays the net of withholding for the project, organization, and account combination for the fiscal year up to and including the specified subperiod. |
Subtasks
Subtask | Description |
---|---|
Project Status | Click this link to view additional project status information about the row that is highlighted in the table window. The information on the Project Status subtask defaults from the Project Status Report (PSR) table. |
GLC Labor Summary | Click this link to view project labor detail by General Labor Category (GLC). The information on the GLC Labor Summary subtask defaults from the Project Labor Summary Report table. |
PLC Labor Summary | Click this link to view project labor detail by Project Labor Category (PLC). The information on the PLC Labor Summary subtask defaults from the Project Labor Summary Report table. |
Employee Labor Summary | Click this link to view employee labor detail for the selected project. |