The query and dashboard filter records differently, which will likely result in different totals.  

  • The applicant query will pull applicants with active applications as well as those that have an active enrollment associated with that application (applicants that have been enrolled).  
  • The Status Pipeline dashboard only counts applicants with active applications and excludes any applicant that has been enrolled if the parameter is set to only include new applicants.  
Because the query pulls information in a different manner than the dashboard, the applicant query will not be comparable to the Applicant Status Pipeline dashboard if any of the applicants have already been enrolled.  To find an accurate count of how many applicants have a certain status, the applicant query will give the most accurate results.