PUBLISH USER CALCULATIONS#
UserCalc administration should be done by your System Administrator signed who should be signed on as 'P2K'. This form allows UserCalcs to be published, analyzed, deleted, and unpublished.
This form uses a find line of the Product in order to make it easy to find the UserCalcs you are looking for.
'Publish User Calculations Usages and Examples UserCalc data is stored in the P2K_AM_USER_CALCS table.
As of the 5.05.22 release, the following changes have been implemented:
- The DELETE Button has been disabled for User Calcs that are a Status of 'In Production'.
- A new confirmation dialog with 'OK and Cancel' options has been added when a user attempts to delete a User Calc that is a status other than 'In Production'. This has been implemented to prevent accidental deletion of User Calcs.
- Product Code
- The product defines which module the UserCalc has been defined for, such as Payroll, Benefits, Attendance, or Workflow. Dependent upon the UserCalc, the value stored here is identical to the "Product" field in IMUC and the "Table" field in IMWA. This is a supplied value.
- Description
- This is the product description as specified on IMPD. This is a supplied value.
- User Calc
- This is the user-defined name of the UserCalc.
- User Name
- This is the name of the user who currently owns the UserCalc.
- Type
- This field describes the "Type" of UserCalc, defines what values may be used/passed between UserCalcs and what capabilities may be performed. There are three available "Types": Qualifier, Function and Calculation. Workflow UserCalcs will always have the type, "Calculation".
- Status
- This is the current status of the User Calc.
Buttons#
- Publish
- When the status of a UserCalc is set to "To Be Published", the user may be put in to production using this button.
- View Code
- Clicking on this button provides the SQL code for the UserCalc. Our Customer Support team may ask that you send in the SQL code for a UserCalc if you have reported a problem with it. Note that support of User Calculations is not covered by your normal support agreement and will be billable.
- Delete
- If a UserCalc is not attached to any calling forms it may be deleted.
The DELETE Button will be disabled if the User Calc is Status=In Production
- Unpublish
- If a UserCalc is "In Production" and it is not attached to any calling forms it may be unpublished. This takes it back to the 'To Be Published' status.
Steps to Publishing a User Calc#
Publishing UserCalcs #
- Create a UserCalc through IMUC. The initial status will be 'Under Construction'.
- Compile the UserCalc using the 'Compile UserCalc SQL' button in IMUC.
- When ready, change the status to 'To Be Published'.
- Within Personality sign in as the 'P2K' User
- Go to IMUCA - Administer UserCalcs.
- Select the 'To Be Published' UserCalc, and publish it by clicking on the 'Publish UserCalc' button.