Display lottery information in the Applications module using a Saved View

Learn how to display lottery information in a Saved View in the Applications module

What's included in this article?

• Step 1: Set your Quick Filters
• Step 2: Click Save View
• Step 3: Name your View
• Step 4: Set Sort Data By and click Add Columns
• Step 5: Review and Remove Unwanted Columns
• Step 6: Click Add Columns to Select Lottery Fields
• Step 7: Set Filters (optional)
• Step 8: Save View

Step 1:  Set your Quick Filters

Using your Quick Filters, identify which applications (Program, Program Category, Grade, etc.) will be included in this Saved View. Click the Apply Filters button to display all applications for the selected programs.

Step 2: Click the Save View button

Step 3: Name your View and determine who should have access to this view. 

Step 4: Set your Sort Data and Add Columns

Step 5: Review the list of default columns and remove any that you do not want included in this new view.

Step 6: Click Add Columns to display the rules engine where you will select fields from the Lottery Rankings table.

• The Lottery Rankings Data Dictionary in the Enroll User Guide provides a list of lottery fields available, including descriptions. 

Common Lottery Fields and Suggested Column Names for your Saved View

Table	Field	Suggested Column Name
Application	lottery_priorities_name	Priority
Application	lottery_sublottery	Sub Lottery
Lottery Ranking	lottery_list	Lottery List
Lottery Ranking	rank_adjusted	Placement on List
Lottery Ranking	accepted	Placement Status
Lottery Ranking	accepted_declined_by	Accepted/Declined By (System, Admin, Parent)
Lottery Ranking	timestamp_expire	Offer Deadline (if using Auto Decline)

Step 7: Set Filters (optional) to further narrow down which applications to be included in this view.

• To include applications in your view that are on the offered list OR the waiting list, configure your filter as below:

• Note: When including the Lottery List field in your Saved View and using no filters, a blank value in the Lottery List column will represent a Not Placed application (not yet run through a lottery or not yet auto-added to your lottery list).  Click here to learn more about Not Placed applications.

Step 8: Click Save View to be redirected to the Applications screen where your Saved View and corresponding results will be displayed.