Defining the Planning Model

This section provides overviews of how to set up the planning model and activity scenario combinations and discusses how to:

Define planning model defaults.
Copy existing planning models.
Manage activities and scenarios in the planning model.
Send email to users.
Define dimension levels for planning centers and prepare activities and scenarios.
Define data sources for asset activities.
Define data sources for line item activities.
Assign planning target scenarios and controls.
Associate spread types with line item activities.
Define data sources for position activities.
Associate spread types with position activities.
Assign planning method defaults to line item activities.
Define views.
Specify user view details.
Specify row display filters.
Specify row display options.
Specify column display options.
Assign email templates.
Define currency options.

Pages Used to Define the Planning Model

Page Name	Definition Name	Navigation	Usage
Model	BP_MODEL	select Planning and Budgeting, then select Planning and Budgeting Setup, then select Setup Model, then select Planning Models	Create a planning model and assign the related default parameters.
Copy Model	BP_MODEL_COPY	Click the Copy Model button on the Model page.	Copy an existing planning model to use as a starting point for a new planning model.
Activity Group	BP_ACTIVITY_GRP	Click the link next to the Activity Group drop-down list box on the Model page. Click the Create Activity Group button on the Model page. Click the link next to the Activity Group field on the Activity Scenario page.	Edit or create an activity group.
Scenario Group	BP_SCENARIO_GRP	Click the link next to the Scenario Group drop-down list box on the Model page. Click the Create Scenario Group button on the Model page. Click the link next to the Scenario Group field on the Activity Scenario page.	Edit or create a scenario group.
Activity Scenario	BP_ACTV_SCEN	select Planning and Budgeting, then select Planning and Budgeting Setup, then select Planning and Budgeting Setup, then select Setup Model, then select Planning Models, then select Activity Scenario	Set up and manage activities and scenarios in the planning model.
Scenario Manager	BP_SCENARIO_MGR	Click the View Scenario Manager link on the Activity Scenario page.	Manage and update status for activities and scenarios in a planning model.
Compose Mail	BP_EMAIL	Click the Email link on the Activity Scenario page.	Send email to users about budgets and plans.
Dimension Level Summarization	BP_ACT_SCN_LVL	Click the Dimension Level link on the Activity Scenario page.	Define dimension levels, including the planning center dimension, in which an activity scenario is prepared.
Display and Select TreeNodes	PSTREEVIEWER	Click the Tree View icon on the Dimension Level Summarization page.	Select a tree node to define the level of preparation, summarization, or both for the dimension.
Data Source	BP_DATSRC_ASSET	Click the Data Source link (associated with an asset activity) on the Activity Scenario page.	Define data sources for asset activities.
Data Source	BP_SOURCE_SCEN	Click the Data Source link (associated with a line item activity) on the Activity Scenario page.	Define data sources for line item activities.
Spread Definition	BP_ACTVSCN_SPRD	Click the Select Spreads link on the Data Source page (associated with a line item activity). Click the Select Spreads link on the Data Source page (associated with a position budgeting activity).	Enter spread IDs for a line item activity when AMTPER Method ID is used. Enter defaults and available spread IDs for a position activity.
Planning Target Control	BP_TGT_CONTROL	Click the View Target Control link on the Data Source page (associated with a line item activity).	Review target control definitions.
Planning Targets	BP_TGT_SUMMARY	Click the View Targets link on the Data Source page (associated with a line item activity).	Define planning target details for the activity scenario in the planning model.
Data Source	BP_POS_SRC_SCEN	Click the Data Source link (associated with a position activity) on the Activity Scenario page.	Define data sources for position activities.
Planning Method Group	BP_MTHD_GROUP	Click the link in the Method Group column on the Line Item Defaults tab on the Activity Scenario page.	Review the planning method group defaults.
Assign Planning Method Defaults	BP_MTH_GRP_DFLT	Click the Method Defaults link on the Line Item Defaults tab on the Activity Scenario page.	Assign method defaults by account to line item activities.
Override Controls Help	BP_MTH_DFLT_OVRIDE	Click the Override Controls Help link on the Assign Planning Method Defaults page.	Review how to override controls.
Define View	BP_DEFINE_VIEW	Click the Define View link on the Line Item Defaults tab on the Activity Scenario page.	Create or edit a public view definition to determine how users view data in line item activities. Enter a view name and description.
User View Details	BP_USRVIEW_DEFN1	Click the Edit or Create link on the Define View page.	Enter a description to identify the public view details.
Row Display Filter	BP_USRVIEW_DEFN2	Click the Edit or Create link on the Define View page, and then select the Row Display Filter tab.	Define dimension defaults that appear in a line item activity.
Row Display Options (help page)	BP_USRVIEW_TEXT	Click the Row Display Help link on the Row Display Filter page. Click the Row Display Help link on the Row Display Options page.	View help documentation for row display view definition options.
Row Display Options	BP_USRVIEW_DEFN3	Click the Edit or Create link on the Define View page, and then select the Row Display Options tab.	Define whether dimension values appear in line item activities at the detail or summary level. Define amount types and currency display options.
Column Display Options	BP_USRVIEW_DEFN4	Click the Edit or Create link on the Define View page, and then select the Column Display Options tab.	Define the type of data that appears in line item activity columns.
Column Display Options (help page)	BP_USRVIEW_TEXT2	Click the Column Display Help link on the Column Display Options page.	View help documentation for column display view definition options.
Assign Email Templates	BP_MDL_TMPL_DEFN	Click Email Templates on the Security and Email tab on the Activity Scenario page.	Assign email templates for specific actions for the line item activity scenario.
Currency Options	BP_MODEL_CURR	select Planning and Budgeting Setup, then select Setup Model, then select Planning Models, then select Currency Options	For a multicurrency model, select entry and target currency codes used in the planning model.
Notes	BP_MODEL_NOTES	select Planning and Budgeting, then select Planning and Budgeting Setup, then select Setup Model, then select Planning Models, then select Notes	Enter notes for the planning model.

Understanding How to Set Up the Planning Model

Define the framework for the budget by performing the following tasks:

Define the planning model.
Assign an activity group to the planning model.
Assign a scenario group to the planning model.
Activity scenario combinations are created based on the groups associated with the planning model.

For these combinations define:

- Dimension levels or summarization for planning center and other dimensions.

- Data sources for activities.

- Comparison scenarios and target scenarios for line item activities.

- Default values for line-item activity types, including account category, enforce budget and zero base budget options, method defaults, and public views.
Assign a security group and (optionally) a secondary security group to each activity scenario.
Assign email templates.
Define currency options for a multiple currency planning model.
Enter any notes about the planning model.

Understanding Activity Scenario Combinations

You can use activity scenarios to organize the timing of different plans or budgets at similar or varying times throughout your organization's budget cycle. Each activity scenario combination is like its own independent data repository. Activity scenario combinations are automatically created in your planning model when you choose an activity group and scenario group definition in your model. You can leverage some of the same setup data defined by the model, with the scenario's main attribute using the time-related data and the main attribute of the activity using the dimension-related data. The intersection of the two (activity scenario) provides multiple plans and budgets that can be related or independent. The unique activity scenario combinations control the information that you can view and modify under the umbrella of a planning model, which is defined for a business unit. You can have one or many activity scenario combinations within each planning model that you create. Each activity scenario that you define can be staged, released to end users, or placed on hold at any time you define.

Note: When using a Commitment Control planning model, ensure that the activity group you assign contains no activities allowing balance sheet planning, because it is not supported by Commitment Control.

For example, detailed revenue and expense budgets are prepared at the greatest level of detail, and the data is sent back to the general ledger system for storing and tracking. Prior to the commencement of the following year's budget, a higher-level strategic plan may be developed first, covering anywhere from one to five years. As a business process, this information is prepared and reviewed prior to creating a more detailed budget for the following year. In the following example, the first two columns indicate the activity scenario combinations. It includes three line item activities and two scenarios. Because the Strategic Two-Year Plan is associated with a different scenario (2007–2008 Plan), it may use a different element of time, such as an annual calendar. This strategic plan is prepared well before any detail plans are created, having a start date and end date of April 1 and April 30, respectively, for preparation. It is completed before the revenue and expense detail plans are prepared. Using the start and end dates with the activity scenario enables you to open up preparation of the data based on your organization's requirement for the information, or the phase or stage of the budgeting cycle that you are in. You can overlap or stagger the preparation of activity scenarios. No restrictions are placed on the start and end dates. The 2007 Budget Scenario has the two activities, revenue and expense. The start and end dates of budget preparation of these two activity scenarios are not the same, but are overlapping.

Line Item Activity	Scenario (Calendar Years)	Start Date	End Date
Strategic Two-Year Plan	2007–2008 Plan	April 1, 2006	April 30, 2006
Projected Revenue	2007 Budget	July 1, 2006	August 31, 2006
Expense Budget	2007 Budget	August 1, 2006	September 30, 2006

Line Item Activity

Scenario

(Calendar Years)

Start Date

End Date

Strategic Two-Year Plan

2007–2008 Plan

April 1, 2006

April 30, 2006

Projected Revenue

2007 Budget

July 1, 2006

August 31, 2006

Expense Budget

2007 Budget

August 1, 2006

September 30, 2006

Use the Activity-Scenario page in your planning model to define rules and indicate the start and end dates for preparation of the activity scenarios by users.

See Understanding Planning and Budgeting Parameters.

Model Page

Use the Model page (BP_MODEL) to create a planning model and assign the related default parameters.

Navigation

select Planning and Budgeting, then select Planning and Budgeting Setup, then select Setup Model, then select Planning Models

Image: Model page

This example illustrates the fields and controls on the Model page. You can find definitions for the fields and controls later on this page.

Copy Model

Click to copy the model to a new planning model or business unit

Status

Select the desired status. Values are Active (default) and Inactive.

Note: You can change the status to Inactive only if no activity scenario in the model has a status of Released.

Activity Group

Select the desired activity group.

Click the link next to the drop-down list box to access the Activity Group page and edit or view the selected activity group.

See Establishing Activities and Activity Groups.

Note: This drop-down list box is unavailable when at least one of the activities or scenarios is staged.

Scenario Group

Select the desired scenario group.

Click the link next to the drop-down list box to access the Scenario Group page and edit or view the selected scenario group.

See Setting Up Scenarios and Scenario Groups.

Note: This drop-down list box is unavailable when at least one of the activities or scenarios is staged.

Create Activity Group

Click to create a new activity group.

See Establishing Activities and Activity Groups.

Create Scenario Group

Click to create a new scenario group.

See Setting Up Scenarios and Scenario Groups.

Multi-Currency

Select to enable setup of currency options for the model, which displays the Currency Options tab. Whether or not you select this option, the business unit base currency is the default currency for the model.

Note: If you clear the Multi-Currency check box, the system removes any definition that you create using the Currency Options page.

Copy Model Page

Use the Copy Model page (BP_MODEL_COPY) to copy an existing planning model to use as a starting point for a new planning model.

Navigation

Click the Copy Model button on the Model page.

Copy an existing planning model to use as a starting point for a new planning model, open the new planning model, and then modify the parameters for the new model as needed.

Business Unit and Planning Model ID

Enter a business unit and planning model ID to create the new target model that you want to create.

When creating a new model for a different business unit, you may want to use one that shares the same setID defaults. Otherwise, the new business unit model may require changes before it will pass model validation or run data staging.

Managing Activities and Scenarios in the Planning Model

Use the Activity Scenario page (BP_ACTV_SCEN) to set up and manage activities and scenarios in the planning model.

Navigation

select Planning and Budgeting, then select Planning and Budgeting Setup, then select Planning and Budgeting Setup, then select Setup Model, then select Planning Models, then select Activity Scenario

Image: Activity Scenario page

This example illustrates the fields and controls on the Activity Scenario page. You can find definitions for the fields and controls later on this page.

Show

Select which activity scenario combinations you want to display. Values are:

All Activity Scenario: Displays all valid activity and scenario combinations for the planning model.

Selected Activity Scenario: Displays only the selected activity scenario combinations.

Edit/View Activity Group

Click to access the Activity Group page and edit or view the selected activity group.

Edit/View Scenario Group

Click to access the Scenario Group page and edit or view the selected scenario group.

View Scenario Manager

Click to access the Scenario Manager page and manage, update, change status, or review process results of the activity scenarios defined.

Click to access the Compose Mail page and send emails to planning and budgeting users.

See Compose Mail Page.

Details

Access the Details tab of the Activity Scenario page.

Image: Activity Scenario page: Details tab

This example illustrates the fields and controls on the Activity Scenario page: Details tab. You can find definitions for the fields and controls later on this page.

Based on the selected activity group and scenario group, the following table depicts all the permitted combinations of activity scenarios. The combinations allowed are driven by the budgeting type of the scenario group, each of the scenario types in the group, and the activity types allowed with each:

		Scenario Type
Budgeting Type	Activity Type	History	Bottom Up	Forecast	Top Down
Standard Budget Ledger	Line Item	X	X	X	X
	Position		X
	Assets		X
Controlled Budget Ledger	Line Item	X	X	X	X
	Position		X
	Assets		X
Project Budget Ledger	Line Item	X	X	X	X
	Position
	Assets

Select

Select to include and display the links on the associated row so that you can set up the activity scenario.

Activity

Displays the short description of the activity that you can click to access the Activity page and review the activity's definition.

See Establishing Activities and Activity Groups.

Scenario

Displays the short description of the scenario that you can click to access the Scenario page and review the scenario's definition.

See Setting Up Scenarios and Scenario Groups.

Dimension Level

Click to access the Dimension Level Summarization page and define dimension levels for the planning center and other dimensions associated with a tree for the specified activity scenario to be prepared.

If you did not set up the Dimension Level Summarization page, then staging assumes the lowest level for processing.

See Dimension Level Summarization Page.

Note: This link is available when you select the activity scenario row on the Details tab.

Data Source

Click to access the Data Source page and define data sources for the activity scenario.

See Dimension Level Summarization Page.

Note: This link is available when you select the activity scenario row on the Details tab.

Start Date and End Date

Enter the date range within which your users will access the activity scenario for preparation, submission, or approval.

If the current date is outside of the start and end date range, the activity scenario is unavailable to the end users.

You can change the dates as necessary, because model processes are not associated with them.

Activity Scenario Status

Displays the status of the activity scenario.

Values are:

Initiated: Appears when you select the row's Select check box, but have not yet processed or staged the activity scenario. End users cannot see their planning centers on the My Planning Workspace page while an activity scenario is initiated.

Staged: Appears automatically when the activity scenario has been successfully staged. End users cannot see their planning centers on the My Planning Workspace page while an activity scenario is staged.

Released: Appears when you change the status to Released on the Scenario Manager page. End users can see and work with their planning centers on the My Planning Workspace page.

On Hold: Appears when you change the status to On Hold on the Scenario Manager page. End users cannot see their planning centers on the My Planning Workspace page while an activity scenario is on hold.

View Only: Appears when you change the status to View Only on the Scenario Manager page. End users cannot edit the planning center data when it is in View Only status.

Note: The status can be changed manually on the Scenario Manager page, or automatically when the complete data staging process is run (the process sets an Initiated activity scenario to Staged).

Line Item Defaults

Access the Line Item Defaults tab of the Activity Scenario page.

Image: Activity Scenario page: Line Item Defaults tab

This example illustrates the fields and controls on the Activity Scenario page: Line Item Defaults tab. You can find definitions for the fields and controls later on this page.

Account Category

(Optional) Enter the desired account category default for a line item activity.

After you stage the activity scenario, end users can use the account category as a way to filter on data within their line item grid as a view option or for reporting.

Enforce Budget

Select to have the staging process validate dimension (ChartField) combinations or controlled budget rules for line-item activity scenarios. Any combination rows marked in error are indicated with the error icon in the line item activity grid. End users are responsible for correcting the invalid combination or deleting the row before submitting their plan or budget. Any new rows added during the preparation of the line item activity need to be valid to be saved.

When the check box is not selected, the system does not enforce dimension combinations or controlled budget rules.

You can disable the option after a stage, which enables users to submit budgets with invalid rows.

Note: Enforce budget applies only to line item activity types. If invalid rows are created in child activities such as assets and positions, users will need to modify the dimension combinations in the child to update the parent line item with the correct and valid combinations.

See Understanding the Combination Data Validation Process.

Zero Base Budget

Select to enable preparers to develop budgets without a base amount as a starting point.

The system distributes to preparers a line-item activity scenario that contains all the rows from the base budget (data source) selected, except that all the budget amounts are zero.

Note: After you stage the data, this check box is unavailable.

Method Group

Click to access the Planning Method Group page and view the method and driver defaults in the group.

See Defining the Planning Model.

Method Defaults

Click to access the Assign Planning Method Defaults page and assign planning method defaults to line item activities by account, or account and an optional dimension.

See Assign Planning Method Defaults Page.

Define View

Click to access the Define View page and define the public view for line item activities.

See Define View Page.

Security and Email

Access the Security and Email tab of the Activity Scenario page.

Image: Activity Scenario page: Security and Email tab

This example illustrates the fields and controls on the Activity Scenario page: Security and Email tab. You can find definitions for the fields and controls later on this page.

Security Group

Enter the desired security group. This field is available when you select the Select check box in the applicable activity scenario row.

Note: This field is disabled when the activity scenario has been staged.

You can update or add planning and budgeting users within the security group after stage, without running any further processes.

Description

Click to access the Security Group page and display details about the associated security group.

Create Security Group

Click to access the Security Group page and create a new security group.

Use EW Security

This check box is available only for line item activities that are associated with a secondary security dimension. Select to use the EW (EPM Warehouse) security definition, based on the secondary security dimension that is specified for the activity on the Activity page. If this option is selected, you cannot select a secondary security group from the drop-down list box, because the system uses a predefined secondary security group name based on the EW security definition.

If you do not select this check box, then you can select a secondary security group from a list defined in Planning and Budgeting, based on the secondary security dimension that was specified for the activity on the Activity page. You can also create a secondary security group by clicking Create in the Secondary Security Group column.

Secondary Security Group

This field is active only for line item activities that are associated with a secondary security dimension. Select the desired secondary security group from the drop-down list box.

Note: When you are associating an activity scenario with the secondary security group, the dimension level (Dimension Level Summarization page) must be the same as the selected secondary security group tree level.

Create Secondary Security Group

Click to access the Secondary Security Group page and create a new secondary security group in Planning and Budgeting.

The following rules apply when you are associating a secondary security group with an activity scenario:

The dimension on which the secondary security group is based must be the same as the secondary security dimension specified for the activity.
The secondary security group must be effective as of the as of date of the activity group.
If you use trees for the dimension both in the secondary security group definition and the activity group hierarchies, then they must be the same and the dimension levels must be the same as well. This is to ensure that the dimension is secured at the same level as the level at which it is budgeted.

Note: If you are unable to access any line item rows that you were intended to access, check whether the preceding rule was violated.

Email Templates

Click to access the Assign Email Templates page and assign email templates to the associated activity scenario for line item types.

See Using Planning and Budgeting Email Templates.

Compose Mail Page

Use the Compose Mail page (BP_EMAIL) to send email to users about budgets and plans.

Navigation

Click the Email link on the Activity Scenario page.

Image: Compose Mail page (displaying the User Planning Centers group box)

This example illustrates the fields and controls on the Compose Mail page (displaying the User Planning Centers group box). You can find definitions for the fields and controls later on this page.

Users designated as Planning and Budgeting users who have email addresses appear on this page. Enter email subject and text information in the Email Details section.

Subject and Email Text

Enter the desired subject and main text of your email.

Send Email

Click to send the email to the selected recipients.

Select All

Click to specify that all displayed recipients should receive the email.

Select

Select to specify that the associated recipient should receive the email.

User Details (button)

Click to display the associated recipient's Role Name, Business Unit, and Planning Center.

Dimension Level Summarization Page

Use the Dimension Level Summarization page (BP_ACT_SCN_LVL) to define dimension levels, including the planning center dimension, in which an activity scenario is prepared.

Navigation

Click the Dimension Level link on the Activity Scenario page.

Image: Dimension Level Summarization page

This example illustrates the fields and controls on the Dimension Level Summarization page. You can find definitions for the fields and controls later on this page.

The system displays all dimensions selected for the activity as well as the trees defined on the Activity Group Hierarchy page.

Dimension

Displays a dimension field ID (ChartField) located in the source tables.

Displays the dimension ID values that were selected for the specified activity. Only dimensions defined as active on the Dimension Configuration page in Planning and Budgeting could have been selected for the activity.

Tree Name

Displays the name of the tree with which the dimension is associated on the Hierarchies tab of the activity group page.

No Summarization

Select to have the system avoid summarizing any table row that contains source data for the associated dimension during the data staging process. This will be the level at which the activity will be prepared by end users.

Note: Optionally, you can use the Dimension Member Mapping page on the Hierarchies tab of the Activity Group page to define any special mapping rules or summarization of specific dimension members that you want included in the planning model.

Summarize Data to Level

Enter the level in the tree to which you want the system to summarize the source data during the staging process. This will be the level at which the activity will be prepared by end users. This option is available only when a tree is associated with the dimension.

Note: Any dimension not used in the activity, but with corresponding data for the dimension not included in the source table, will be aggregated and becomes a blank value. You cannot budget against this dimension in the activity.

View Tree (icon)

Click to access the Display and Select Tree Nodes page and select a tree node to assign that node's level as the summarization level, which also enters the selected value into the Summarize Data to Level field.

Note: Any activities associated with the planning model require dimensions for account and the planning center dimension.

If you have staged the activity scenario, you should not change the fields on this page.

Data Source Page

Use the Data Source page (BP_DATSRC_ASSET) to define data sources for asset activities.

Navigation

Click the Data Source link (associated with an asset activity) on the Activity Scenario page.

Image: Data Source page

This example illustrates the fields and controls on the Data Source page. You can find definitions for the fields and controls later on this page.

The Data Source page for asset-related defaults is available only when you have defined an asset activity type that is used in conjunction with a bottom-up scenario type.

Use Source Data

Select to stage data from your source asset management system when you integrate data for assets and depreciation.

When the check box is selected, data is located in the source tables BD_ASSET and BD_ASSET_DEPR, and the stage process will retrieve any related data. You do not need to select the check box when you do not bring data from your source system for assets and depreciation.

Asset Book Name

Enter the book name for the asset information that you want to retrieve for the business unit.

Default Depreciation Account

Enter to populate the default depreciation account for assets that do not have matching depreciation rows. The valid depreciation accounts are taken from those defined using the Depreciation Accounts page.

Data Source Page

Use the Data Source page (BP_SOURCE_SCEN) to define data sources for line item activities.

Navigation

Click the Data Source link (associated with a line item activity) on the Activity Scenario page.

Image: Data Source page for line items

This example illustrates the fields and controls on the Data Source page for line items. You can find definitions for the fields and controls later on this page.

Select Spreads

Click to access the Spread Definition page and enter a spread ID for an activity.

See Spread Definition Page.

Source

Use Multiple Data Sources

Select to choose more than one source scenario to seed or create the base budget for the line item activity.

Note: You can use multiple data sources for all planning scenario types.

Source Scenario

This is a scenario (or multiple scenarios when you select Use Multiple Data Sources) that you select that was defined within your scenario group, and serves as your seed data or budget base during the stage process. This data source scenario is the starting point for your proposed budget and plan development process.

Note: You will define a source scenario even when using zero base budgets so that the stage process can establish dimension combination rows as a starting point for entering amounts and data into the line item activity.

Start Fiscal Year, Start Period, End Fiscal Year, and End Period

If you select Use Multiple Data Sources for a standard or project budgeting type, you must enter your from/to year and period range for each source scenario that you pick. From/to ranges should not overlap.

Start Budget Period and End Budget Period

If you select Use Multiple Data Sources for a control budgeting type, you must enter your from/to year and period range for each source scenario that you pick. From/to ranges should not overlap.

Incremental % (incremental percentage)

Specify an incremental increase or decrease to be applied using a percentage that is applied globally to the source scenario data that creates or seeds your budget base. The calculated result is what is distributed in the base budget to end users. If you leave the Incremental % field blank, the system treats it as a zero percent increase or decrease factor, so the plan or budget base remains unchanged from the source scenario that you select. When using multiple source scenarios, you can apply an incremental increase or decrease for each source that you select.

1st Period to Update

Enter the first period to update when defining the source for a scenario defined as a forecast scenario type. You enter a budget period within the defined scenario specifying the period in which you want update to begin for users. Any period prior to this period will not allow update in the scenario for the related activity.

1st Fiscal Year to Update

When you define a source for a forecast scenario type, you must indicate to which year the first period to update applies. If you are using a single year plan or budget, only one year will be available. For multiyear budgets, more than one option may be available.

Comparison Scenarios

Comparison Scenario

Select scenarios from the scenario group that you want to use in conjunction with the specified line item scenario. These are scenarios that are used as a source for methods, comparison in line item, additional seed, inquiry, and reporting. These scenarios will be ones that end users can access and use when working with their proposed plan or budget, such as using them in conjunction with method bases, comparison during analysis, and reporting. For staging, the source scenarios can be used as additional budget base source.

Description

Click to access the Scenario page and review the scenario definition.

Analysis Base

Select the desired analysis base.

You can select from one that you may have defined earlier, or one of the predefined values of Current Year Budget, Current Year Forecast, Prior Year Actuals, or Year To Date Actuals.

See Understanding Planning and Budgeting Parameters.

Use as Additional Source

Select to use the selected comparison scenario to generate historical row combinations for your proposed plan or budget. The data staging process recognizes this flag. If this option is selected, then during the data staging process any rows in this scenario that do not exist in the source scenario will be created for every missing dimension combination, creating a zero-amount base budget row.

Note: When using comparison scenarios (for example, to compare history to budget for reporting), you cannot view related history when no row exists in the activity scenario for which you are preparing plans or budgets.

Target Scenario

(Optional) Select a target scenario. Only top-down scenario types can be selected here.

If you select a target scenario, you must select a target control group.

Click the adjacent link to access the Scenario page and view the scenario definition.

Target Control

Select a target control group for the planning target scenario, which assigns submission controls by user role.

Available values include data that you enter using the Planning Target Control page.

View Target Control

Click to access the Planning Target Control page and review the associated target control definition.

View Targets

Click to access the Planning Targets page and specify dimensions to include for validating planning targets, or to allow users to override when submitting their budgets.

Planning Targets Page

Use the Planning Targets page (BP_TGT_SUMMARY) to define planning target details for the activity scenario in the planning model.

Navigation

Click the View Targets link on the Data Source page (associated with a line item activity).

Image: Planning Targets page

This example illustrates the fields and controls on the Planning Targets page. You can find definitions for the fields and controls later on this page.

Account

The system automatically selects this dimension and validates the account node at the planning center level.

Note: Account is a required dimension with planning targets.

The system automatically selects the dimension that you use to define the planning center.

Because the dimension that you use as your planning center is required, the displayed dimension may be different. For example, if Department is your planning center, the system validates planning targets for the detail or roll-up Department dimension and the account roll-up. Dimensions available as the planning center depend on your source financial system and can include Department, Fund, Operating Unit, Product, Program, Class, Project, ChartField 1, ChartField 2, and ChartField 3.

Note: You can select one additional dimension (other than fiscal year) to validate at the planning center level. If you select an additional dimension, the system validates planning targets for this dimension at the defined account roll-up, planning center level, and the other dimension level.

Fiscal Year

Select to indicate that targets are validated by each year (if you defined a multiyear budget or forecast).

If you do not select this check box, the system uses the sum of all years as the planning target.

View Target Details

Click to view target values for all valid rows associated with the line-item activity scenario.

The system displays the complete planning center tree and the parent and child relationship. It displays detail only for actual rows in the planning target ledger and for the summary levels displayed at the rollup for a total of the planning target amounts.

Select (allow target override)

Select to enable users to submit their budgets when the activity scenario falls outside the defined planning target tolerance range.

Spread Definition Page

Use the Spread Definition page (BP_ACTVSCN_SPRD) to enter spread IDs for a line item activity when AMTPER Method ID is used.

Enter defaults and available spread IDs for a position activity.

Navigation

Click the Select Spreads link on the Data Source page (associated with a line item activity).
Click the Select Spreads link on the Data Source page (associated with a position budgeting activity).

Image: Spread Definition page for line item

This example illustrates the fields and controls on the Spread Definition page for line item. You can find definitions for the fields and controls later on this page.

For the proposed line-item activity scenario, you can associate spread IDs to be used in conjunction with the amount per period (AMTPER) methods for budget preparation. When the scenario for the line item activity is a Forecast scenario type, the page is still available to allow for the AMTPER definitions.

Spread ID

Select the desired custom spread IDs that will be available to the user during the plan and budget preparation as an option for the AMTPER method.

Because the calendar ID is already defined for the spread ID using the Periods Ratio Entry page, only those spread IDs that use the same calendar ID are available.

The AMTPER does not require a default setting. The spread IDs defined and selected here for the AMTPER method are merely used as a data entry tool for this method (similar to the hot keys). The system uses this field only if it contains a value when you are using the AMTPER method, and not for any adjustment type options. No default setting exists for the AMTPER method.

Note: A spread ID for spread evenly is delivered with the system. You do not need to define a custom ID for evenly spread.

Description

Displays the description of the spread ID, as defined on the Spread ID Definition page, that you can click to access and view the spread ID page where you defined this information.

Data Source Page

Use the Data Source page (BP_POS_SRC_SCEN) to define data sources for position activities.

Navigation

Click the Data Source link (associated with a position activity) on the Activity Scenario page.

Image: Data Source page for position activity

This example illustrates the fields and controls on the Data Source page for position activity. You can find definitions for the fields and controls later on this page.

The Data Source page for position-related defaults is available only when you have defined a position activity type that is used in conjunction with a bottom-up scenario type.

Use Source Data

Select when you integrate data for position and employee jobs and want to stage the data from your source human resources system, Workforce Analytics and Workforce Rewards (WFA), or another position activity scenario. The flag enabled indicates that data is located in the source tables (BP_JOB_F00, BP_COMP_F00, and BP_POSITION_D00) and the stage process will retrieve any corresponding data. You do not need to select the check box when you do not bring data from your source system, WFA, or another activity scenario for existing position and employee job data.

Select Spreads

Click to access the Spread Definition page and define the spread of amounts across periods.

Priority and Data Source

Select from the data source drop-down list by order of priority. Available options are HRMS, WFA, and POSBUD (Planning and Budgeting).

The budget model can stage data from multiple sources for an activity scenario, and you can prioritize the list of sources that is used to populate the budget data. For each budget component (positions, jobs, salaries, earnings, benefits and taxes), the staging process queries each source in the order specified by the priority.

Budgeting/WFA Scenario

Select from the available scenarios for each of the data sources, except for an HRMS data source, which is always blank.

Position Source Scenario

For each of the Budgeting or WFA scenarios, select from one of the available scenarios (at the next level of granularity). This field is blank for an HRMS data source because data brought from that source system does not have or use scenarios.

Note: Typically, the scenario ID field is populated if you previously exported the data from another position activity scenario within the application. For example, you are preparing a second scenario for the same activity and want to modify the data stored in the first scenario to create and generate a second optional scenario. Basically, you will use this as your base budget or seed data for the second scenario.

Include Tax Calculation

Select to have the system perform tax-related calculations while loading the position data.

The process uses the tax information from the Job Codes Default page by default, or the Positions Data Defaults page by business unit.

Use Defaults for Employee Data

Select this option to also assign the same compensation defaults to populate data at the employee level.

This check box is optional. It is particularly useful when you are not using PeopleSoft Human Resources payroll or total compensation and want to prepopulate compensation components at the employee level because you did not bring the source data for earnings and benefits from the human resources system.

If you select this option, the system uses job code and position data defaults to populate missing employee compensation components. These compensation components (benefit and earning types) are populated with position defaults when no other rows are associated with the employee for that compensation type. For example, if the employee has existing benefit data, but no earnings data, only earnings data will be picked up from the position defaults for earnings when defined, and benefit data will not because something already exists. If you do not want employee data rows populated with position defaults, do not select this option.

Create New Positions

Select to have the system create positions within PeopleSoft Planning and Budgeting for employees who do not have assigned positions.

The system automatically generates a position number for the employee. If you do not select this option, only vacant positions and employees assigned a position number will be staged.

Exclude Temporary Employees

Select this check box if you want the system to include those employees who are designated as temporary on the BP_JOB_F00 table when creating positions.

Note: This check box is available when you select Create New Positions.

Include Employee Contribution

Select to include the employer-paid portion of the employee's benefit retirement contribution.

Spread Definition Page

Use the Spread Definition page (BP_ACTVSCN_SPRD) to enter defaults and available spread IDs for a position activity

Navigation

Click the Select Spreads link on the Data Source page (associated with a position budgeting activity).

Image: Spread Definition page for position activity

This example illustrates the fields and controls on the Spread Definition page for position activity. You can find definitions for the fields and controls later on this page.

For the proposed position activity scenario, you can associate spread IDs to be used in conjunction with the position budgeting (POSBUD) method for budget preparation.

The Position Budgeting Spread group box sets the global default for all positions in the activity scenario. This group box is available when:

A position activity is associated with a bottom-up scenario type.

Note: The position activity is not supported with forecast or top-down scenario types.
The associated scenario is not using an annual calendar.
A standard or control budget type exists, as defined by the scenario group.

Project type budgets do not allow position budgeting.

Spread Evenly

Select to have position expenses spread evenly across budget periods as the global default during data staging and when adding new positions.

User Defined Spread ID

Select to assign your own custom spread ID as the global default during data staging and when adding new positions.

Note: A spread ID for spread evenly is delivered with the system. You do not need to define a custom ID for evenly spread.

Allow Override

Select to let the budget preparer, within position activity at the position level, define a different spread ID than that set at the global level.

The preparer can select from the additional spread IDs selected by the coordinator in the Spread ID for the Activity grid.

If you clear this check box, no user intervention is allowed and one global setting applies to the entire position activity scenario. The Spread ID for the Activity grid is unavailable.

Note: Whether you spread evenly or specify a custom spread ID, these options are unavailable after staging a model. The system uses the default spread ID to stage position data for the activity scenario; all existing positions staged use this global default. After position budgeting begins, new positions added will also use the default spread ID. The Allow Override check box is still available after you stage a model. You can select it to allow users to select different spread IDs during position budgeting.

Spread ID

Select the desired additional custom spread IDs that will be available to the user during the position budget preparation as an option for assigning to a position.

The use of a custom spread, or even spread evenly, is a default used against the annual position and employee job amounts that dictates how the data is spread across periods when inserted into a parent line-item activity.

Because the calendar ID is already defined for the spread ID (using the Periods Ratio Entry page), only those spread IDs that use the same calendar ID are available.

Note: After the position activity scenario has been staged, you will not be allowed to delete any custom spread ID rows that are defined on the page. You will be allowed to add new rows only.

Description

Displays the description of the spread ID (as defined on the Spread ID Definition page) that you can click to access the spread ID page where you defined this information.

Assign Planning Method Defaults Page

Use the Assign Planning Method Defaults page (BP_MTH_GRP_DFLT) to assign method defaults by account to line item activities.

Navigation

Click the Method Defaults link on the Line Item Defaults tab on the Activity Scenario page.

Image: Assign Planning Method Defaults page

This example illustrates the fields and controls on the Assign Planning Method Defaults page. You can find definitions for the fields and controls later on this page.

To review and edit any of the planning method group defaults that are available for the line item activity, you can click the Method Group ID link (method group ID assigned in the activity group) in the Method Group column on the Line Items Defaults tab.

The Method Defaults link on the Line Item Defaults tab is used to assign any exceptions by account in the line item activity. Without a method default for an account, the system automatically assigns the BASBUD (base budget amount) method to every line item in a base budget and allows override for each row. Use the Assign Planning Method Defaults page to define exceptions by account, including override restrictions on methods.

Dimensions

(Optional) Select an additional dimension for assigning method defaults for the line item activity. The dimensions that you can select include any dimensions that are associated with your activity.

If you select any of these values, the system makes available associated range fields in the Planning Method Defaults group box.

Note: After defining a method that uses an additional dimension, you should not change the settings.

Override Controls Help

Click to access the Override Controls Help page and review how to override controls.

Assign Methods

From Account and To Account

Enter the account range to which you assign a method and related defaults that apply.

Values for the account dimension are based on the setID used for the dimension.

From <Dimension> and To <Dimension>

Enter the additional dimension range to which your method and related defaults will apply.

Note: These columns and fields are available when you select an additional dimension.

Method ID

Select the desired method ID (defined using the Method Group ID page and selected for the line item activity).

Note: Depending upon the method ID chosen, you may need to define the following options: Flexible Formula ID, Driver ID, and Analysis Base.

Flexible Formula ID

Select the desired flexible formula ID from the valid IDs that are associated with the FLEX method ID when you select it.

Driver ID

Select the desired driver ID from the valid driver IDs that are associated with the method ID that you select (if the selected method requires a driver).

Analysis Base

Select the desired method base against which you want to apply the driver (if the selected method requires a base).

Override Controls

Select or clear the following check boxes to specify which method and related defaults (that you assign to each account row in the line item activity) the preparers can override using the data entry pages. Insert rows to identify exceptions to the base budget default method.

Override Method, Override Driver, Override Base, or Driver Parameter

Select to enable preparers to override the method, driver, base, or parameter associated with the specified account or account and additional dimension.

Adjustments

Select to enable incremental or mass adjustments for all users in the line item activity, specified account, or account and additional dimension.

If you clear this check box, users cannot perform line item adjustments or mass adjustments.

Hold

Select as a default for the specified accounts used in the line item activity during data staging that any user can change.

Assigning a Hold flag causes the mass adjustment feature to ignore the row when applied by users.

Note: If you do not change the system defaults for methods and method override controls assigned to a line item in the base budget, the system allows override of all method details.

Define View Page

Use the Define View page (BP_DEFINE_VIEW) to create or edit a public view definition to determine how users view data in line item activities.

Enter a view name and description.

Navigation

Click the Define View link on the Line Item Defaults tab on the Activity Scenario page.

Views defined here are public and available options when using a line item activity. Users can select these public views from the line item entry page while working on the activity.

View Name and Description

Enter a name for the view before clicking the Create link to define details for it.

If the view already exists, select the Edit link to update the defaults.

Casual Preparer

Select to enable users with this role to use predefined public views when preparing line item activities.

If you clear this check box, the system uses a flat view of the model when casual preparers access line items.

Default

Select to provide a default view that will be used when accessing the line item activity until changed by the end user. You can define one default for Casual Preparer role, and one default that can be used for non-Casual Preparer roles when selected.

Note: If a user view has a planning center filter on it, you cannot select the default check box. The system displays an error message if you do. You must either change the view or choose another public view as the default.

Edit

Click to access the User View Details, Row Display Filter, Row Display Options, and Column Display Options pages and further define view details.

Note: The link will say Create instead if it is a new public view. You must first enter a view name before clicking this link.

If a secondary security group is on the activity scenario, and the default user view displays a tree, then the system does not save the page and displays an error message indicating that a default user view with a tree is not allowed with a secondary security group; you cannot use a secondary security group in combination with a default user view that has a dimension level. To resolve this, you can either clear the dimension levels of the default user view, or remove the secondary security group from the activity scenario.

See User View Details Page, Row Display Filter Page, Row Display Options Page, Column Display Options Page.

User View Details Page

Use the User View Details page (BP_USRVIEW_DEFN1) to enter a description to identify the public view details.

Navigation

Click the Edit or Create link on the Define View page.

Copy

Click to duplicate an existing public view definition if you accessed this page through the line item activity and you can access private views.

Description

Enter a description for the view definition.

If you are defining the view at the coordinator level, the description for the view is supplied by default from the information that you enter using the Define View page.

Row Display Filter Page

Use the Row Display Filter page (BP_USRVIEW_DEFN2) to define dimension defaults that appear in a line item activity.

Navigation

Click the Edit or Create link on the Define View page, and then select the Row Display Filter tab.

Image: Row Display Filter page

This example illustrates the fields and controls on the Row Display Filter page. You can find definitions for the fields and controls later on this page.

Row Display Help

Click to access the Row Display Help page and review information about each page element.

Dimensions

Displays dimensions included in the line item activity.

Dimension Level

Select the order in which to display dimension data summarized, up to three dimensions in a row. Values are First, Second, and Third.

The dimension that you assign as the first dimension must use a tree that you define using the Activity Group, Hierarchy page. If you do not assign any dimension levels to the dimensions, users see only a flat view of the activity data when preparing line items.

If a secondary security group is on the activity scenario, and the default public view displays a tree, then the system does not save the page and displays an error message indicating that a default user view with a tree is not allowed with a secondary security group; you cannot use a secondary security group in combination with a default user view that has a dimension level. To resolve this, you can either clear the dimension levels of the default user view, or remove the secondary security group from the activity scenario.

Note: You cannot assign a dimension level to the statistic code or currency code dimensions.

Show Code

Select to display the value code for the dimension in line item activity.

Show Description

Select to display the description of the dimension in line item activity.

Note: For a flat view, do not select any dimension levels.

In a flat view, some rows may appear to be duplicate rows unless you define a view that includes all the dimensions. Selecting one of each of these check boxes enables the user to view a distinction between the rows. You can also use these check boxes to view dimensions to which you did not assign a dimension level. For these dimensions to appear, you must select either a code or a description for those dimensions with defined dimension levels.

Filter Dimension Members

From and To

Enter specific values or a range of values to display and work within your line-item activity view.

If you do not enter values, the system displays all valid dimension values.

Note: If end users of the default public view attempt to assign a filter to the Planning Center dimension, the system errors out.

Account Category

Select a value to view a similar group of accounts on a specified level of an account tree.

Note: You cannot use a filter for statistics code and currency code at the same time. Using this combination produces zero rows on the Line Item Details page.

Row Display Options Page

Use the Row Display Options page (BP_USRVIEW_DEFN3) to define whether dimension values appear in line item activities at the detail or summary level.

Define amount types and currency display options.

Navigation

Click the Edit or Create link on the Define View page, and then select the Row Display Options tab.

Image: Row Display Options page

This example illustrates the fields and controls on the Row Display Options page. You can find definitions for the fields and controls later on this page.

Row Summary

Select to display only the node-level summary values for the dimension that you define as the first dimension level using the Row Display Filter page.

Row Detail

Select to display editable, detailed cells for all row dimensions.

Hide Zero Total Amounts for Proposed Budget/Forecast

Select to hide rows in the line item activity total amounts that equal zero.

This selection applies only to the Line Item Details page; the analysis and reporting options do not recognize it.

Method Amount

Select to display the amount based on the method that is assigned to a line item row.

If this option is selected, users can access method details in the line item activity. For example, if you enable override capability of the BASBUD method at the coordinator level, budget users can access the method details and modify the method to AMTPER, which enables them to enter a budget value manually for the line item.

Adjustment Amount

Select to display any incremental or mass adjustment amounts associated with the line item row.

If you enable adjustments for line item activity, budget users can apply adjustments to a line item budget row.

Allocation Amount

Select to display any amount defined by the allocations activity.

Users cannot edit this value.

Total Amount

Select to display the total budget amount for a line item row, which includes the method, adjustment, and allocation amounts.

Users cannot edit this value.

Display Entry Currency

Select to display all entry currency values during line item preparation.

Display Statistic Rows

Select to have the system add the statistics code to the view definition and display statistical amounts by account during line item preparation.

Budget users cannot view both statistical accounts and target currency amounts.

Display Target Currency

Select to display one target currency or all target currencies in line item activity defined in the model.

One

Select to view a specific target currency in the line item activity defined for the model, and then use the Row Display Filter page to select the currency code that you want to view as the single target currency value for the model.

All

Select to view all target currencies in the line item defined for the model.

If you define target currency values for the view, then you cannot display statistic rows during line item preparation.

Note: If the model is not defined as a multicurrency model, the currency options are unavailable.

The system does not add statistical amounts to totals or display statistical amounts at the summary level of a node. If you select Display Entry Currency, the system does not summarize statistical amounts. To summarize statistical amounts at the node level, select a specific dimension value for statistics code.

To display:	Set these filter dimension values:	Set these currency and statistics options:
No currency 1 statistics code	Select a statistics code	Display Statistic Rows
No currency All statistics	None	Display Statistic Rows
All entry currency All statistic codes	None	Display Entry Currency Display Statistic Rows
1 entry currency No statistic codes	Select a currency code	Display Entry Currency Display Target Currency (optional)
All entry currency No statistics	None	Display Entry Currency Display Target Currency (optional)

When you use statistical accounts, if you select Display Statistic Rows, the system displays statistical accounts, but these accounts are not rolled up or summarized with currency data. If you leave the dimension value blank, when displaying currency or statistics, the system displays all values.

Use the Row Display Options page to set currency and statistics options.

Column Display Options Page

Use the Column Display Options page (BP_USRVIEW_DEFN4) to define the type of data that appears in line item activity columns.

Navigation

Click the Edit or Create link on the Define View page, and then select the Column Display Options tab.

Image: Column Display Options page

This example illustrates the fields and controls on the Column Display Options page. You can find definitions for the fields and controls later on this page.

Column Display Help

Click to access the Column Display Help page and review information about each check box.

Period Summary

Select to display only summary nodes for the period dimension, such as annual total and quarterly subtotals for a monthly budget.

To summarize the period, the system uses the time hierarchy defined and associated with the scenario group used by the planning model.

Period Detail

Select to display only detailed, editable cells for the period dimension.

Prior Year Actuals

Select to display defined actual expenditures or revenues received for the last completed year in line items.

Year to Date Actuals

Select to display defined actual expenditures or revenues received form the beginning of the year to the present in line items.

Current Year Budget

Select to display defined budget plans approved for the current year in line item budget.

Current Year Forecast

Select to display previously defined forecast projections for the current year.

Note: These four analysis bases—Prior Year Actuals, Year to Date Actuals, Current Year Budget, and Current Year Forecast—are predefined and system-delivered. Coordinators can use these as part of their models, in addition to five others they can define themselves.

History 1– 5 (optional and variable label)

The coordinator can include additional analysis bases, which when defined, are also available for selection in the user view.

Note: The system displays ledger data associated with the analysis base that you define using the Data Source page for the line-item activity scenario.

The coordinator defines analysis bases that determine historical periods included in the view. The historical information appears as annual totals in the columns.

Assign Email Templates Page

Use the Assign Email Templates page (BP_MDL_TMPL_DEFN) to assign email templates for specific actions for the line item activity scenario.

Navigation

Click Email Templates on the Security and Email tab on the Activity Scenario page.

Image: Assign Email Templates page

This example illustrates the fields and controls on the Assign Email Templates page. You can find definitions for the fields and controls later on this page.

Use Email

Select to send a predefined email when the associated action occurs.

Template ID

Select the predefined email template that you want the system to use when the associated action occurs.

You create the predefined email text using the Email Template Definitions page. Values are:

Model Stage: After the activity, scenario, and planning model is successfully staged, the system sends the specified email to all users whom you select using the Email Template Definitions page.

Budget Reject: After a budget is rejected, the system sends the specified email to those users who submitted the rejected budget and to any users whom you select using the Email Template Definitions page.

Budget Submit: After a budget is submitted, the system sends the specified email to users who are assigned at the next level of the planning center (approval hierarchy) as determined by the tree definition for the planning center and to users whom you select using the Email Template Definitions page for the template.

Planning Target: After a budget is submitted that includes data outside the planning target tolerance definitions and if the planning target is defined as passive control, the system sends the specified email to users who are assigned at the next level of the planning center hierarchy as determined by the tree definition for the planning center and to users whom you select using the Email Template Definitions page.

You use the Planning Target Tolerance and Planning Target Control pages to set up planning target definitions.

Email Templates (button)

Click to access the Email Template Definitions page that you defined when you set up planning and budgeting parameters.

Currency Options Page

Use the Currency Options page (BP_MODEL_CURR) to for a multicurrency model, select entry and target currency codes used in the planning model.

Navigation

select Planning and Budgeting Setup, then select Setup Model, then select Planning Models, then select Currency Options

Image: Currency Options page

This example illustrates the fields and controls on the Currency Options page. You can find definitions for the fields and controls later on this page.

Note: The Currency Options tab is available when you select multicurrency on the Model page.

See Understanding Multiple Currencies.

If you are working with a multicurrency planning model, the Currency Options grid displays the one or more rows that you define, and the three available check boxes, in which the base business unit currency definition is the default. After one activity scenario has been staged, you cannot delete any rows or change any check boxes.

Currency Code

Enter the desired currency code.

Create rows for each currency code used in the planning model.

Entry Currency

Select to designate the currency code to perform data entry.

You can specify an unlimited number of entry currencies.

If the transaction currency is not defined as an entry currency, the system translates it into the default currency during the data staging process. At the same time, the system maintains the original transaction currency so that you can export data to external applications with the original currency.

Entry Default

Designates the currency code as the default.

The base currency of the business unit is the default currency for the planning model.

Target Currency

Select to designate the currency code as the one into which the system translates entry currency values. This option is used for reporting and analyzing.

You can specify an unlimited number of target currencies.

Note: After you stage a model, you cannot change the values on the Currency Options page. To add or delete currencies, you cannot have a single activity or scenario staged in the planning model.