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

Version management

Difference between version and

At line 4 removed 41 lines
!!Processing Information
The UPRLU is used to generate the values on the IPRLUS form.
The UPRLU reads IMCT 'UPRLU MAPPING' to generate the Misc. Tax Parameters on IPRLUS with the default set up.
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
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 3 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.
|As of Date|Mandatory, user must provide a Date for the system to select which assignment and personal records to review for work and resident state
|Create File|Optional, when 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
|Update Method|Mandatory,[X_UPRLU_METHOD] lexicon available\\You must select which update option the UPRLU must perform.\\ \\Vertex Conversion - inserts Miscellaneous Tax Parameters in IPRLU based on current information in State tab of IPRLU\\ \\Update Misc Tax Parameters – not supported at this time, intention is that this method will update IPRLU with any new tax parameters
At line 17 added 7 lines
||Report Filters||
|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 59 changed 2 lines
||Report Filters||
|People List|Optional, LOV Available\\This will limit the report to the people list selected.
|People List|
At line 66 changed one line
|Org Level Type|Optional, [X_ORG_LEVEL_TYPE] lexicon available\\This will limit the report to the org level type selected.
|Org Level Type|
At line 74 changed 3 lines
|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.
|Employment Type|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the employment types selected.
|Assignment Type|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the assignment types selected.
|Pay Type|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the pay types selected.