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.

Type
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 assumption.
Group
This field will display the name of the group associated with this assumption
Statement_Group is a mandatory field you must fill using the fixed lexicon X_STATEMENT_GROUP.
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.