Labor Ledger - Actuals Only

Description

Use this query to view actuals data from the KFS Labor Ledger.

Note: users must belong to the FIS_LD_ALL group to access this report.

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Fiscal Year(s): leave blank to search all fiscal years on record, or enter a value(s) to limit the report to one or more fiscal years.
  2. Pay Run ID(s): leave blank to search across all pay runs, or enter a value(s) to limit the report to one or more pay runs.
  3. Pay Period End Date - Begin Range (MM/DD/YYYY): leave blank to capture all recent pay periods, or enter a specific pay period end date at which to begin the search. To select a specific pay period, enter the same pay end date in this field and the field below.
  4. Pay Period End Date - End Range (MM/DD/YYYY): leave blank to capture the all pay periods, or enter a specific pay period end date at which to end the search. To select a specific pay period, enter the same pay end date in this field and the field below.
  5. RC Code(s): leave blank to search across all RCs, or enter a value(s) to limit the report to one or more responsibility centers.
  6. Chart Code(s): leave blank to search across all charts, or enter a value(s) to limit the report to one or more charts.
  7. Org Code(s): leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  8. Account Number(s): leave blank to search across all accounts, or enter a value(s) to limit the report to one or more accounts.
  9. Sub Account(s): leave blank to search across all sub-accounts, or enter a value(s) to limit the report to one or more sub-accounts.
  10. Object Code(s): leave blank to search across all object codes, or enter an object code(s) to limit the report to one or more object codes.
  11. Paygroup: leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups.
  12. Earn Code(s): leave blank to search across all earn codes, or enter a value(s) to limit the report to one or more earn codes.
  13. Employee Id(s): leave blank to search all employee data, or enter one or more 10-digit ID numbers to limit the report to one or more employees.
  14. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  15. Select Output Destination: this report usually runs quickly; "Wait" is a good option.