Tip | ||
---|---|---|
| ||
Contains USPS template reports created and shared by other users which can be downloaded and used in your local application. The Example are mainly PDF |
Search this documentation
Live Search | ||
---|---|---|
|
Panel | |
---|---|
|
border | true |
---|
Per pay Reports
Tip | ||
---|---|---|
| ||
The USPS public shared library contains various custom report definitions, CSV spreadsheets and custom forms (xdoc) that can be downloaded by clicking on the name (title). Most of the report definitions and forms contains an example (PDF) of what the report/forms looks like once generated.
|
Live Search | ||
---|---|---|
|
Table of Contents | ||
---|---|---|
|
Section | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Per pay Reports
Monthly Reports
Quarterly Reports
FYE-Based Reports
CYE-Based Reports
Monthly Reports
EMIS Related ReportsCYE-Based
RITA Payables History report to complete Form 11, the example is the summary version of the full report. | CCA Tax Report.rpd-json | Click Here | Payroll Item History report, range of codes, range of dates. Totals by code/residence or employment tax, one line per employee. Used to complete the monthly CCA remittance form. The example is run in summary form. | Quarterly Reports | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Title (downloadable rpd-json file) | Example | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ODJFS Not Reportable.rpd-json | Click Here | This report shows any employees with QTD wages greater than zero that are not marked to report to ODJFS. Can be used to find employees that should be reported that are not marked correctly. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Title (downloadable rdp-json file) | Example | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
New Contract Compensation Worksheet.rpd-json | To see excel file format right click on Click Here and select Open Link in New Tab | The report pulls information into an Excel Worksheet from the Employee's current Compensation Contract record. Position Data is al so included. Headers that would be needed for the New Contract Import are written into the worksheet so districts can modify and use to import new contracts. *NOTE*- This file needs to be converted to csv format before importing to New Contracts. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
New Contract Payroll Accounts & Original Pay Account.rpd-json | Click Here | Summary of records in New Contracts page that also shows their current Payroll Accounts since these do not show in New Contract. Districts requested a way to see accounts easily to help with updates. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Non-Contract Mass Load Extract Worksheet w/Pay Groups | To see excel file format right click on Click Here and select Open Link in New Tab | This will create a template excel file (with field name) for manipulation to non contract for new school year. *NOTE*- This file needs to be converted to csv format before importing using Mass Load/Compensations. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Leave Usage.rpd-json | Click Here | Employee Leave usage, date used, type of leave used, choice by certified and classified, each employee on separate page |
Lists employees with their compensation and position flags. Also lists an employee's position information | ||
EMIS Reportable Report | Click Here | Report that pulls EMIS data from Employee, Compensation and Position records in csv format. |
EMIS Staff Report | Report that pulls EMIS data from Employee, Compensation and Position records excluding Archived records. | |
FTE Report w/Hire Date (PDF) | Click Here | Report in PDF format listing Position code with FTE, Employee Name, Hire Date, Position Number, Authorized Experience, Total Experience, Job Status, EMIS FTE and Compensation is Currently Active. |
FTE Report w/Hire Date (CSV) | Click Here | Report in CSV format listing Position code with FTE, Employee Name, Hire Date, Position Number, Authorized Experience, Total Experience, Job Status, EMIS FTE and Compensation is Currently Active. |
EMIS Employees Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Employee records with the Report to EMIS checkbox marked are populated. |
EMIS Active Positions Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Position records with the Job Status set to Active are populated. |
EMIS Inactive Positions Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Position records with the Job Status set to Inactive are populated. |
EMIS Active Contract Compensations Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Compensations with the Type set to Contract and Position records with Job Status set to Active are populated. |
EMIS Active Non Contract Compensations Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Compensations with the Type set to Non Contract and Position records with Job Status set to Active are populated are populated. |
EMIS Inactive Contract Compensations Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Compensations with the Type set to Contract and Position records with Job Status set to Inactive are populated. |
EMIS Inactive Non Contract Compensations Report | Click Here | This report will assist in verifying all the necessary EMIS elements on Compensations with the Type set to Non Contract and Position records with Job Status set to Inactive are populated are populated. |
Miscellaneous USPS-R Reports
Title (downloadable rdp-json file) | Example | Description | |
---|---|---|---|
OAPSE ReportAbsence-Attendance Report by Employee Name.rpd-json | Click Here | OAPSE union requests of specific employee information. In Excel format. Contains Employee name, Employee ID, address, primary email, YTD gross, address, and home phone. | Detailed Contract CompensationAbsence or Attendance Report similar to Classic ABS101. Sort and subtotal by full name then leave category. Also includes Leave Balances. |
Certified Rehired Retirees.rpd-json | Click Here | List Lists certified employees with their position and detailed compensation information for Contract Compensations only. Includes YTD earnings. (The sample report has the Active parameter selected)CITY TAX REPORTrehired retiree flags marked true. Report also includes date employee was rehired. | |
Classified Rehired Retirees.rpd-json | Click Here | City tax report that can be used for W2's, allows for multiple codes, each code on separate page with subtotal by code. Must make Dec the "current" period before running to get accurate information fo the CY, |
EMIS Related Reports
Lists classified employees with their rehired retiree flags marked true. Report also includes date employee was rehired | ||
Employee Info.rpd-json | Click Here | Lists all employees with their contact information and address. Also lists birth date and hire date |
Pay Distribution Codes.rpd-json | Click Here | Lists employees sorted by employee number with their pay distribution information |
Position Report.rpd-json | Click Here | Lists employees |
and their |
Miscellaneous USPS-R Reports
Title (downloadable rdp-json file) | Example | Description | |
---|---|---|---|
Absence-Attendance Report by Employee Name.rpd-json | Click Here | Absence or Attendance Report similar to Classic ABS101. Sort and subtotal by full name then leave category. Also includes Leave Balances. | |
Certified Rehired Retireespositions, position numbers, position codes, and pay groups | |||
Historical Payroll Item Report.rpd-json | Click Here | HistoricalPayrollItem Report provides detail of payroll item by pay. You can choose individual or multiple payroll items as well as individual or multiple employees by employee number | |
Hours Worked Report | Click Here | Report using query-payroll start and stop date. Reports lists Full Name, Position Description, Total Position Hours Worked, Gross, Adjusted Gross, Start Date and Stop Date. | |
Payroll Item History Report.rpd-json | Click Here | Report of payroll items that also lists the Deduction, Type of Employment, or Residential etc. allows for Multiple items, and by dates | |
Total Leave Used During Date Range (1).rpd-json | Click Here | Lists certified employees with their rehired retiree flags marked true. Report also includes date employee was rehired. | Classified Rehired RetireesAttendanceJournal Report shows total leave used for entered time period - without each absence being listed |
American Fidelity Demographics.rpd-json | Click Here | Lists classified employees with their rehired retiree flags marked true. Report also includes date employee was rehired | Employee InfoDemographic Report for American Fidelity- Filter by Last Paid Date (greater than or equal to) |
American Fidelity Census.rpd-json | Click Here | Lists all employees with their contact information and address. Also lists birth date and hire date | |
Pay Distribution Codes.rpd-json | Click Here | Lists employees sorted by employee number with their pay distribution information | |
Position Report.rpd-json | Click Here | Lists employees and their positions, position numbers, position codes, and pay groups | |
Historical Payroll Item ReportCensus Report for American Fidelity. Can be sorted by Last Paid Date Greater Than or Equal to. CSV can be filtered to remove duplicates by SSN | |||
American Fidelity Payroll Item.rpd.json | Click Here | Payroll Item Report for American Fidelity-Payroll Item codes need to be added in query and Last Paid Date greater than need to be added. | |
EEO-5.rpd-json | Click Here | HistoricalPayrollItem Report provides detail of payroll item by pay. You can choose individual or multiple payroll items as well as individual or multiple employees by employee number | |
Hours Worked Report | Click Here | Report using query-payroll start and stop date. Reports lists Full Name, Position Description, Total Position Hours Worked, Gross, Adjusted Gross, Start Date and Stop Date. | |
Payroll Item History Report.rpd-json | Click Here | Report of payroll items that also lists the Deduction, Type of Employment, or Residential etc. allows for Multiple items, and by dates | |
Total Leave Used During Date Range (1).rpd-json | Click Here | AttendanceJournal Report shows total leave used for entered time period - without each absence being listed | |
American Fidelity Demographics.rpd-json | Click Here | Demographic Report for American Fidelity- Filter by Last Paid Date (greater than or equal to) | |
American Fidelity Census.rpd-json | Click Here | Census Report for American Fidelity. Can be sorted by Last Paid Date Greater Than or Equal to. CSV can be filtered to remove duplicates by SSN | |
American Fidelity Payroll Item.rpd.json | Click Here | Payroll Item Report for American Fidelity-Payroll Item codes need to be added in query and Last Paid Date greater than need to be added. | |
EEO-5.rpd-json | Click Here | Report in csv format listing Full Name, Position Description, Assignment Area, Gender, Hispanic Latino Option, Race options, ODJFS Hire Date, Compensation Start Date and Part-time. | |
Check Register.rpd.json | Click Here | List of checks- payroll, refund, deduction checks based on issued date(s) entered-Check Number, Payment Number, Pay to Name, Transaction Type, Amount, Issued Date, Transaction Date, Reconciled Date, Status and Voided Date. | |
Direct Deposit Register.rpd.json | Click Here | List of Direct Deposits based on issued date(s) entered-Payment Number, Employee Name, Amount, Issued Date, Transaction Date, Reconciled Date, Status and Voided Date | |
Electronic Payment Register.rpd.json | Click Here | List of Electronic Payment based on issued date(s) entered-Payment Number, Name on Payment, Amount, Issued Date, Transaction Date, Reconciled Date, Status, Voided Date | |
Payroll Item Detail w/YTD Totals | Click Here | List of queried Payroll Items with Employee Name, Number, Code, Rate Type, Rate, Additional Withholding, Employer Rate, Pay Cycle, Max Amount, Start Date, Stop Date, YTD Applicable Gross, YTD Employer Amount, YTD Total Gross and YTD Withholding. | |
Regular Pay Account History Report | Click Here | Regular pay accounts charged, sorted by expenditure account. Includes Pay Date, Employee Number, Position Number, Employee Name, Expenditure Account, Amount Charged and Chargeable Calculation Percentage. | |
Specific Miscellaneous Accounts History Report | Click Here | Specific Miscellaneous accounts are listed that were charged during payroll. Includes Pay Date, Position Number, Employee Number, Employee Name, Any employee paid out of a specific miscellaneous account will be listed under the Specific Accounts Charged header. | |
Users Listing Report | Click Here | This report will show Username, Name, Last Login, Enables, Locked and Roles assigned. Can query to exclude roles or to pull only enabled accounts. | |
Public Records Request Report | Click Here | This report will list Last Name, First Name, Middle Name, Hire Date, Other Email, Primary Email, Secondary Email, Department, Position Description and Contract Amount. If wanting to use the district email, depending where the district has the district email defined ,you can remove the other two email field headers that do not apply. Also, when the report is created it may have employee duplicates since it is using Compensation Object. The district can use Data/ Remove Duplicates in excel to remove duplicates with same primary email, secondary email or other email address that is being used. |
New Hire Employee Templates
Report in csv format listing Full Name, Position Description, Assignment Area, Gender, Hispanic Latino Option, Race options, ODJFS Hire Date, Compensation Start Date and Part-time. | ||
Check Register.rpd.json | Click Here | List of checks- payroll, refund, deduction checks based on issued date(s) entered-Check Number, Payment Number, Pay to Name, Transaction Type, Amount, Issued Date, Transaction Date, Reconciled Date, Status and Voided Date. |
Direct Deposit Register.rpd.json | Click Here | List of Direct Deposits based on issued date(s) entered-Payment Number, Employee Name, Amount, Issued Date, Transaction Date, Reconciled Date, Status and Voided Date |
Electronic Payment Register.rpd.json | Click Here | List of Electronic Payment based on issued date(s) entered-Payment Number, Name on Payment, Amount, Issued Date, Transaction Date, Reconciled Date, Status, Voided Date |
Payroll Item Detail w/YTD Totals | Click Here | List of queried Payroll Items with Employee Name, Number, Code, Rate Type, Rate, Additional Withholding, Employer Rate, Pay Cycle, Max Amount, Start Date, Stop Date, YTD Applicable Gross, YTD Employer Amount, YTD Total Gross and YTD Withholding. |
Regular Pay Account History Report | Click Here | Regular pay accounts charged, sorted by expenditure account. Includes Pay Date, Employee Number, Position Number, Employee Name, Expenditure Account, Amount Charged and Chargeable Calculation Percentage. |
Specific Miscellaneous Accounts History Report | Click Here | Specific Miscellaneous accounts are listed that were charged during payroll. Includes Pay Date, Position Number, Employee Number, Employee Name, Any employee paid out of a specific miscellaneous account will be listed under the Specific Accounts Charged header. |
Users Listing Report | Click Here | This report will show Username, Name, Last Login, Enables, Locked and Roles assigned. Can query to exclude roles or to pull only enabled accounts. |
Public Records Request Report | Click Here | This report will list Last Name, First Name, Middle Name, Hire Date, Other Email, Primary Email, Secondary Email, Department, Position Description and Contract Amount. If wanting to use the district email, depending where the district has the district email defined ,you can remove the other two email field headers that do not apply. Also, when the report is created it may have employee duplicates since it is using Compensation Object. The district can use Data/ Remove Duplicates in excel to remove duplicates with same primary email, secondary email or other email address that is being used. |
New Hire Employee Templates
Title (downloadable CSV file) | Description |
---|---|
New Employee CSV Template | This file contains line data so it is easier for the district to add new Employee record with the correct formatting for certain fields. They can always remove the template line when they have added the new employee data. |
New Position CSV Template | This file contains line data so it is easier for the district to add new Position record with the correct formatting for certain fields. They can always remove the template line when they have added the new position data. |
New Contract Compensation CSV Template | This file contains line data so it is easier for the district to add new Contract Compensation record with the correct formatting for certain fields. They can always remove the template line when they have added the new Contract Compensation data. |
New Non Contract Compensation CSV Template | This file contains line data so it is easier for the district to add new Non-Contract Compensation record with the correct formatting for certain fields. They can always remove the template line when they have added the new Non-Contract Compensation data. |
New Leaves CSV Template | This file contains line data so it is easier for the district to add new Leaves record with the correct formatting for certain fields. They can always remove the template line when they have added the new Leaves data. |
New Pay Distributions CSV Template | This file contains line data so it is easier for the district to add new |
Pay Distributions records with the correct formatting for certain fields. They can always remove the template line when they have added the new |
Pay Distributions data. |
New |
Payroll Items CSV Template |
This file contains |
multiple lines data so it is easier for the district to add new |
Payroll Item records with the correct formatting for certain fields. They can always remove the template line when they have added the new |
Payroll Items data. |
New Pay Account CSV Template |
This file contains |
multiple lines data so it is easier for the district to add new |
Pay Accounts records with the correct formatting for certain fields. They can always remove the template line when they have added the new |
Pay Accounts data. |
Custom Form Templates
Title (downloadable xdoc form) | Example | Description | ||
---|---|---|---|---|
Default Direct Deposit Template | Click Here | This is the default direct deposit form. | ||
Default Salary Notice Template | Click Here | This | file contains line data so itis | easier for the district to add new Non-Contract Compensation record with the correct formatting for certain fields. They can always remove the template line when they have added the new Non-Contract Compensation data.New Leaves CSVthe default salary notice form. |
Direct Deposit Pay Group Template | Click Here | This direct deposit will include the pay group and period ending date. | ||
Direct Deposit New W4 Template | Click Here | This | file contains line data so it is easier for the district to add new Leaves record with the correct formatting for certain fields. They can always remove the template line when they have added the new Leaves data.||
New Pay Distributions CSV Template | Click Here | This file contains line data so it is easier for the district to add new Pay Distributions records with the correct formatting for certain fields. They can always remove the template line when they have added the new Pay Distributions data. | ||
New Payroll Items CSV Template | Click Here | This file contains multiple lines data so it is easier for the district to add new Payroll Item records with the correct formatting for certain fields. They can always remove the template line when they have added the new Payroll Items data. | ||
New Pay Account CSV Template | Click Here | This file contains multiple lines data so it is easier for the district to add new Pay Accounts records with the correct formatting for certain fields. They can always remove the template line when they have added the new Pay Accounts data.direct deposit will include the new W4 information. NOTE: If using XML for 3rd party printing, the new W4 fields will only appear if the employee has the 'Use new W4' checked in their 001 Federal Payroll Item. | ||
Direct Deposit with Rate | Click Here | This direct deposit will include the hourly or daily rate. | ||
Salary Notice with Experience Template | Click Here | This salary notice will print the salary schedule column, salary schedule step, salary schedule id, and district experience. | ||
Salary Notice including All Template | Click Here | This salary notice includes all information that can currently be printed on salary notices. | ||
Salary Notice with Rate Information Template | Click Here | This salary notice will print the the rate, rate type, and district experience. |
Mass Load Templates
Title | Description |
---|---|
Employee Number Template | This template can be used to change employee numbers. The name columns are included in the template to help update the the number. The name.lastName and name.firstName columns should be deleted prior to saving as a CSV fie and loading. |