This page (revision-5) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 3 KB JMyers to previous
4 26-Nov-2021 10:22 3 KB JMyers to previous | to last
3 26-Nov-2021 10:22 3 KB JMyers to previous | to last
2 26-Nov-2021 10:22 4 KB JMyers to previous | to last
1 26-Nov-2021 10:22 4 KB JMyers to last

Page References

Incoming links Outgoing links
IFAS
IFAS

Version management

Difference between version and

At line 1 changed one line
!!!DEFINE ASSUMPTION STATEMENTS
!!!Define Assumption Statements
At line 5 changed one line
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].
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.
You may access this feature through the Screens/Forms menu:
Forecasting and Costing > Define Assumption Statements
At line 7 changed 21 lines
The definition data for the Assumption Statements screen is maintained on the [P2K_FC_ASSUMPTION_STATEMENTS] table.
;[Seq #|ASSUMPTION_SEQUENCE]:The field will indicate the sequential order of the assumption statement.
;[Assumption Type|ASSUMPTION_TYPE]:This field will display the type of assumption being defined.
;[Status|STATEMENT_STATUS]:This field will display the status of the statement.
;[Group|STATEMENT_GROUP]:This field will display the name of the group associated with this assumption
;[Statement|STATEMENT_CODE]:This field holds the user-defined name for the statement assumption being created.
;[Start Date|START_DATE]:This field holds the date the assumption is to begin.
;[End Date|END_DATE]:This field holds the date the assumption is to end.
;[Description|DESCRIPTION]:This field provides a short description of how the assumption will operate.
;:e.g. add 2% raise to union members
;[Assumption Action|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|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
%%warning Ensure you place spaces before and after the ‘=’ in the formula line.%%
;[Assumption Where|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’\\
%%information 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
‘’ Field Descriptions
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_Sequence is a mandatory 5-character numeric field you must enter manually.
Assumption Type
This field will display the type of assumption being defined.
Assumption_Type is a mandatory field you must fill using the fixed lexicon X_ASSUMPTION_TYPE.
Status
This field will display the status of the assumption.
Assumption_Status is a mandatory field you must fill using the fixed lexicon X_ASSUMPTION_STATUS.
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.
Statement_Code is a manual 16-character alphanumeric field you may fill manually.
Start Date
This field holds the date the assumption is to begin.
Start_Date is a mandatory field you may fill manually or using the calendar icon provided (F9).
End Date
This field holds the date the assumption is to end.
End_Date is a mandatory field you may fill manually or using the calendar icon provided (F9).
Description
This field provides a short description of how the assumption will operate.
e.g. add 2% raise to union members
Description is a 50-character alphanumeric field you may manually enter.
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)
Add Update
Assumption_Action is a mandatory field you must fill using the fixed lexicon X_ASSUMPTION_ACTION.
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_Formula is an optional 2000-character alphanumeric field you may fill manually. The information for this field will automatically fill, however, you may edit it.
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’
Assumption_Where is an optional 2000-character alphanumeric field you may fill manually. The information for this field will automatically fill, however, you may edit it.
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
At line 29 changed 3 lines
#Create an assumption in IFBA
#Click on ‘Add New Assumption Statement’ button.
#Fill in statement information.
Create an assumption in IFBA
Click on ‘Add New Assumption Statement’ button.
Fill in statement information.
At line 33 changed 4 lines
;[Statement|STATEMENT_CODE]:This field holds the name of the assumption statement.
;[Status|STATEMENT_STATUS]:This field will display the status of the assumption statement.
;[Group|STATEMENT_GROUP]:This field indicates the group the statement is associated with.
Statement
This field holds the name of the assumption statement.
Statement_Code is a mandatory 16-character alphanumeric field you must manually enter.
Status
This field will display the status of the assumption statement.
Statement_Status is a mandatory field you may fill using the fixed lexicon X_Statement_Status.
Group
This field indicates the group the statement is associated with.
Statement_Group is a mandatory field you may fill using the fixed lexicon X_Statement_Group.
At line 40 removed 5 lines
----
![Notes|Edit:Internal.IFAS]
[{InsertPage page='Internal.IFAS' default='Click to create a new notes page'}]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by JMyersTop