There are several locations where reports can be run and data can be exported from Assignr.
Most of the reports provide by Assignr can be run from the Reports menu:
Additionally, there are additional reports that can be run:
- from the bottom of the People page (to export a list of people),
- from the bottom of the Games page (to export a list of games or assignments)
- in the Financial module, from the Statements screen.
Games Report / Assignments Report
Most reports involving game data fall into one of two types of reports.
- A Games Report is an export of information in a one-row-per-game format.
- An Assignments Report is an export of information in a one-row-per-assignment format. As an example, if a game is expecting to have three officials assigned, an Assignments report will show this game on three rows of your spreadsheet. This format works well when you need to see assignment level detail.
Report Fields
Most columns in the reports generated by Assignr are self explanatory. Here are a few that likely need a little more explanation:
- Confirmed: Will show an A for games that have been accepted, and a D for games that have been declined and where the official has not yet been removed from the game.
- Default Fee: Shows the configured default fee for the position, based on the game's age group, pattern and position.
- Override Fee: Shows the override amount (if any) that was entered for this specific assignment
- Pay Scale Fee: Shows the amount that should be paid for the assigned official, based on the assigned official's pay scale. If pay scales are not used, or the official is not assigned to a pay scale, this will be blank.
- Budgeted Fee: Shows the amount that is budgeted for this game, regardless of whether the game has been assigned or not, or whether the game has been cancelled or not. This amount will be, in priority order, the Override Fee, the Pay Scale Fee, or the Default Fee.
- Final Fee: This is the actual amount that should be paid to the official. This will be zero if the game status is set to "cancelled no pay," or if an official is not assigned to the position
If you are using the Assignr financial module, either to track payments or with Direct Deposit, you will also see the following information for each game:
- Statement: The statement ID number corresponding to this assignment.
- Statement Date: The date of the statement
- Statement Amount: The amount approved to be paid for this assignment
- Paid: Indicator that shows whether this assignment has been paid or not.
Available Reports
The Reports screen provides the following reports:
Games
The Games report is a list of all games, one row per game
Assignments
The Assignments report is nearly identical to the Games report, except for each game assignment is on a row. For games that expect 3 officials to be assigned, the game will have three rows in the spreadsheet
Budget
The Budget report provides a high-level overview by date of fees that are configured for each game. The Budget report assumes that each game is played (e.g. not cancelled), and all assigned officials show up.
Payroll Summary
The Payroll Summary report rolls up the financials for each assigned official.
Payroll Detail
The Payroll Detail provides line-item game and detail for each game assignment.
Game Reports
The Game Reports report is an export of all game reports submitted
Game Reports by Game
The Game Reports by Game report is a list of all games, along with the game report information if it was submitted.
Game Reports by Assignment
The Game Reports by Assignment report is a list of all game assignments, along with the game report information submitted by each assigned official, if a report was submitted.
Game Counts by Position
The Game Counts by Position report provides a count of the number of times each official has worked a specific position.
Game Counts by Date
The Game Counts by Date report provides a count of the number of times each official has worked a specific position.