School Store Fields for Ad Hoc Reporting

Tool Search: Filter Designer

The Ad hoc Reporting tools allow users to create custom queries and reports on various types of information stored within the Campus database. Reports may be used for data analysis and state reporting and queries may be exported out of Campus or used to create filters for standard reports. Custom filters and reports are built by adding elements from Ad hoc Reporting tools like the Filter Designer. The following is a list of available fields that can be included in Ad hoc reports that draw from School Store data.

The name of an Ad hoc element is not necessarily the name listed in the user interface; therefore, the following tables briefly define and map Ad hoc elements to the appropriate interface locations/fields.

Screenshot example of School Store fields available from the Filter Designer.

Example Ad Hoc Fields

School Store > Pick List Filter Fields

These fields are available when building a Student selection filter or a Census/Staff selection filter then picking School Store > Pick List.

Filter Field Definition
itemName

The name of the item that was purchased.

customerComments

Information the customer added to their purchase before they checked out.

purchaseDate

The date on which the purchase was made.

schoolIDA unique identifier for the school.
recipientThe person for whom the item was purchased.
customerThe person who placed the order on the School Store.
itemSKUA unique identifier for the item.
transactionTypeIdentifies whether the purchase was made with a credit card or an e-check.
pickedUpIdentifies whether the item was picked up.
recipientPersonIDThe recipient's unique ID.
schoolNameThe name of the school from which the purchase was made.
categoriesThe Category in the School Store to which the purchased item belongs.