Open Payroll 101
Schema and Examples
Welcome to Tyler Technologies' Open Payroll experience. This page is designed to provide documentation that will help your team better understand the Open Payroll application, and how you'll need to structure your data so that the application can read and display information in meaningful ways.
This page includes:
- Introducing Open Payroll
- Understanding Schemas
- Schema Documentation
- Customer Examples
- Additional Resources
Introducing Open Payroll
Open Payroll is a powerful but simple tool that allows your constituents and internal staff to see the total compensation of government employees. The primary challenge in implementing the tool is to get your payroll data into the Open Payroll schema - this schema often reflects the format in which Payroll data is already stored
This page is here to help provide more information and context about how your data should be structured, as well as customer examples so that you can see live examples of both datasets as well as the finished product.
Understanding Schemas
Within the schema documentation, you'll find three field types:
- Required Fields: These fields are required by Open Payroll to function. Think of these as the data that you simply could not report payroll without. For example, position titles, employee IDs (not employee names) , and total annual pay.
- Recommended Fields: These fields are not required, but including them will allow users to see a richer picture of your spending information. For example, different breakdowns of the total annual pay, such as overtime pay, and benefits pay. Note that employee first/last names are recommended for transparency, but not necessarily required.
- Optional Fields: These fields are useful for analysts or power-users accessing the information, or for adding a deeper level of hierarchy. For example, listing the union(s) or bargaining group(s) that employees belong to. Additionally, you can include a "projected total pay", so that users can compare this projected amount with the end-of-year actuals.
Schema Documentation
For the full documentation of the Open Payroll schema, click the link below:
Payroll Data Schema
Customer Examples
Below are examples of actual customers' Open Payroll implementations, from both the application level as well as the data level. Use the below examples to explore how the data is structured, and how it is displayed in the final version of an application.
City
City of Tuscaloosa
Payroll Datasets
City of Tuscaloosa
Payroll App
State
Commonwealth of Massachusetts
Payroll Dataset
Commonwealth of Massachusetts
Payroll Application
State of Connecticut
Payroll Datasets
State of Connecticut
Payroll App
Additional Resources
Our support team has put together a list of articles to assist with your implementation. Find additional support articles here.
Have questions? Feel free to reach out to your program manager, customer success manager, or our support team at di-support@tylertech.com