Skip to main content

Number of Students Actively Pursuing Degrees

Performance is impacted when graduated and former students remain active/current in the system. Jenzabar provides a script to help evaluate the active/open rows in the Degree History table letting you identify and deactivate graduate and former students.

To Resolve the Issue

  1. Run the EXiPermissionsChange script below while the system is running. The EXiPermissionsChange stored procedure evaluate rows in degree_history marked active/open.

    Warning

    Because this script is executed while the system is running, performance is impacted. Jenzabar recommends running it during a less active time.

    SELECT count(*) -- sm.ID_NUM, nmStudent.LAST_NAME, nmStudent.FIRST_NAME
  FROM STUDENT_MASTER sm
  JOIN DEGREE_HISTORY dh ON sm.ID_NUM = dh.ID_NUM AND dh.ACTIVE = 'Y' AND dh.DTE_DEGR_CONFERRED IS NULL
              AND dh.EXIT_DTE IS NULL AND dh.CUR_DEGREE = 'Y'
  JOIN NAME_MASTER nmStudent ON sm.ID_NUM = nmStudent.ID_NUM
  JOIN Person peStudent ON nmStudent.APPID = peStudent.NameMasterAppID
  JOIN Party paStudent ON peStudent.AppID = paStudent.AppID

  2. Evaluate all the active/current students listed.

  3. Deactivate graduated and former students.