Topics Map > Human Resource System (HRS) > HRS Human Resources Administration
Running the Lump Sum and Lump Sum Adjustment forms HR Data Query in HRS
Overview:
This query provides the data of the Lump Sum forms or Lump Sum Adjustment forms that are in the completed status.Process Considerations:
- Security roles required to run this report include: UW_UNV_HR_REPORTS or UW_UNV_HR_QUERY_NS
- Query results will return result based on user's row level security
- User can limit results by Business Unit (Optional), Department ID (Optional), From Executed From Date, From Executed To Date prompts
Instructions
- Navigate to: Reporting Tools > Query > Query Viewer
- Enter UW_HR_LUMPSUM_ADJ_HR_DATA
- Click Search
- Click the Run to HTML or Excel hyperlink
- When prompted you can choose to limit results by Business Unit, Dept ID, From Executed From Date, Executed To Date or leave blank for Business Unit, Department to pull all the Business Units, Departments which are completed status (Executed Status) with Date range entered in From Executed From Date and Form Executed To Date.
- Review the Results.
Field Explanations:
Form Executed From Date and Form Executed To Date
- These Dates are the range dates where all the forms which are in completed (Executed status). (Example: If you want extract/pull all the forms which are completed (Executed Status) from June 1 to June 30).
Note: The data appearing in the Excel spreadsheet or HTML output is:
- Original Form ID
- Adjustment Form ID
- Requester
- Form Created on
- Business Unit
- Department ID
- Employee ID
- Employee Rcd
- Employee Name
- Earning Code
- Start Date (Lumpsum Work Start Date)
- End Date (Lumpsum Work End Date)
- Adjustment (Lumpsum Amount from Adjustment form)
- Payment (Lumpsum Amount)
- ACA Hours
- Supervisor/Reports to ID
- Supervisor/Reports To Name
- Reports To Position
- Teacher (Course teaching)
- Course Title
- Course Section
- Lumpsum Work Description
- Why Requesting
- Additional Comments
- Fund (Funding Entry field1)
- Dept ID (Funding Entry field2)
- Program code (Funding Entry field3)
- Project (Funding Entry field 4)
- Amount% (Funding Entry field 5)
- Position (Lumpsum Employee Position#)
- Job Code
- Location
- Full/Part
- Reg/Temp
- Working Title
- Continuity
- Employee Class
- Pay Basis
- Form Status
- Compensation Frequency
- Rate Code
Sample Reports:
Note: In the sample reports it won't display all the fields