RA - Fine Reports Small Group Fall 2019 - Summary

General Recommendations:

CSV format is fine for all of these reports, additional formats are not needed.
Permission controls are needed for all of the in-app reports, for the following reasons:
1. Anything having to do with financial data would not be something we would want to have open to all operators.
2. If the report did not have permission controls, you would not be able to know who had potentially run the report.
3. These specific reconciliation reports have associated service points, which identifies how much money is being handled at that location - a physical security concern.
One point that will need resolution - whether the in-app report can be thin-threaded by setting default time periods for running the report. Because of this, we are recommending that the report be required to have a prompt for date, and not a hard-coded default time period. If that truly can't be done, we believe the report will need to run for at least a four month time period to accommodate quarterly, monthly, and daily reconciliation and audit needs.

Requested Feature	Timeframe to run report	Service Point for Report	Payment Methods in Report	Thin Thread Options	Data Points	Other info	Questions from Holly
In-App Report: Cash Drawer Reconciliation Report	Prompt on run for start date and end date (default to current date/time)	Prompt for Selection	Prompt for Selection	Use logged in service point Return all payment methods Return transactions and libraries compute summary values on their own.	For each transaction returned in the query: Transaction date/time Transaction Amount Payment Status Payment Method Waive Reason (if applicable) Refund Reason (if applicable) Add'l actions: Cancelled as Error, Suspended as Claim Returned, Staff Info Only Add'l information: Staff, Patron Operator ID Fee/Fine owner Summary values: Total payment by fee/fine payment type. Total by fee/fine payment method.	Personal Data: Operator ID Add'l Information - Patron (potentially) Same-Day Data needed? Yes	Do you want each fee/fine to be one row in the spreadsheet? (Keeping in mind that a fee/fine can have multiple 'actions' (aka transactions) such as payments, waives, transfers, refunds. Which date should I be checking in order to include the item in the report? Payment date? Refund date? 'Action' date? "For each transaction returned in the query" does not include Fee/Fine Type (e.g. Lost item fee, Overdue fine, Locker rental fee, Damaged item fee). Shouldn't that be included? "Summary values" included Fee/Fine Payment Type, which does not exist. What should this be? Fee/Fine Payment Method does exist.
In-App Report: Financial Transactions Detail Report	Prompt on run for start date and end date (default to current date/time)	Prompt for Selection	Prompt for Selection	Use logged in service point Return all payment methods	For each transaction in the timeframe: Transaction date/time Transaction Amount Payment Status Payment Method Waive Reason (if applicable) Refund Reason (if applicable) Add'l actions: Cancelled as Error, Suspended as Claim Returned, Staff Info Only Add'l information: Staff, Patron Operator ID Fee/Fine owner Add'l specific info Patron Name Patron ID (Default - External System ID) Patron Email Instance Title Instance Author Item Barcode Item Call Number Item Loan Date Item Return Date (if applicable) Item Effective Location Overdue Policy Name Lost Item Fee Name	Personal Data: Operator ID Add'l Information - Patron (potentially) Patron name Patron ID Patron Email Item information (because Same-Day Data needed? Yes
ID440: Fine Fee Reconciliation	This report is essentially the same as the two reports above (depending on whether an institution includes patron info as part of their reconciliation process.)
ID483: Monies paid/collected for fines/fees, privileges, purchases, or other reasons by payment method, date range, location, or operator	This report is intended for annual statistics UChicago reported that it does not need to include operator information (contrary to report title description) This report can be accommodated for in the LDP.