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 14 changed one line
;[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.
;[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.
At line 18 changed one line
;Status: This field describes the status of the UserCalc. The following values are available.
;[Status]: This field describes the status of the UserCalc. The following values are available.
At line 24 changed one line
[Type]: The 'type' of UserCalc defines what values may be used/passed between UserCalcs and what capabilities may be performed. Three types are available:
;[Type]: The 'type' of UserCalc defines what values may be used/passed between UserCalcs and what capabilities may be performed. Three types are available:
At line 30 added 2 lines
;[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.
At line 31 changed 3 lines
;[FieldNameInHdr]:description
;[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.
;[Pre-publish]: [CLEANUP]
At line 38 changed 2 lines
!Section Headings within in each tab
;[FieldName]:Definition
The data shown in this tab is stored in the [P2K_AM_USER_CALC_DETAILS] table.
;[Line]: (00010, 00020, etc.)
This field defines the sequential order in which the UserCalcs will follow instructions.
CMD
Type
OT Operand Type 1 - (PC, A, etc.)
Operands must have a ‘Type’. This type is defined in the field before each Operand. See detailed descriptions in the Operand Types section.
Operand1 (7100, EE rec’d birthday bonus this pay, etc.)
Operand1 is typically used to store the result of any line of a UserCalc, or to compare to a
value in Operand2.
OPER Operator - (BD, EQ, etc.)
Operators are the action to be taken in regard to the command issued and the operands
indicated.
See detailed description in the Operators section.
OT Operand Type 2 - (DB, $C, etc,)
Operands must have a ‘Type’. This type is defined in the field before each Operand.
Operand2 (EID.Birth_Date, Birthday Bonus, etc.)
Operand2 is used to compare values or assign values.
Operand 3
Operand 3 is used, when necessary, to further define Operand 2, or in mathematical
operations.
If Goto
• The ‘If Goto’ field must be completed for every line.
• For any IF, FREQ, PPE, BOM, or EOM command there must be a true path (If
Goto), and a false path (Else Goto).
• The ‘If Goto’ field tells the UserCalc program which line to proceed to in a ‘True’
situation.
• In a situation without a true and false path (i.e. Let PC 110 Equal +12), only the ‘If
Goto’ field is mandatory.
• If the 'If Goto' column is double-clicked on the user will be taken to that line.
Else Goto
• For any IF, FREQ, PPE, BOM or EOM command, the ‘Else Goto’ field tells the program
which line to proceed to in the ‘False’ situation.
• If the 'Else Goto' column is double-clicked on the user will be taken to that line.
;[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.