Labor Ledger Empl Summary w Fringes

Description

This query provides detailed wage and fringe per employee ID per earn code from the Labor Ledger file in KFS out of the payroll.  

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Fiscal Year:  Enter fiscal year(s).

  2. Campus Code:  Leave blank or click on the Valid Values button to select from a list.

  3. RC Code:  Leave blank for ALL or click on the Valid Values button to select from a list.

  4. Dept Id:  Enter your department code or click on the Valid Values button to select from a list.

  5. Account Number: Leave blank for ALL or enter specific accounts

  6. Employee ID:  Leave blank for ALL or enter specific ID number(s).

  7. Position Nbr:  Leave blank for ALL or enter specific position number(s).

  8. Paygroup:  Leave blank or click on the Valid Values button to select from a list.

  9. Salary Plan:  Leave blank for ALL or click on the Valid Values button to select from a list.

  10. Salary Grade:  Leave blank for ALL or click on the Valid Values button to select from a list.

  11. Report Format: Select Standard Report or Account Report.

  12. Select Output Format:  This will default to MS Excel (XLS).

  13. Select Output Destination:  You should select “Send Output to Completed Reports”.  The report will be in your Completed Reports folder in My Catalog when it’s done running.  You usually want to do this for long-running reports.

  14. Click the RUN button.