School Store Fields for Ad Hoc Reporting

Classic View: Ad hoc Reporting > 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 eligibility 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.

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 FieldMapping & Definition
itemName

School Store > Reports > Pick List

The name of the item that was purchased.

customerComments

School Store > Reports > Pick List

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

purchaseDate

School Store > Reports > Pick List

The date on which the purchase was made.

schoolIDSchool Store > Reports > Pick List
A unique identifier for the school.
recipientSchool Store > Reports > Pick List
The person for whom the item was purchased.
customerSchool Store > Reports > Pick List
The person who placed the order on the School Store.
itemSKUSchool Store > Reports > Pick List
A unique identifier for the item.
transactionTypeSchool Store > Reports > Pick List
Identifies whether the purchase was made with a credit card or an echeck.
pickedUpSchool Store > Reports > Pick List
Identifies whether the item was picked up.
recipientPersonIDSchool Store > Reports > Pick List
The recipient's unique ID.
schoolNameSchool Store > Reports > Pick List
The name of the school from which the purchase was made.
categoriesSchool Store > Reports > Pick List
The Category in the School Store to which the purchased item belongs.