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
- 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’
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.- Create an assumption in IFBA
- Click on ‘Add New Assumption Statement’ button.
- 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.