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

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

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
26 26-Nov-2021 10:22 14 KB rforbes to previous
25 26-Nov-2021 10:22 14 KB jmyers to previous | to last WORK_RULE_CODE ==> WORK_RULE (Field)
24 26-Nov-2021 10:22 14 KB JEscott to previous | to last
23 26-Nov-2021 10:22 14 KB JMyers to previous | to last
22 26-Nov-2021 10:22 14 KB JMyers to previous | to last
21 26-Nov-2021 10:22 14 KB JMyers to previous | to last

Page References

Incoming links Outgoing links
IFBA
IFBA

Version management

Difference between version and

At line 127 changed one line
;:The information for this field will automatically fill through the IFAS ([P2K_FC_ASSUMPTION]) table. You may however, change this data either manually or by using the calendar icon provided.
;:The information for this field will automatically fill through the IFAS ([P2K_FC_ASSUMPTIONS]) table. You may however, change this data either manually or by using the calendar icon provided.
At line 129 changed one line
;:The information for this field will automatically fill through the IFAS (P2K_FC_ASSUMPTION) table. You may however, change this data either manually or by using the calendar icon provided.
;:The information for this field will automatically fill through the IFAS ([P2K_FC_ASSUMPTIONS]) table. You may however, change this data either manually or by using the calendar icon provided.
At line 133 changed 11 lines
;[Process Assumption|]:The Process Assumption icon allows you to see the result of an assumption. In order to perform this function, you must first highlight the appropriate assumption and then click on the Process Assumption button. When completed you will be informed as to how many records were processed.
;[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). That action will be indicated in this field.
Assumption_Action is a mandatory field. The information for this field will automatically fill, however, you may edit it 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.
;[Process Assumption|]:The Process Assumption icon allows you to see the result of an assumption.
;:In order to perform this function, you must first highlight the appropriate assumption and then click on the Process Assumption button. When completed you will be informed as to how many records were processed.
;[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). That action will be indicated in this field.
;[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
;:%%information Ensure you place spaces before and after the ‘=’ in the formula line.%%
At line 145 changed 15 lines
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 (update)
Formula: PREMIUM_CODE = 'UNIFORM' (add)
Where: UNIT = 'alphanumeric'
Where: WAGE_RATE > 12.25
Where: VACANT not filled positions
Where: NOT VACANT only filled positions
;: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.0 (update)
\\Formula: PREMIUM_CODE = 'UNIFORM'(add)
\\Where: UNIT = 'alphanumeric'
\\Where: WAGE_RATE > 12.25
\\Where: VACANT not filled positions
\\Where: NOT VACANT only filled positions%%
At line 163 changed one line
The Assumption Log tab is the record of all the assumptions that have been processed for the scenario you is currently viewing. The information for this screen will default in from the [P2K_FC_ASSUMPTIONS_LOGS] table. You may NOT edit the data in this tab, it is for viewing ONLY.
The Assumption Log tab is the record of all the assumptions that have been processed for the scenario you is currently viewing. The information for this screen will default in from the [P2K_FC_ASSUMPTION_LOGS] table. You may NOT edit the data in this tab, it is for viewing ONLY.
At line 165 changed 8 lines
;[Seq|]:This field displays the sequential number of the processed assumption.
;[Description|]:This field provides a short description of the assumption.
;[Seat|]:This field will display the budget seat code.
;[Seat Title|]:This field will display the seat title for this budget seat.
;[Effective|]:This field will show the date the assumption is to begin.
;[Expiry|]:This field will show the date the assumption is to end.
;[Before Value|]:This field displays the value of the ‘item’ prior to the assumption being processed.
;[After Value|]:This field displays the value of the ‘item’ after the assumption has been processed.
;[Seq|ASSUMPTION_SEQUENCE]:This field displays the sequential number of the processed assumption.
;[Description|DESCRIPTION]:This field provides a short description of the assumption.
;[Seat|BUDGET_SEAT_CODE]:This field will display the budget seat code.
;[Seat Title|BUDGET_SEAT_TITLE]:This field will display the seat title for this budget seat.
;[Effective|EFFECTIVE]:This field will show the date the assumption is to begin.
;[Expiry|EXPIRY]:This field will show the date the assumption is to end.
;[Before Value|BEFORE_VALUE]:This field displays the value of the ‘item’ prior to the assumption being processed.
;[After Value|AFTER_VALUE]:This field displays the value of the ‘item’ after the assumption has been processed.
This page (revision-26) was last changed on 26-Nov-2021 10:22 by rforbesTop