Reporting

Check-In books for Inventory Distribution

1. Printed Report for collecting signatures a sticker booth
2. Displays camping passes assigned to each Root Group organized by pass type - STaff, SOP, Trade, Teen/Youth then alphabetically by last name
3. Contains blank line for recording camping pass serial number and participant signature.

Printed Master Lists for Fair Central

1. Printed Report for cross referencing participants with the root group they received a camping pass from. List is organized alphabetically by last name and displays the person and group name.

Assigned vs Budgeted Dashboard

1. Electronic Report for identifying budget totals compared to assignments for all inventory types for all root groups. This serves as a dashboard to help inventory crew identify where inventory assignments for groups are over or under allocated relative to their budgets.
2. Displays combined totals for all assigned inventory by Type
3. Displays each group name along with that group’s
   1. current total owed
   2. current total received
   3. current balance due.
   4. A total budget / total assigned for each type of inventory. Any over allocations display the assigned total in red

Double Dipping

1. Electronic Report for identifying people who are set to receive inventory from more then one root group. This data condition is valid but a report is used to make sure all the instances of this condition are expected.
2. People names are listed and the specific root groups they are receiving inventory from are listed below their names.
3. Displays a list of “Positive” double dippers where one unique Person record is definitely assigned inventory from more than one root group.
4. Displays a list of “Possible” double dippers where people with the exact same First and Last name are assigned inventory from more than one group. These could be different people with the same name or accidental/careless duplicates.
5. Each person listed will be hyperlinked to their Person Record
6. Each root group listed will be hyperlinked to their root group

Inventory Swapping

1. Electronic Report for identifying groups with removed inventory hat has been “paid for”. It also shows any unpaid inventory assignments for the same group - possibly indicating that the unpaid inventory was really intended to replace the removed inventory.
2. For each group with removed pid inventory the report shows
   1. root group name as hyperlink to their root group management page
   2. a column listing all removed inventory listed as
      1. date removed
      2. person it was assigned to
      3. Type of inventory
      4. cost of inventory
   3. a column listing all unpaid inventory listed as
      1. person it is assigned to
      2. Type of inventory
      3. cost of inventory

Authentication Log

1. Electronic Report for identifying list of successful authentications to the system. This provides insight into usage patterns and validated coordinator activity on the system.
2. Displays the
   1. authentication month
   2. number of authentication for that month
   3. the name of System User who logged in.
   4. Any group affiliations the System User has

Activity Log

1. Electronic Report for displaying transaction history on the system.
2. Displays the
   1. Transaction date
   2. System User
   3. SQL query executed for the transaction