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

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

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
41 26-Nov-2021 10:22 10 KB Kevin Higgs to previous

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }] <-- only if tabbed form
!!!FUNCTION NAME
[{TableOfContents }]
!!!DEFINE USER CALCULATIONS
At line 5 removed one line
text on form
At line 6 added 26 lines
UserCalcs may be defined within the Define UserCalcs (IMUC) form. This screen will allow
you to create the lines, variables, commands, etc. for each UserCalc. The definition data for the Define User Calculations screen is stored in the [P2K_AM_USER_CALCS] tables.
;[User Calc|USER_CALC_CODE]: This field refers to the user-defined name given to the UserCalc. Once the UserCalc has been created it can be edited, however, you can not edit it once the UserCalc is in production. You have to Un-Publish it on [IMUCA] first. As with Benefit and Attendance UserCalcs, we recommend that a naming convention be used for Workflow UserCalcs. For example, AT is used for the Attendance application, BE for the Benefits application and WF for the Workflow application. This will allow for efficient queries once the UserCalc list becomes large. __See [special characters] section for naming rules.__
;[Description]: The description field may be used to further define the purpose of the UserCalc in more detail than is available in the UserCalc name.
;[Product|: The product indicates which module the UserCalc has been defined for. For example, PR-Payroll, BE-Benefits, AT- Attendance, FC-Forecasting & Costing and WF-Workflow.
With respect to Workflow, this field specifies the table code on which the workflow trigger is located. This field should be identical to the name of the "Table" in [IMWA]. In all cases except workflow, it is the application that controls which fields in which tables will be accessible by the UserCalc. For example, in an Attendance UserCalc, the Leave Accrual Table would be accessible, but not benefits information.
;Status: This field describes the status of the UserCalc. The following values are available.
|Under Construction|This status value indicates that the UserCalc has not been completed and therefore will not be published.
|Being Tested |This status value indicates that the UserCalc has been completed, compiled and is being tested by the user who created it. It will not be published.
|To Be Published |This status value indicates that the UserCalc is ready for publishing. You can not set the user calc to this value manually.
|In Production |This status value indicates that the UserCalc has already been published and is in use.
[Type]: The 'type' of UserCalc defines what values may be used/passed between UserCalcs and what capabilities may be performed. Three types are available:
|Qualifiers | Used to reduce the number of employees or calculations processed by the UserCalc.
|Functions | Used to perform a calculation or query, and return a value to the calculation. The Attendance and Benefits Applications use Functions exclusively.
|Calculations| Used as the main program area, and may call Qualifiers and Functions in order to perform some kind of customized
action or operation. Calculations are only performed in the Payroll Calculation, and Forecasting and Costing applications.