Reports

The following outlines the some of the key reports available in GEMS and provides a brief description of each report.  Related Public Queries are highlighted below.

ATTENDANCE AND LEAVE – BALANCE

GEMS Navigation: Home > USF Menu Items >  USF Menu Items > Report > Employee Leave Year End Report

  • Leave Balance Detail Report- ALT001: This report shows each plan type for each employee with a leave balance
  • Leave Balance Summary Report- ALT002: The report shows a summary of beginning and ending balances for each plan type including a signature page for the employee and accountable officer.

ATTENDANCE AND LEAVE – ABSENCE

GEMS Navigation: Home > Workforce Administration > Absence and Vacation > Absence-Report

  • Absence Listing: View information about an employee’s absence history
  • Time Lost Due to Absence: Captures information about an employee’s total days missed for each leave occurrence

APPOINTMENT INFO

GEMS Navigation: Home > Workforce Administration > Workforce Reports > USF Reports

  • A/P Appointments: Listing of Administrative and Professional Appointments sorted by job code (class). Public Query: U_ANP1All Employees Contact Info: Lists Location, Mailing Address, Mail Drop (campus mail point) and Work Phone for all employees by College/Division or GEMS Dept ID. Public Query: U_ALL
  • All Employees Job Info: Lists appointment and demographic type info for all employees by College/Division or GEMS Dept ID. Public Query: U_ALL
  • Class Salary Equity – AP:  A&P Salary Equity Report sorted by job code (class), then by salary in ascending order. Run options: All USF, VP area, Coll/Div, Dept ID, Campus or Job Code. Public Query: U_CEQA
  • Class Salary Equity – Faculty:  Faculty Salary Equity Report sorted by job code (class), then by salary in ascending order.  Run options: All USF, VP area, Coll/Div, Dept ID, Campus or Job Code. Public Query: U_CEQF
  • Class Salary Equity – USPS:  USPS Salary Equity Report sorted by job code (class), then by salary in ascending order. Run options: All USF, VP area, Coll/Div, Dept ID, Campus or Job Code. Public Query: U_CEQU
  • Extra Comp by Home Dept(s):  Lists all employees with Extra Compensation appointments by the Home Dept ID (Primary Employer) reflects Paying Dept ID (Secondary Employer) and Total Gross amounts for the Extra Comp appointments. Run options: Must enter Begin Date & End Date then choose; Company (All USF), Coll/Div, Dept ID or Campus. Public Query: U_ESC2
  • Extra Comp by Paying Dept(s):  Lists all employees with Extra Compensation appointments by the Paying Dept ID. Reflects Total Gross amounts for the Extra Comp appointments. Run options: Must enter Begin Date & End Date then choose; Company (All USF), Coll/Div, Dept ID or Campus. Public Query: U_ESC1
  • Faculty Appointments: Listing of Faculty Appointments sorted by job code (class). Public Query: U_FAC1
  • Faculty OPS Appointments:  Active, non-resident, reoccurring faculty & fellowship OPS, basic appointment data, such as name, EmplID, job code, compensation, Department, OPS service date, termination date. Public Query: U_FACO
  • FWS Balances by Dept: Displays Name, EmplId, Empl Rcd#, FWS Award Amount, Paid Amount, and Available Balance. Prompted by Department & Effective Dating criteria. Public Query:  U_FWSP_BALANCES
  • Hourly OPS Appointments:  Active, reoccurring hourly paid OPS, includes Name, EmplID, Job Code, Compensation, Department, OPS service date, Termination Date. Public Query: U_HRLY
  • New Hires:  Enter start and end dates. Run options: All USF, VP area, Coll/Div, Dept ID or campus. Public Query: U_APP1
  • Prof Salaried OPS Appointment:  Active reoccurring salaried OPS, includes name, EmplID, job code, compensation, Department, OPS service date, termination date. Public Query: U_PSOP
  • Resident OPS Positions: Includes Name, EmplID, Job Code 9188, Compensation, Department, OPS Service Date, Termination Date, Grade and Step. Public Query: U_RESO
  • Terminations:   Enter start and end dates. Run options: All USF, VP area, Coll/Div, Dept ID or campus. Public Query: U_TER1
  • USPS Appointments: Listing of USPS Appointments sorted by job code (class). Public Query: U_USPS

BUDGETED POSITION

GEMS Navigation: Home > USF Menu Items > USF Menu Items > Report

  • Budgeted Position Summary Report:  Enter the first 6 characters of the Dept ID, including the dash (i.e. 0-0320). The wildcard symbol may be used as a placeholder (i.e. 0-03%).  Budgeted position information will be refreshed every other pay period to update data from position, job and pay distribution data in GEMS. Public Query: BPA_Budget_position_query

PAY DISTRIBUTION

GEMS Navigation:  Home > USF Menu Items > USF Menu Items > Report

  • Department Summary Report: Enter the GEMS Dept ID, choose to leave blank or enter Date. The report reflects the percent of pay distributed to each GEMS Account Code and its associated Chartfields, in addition to general appointment related data for each position and appointment listed. Public Query: Not available (SQR only).

PAY HIST PREFAST

(For Payroll information prior to Pay Period #0402)

GEMS Navigation: Home > USF Menu Items > USF Menu Items > Report

Three different reports are available for pay periods #0001 through 0401. These reports can be printed for one pay period or multiple pay periods. The online reports are as follows:

  • Pay Expenditure by Account:  Input the SAMAS Account Number and the beginning and ending Pay Period number.  Displays payroll register information for the account number entered (Select Format: RTF). Public Query: U_PAY_EXPEND_BY_ACCT
  • Pay Expenditure by DeptId:  Input the GEMS Department ID and the Pay Period number.  Displays payroll register information for the Department as entered (Select Format: RTF). Public Query: U_PAY_EXPEND_BY_DEPTID
  • Pay Expenditure by Employee:  Input the employee’s GEMS EmplID or SSN and the beginning and ending Pay Period number.   Displays payroll register information for the employee as entered (Select Format: RTF). Public Query: U_PAY_EXPEND_BY_EMPLOYEE

PAYROLL REGISTER

GEMS Navigation: Home > USF Menu Items > USF Menu Items > Report

  • Department Check Register: Enter the GEMS Dept ID and the beginning and ending pay period end date. Displays pay check details for the department entered. Public Query: U_DEPT_CHECK_REG

Comments are closed.