Personnel Budgeting - Filled Position Detail Report

The Filled Position Detail Report in Personnel Budgeting is a customizable report with many columns of information to choose from. This article will walk through the types of columns available and how they are calculated. 

Note: The Filled Position Detail Report includes Vacant Position information as well! 

Navigate to the Filled Position Detail Report

1. Open your Personnel Budget. Make sure you have completed the entire data model manager and uploaded your Filled Positions. If you have not completed those steps, see our Personnel Budgeting Checklist first.
2. Navigate to the Reports Tab and select Filled Position Detail Report. 
3. Open the columns menu on the right-hand side to view all available columns. We will explain each column below.

General Information Columns

Call out pertinent information here, like the different status types and when statuses change. 

Examples of General Information Columns: 

• Filled Position ID
• Name
• Job Title
• Position Code
• Unit
• Standard Hours
• Department
• Object
• FTE
• Type (Full Time or Part Time)

You might have additional columns, unique to your chart of accounts, depending on your available dimensions and budget classification fields. 

Pro Tip: Don’t forget to use these columns as Row Groups if you want to see sub-totals for specific groups of your budget!

Note: You can click the image above to zoom in. 

Calculation Columns 

Calculations that come from the Positions Tab: 

These columns are pulling information from the Positions Tab. If a calculation column does not have “adjusted’ in the title, it would not reflect Scenario adjustments in the total. 

Examples of Positions Tab Calculation columns: 

• 2027 Total Wages
• 2027 Additional Pay Total
• 2027 Benefit Total
• 2027 Compensation Total
• Additional Pay Details
• Benefit Details

Calculations that come from the Scenarios Tab: 

Calculations that include adjustments from the scenario would have the word “adjusted” in the title. If a calculation column does not have “adjusted’ in the title, it will not reflect Scenario adjustments in the totals. 

Examples of Scenario Calculation columns: 

• Name of Scenario FY2027 Adjusted Total Wages
• Name of Scenario FY2027 Adjusted Total Benefits
• Name of Scenario FY2027 Adjusted Total Comp
• Adjusted Additional Pay Details
• Adjusted Benefits Details

You will have a column available for each of your Scenarios, and you will see the exact name of the Scenario listed in the title of the column. 

Default Scenario for the Report 

Select the scenario and year in the upper left corner of the Filled Position Detail Report. This is the scenario that will be used for any columns that have “Adjusted” in the title but no Scenario listed. 

For example:

• Adjusted Additional Pay Details

• Adjusted Benefits Details

Note: Both of these columns expand into more columns for every Additional Pay and Benefit. 

The data will come from the default Scenario selected for this report. 

Additional Resources

• Learn more about Scenarios in the article: Personnel Budgeting - Scenarios