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 24 changed one line
;[FTE|FTE]:The number of full time equivalent positions for which a commitment has been made by the organization. FTE is an optional 9-character numeric field you may manually enter.
;[FTE|FTE]:The number of full time equivalent positions for which a commitment has been made by the organization.
At line 44 changed one line
;[Work Rule|WORK_RULE_CODE]:Work rules are used to determine the standard processing information required to create pay headers and transactions for an employee.
;[Work Rule|WORK_RULE (Field)]:Work rules are used to determine the standard processing information required to create pay headers and transactions for an employee.
At line 50 changed one line
The data for the Distributions tab comes from the [IEAS] ([P2K_HR_ASSIGNMENT_DETAILS]) or if the assignment is vacant, from [IDPS] ([P2K_CM_POSITION_Details]) table. You MAY, however, change the information directly on this tab.
The data for the Distributions tab comes from the [IEAS] ([P2K_HR_ASSIGNMENT_DETAILS]) or if the assignment is vacant, from [IDPS] ([P2K_CM_POSITION_DETAILS]) table. You MAY, however, change the information directly on this tab.
At line 70 changed one line
The data for the Statistics tab comes from the IEST (P2K_HR_STATISTICS) table; however, you MAY change the information directly on this tab.
The data for the Statistics tab comes from the [IEST] ([P2K_HR_STATISTICS]) table; however, you MAY change the information directly on this tab.
At line 72 changed 9 lines
Statistics
This field will hold the user-defined statistic code.
Statistic_Code is a mandatory field you must fill using the LOV derived from the P2K_CM_STATISTIC_COMPONENT table.
Abbreviation
This field will hold the abbreviated description of the pay component.
The information for this field will default in once the Stat Code has been selected. You may NOT alter edit this field.
Amount $
User-defined statistical amount
Amount is an optional 18-character numeric field you may manually enter.
;[Statistics|STAT_CODE]:This field will hold the user-defined statistic code.
;[Abbreviation|ABBREVIATION]:This field will hold the abbreviated description of the pay component. The information for this field will default in once the Stat Code has been selected. You may NOT alter edit this field.
;[Amount $|AMOUNT]:User-defined statistical amount.
At line 84 changed one line
This tab is the log of assumptions that have been processed for the budget seat that you is on. The information data for the Assumption Log tab is derived from the P2K_FC_ASSUMPTIONS_LOGS table. You may NOT ALTER the information within this tab.
This tab is the log of assumptions that have been processed for the budget seat that you are on.
At line 86 changed 10 lines
Seq
This field displays the sequential order of the assumption within this budget seat.
Assumption Action
This field will show what action the assumption will perform.
Description
This field will provide a short description of the assumption processed.
Before Value
This field shows the value of the ‘item’ prior to the assumption being processed.
After Value
This field shows the value of the ‘item’ after the assumption has been processed.
The information data for the Assumption Log tab is derived from the ([P2K_FC_ASSUMPTION_LOGS]) table.
%%information You may NOT ALTER the information within this tab.%%
;[Seq|ASSUMPTION_SEQUENCE]:This field displays the sequential order of the assumption within this budget seat.
;[Assumption Action|ASSUMPTION_ACTION]:This field will show what action the assumption will perform.
;[Description|DESCRIPTION]:This field will provide a short description of the assumption processed.
;[Before Value|BEFORE_VALUE]:This field shows the value of the ‘item’ prior to the assumption being processed.
;[After Value|AFTER_VALUE]:This field shows the value of the ‘item’ after the assumption has been processed.
At line 99 changed one line
You may view the calculated budget amounts by selecting the Display Budget Amounts tab.
You may view the calculated budget amounts by selecting the Budget Amounts tab.
At line 101 changed one line
Start Date / End Date
;[Start Date|START_DATE]/[End Date|END_DATE]:
At line 103 changed 15 lines
Budgets are dealt with on a Monthly basis, if you run UFCALC for a Bi-weekly Payroll, the Start and End Dates will be that of the Pay Period for that Budget.
If it is on a Bi-weekly basis and the start of the first Pay Period was 01-Jan-2007, then UFCALC would generate as follows:
01-Jan-2007 to 13-Jan-2007
14-Jan-2007 to 27-Jan-2007
28-Jan-2007 to 31-Jan-2007
01-Feb-2007 to 10-Feb-2007
It does this so that the Pay Period 28-Jan-2007 to 10-Feb-2007 is split over the 2 months as the budget is to be created by month.
Pay Component
This field displays the pay component generated for this period.
Abbreviation
This field displays the abbreviated description of the pay component.
Amount $
This field displays the amount calculated in UFCALC.
Distribution
If the pay component has a distribution code attached to it, the distribution heading will be displayed here.
;:Budgets are dealt with on a Monthly basis, if you run [UFCALC] for a Bi-weekly Payroll, the Start and End dates will be that of the Pay Period for that Budget.
;:If it is on a Bi-weekly basis and the start of the first Pay Period was 01-Jan-2007, then [UFCALC] would generate as follows:
;:01-Jan-2007 to 13-Jan-2007
;:14-Jan-2007 to 27-Jan-2007
;:28-Jan-2007 to 31-Jan-2007
;:01-Feb-2007 to 10-Feb-2007
;:It does this so that the Pay Period 28-Jan-2007 to 10-Feb-2007 is split over the 2 months as the budget is to be created by month.
;[Pay Component|PC_CODE]:This field displays the pay component generated for this period.
;[Abbreviation|ABBREVIATION]:This field displays the abbreviated description of the pay component.
;[Amount $|AMOUNT]:This field displays the amount calculated in [UFCALC].
;[Distribution|DISTRIBUTION_CODE]:If the pay component has a distribution code attached to it, the distribution heading will be displayed here.
At line 122 removed 6 lines
Copy the BASE scenario before doing any assumptions.
Assumption can be one of three types:
Planned When you know that there are changes to be made, you should create ‘Planned’ assumption.
What If When you are attempting to ‘forecast’ a possible change, you should create a ‘What If’ assumption.
Wage Step If UFSTEP is run as part of the forecasting process, assumptions will be created and stored as ‘Wage Step’ assumptions by Personality HHRM
The information data for the Assumptions tab can be found in the P2K_FC_ASSUMPTION_LOGS table.
At line 129 changed 23 lines
Seq
This field will display the sequential order of the assumption.
Assumption_Sequence is a mandatory 5-character numeric field you must enter manually.
Type
This field will display the assumption type being defined.
Planned What If Wage Step
Assumption_Type is a mandatory field you must fill using the fixed lexicon X_ASSUMPTION_TYPE.
Status
This field indicates the status of the assumption.
Assumption_Status is a mandatory field you must fill using the fixed lexicon X_ASSUMPTION_STATUS.
Statement
Users may create global or general statements through the Define Assumption Statement (IFAS) form. This field allows you to link the statement to the assumption.
Statement is an optional field you may fill using the LOV derived from the IFAS (P2K_FC_ASSUMPTION_STATEMENT) table.
Start
This field shows the date the assumption is to begin.
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.
End
This field shows the date the assumption is to end.
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.
Description
This field provides a short description of the assumption.
Description is an optional 50-character alphanumeric field you may manually enter.
Add Assumption Statement
%%warning Copy the BASE scenario before doing any assumptions.%%
At line 153 changed one line
You may add an assumption through the Add New Assumption Statement button.
Assumption can be one of three types:
|Planned|When you know that there are changes to be made, you should create ‘Planned’ assumption.
|What If|When you are attempting to ‘forecast’ a possible change, you should create a ‘What If’ assumption.
|Wage Step|If [UFSTEP] is run as part of the forecasting process, assumptions will be created and stored as ‘Wage Step’ assumptions by Personality.
At line 155 changed 2 lines
Please refer to Assumption Statements for further information on this function.
Process Assumption
The information data for the Assumptions tab can be found in the ([P2K_FC_ASSUMPTION_LOGS]) table.
At line 158 changed one line
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.
;[Seq|ASSUMPTION_SEQUENCE]:This field will display the sequential order of the assumption.
;[Type|ASSUMPTION_TYPE]:This field will display the assumption type being defined.
;[Status|ASSUMPTION_STATUS]:This field indicates the status of the assumption.
;[Statement|STATEMENT_CODE]:Users may create global or general statements through the Define Assumption Statement (IFAS) form. This field allows you to link the statement to the assumption.
;[Start|START_DATE]:This field shows the date the assumption is to begin.
;: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.
;[End|END_DATE]:This field shows the date the assumption is to end.
;: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.
;[Description|DESCRIPTION]:This field provides a short description of the assumption.
;[Add Assumption Statement]:You may add an assumption through the Add New Assumption Statement button.
;:%%information Please refer to Assumption Statements for further information on this function.%%
;[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.%%
;[Assumption Where|ASSUMPTION_WHERE]:This field allows you 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’
At line 160 changed 29 lines
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.
Assumption Where
This field allows you 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 (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
%%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 192 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 194 changed 16 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.
At line 169 added 5 lines
----
![Notes|Edit:Internal.IFBA]
[{InsertPage page='Internal.IFBA' default='Click to create a new notes page'}]
This page (revision-26) was last changed on 26-Nov-2021 10:22 by rforbesTop