DEFINE USER CALCULATIONS#
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
- 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 |
- Return Value
- The return value is used by Functions and Qualifiers to define what type of value will be returned by the Function or Qualifier UserCalc. If the UserCalc type is Qualifier, the return value will be set to Boolean. If the UserCalc type is Function, the user may choose Boolean, Char(acter), Date or Number as the type of value that will be returned.
- Usage
- The Usage field defines whether or not the UserCalc will be used to print a disbursement message. Disbursement messages are lines of information that will print on the employee's payroll stub/deposit stub. Users may choose from 'Disbursement Message' or 'Not Specified'. If 'Disbursement Message' is indicated, the UserCalc will be executed when UPDISB is run.
- Compile UserCalc
- This button allows the user to check the syntax of a UserCalc by creating the SQL code. This step does not ensure accuracy of the UserCalc, it merely checks that there are no UserCalc language errors such as incorrect syntax or infinite loops.
- Publish UserCalc
- If the user is signed-on as 'P2K' then a UserCalc may be re-published directly in the IMUC form if it was already 'In Production' and needed to be re-validated. If a user has taken a copy of an 'In Production' UserCalc and wishes to test it without losing the original UserCalc, then they may publish it. This means that wherever the original UserCalc is referenced, Personality will now use the newly published version.
Lines#
The data shown in this tab is stored in the P2K_AM_USER_CALC_DETAILS table.
- Line
- (00010, 00020, etc.)
- Description
- To make UserCalcs more easily read and maintained, a Notes field has been provided. Notes should be used to explain the calculations made and the logic of the UserCalc.
Variables#
Section Headings within in each tab#
- FieldName
- Definition
Globals#
Section Headings within in each tab#
- FieldName
- Definition
Commands#
Section Headings within in each tab#
- FieldName
- Definition
Operators#
Section Headings within in each tab#
- FieldName
- Definition