This page (revision-10) was last changed on 26-Nov-2021 10:22 by Karen Parrott

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

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
10 26-Nov-2021 10:22 6 KB Karen Parrott to previous
9 26-Nov-2021 10:22 6 KB Karen Parrott to previous | to last
8 26-Nov-2021 10:22 4 KB jmyers to previous | to last
7 26-Nov-2021 10:22 4 KB jmyers to previous | to last
6 26-Nov-2021 10:22 4 KB jmyers to previous | to last
5 26-Nov-2021 10:22 4 KB jmyers to previous | to last
4 26-Nov-2021 10:22 4 KB jmyers to previous | to last
3 26-Nov-2021 10:22 4 KB jmyers to previous | to last
2 26-Nov-2021 10:22 4 KB jmyers to previous | to last
1 26-Nov-2021 10:22 1 KB jmyers to last

Page References

Incoming links Outgoing links
UPRLU
UPRLU

Version management

Difference between version and

At line 1 changed one line
!!!AUDIT US TAX FILING INFORMATION
!!!PROCESS TIME RULES
At line 3 removed one line
----
At line 5 changed one line
The UPRLU is used to generate the values on the IPRLUS form.
Up to this point, [{$applicationname}] is showing ONLY what it will do once the Process Time Rules
function, UPRL, is run. This process should be run when all time has been entered for a period
or a batch.
At line 8 added 2 lines
If you run UPRL with an exception level of 'user trace' you will see how the entered time
will be affected by the over time rules
At line 8 changed one line
The UPRLU reads IMCT 'UPRLU MAPPING' to generate the Misc. Tax Parameters on IPRLUS with the default set up.
Once UPRL has been run and the rules applied, the [IPTR] screen will reflect the results of the processed time rules.
At line 10 changed one line
IMCT ‘UPRLU MAPPING’ contains the list of Tax Parameters at the employee level only, therefore if the IPUTP Tax Parameter does not exist on IMCT, this IPUTP tax parameter will not be inserted on IPRLUS, this means the IPUTP tax parameter is for UPCALC internal use only
%%information Note:Only the following time rules can be used with UPRL to update pay transactions on [IPTR]; 'OT WEEKLY', 'OT WEEKLY RATED', 'OT DAILY', 'OT CONSECUTIVE', ‘OT DAYS + HOURS', 'PP DAYS + HOURS', 'OT HOLIDAY', 'OT 7TH DAY', 'OT MONTHLY', 'GA WEEKLY TIME'%%
At line 12 changed 33 lines
If the UPRLU is run with 'Exception Level: 0-Exception Level', UPRLU displays the report with Statistics only
* UPRLU Version: 27-Oct-2019
* 257 Assignments (Current and Future) Processed
* 211 Employees Processed
* Trial Mode, All Updates have been Rolled Back
If the UPRLU is run with 'Exception Level: 1-User Trace', UPRLU displays the report with Tax Parameters
* UPRLU Version: 27-Oct-2019
* As of Date: 01-Aug-2019
* Create File: Y
* Update_method: (01) Default Method
* Directory Name: OUTPUT
* File Name: UPRLU-487634.xls
* Exception Level: 1
* Trial: Y
*Process_misc 0000000973 -- Process Empl (0000000973) Winfield, PAUL for IPRLUS Misc Parameters for State: CT\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000005 2020_W4 = FALSE\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000006 TOTAL ALLOWANCES = 0\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000007 FILINGSTATUS = S\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000008 TWO_JOBS = FALSE\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000009 DEPENDENTS_AMT = 0\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000010 OTHER_INCOME = 0\\
*Insert_misc 0000000973 INSERT IPRLUS Federal Tax Parameter: 000011 DEDUCTIONS = 0\\'
'
During testing of the UPRLU, the user may wish to re-run the UPRLU to re-test.
* an SQL script is delivered to help the user delete IPRLUS Tax Parameters for SYSDATE so users can re-test.
*In SQL+, login to the database and execute:
**>@DELETE_IPRLUS_TAX_PARM.sql
----
At line 48 changed 8 lines
|As of Date|Mandatory, Date LOV available\\This field indicates the date from which information is to be collected. You must provide a date for the system to select which assignment and personal records to review for work and resident state.
|Create File|Optional, [Yes or No|X_YES_NO] lexicon available\\If <Yes> is selected UPRLU will create a flat file showing the original information in the Vertex columns and the new value in the Misc Tax Parameters. If NO, the report will be run without creating an interface file (normally for testing purposes).
|Update Method|Mandatory, [X_UPRLU_METHOD] lexicon available\\You must select which update option the UPRLU must perform.
|Directory Name|Optional, allows the user to specify a valid directory known to the database server. This is used when the Create File parameter is set to <Yes>.
|File Name|Optional, Text\\This field displays the file name of the data being uploaded.\\ \\The file extension must be .xls, this is the only supported file format for UPRLU.
|Trial|Mandatory, [Yes or No|X_YES_NO] lexicon available\\You may choose to run the report in a trial mode to see results <Yes> or in update mode <No>.\\ \\If this toggle is set to <No>, the miscellaneous tax parameters will be inserted in [IPRLU].\\ \\If this toggle is set to <Yes>, the report will indicate which records could potentially be updated. If the Create File toggle is also set to <Yes>, the flat file will still be created.
|Exception Level|Mandatory, [Exception Level|X_TRACE_LEVEL] lexicon available\\This field defines the exception level (report messages) required.\\ \\Report should be run with Exception Level 0\\ \\If issues are encountered re-run UPRLU with Exception Level = 9 for one employee.
|User Comments |Optional, Text \\This field holds the user-supplied comment which will appear in the header of all pages of the report. This is useful during testing phases to identify similar reports from each other.
|Entity|Mandatory, LOV Available \\Limits the process to the entity specified.
|Respect Time Code Seq.|Optional, LOV Available
|Exception Level|Mandatory, LOV Available\\Users may increase the level of logging done from exception to user, legislation, usercalc, program or utility levels.
|Trial|Optional, Toggle\\If ‘ON’ then the update is not committed and UPRL may be run again.\\If ‘OFF’ then the update is committed.
At line 57 removed 2 lines
The report filters may be used to filter the employee records by the selected options, for example only run for Employment Status = Active.
At line 60 changed 17 lines
|People List|Optional, LOV Available\\This will limit the report to the people list selected.
|Person|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the persons selected.
|Entity|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the entities selected.
|Location|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the locations selected.
|Auth Area|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the authorization areas selected.
|Department|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the departments selected.
|Org Level Type|Optional, [X_ORG_LEVEL_TYPE] lexicon available\\This will limit the report to the org level type selected.
|Org Level Code|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the organizational levels selected.
|Unit|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the units selected.
|Group|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the groups selected.
|Payroll|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the payrolls selected.
|Job|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the jobs selected.
|Position|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the positions selected.
|Employment Status|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the employment statuses selected.
|Employment Type|Optional, [X_EMPLOYMENT_TYPE] lexicon available\\This will limit the report to the employment types selected.
|Assignment Type|Optional, [X_ASSIGN_TYPE] lexicon available\\This will limit the report to the assignment types selected.
|Pay Type|Optional, [X_PAY_TYPE] lexicon available\\This will limit the report to the pay types selected.
|Payroll|Optional, Multiple, and LOV available\\Multiple payrolls may be selected per execution of this function.
|Pay Category|Optional, Multiple and LOV available\\Multiple pay categories may be selected.
|Pay Period|Optional, Multiple, and LOV available\\Users may limit the information selected by indicating specific pay periods.
|Batch Number|Optional, Multiple, and LOV available\\Users may limit the information selected by specifying batch numbers.
At line 79 removed 4 lines
This page (revision-10) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop