DEFINE ASSUMPTION STATEMENTS#

Global Assumptions will allow you to create a statement of change that will apply to a set of budget seats for a period of time.

Global assumptions operate like the assumptions tab on (IFBA), the difference however, is that global assumptions may be created in the Define Assumption Statements (IFAS) field and then applied to different budget scenarios through the ‘Statement’ field in the Assumptions tab of IFBA.

The definition data for the Assumption Statements screen is maintained on the P2K_FC_ASSUMPTION_STATEMENTS table.

Seq #

The field will indicate the sequential order of the assumption statement.

Assumption Type

This field will display the type of assumption being defined.

Status

This field will display the status of the statement.

Group

This field will display the name of the group associated with this assumption

Statement

This field holds the user-defined name for the statement assumption being created.

Start Date

This field holds the date the assumption is to begin.

End Date

This field holds the date the assumption is to end.

Description

This field provides a short description of how the assumption will operate.

e.g. add 2% raise to union members

Assumption Action

An assumption is either added to the database (a new premium or statistics) or is updating existing information (a wage increase or FTE change)

Assumption Formula

This field holds the formula for the assumption.

For example, if you requires a wage increase of 2.5%, the statement for is assumption is ‘Let the wage rate be equal the wage rate times 1.025’.
Therefore the formula for his assumption would be:
Wage_Rate = Wage_Rate * 1.025

Ensure you place spaces before and after the ‘=’ in the formula line.

Assumption Where

This field allows users to limit the formula to the statement in the ‘where’ clause.

For example, if you wishes to increase the wage rate of all in Unit of AMW by 2.5%, the statement would be, ‘Let the wage rate be equal the wage rate times 1.025 where the employee’s Unit is AMW’
Therefore, the formula for the assumption would be:
Wage_Rate = Wage_Rate * 1.025
The ‘Where’ clause would be:
Group_Code = ‘FULL-TIME’

FORMULA RULES
All CHAR or alphanumeric information must be entered with single quotes around them.
Standard formula format is A = B + C not B + C = A, as with UserCalcs.

Formula: WAGE_RATE = WAGE_RATE * 1.02

Formula:PREMIUM_CODE = 'UNIFORM'

Where:UNIT = 'alphanumeric'

Where: WAGE_RATE > 12.25

Where: VACANT not filled positions

Where:NOT VACANT only filled positions

Creating an IFAS Statement from an IFBA Assumption#

It is possible to create an assumption in the budget area and have a ‘statement’ created from it. This makes it available to all budget areas.

1. Create an assumption in IFBA
2. Click on ‘Add New Assumption Statement’ button.
3. Fill in statement information.

Statement

This field holds the name of the assumption statement.

Status

This field will display the status of the assumption statement.

Group

This field indicates the group the statement is associated with.

The assumption statement will now appear on the IFBA forms.

The new assumption statement can be accessed through the IFAS screen.

---

Notes #

Click to create a new notes page