When creating or Editing a report in the Custom Report Builder, you will need to be familiar with the fields used in the creation and set up of your application forms. It is suggested to have a separate window open with the SETTINGS>> FORMS window open to reference specific fields when building reports. In addition to reviewing the fields in your school or districts specific forms, here are a list of the commonly used filters when building reports for reference. 


Frequently Used Fields for Filters:


Application Filters:


Application Submission Status (Submitted / Not Submitted) - 

  • Record - Application
  • Field - submitted
  • Values
    •  Submitted = 1
    • Not Submitted = 0


Application Eligibility Status (Eligible / InEligible / In Processing) - 

  • Record - Application
  • Field - status
  • Values
    • Eligible = 1
    • Ineligible = 0
    • In Processing = -1


Program Student is Applying to - 

  • Record - Application
  • Field - program_id
  • Filter by - Programs


Lottery Filters:


Lottery List the Student is on (Accepted / Waiting List) - 

  • Record - Lottery Ranking
  • Field - lottery_list
  • Values
    • offered
    • waiting

How a Student has Responded to their Lottery Seat (Accepted Seat / Declined Seat / Pending Reponse) - 

  • Record - lottery_rankings
  • Field - accept
  • Values
    • Accepted Seat = 1
    • Pending or Haven't Responded = 0
    • Declined Seat = -1


Enrollment Filters:


Enrollment Submission Status (Submitted / Not Submitted) 

  • Record - Student_Annual
  • Field - enroll_submitted
  • Values
    • Yes = 1
    • No = 0

Enrollment Approval Status (Approved/Denied/In Processing) - 

  • Record - Student_Annual
  • Field - enroll_status
  • Values
    • Approved = 1
    • Denied = 0
    • In Processing = -1

Enrollment Type (New Enrollment / Re-Enrollment)

  • Record - Student_Annual
  • Field - enroll_type
  • Values
    • ENROLL
    • REENROLL