UPRLU
Back to current versionRestore this version

AUDIT US TAX FILING INFORMATION#


Report Parameters & Filters#

Report Parameters
As of DateMandatory, user must provide a Date for the system to select which assignment and personal records to review for work and resident state
Create FileOptional, 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 MethodMandatory,X_UPRLU_METHOD lexicon available
You must select which update option the UPRLU must perform.
Directory NameOptional, 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 NameOptional, 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.
TrialMandatory, Yes or 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 LevelMandatory, Exception 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.

Report Filters
PayrollOptional, Multiple, and LOV available
Multiple payrolls may be selected per execution of this function.
Pay CategoryOptional, Multiple and LOV available
Multiple pay categories may be selected.
Pay PeriodOptional, Multiple, and LOV available
Users may limit the information selected by indicating specific pay periods.
Batch NumberOptional, Multiple, and LOV available
Users may limit the information selected by specifying batch numbers.

The report filters may be used to filter the employee records by the selected options, for example only run for Employment Status = Active.

People List
PersonOptional, Multiple Selection Available, LOV Available
This will limit the report to the persons selected.
EntityOptional, Multiple Selection Available, LOV Available
This will limit the report to the entities selected.
LocationOptional, Multiple Selection Available, LOV Available
This will limit the report to the locations selected.
Auth AreaOptional, Multiple Selection Available, LOV Available
This will limit the report to the authorization areas selected.
DepartmentOptional, Multiple Selection Available, LOV Available
This will limit the report to the departments selected.
Org Level Type
Org Level CodeOptional, Multiple Selection Available, LOV Available
This will limit the report to the organizational levels selected.
UnitOptional, Multiple Selection Available, LOV Available
This will limit the report to the units selected.
GroupOptional, Multiple Selection Available, LOV Available
This will limit the report to the groups selected.
PayrollOptional, Multiple Selection Available, LOV Available
This will limit the report to the payrolls selected.
JobOptional, Multiple Selection Available, LOV Available
This will limit the report to the jobs selected.
PositionOptional, Multiple Selection Available, LOV Available
This will limit the report to the positions selected.
Employment StatusOptional, Multiple Selection Available, LOV Available
This will limit the report to the employment statuses selected.
Employment TypeOptional, Multiple Selection Available, LOV Available
This will limit the report to the employment types selected.
Assignment TypeOptional, Multiple Selection Available, LOV Available
This will limit the report to the assignment types selected.
Pay TypeOptional, Multiple Selection Available, LOV Available
This will limit the report to the pay types selected.


Notes #

Click to create a new notes page