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 Activity Registration 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.
This article details the fields available for building Activity Registration filters. For other available fields, see the Query Wizard article.
Activity Roster Filter Fields
The following Activity Roster fields are available for creating queries with the filter Data Type of Student.
Student > Activity Registration > Roster
| Roster Data | Ad hoc Field Name |
|---|---|
| Person ID | actRegRoster.personID |
| Activity Type | actRegRoster.activityType |
| Activity Name | actRegRoster.activityName |
| Item Name | actRegRoster.itemName |
| Activity Start | actRegRoster.activityStart |
| Activity End | actRegRoster.activityEnd |
| Registration Start | actRegRoster.regStart |
| Registration End | actRegRoster.regEnd |
| Sign Up Date | actRegRoster.signUpDate |
| Payment Complete | actRegRoster.paymentComplete |
| Forms Complete | actRegRoster.formsComplete |
| Registration Complete | actRegRoster.registrationComplete |
| Posted to Course Section | actRegRoster.postedToCourseSection |
Student > Activity Registration > Roster Purchase
| Roster Data | Ad hoc Field Name |
|---|---|
| Payment Timestamp | actRegRosterPurchase.paymentTimestamp |
| Person ID | actRegRosterPurchase.personID |
| School ID | actRegRosterPurchase.schoolID |
| Purchase Processor Person ID | actRegRosterPurchase.purchaseProcessorPersonID |
| Purchase Payer Person ID | actRegRosterPurchase.purchasePayerPersonID |
| Option Purchased | actRegRosterPurchase.optionPurchased |
| Payment Transaction Product Reference | actRegRosterPurchase.paymentTransactionProductRef |
| Fund ID | actRegRosterPurchase.fundID |
| Payment Method | actRegRosterPurchase.paymentMethod |
| Check Number | actRegRosterPurchase.checkNumber |
| Payment Source | actRegRosterPurchase.paymentSource |
| Override | actRegRosterPurchase.override |
| Override Person ID | actRegRosterPurchase.overridePersonID |
| Override Comment | actRegRosterPurchase.overrideComment |
| Amount | actRegRosterPurchase.amount |
| Refund | actRegRosterPurchase.refund |
| Refund By | actRegRosterPurchase.refundBy |
| Comments | actRegRosterPurchase.comments |
Student > Activity Registration > Roster Transfer
| Roster Data | Ad hoc Field Name |
| Transfer Processor Person ID | actRegRosterTransfer.transferProcessorPersonID |
| Person ID | actRegRosterTransfer.personID |
| Origin Activity | actRegRosterTransfer.originActivity |
| Destination Activity | actRegRosterTransfer.destinationActivity |
| Transfer Action | actRegRosterTransfer.transferAction |
| Additional Amount | actRegRosterTransfer.additionalAmount |
| Refund Amount | actRegRosterTransfer.refundAmount |
| Transfer Amount | actRegRosterTransfer.transferAmount |
| Total Amount | actRegRosterTransfer.totalAmount |
| Comments | actRegRosterTransfer.comments |
| Origin Item | actRegRosterTransfer.originItem |
| Destination Item | actRegRosterTransfer.destinationItem |
Transfer Timestamp | actRegRosterTransfer.transferTimestamp |
Staff Role Filter Fields
The following Staff Role fields are available for creating queries with the filter Data Type of Census/Staff.
Person > Staff >Assignment
| Staff Role | Ad hoc Field Name |
|---|---|
| Activity Staff | schoolEmployment.Activity Staff |
| Activity Preapproval | schoolEmployment.Activity Preapprover |
