Payroll Report Builder

Payroll Report Builder

The Payroll Report Builder is a tool for generating custom reports based on payroll data for the college. Specifically the tool allows for the creation of time series representations of the data with custom grouping options. The tool offers a great deal of flexibility in reporting and grouping of data, and as such it is possible to create reports that do not make sense or is otherwise misleading. It is imperative that those using this tool are familiar not only with the data, but with the conventions and practices used and implemented by this tool.

Conventions, Terminology, and Field Descriptions

Conventions

This page uses many WSU codes whose meanings can be found here. Additionally many of the fields described by the tool allow for multiple delimited entries. In keeping with CBS conventions our delimiter is the semi-colon ";".

Terminology

Area: An Area is a high level organizational unit within the college, e.g. Area 3, 30 and 41.

Type: Type, short for Employment Type is a classification of employee appointments such as Faculty, Exempt, Hourly, etc...

Sub Type: A Sub Type is a child category of an appointments employment type. For instance the Faculty type may have a sub type of Tenured, or Non-Tenured. Sub types may be predefined or custom created.

Unit: A Unit is an organization unit with an area of the college and often corresponds to a department. Units are designated by 4 digit codes

Field Descriptions

Starting: The starting field expects a date value which will act as the right end point in our time series. In the event that we are not making a time series the starting value will correspond to our lone data point. It is important to note that when the report is ran the starting value is translated to the ending date of the pay cycle that contains that date.