This chapter provides an overview of position budgeting setup and discusses how to:
Set up general position budgeting defaults.
Set up job code defaults.
Set up position data defaults.
Review human resource default data.
To use position budgeting activities, you define defaults at the coordinator level that the system uses when you import position and employee data and add new positions during the budgeting process. As you define the defaults, you can allow override of default information for position budget preparers.
You need position and employee defaults before you can use position budgeting. You can enter new positions directly into Planning and Budgeting or you can import existing data from PeopleSoft Human Resource Management System, or another human resource system into the PeopleSoft Enterprise Performance Management interface tables that Planning and Budgeting accesses.
When you load position data from your human resource system into the Planning and Budgeting database, you bring in compensation amounts and distributions associated with each position. Associate positions with the planning centers in your planning model by assigning your human resource departments to planning centers as part of the human resource data integration process.
See Integrating with PeopleSoft HRMS.
If a position in your human resource system does not have compensation or distributions associated with it, the system assigns these values using defaults that the coordinator defines. If a position has salary distributions associated with it, the system generates earnings, benefits, and employer-paid tax distributions using the same dimensions as the salary distribution, with the exception of the account. If a position does not have a salary distribution, the system uses the job code associated with the position to determine the salary, earnings, benefits, and tax defaults. If these compensation and distribution defaults are unavailable in the job code definition, the system uses the defaults that you define using the Position Data Defaults page by business unit.
The hierarchy of position data, including compensation and distributions defaults for existing positions loaded into Planning and Budgeting from your human resource system, is illustrated as follows:
Hierarchy of position data defaults for existing positions
Your organization may fund a position from one or many department budgets. Your organization may also use different budgets for different position compensation costs. Use the distribution pages to distribute position costs across multiple planning centers or dimension values in position budgeting. To distribute costs to the appropriate dimensions, define the dimension distributions for salary, earnings, benefits, and taxes. You can distribute salary and earnings costs to one budget and distribute benefit and tax costs to a different budget. Define position cost distributions according to your organization's business practice regarding the budgeting and tracking of employee costs.
The sources of defaults on the distribution pages depend on the type of position—existing, copied, or added—as listed in the following table:
Field |
Default Source for Existing Position |
Default Source for Copied Position |
Default Source for Added Position |
Account |
|
Account associated with the copied position. |
|
Distributions by Percentage |
|
Distributions associated with the copied position. |
|
Position Amounts |
|
Salary, earnings, benefits, and tax amounts associated with the copied position. |
|
See Also
Integrating With Other Applications
Define general defaults for position activities, including system-generated position numbers and the accounts used for position budgeting.
To set up your general position budgeting defaults, use the following components:
Position Number Default (BP_HRMS_INSTALL).
Position Account Defaults (BP_POS_BUDG_ACT).
This section discusses how to:
Set up auto numbering for positions.
Identify accounts for position account categories.
Page Name |
Object Name |
Navigation |
Usage |
BP_HRMS_INSTALL |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Position Number Default, Position Number Default |
Enter the position prefix and the last assigned position number used by Planning and Budgeting. |
|
BP_POS_BUDG_ACT |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Position Budgeting Accounts, Position Salary Account Defaults |
Identify salary accounts related to position budgeting used to define the personnel line-item budgets. |
|
BP_POS_BNFT_ACT |
Click the Benefits Account link on the Position Salary Account Defaults page. |
Identify benefits accounts related to position budgeting used to define the personnel line-item budgets. |
|
BP_POS_EARN_ACT |
Click the Earnings Account link on the Position Salary Account Defaults page. |
Identify earnings accounts related to position budgeting used to define the personnel line-item budgets. |
|
BP_POS_TAX_ACT |
Click the Tax Account link on the Position Salary Account Defaults page. |
Identify employer paid tax accounts related to position budgeting used to define the personnel line-item budgets. |
Access the Position Number Default page.
Position Prefix |
Enter a prefix for the system to attach to each new position number so that new positions are distinguished from positions imported from the human resource system. The user cannot override this prefix; it applies to all positions created during the budgeting process. |
Last Assigned Position Number |
Enter the last assigned position number. The system assigns the next number in sequence, and then adds the position prefix for newly created positions. The user cannot override this default. |
Note. The PeopleSoft Position Management application in the Human Resource Management System is not a required component of Planning and Budgeting integration. However, because Planning and Budgeting uses a position number to manage data within the planning model and activity, the system also uses the default position prefix and last assigned position number during the Budgeting Stage Application Engine process (BP_STG) to assign a position number when none is present.
Access the Position Salary Account Defaults page.
Identify position budgeting accounts to:
Determine the salary, earnings, benefits, and tax accounts used for position budget activities by account category.
Determine the account members allowed for the position budgeting activity by business unit.
From Account and To Account |
Enter one account value or a range of values to define your available salary, benefits, earnings, and employer-paid tax expense accounts by business unit. The system associates the accounts on these pages with the corresponding salary, benefits, earnings, and tax expense categories in position budgeting. |
Salary Account |
Click to access the Position Salary Account Defaults page and identify salary accounts related to your position budgeting activity used to define the personnel expenses. |
Benefits Account |
Click to access the Position Benefits Account Defaults page and identify benefits accounts related to your position budgeting activity used to define the personnel expenses. |
Earnings Account |
Click to access the Position Earnings Account Defaults page and identify earnings accounts related to your position budgeting activity used to define the personnel expenses. |
Tax Account |
Click to access the Position Tax Account Defaults page and identify employer paid tax accounts related to your position budgeting activity used to define the personnel expenses. |
Note. Since these account default rules represent the dimension members for the position activities in your planning model, make sure that the values all exist on the same level of an account tree you use in your activity group. You want all the accounts used for position budgeting to be consistent with the account tree, dimension leveling, and parent line-item activity, within the scenario of your business unit's planning model. Users may not be able to add positions or run reports when the accounts used are at varying levels of an account tree.
To set up your job code defaults, use the following components:
Distribution Profile (BP_DISTR_PRFL).
Salary Group (BP_SAL_GRP).
Salary Grade Data (WA_SAL_GRADE_D00).
Benefit Group (BP_BNFT_GRP).
Earnings Group (BP_EARN_GRP).
Employer Tax Group (BP_TAX_GRP).
Job Code Defaults (BP_JOB_DEFAULT).
Job Code (JOBCODE_D00).
This section provides an overview of job code defaults and discusses how to:
Define distribution profiles.
Define salary defaults.
Define benefit plan defaults.
Define earnings defaults.
Define employer-paid tax defaults.
Assign defaults to job codes.
Job code defaults link in Planning and Budgeting compensation, distribution, and union code information. When you attach a job code to a position, you assign the compensation costs and define how the system distributes those costs to specific dimensions. If enabled at the coordinator level, budget preparers can override these defaults at the position-detail level.
Use these defaults for existing positions, loaded from your human resource system, that do not have compensation costs associated with them and for new positions created using Planning and Budgeting.
Page Name |
Object Name |
Navigation |
Usage |
BP_DISTR_PRFL |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Distribution Profile, Distribution Profile |
Set up distribution profiles that include default distributions for salary, earnings, benefit, and tax costs. |
|
BP_SAL_GRP |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Salary Group, Salary Group |
Define salary default groups. |
|
WA_SAL_GRADE_D00 |
EPM Foundation, Business Metadata, OW-E Dimension Maintenance, HRMS, Salary, Grade, Salary Grade Data |
Inquire and update existing grades associated with a salary administration plan. |
|
WA_SAL_STEP_D00 |
EPM Foundation, Business Metadata, OW-E Dimension Maintenance, HRMS, Salary, Grade, Salary Step Data |
Inquire and update existing steps associated with a salary administration plan. |
|
BP_BNFT_GRP |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Benefit Group, Benefit Group |
Define benefit default groups. |
|
BP_EARN_GRP |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Earnings Group, Earnings Group |
Define earnings default groups. |
|
BP_TAX_GRP |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Employer Tax Group, Employer Tax Group |
Define employer paid tax default groups. |
|
BP_ASSIGN_JOBCD |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Job Code Defaults, Job Code Defaults |
Assign the salary, benefit, earning, and tax default groups to job codes. |
|
JOBCODE_D00 |
EPM Foundation, Business Metadata, OW-E Dimension Maintenance, HRMS, Employee and Job, Job Code, Maintain Dimension |
Inquire, update, or add a job code. |
Access the Distribution Profile page.
Distribution Options
Salary Distribution, Benefit Distribution, Earning Distribution, and Tax Distribution |
Select to apply the default dimension distributions for salary, benefits, earnings, and tax costs respectively. You can select any combination of distribution options to specify the distribution type. Each selected distribution option uses the same default distribution. If you clear the check box for a distribution option, the system uses the planning center associated with the position to populate the dimensions for the distribution lines. |
Enter percentage values for the dimensions to define a dimension distribution.
Enter these values on each distribution row to define the portion of the compensation costs that use the defined dimension distributions. The distribution profile can contain one or multiple distribution lines. This lets you distribute the cost of a position to multiple budgets. You can have an unlimited number of distribution lines for a distribution profile. The dimensions that appear depend on the dimensions that you use for budgeting purposes, as defined on the Dimension Configuration page.
If you leave a dimension value blank for your planning center, the system populates the dimension with the planning center value when you add a new position. In this situation, the distribution default percentage is 100 percent.
If you enter dimensions, the system uses the dimension values from the distribution profile. The coordinator can assign the distribution profile to a job code associated with the position to which you want to assign the default dimension values. A distribution default associated with a job code is global for all positions added by all planning centers for a job code. Leave the distribution profile default option blank on the Job Code Defaults page when your distributions are not global across job codes and planning centers.
Distributions do not include the account dimension. Assign the account defaults for salary, earnings, benefits, and tax costs for these compensation components using the salary, earnings, benefits, and employer tax group pages respectively. The preparer can override the account default at the position level if override capability is enabled in the salary, earnings, benefits, employer tax group definitions. The account dimension values used are determined by the values assigned to salaries, benefits, earnings, or taxes at the time that the distributions are created.
Note. If your organization's labor distribution program does not support or use multiple dimension distributions for a position, define at least one distribution line with a percentage of 100.00. Assign this single distribution profile on the Position Data Defaults page for the business unit because it is unnecessary to associate a distribution default with each job code.
Currency Code |
Enter the same currency code as the one used for the job code defined in the planning model. You cannot modify or convert currency code defaults for the job code record during the position budgeting process. Additionally, when staging data or creating new positions, if the job code's default currency is not an entry currency of the planning model, it will be converted to the business unit's base currency. |
Salary Plan, Grade, and Step |
Enter values to establish and further define the starting salary for positions by job code and the overall salary plan. Available selections depend on the salary plans, salary grades, and salary steps imported from your human resource system. |
Account |
Enter the desired account to be used as the default for salary cost distributions. The system uses only one account for salary distributions for a single position. |
Survey Salary |
Enter or modify the desired survey salary. When you define the salary plan, grade, and step to add a new position, the system displays a Survey Salary value if one is available for the selected job code. You can modify this value. Note. If no survey salary value is available for the selected job code record, use the salary plan, grade, or step value instead, if available. If no value is available, then the position's salary displays 0 (zero). |
Account Override Allowed |
Select to enable override capability of the salary account at the position default and employee job levels. If selected, a preparer can override the account used to distribute a position and employee's salary costs. |
Amount Override Allowed |
Select to enable override capability of the salary default at the position and employee job levels. If selected, you can override the salary amount defined for the position and employee. |
Note. Access the Salary Grade Data and Salary Step Data pages to review and update existing grades and steps associated with a salary plan imported from your human resource system.
Access the Benefit Group page.
Currency Code |
Enter the same currency code as the one used for the job code defined in the planning model. |
Plan Type |
Enter a benefits plan type default defined as translate values like those in PeopleSoft Human Resource Management System. |
Account |
Enter the default account for benefits cost distributions. |
Account Override Allowed |
Select to enable override capability of the benefits account at the position default and employee job levels. If selected, a preparer can override the account used to distribute a position and employee's benefits costs. |
Amount |
Enter a flat amount to define the lump sum cost of benefits for positions and employees. |
% of Salary (percentage of salary) |
Enter a percentage of salary to have the system calculate the benefits costs by applying the percentage against a position or employee's gross pay. Enter an amount or percentage, but not both. Note. Gross pay is defined as the salary amount plus any earnings marked as added to gross pay. The Add Gross field in the earnings table is visible to an end user in position budgeting on the Earnings/Allowance page. |
Amount Override Allowed |
Select to enable override capability of the benefit plan amount at the position default and employee levels. If selected, a preparer can override the amount used to distribute a position or employee's benefits costs. |
Access the Earnings Group page.
Access the Employer Tax Group page.
Currency Code |
Enter the same currency code as the one used for the job code defined in the planning model. |
Tax Class |
Select the default employer-paid tax. The available options are those defined as translate values like those in PeopleSoft Human Resource Management System. |
Account |
Enter the default account for employer-paid tax distributions. |
Account Override Allowed |
Select to enable override capability of the tax account at the position default and employee job levels. If selected, a preparer can override the account used to distribute a position or employee's employer-paid tax costs. |
Amount |
Enter a tax amount to define the lump sum cost for positions and employees. Enter an amount or percentage, but not both. |
Maximum Gross |
Enter the amount that the system uses to control the maximum gross pay amount against which employer-paid taxes are applied. For example, suppose that you define maximum gross as 56,000 USD and taxes as 5 percent of salary. The system calculates taxes for positions up to 56,000 USD in gross salary costs. Thus, the maximum amount applied to employer-paid taxes is 2,800 USD, or 5 percent of 56,000 USD. The system does not apply taxes for salary costs existing above 56,000 USD. |
% of Salary (percentage of salary) |
Enter a percentage of salary to have the system calculate the tax by applying this value against a position or employee's gross pay. Note. Gross pay is defined as the salary amount plus any earnings marked as added to gross pay. The Add Gross field in the earnings table is visible to an end user in position budgeting on the Earnings/Allowance page. |
Amount Override Allowed |
Select to enable override capability of the tax default at the position default and employee job levels. If selected, a preparer can override the employer-paid tax amount defined to distribute a position or employee's costs. |
Access the Job Code Defaults page.
Salary Group ID, Benefit Group ID, Earnings Group ID, and Tax Group ID |
Enter optional group ID information for each job code. The available options for these fields are effective-dated and depend on the data that you enter using the Salary Group, Benefit Group, Earnings Group, and Employer Tax Group pages, respectively, and the currency code associated with the job code. The currency code for salary, benefit, earnings, and tax groups must match the currency code assigned to the job code. If you do not enter a value for one of the fields, the system searches for any corresponding defaults established at the next level within the hierarchy, which is on the Position Data Defaults page by business unit. If the system does not find appropriate defaults, it leaves the information blank. You can manually enter the data at the position level. Note. You cannot modify or convert currency code defaults for the job code default record during the position budgeting process. Currencies are only converted during staging and the creation of new positions when the job code's default currency is not an entry currency of the planning model. |
Union Code |
Enter union code information for each job code as appropriate. The available union code options depend on those in the union code interface table (UNION_TBL) when loaded into the Enterprise Warehouse for Planning and Budgeting. |
Distribution Profile |
Enter distribution profile information for each job code as appropriate. The available options for the distribution profile depend on the data that you enter using the Distribution Profile page. |
Note. Even if you do not want to assign any defaults at the job codes level, you must select at least one effective date to display
available job codes, and then save the page to populate the record used for position budgeting activity. All defaults will
then be extracted from the Position Data Defaults page by business unit.
If you have more than one set of accounts (more than one setID for account dimensions) for multiple models that use a single
set of job code data (one setID), define any account-related defaults at the business unit level using the Position Data Defaults
page.
Note. Access the Job Code - Maintain Dimension page in Enterprise Warehouse to inquire, update or add job codes.
The distributions associated with each job or position imported from your human resource system are the primary defaults used in Planning and Budgeting. If a position in your human resource system does not have compensation or distributions associated with it, the system uses other defaults that you define. The system first looks to the job code definition, and then to the defaults by business unit on the Position Data Defaults page.
To set up your position data defaults, use the Position Data Defaults component (BP_HRMS_DEFAULT).
This section discusses how to define position data defaults.
Page Name |
Object Name |
Navigation |
Usage |
BP_HRMS_DEFAULT |
Planning and Budgeting, Planning and Budgeting Setup, Position Budgeting Defaults, Position Data Default, Position Data Defaults |
Establish defaults for importing position or employee data and performing position budgeting activities. The system applies these defaults when defaults from your human resource system or job code definition are unavailable.
|
Access the Position Data Defaults page.
Distribution Profile |
Enter the distribution profile default used to assign dimension distributions for compensation costs for newly added positions or those associated with existing positions imported from your human resource system that do not have complete distribution information. The options depend on the distribution profiles that you set up. Override the distributions at the position level. |
Salary Account |
Enter the salary account default. The option includes those accounts that you define as your default salary accounts using the Position Salary Account Defaults page. Override this default at the position level. |
Benefit Account |
Enter the benefits account default. The option includes those accounts that you define as your default benefit accounts using the Position Benefits Account Defaults page. Override this default at the position level. |
Earning Account |
Enter the earnings account default. The option includes those accounts that you define as your default earning accounts using the Position Earnings Account Defaults page. Override this default at the position level. |
Tax Account |
Enter the tax account default. The option includes those accounts that you define as your default tax accounts using the Position Tax Account Defaults page. Override this default at the position level. |
Standard Hours |
Enter the default value for positions that do not have standard hours associated with them. Use this field for unfilled and new positions. Override this default at the position level. |
Enter the desired budget factor to calculate position costs for unfilled and new positions. If the budget factor is 1.00, the system budgets 100 percent of the position costs. To prorate the position costs, enter a fraction of the position cost. For example, for a new position effective dated at the first of the budget year that goes unfilled for 3 out of 12 months into the budget year, enter a budget factor of 0.75. The system calculates 75 percent (9 months of expense) of the position costs as expense to spread across the budget year. Override this default at the position level. Note. Budget factor is treated like a percent applied to the overall position costs. As an alternative, use effective dating instead and add the position on the anticipated fill date. Using the same example with a 1.00 budget factor and an effective date starting after the third month, the budget expense is the same for the position. Using an effective date, the expense is recognized in the last 9 months; using the budget factor spreads the expense across all 12 months. |
|
Using HR Position Numbers (using human resource position numbers) |
Select if the customer populated the POSITION_DATA table either from PeopleSoft Position Management or a third-party system. Enabling this flag is an indication that you use position numbers in conjunction with employee records in your source system in human resources.
Note. Using position numbers (or PeopleSoft Position Management) is optional. The flag used in conjunction with “Use Position Delete Rules” will prevent your end users from deleting position numbers that still exist in the POSITION_DATA table. |
Use Position Delete Rules |
Select to enable the user to delete positions. From the Position Overview page in the activity, the user can select Delete a Position. The Delete a Position drop-down list item is available only if you select Use Position Delete Rules for this business unit. |
Benefit Group ID |
Select a benefit group ID for each unique currency code required for position budgeting within the planning model for a business unit. Valid benefit groups include those that you define using the Benefit Group page. The system uses the benefit plan defaults that you define to calculate budget amounts for newly added or unfilled positions if there is no benefit data associated with them. Optionally, you can have the benefit plan defaults inserted for existing employee data when this information is not sourced from your human resource system. Define default benefit plan types as part of the job code definition or you can use this page for a more global default. End users may override the benefit plan defaults, when allowed, at the position level. |
Earnings Group ID |
Select an earnings group ID for each unique currency code required for position budgeting within the planning model for a business unit. Valid earnings groups include those that you define using the Earnings Group page. The system uses the earnings type defaults that you define to calculate budget amounts for newly added or unfilled positions if there are no earnings codes associated with them. Optionally, you can have the earnings type defaults inserted for existing employee data when this information is not sourced from your human resource system. Define default earnings as part of the job code definition or you can use this page for a more global default. End users may override the earnings code defaults, when allowed, at the position level. |
Tax Group ID |
Select a tax group ID for each unique currency code required for position budgeting within the planning model for a business unit. Valid tax groups include those that you define using the Employer Tax Group page. The system uses the tax defaults that you define to calculate budget amounts for newly added or unfilled positions if there are no taxes associated with them. You can also assign employer tax information to existing employee job data. Define default taxes as part of the job code definition or you can use this page for more global default. End users may override the tax defaults, when allowed, at the position level. See Defining Employer-Paid Tax Defaults. Note. Calculated tax information is not sourced from the PeopleSoft Human Resource Management System; therefore, you can choose to apply employer paid tax defaults to both unfilled position defaults and existing employee job data. |
|
Click to access the Benefit Group, Earnings Group, or Employer Tax Group pages. |
Budget coordinators can use inquiry pages to verify that human resource data (such as job codes and benefit plan types) needed for position budgeting setup and user defaults exist in the PeopleSoft Enterprise Performance Management database. If the information does not exist, import it from your human resource database.
This section discusses how to review human resource default data.
Page Name |
Object Name |
Navigation |
Usage |
BP_JOBCODES |
Planning and Budgeting, Planning and Budgeting Setup, Human Resource Default Inquiry, Job Codes, Job Code |
Inquire about existing job codes and defaults imported from your human resource system and assigned by the coordinator. |
|
BP_PLAN_TYPE |
Planning and Budgeting, Planning and Budgeting Setup, Human Resource Default Inquiry, Benefit Plan Type, Benefit Plan Type |
Inquire about existing benefit plan types from the human resource system. The system stores benefits as translate values. |
|
BP_EARNING_TBL |
Planning and Budgeting, Planning and Budgeting Setup, Human Resource Default Inquiry, Earning Codes, Earning Codes |
Inquire about existing earning codes imported from your human resource system. |
|
BP_TAX_CLASS |
Planning and Budgeting, Planning and Budgeting Setup, Human Resource Default Inquiry, Tax Class, Tax Defaults |
Inquire about existing tax codes from the human resource system. The system stores tax codes as translate values. |
|
BP_UNION_CD |
Planning and Budgeting, Planning and Budgeting Setup, Human Resource Default Inquiry, Union Codes, Union Code |
Inquire about existing union codes imported from your human resource system. |
|
BP_ACTION_REASON |
Planning and Budgeting, Planning and Budgeting Setup, Human Resource Default Inquiry, Action Reason, Action Reason |
Inquire about existing codes imported from your human resource system used to track actions performed on position budgets. |
Access any human resource default inquiry page.
All of the pages are view-only and display similar information.
Note. Because you can define job code defaults for position budgeting at business unit and setID levels, all defaults may not be visible.