Program: END OF SPRING TERM CHECKPOINT PROCESS (ZRPHEOS)

Program name: ZRPHEOSVersion: 18.5Location: Jobsub

Description: This Banner process is provided to assist colleges with the tracking of HOPE Scholarshipand Zell Miller Scholarship recipients. Recipients must have a Postsecondary Cumulative Grade Point Average of at least a 3.00for HOPE Scholarship or a 3.30 for Zell Miller Scholarship at the end of the spring term, in order to continue eligibility. The Scholarship Tier Tracking Process (ZRPTIER) and the Three Term Checkpoint Process (ZRPTTCP)must be complete prior to running the End of Spring Checkpoint (ZRPHEOS) Process.

ZRPHEOSis designed to examine HOPE Scholarship and Zell Miller Scholarship recipients’ eligibility at the end of spring term. This process applies to all HOPE Scholarship and Zell Miller Scholarship recipients for the current aid year, except those First Tier (H1 or Z1) students that fall into the part-time (Three Term Checkpoint- 3TC -ZRPTTCP) status. A student that receives the Three Term Checkpoint during spring term will not be rechecked by the EOS program. HOPE Scholarshipand Zell Miller Scholarship eligibility can be lost at End of Spring Checkpoint (EOS) not gained or regained. Eligibility for HOPE Scholarship or Zell Miller Scholarship can only be regained at a future Attempted Hours Checkpoint.

Prerequisites:

  1. RORUSER: Enter the following field description: (Field description for ROAUSDF)

FIELD 39 EOS Status/Term

Banner Form: RORUSER

Prerequisites continued:

  1. The HOPE Scholarship Tier Tracking Process (ZRPTIER) and the Three Term (3TC) Checkpoint (ZRPTTCP) must be run prior to running the End of Spring (EOS) Process (ZRPHEOS).

Parameters:

01 / Aid Year Code / Required / Current Aid Year Code – example 1718
02 / Term code / Required / Enter the Banner Spring Term Code (example: 201814). ZRPHEOS will only run for spring term codes (Banner term codes ending with ‘4’). No report is generated if run on term other than spring. No output file is generated for aid year/term code mismatch.
03 / Run Mode / Valid Values: A, U / A – Audit or U - Update
NOTE: It is recommended that you run this process first in audit mode. Audit mode does not update ROAUSDF.
04 / Email User Name / Not Required, but Recommended / Enter User Name for the output report to be emailed. Only a valid college issued email address user name will process. Example – If Johnnie Smith at Albany Tech is running this process and his email address is , then Johnnie would enter jsmith for Parameter 04.

Process:

At the end of each spring term, colleges must apply the End of Spring(EOS) Checkpoint (Banner process: ZRPHEOS).

  1. The EOS Checkpoint will be applied to any student that is:
  2. Latest tier code is Tier 2, 3, or 4 during the Aid Year. To determine Tier 2, 3, or 4, the process looks at ROAUSDF Fields 38 (Beginning Eligibility), 45 (End of Summer Eligibility), and 50 (End of Fall Eligibility) for the Aid Year.
  3. Tier 1 and full-time during any term during the Aid Year.
  4. Tier 1 and part-time IF they have previously been checked by the Three Term Checkpoint (3TC). To determine whether or not a student has had the 3TC performed, the program looks at ROAUSDF Field 29 (3TC Status = ‘C’) and Field 30 (GSFC Check Term) or Field 40 (3TC Check Term). If Field 30 or Field 40 is less than the EOS Term the student will have the EOS Checkpoint applied.
  5. Tier 1 and ROAUSDF Field 29 (3TC Status = ‘X’). Three Term Checkpoint ‘Not Needed’ because Tier 1 student was full time at least once.
  6. The EOS Process will not be applied to any student that is:
  7. Tier 1 and falls into the 3TC/part-time category.
  8. Not enrolled during the Aid Year.
  9. Not receiving HOPE Scholarship or Zell Miller Scholarship during the Aid Year.
  10. Last Tier Code is ineligible status.

Process continued:

End of Spring ROAUSDF Updates:

  1. The students that are processed through the EOS Checkpoint will have their ROAUSDF records updated as follows:
  1. Passed the EOS:

HOPE Scholarship: If ROAUSDF Field 27 (Overall GPA) is >= 3.00 then the student passes the EOS.

  1. Field 39 (EOS Status/Term) will be set to ‘P201814’. “P” designates “pass” and “201814” is the term the student was checked.

Zell Miller Scholarship: If ROAUSDF Field 27 (Overall GPA) is >= 3.30 then the student passes the 3TC.

  1. Field 39 (EOS Status/Term) will be set to ‘P201814’. “P” designates “pass” and “201814” is the term the student was checked.
  1. Failed the EOS:

HOPE Scholarship: If ROAUSDF Field 27 (Overall GPA) is < 3.00 then the student fails theEOS.

  1. Field 39 (EOS Status/Term) will be set to ‘F201814’. “F” designates “fail” and “201814” is the term the student was checked.
  2. Field 28 (Overall Eligibility) will be set to ‘SBG’. “SBG” designates that the student was below 3.00 GPAat the End of Spring Checkpoint.
  3. Field 60 (End of Spring Eligibility) will be set to ‘SBG’.
  4. Field 97 (HOPE Scholar Loss) updated to the date as MMYYYY. Example: Student lost HOPE Scholarship at the end of spring 2018 (Banner term code 201814). HOPE Scholar Loss date updated to 052018.

Zell Miller Scholarship: If ROAUSDF Field 27 (Overall GPA) is < 3.30 then the student fails the EOS.

  1. Field 39 (EOS Status/Term) will be set to ‘F201814’. “F” designates “fail” and “201814” is the term the student was checked.
  2. Field 28 (Overall Eligibility) will be set to ‘SBG’. “SBG” designates that the student was below 3.30 GPA at the End of Spring Checkpoint.
  3. Field 60 (End of Spring Eligibility) will be set to ‘SBG’.
  4. Field 99 (Zell Miller Scholar Loss) updated to the date as MMYYYY. Example: Student lost Zell Miller Scholarship at the end of spring 2018 (Banner term code 201814). Zell Miller Scholar Loss date updated to 052018.

Note: Zell Miller Scholars with a Scholarship GPA of less than 3.30 but who maintain a Scholarship GPA of at least 3.00 should be evaluated for HOPE Scholarship eligibility. Manual Tier Code updates will be required to establish eligibility for HOPE Scholarship.

  1. If a student does not require the EOS Checkpoint, their ROAUSDF will be updated as follows:
  2. EOS Not Needed: (Tier 1 part-time students.)
  3. Field 39 (EOS Status/Term) will be set to ‘X201814’. “X” designates “not needed” and “201814” is the term the student was considered.

Notes:

  • HOPE Scholarship Process Sequence:
  1. HOPE Scholarship Tier Tracking Process (ZRPTIER)
  2. Three Term Checkpoint (ZRPTTCP)
  3. End of Spring Checkpoint (ZRPHEOS) Important: Only run after spring term
  4. HOPE Scholarship Review Report (ZRRHREV) Run after ZRPTTCP if not spring term.

The HOPE Scholarship Tier Tracking and Three Term Checkpoint process must be run prior to running the End of Spring Checkpoint Process.

The HOPE Scholarship Review Report (ZRRHREV) should be run after ZRPHEOS each spring term. The following two groups of students are identified on the ZRRHREV report. (See ZRRHREV documentation for further information.)

  • Students coded with a HOPE Scholarship Tier Code (‘H1’, ‘H2’,’H3’, or ‘H4’) with at least a 3.30 Scholarship GPA and who has been identified by GSFC as a Zell Miller Scholar (Zell Miller flag = ‘Y’). These students must be reviewed for Zell Miller Scholarship eligibility and manual updates to Tier Codes must be entered to establish eligibility for the Zell Miller Scholarship.
  • Students identified as Zell Miller Scholars (Zell Miller flag = ‘Y’) with a Scholarship GPA of less than 3.30. The student’s Scholarship GPA remains at least a 3.00. These students must be reviewed for HOPE Scholarship eligibility and manual updates to Tier Codes must be entered to establish eligibility for the HOPE Scholarship.
  • ZRPHEOS may be run in (A)udit or (U)pdate mode. It is recommended that you run this process first in audit mode. Audit mode does not update ROAUSDF.

Results:

Possible EOS values are: (ROAUSDF)

FIELD 28Overall Eligibility:

No change if:

  • Student passes the EOS Checkpoint
  • Student does not need EOS Checkpoint applied

Updated:

  • If student fails the EOS, Field 28 updated to SGB (Failed EOS –Lost HOPE Scholarship or Zell Miller Scholarship eligibility)

FIELD 39EOS Status/Term:

Values:P20XX14 = Passed EOS and Term EOS applied

F20XX14 = Failed EOS and Term EOS applied

X20XX14 = EOS Not Needed

FIELD 60End of Spring Eligibility:

No change if:

  • Student passes the EOS Checkpoint
  • Student does not need EOS Checkpoint applied

Updated:

  • If student fails the EOS, Field 60 updated to SGB. (Failed EOS –Lost HOPE Scholarship or Zell Miller Scholarship eligibility.)

FIELD 97 HOPE Scholar Loss – Month and Year student lost HOPE Scholarship eligibility due to a < 3.00 GPA at Checkpoint.

  • Automatically updated as MMYYYY by the End of Spring Term Checkpoint Process, and
  • Manually, as needed, for students with < 3.00 GPA at Checkpoint.

FIELD 99 Zell Miller Scholar Loss – Month and Year student lost Zell Miller Scholarship eligibility due to a <3.30 GPA at Checkpoint.

  • Automatically updated as MMYYYY by the End of Spring Term Checkpoint Process, and
  • Manually, as needed, for students with < 3.30 GPA at Checkpoint.

Scholarship Loss Dates:

Previous New HOPE Sch.Zell Miller

ProcessDescription Status Status Loss DateLoss Date

ZRPTIER / Not Zell Scholar with H% below 3.0 / H% / BG / YES / NO
ZRPTIER / Zell Scholar with Z% below 3.3 / Z% / BG / NO / YES
ZRPTIER / Zell Scholar with H% below 3.0 / H% / BG / YES / YES
ZRPTTCP / Zell Scholar with Z% below 3.3 / Z1 / 3T / NO / YES
ZRPTTCP / Not Zell Scholar with H% below 3.0 / H1 / 3T / YES / NO
ZRPHEOS / Not Zell Scholar with H% below 3.0 / H% / SBG / YES / NO
ZRPHEOS / Zell Scholar with Z% below 3.3 / Z% / SBG / NO / YES
ZRPHEOS / Zell Scholar with H% below 3.0 / H% / SBG / YES / YES

*Above Loss Date determinations for fall 2011 (201212) through spring 2013 (201314). GSFC changed the Loss Date determinations for Zell Miller Scholars losing HOPE Scholarship eligibility effective summer semester 2013 (201316). Change implemented in version 13.3.

Scholarship Loss Dates effective summer semester 2013 (201316):

ZRPTIER / Not Zell Scholar with H% below 3.0 / H% / BG / YES / NO
ZRPTIER / Zell Scholar with Z% below 3.3 / Z% / BG / NO / YES
ZRPTIER / Zell Scholar with H% below 3.0 / H% / BG / YES / NO
ZRPTTCP / Zell Scholar with Z% below 3.3 / Z1 / 3T / NO / YES
ZRPTTCP / Not Zell Scholar with H% below 3.0 / H1 / 3T / YES / NO
ZRPHEOS / Not Zell Scholar with H% below 3.0 / H% / SBG / YES / NO
ZRPHEOS / Zell Scholar with Z% below 3.3 / Z% / SBG / NO / YES
ZRPHEOS / Zell Scholar with H% below 3.0 / H% / SBG / YES / NO

Reports:

Two files are generated from the ZRPHEOS process. These files can be emailed to the valid email address entered in Parameter 04 or may be retrieved from the /u02/jobsub/PROD/gurjobsdirectory.

Reports are located in the user’s home directory.

  1. zprheos_xxxxxx.lis: This file contains a list of students that were EOS checked.
  2. zrpheos_xxxxxx.err: This file contains a list of students that have invalid data in ROAUSDF:
  • Field 27 (Overall GPA).
  • Field 41 (Summer Attempted Hours)
  • Field 46 (Fall Attempted Hours)
  • Field 56 (Spring Attempted Hours)

Review this file to ensure no errors exist. If the file has errors, the processdid not run. All errors must be resolved before ZRPHEOS will complete.

Technical Support:

If you have additional questions or problems running this process, please contact the TCSG Data Center by emailing the Help Desk at .

ZRPHEOS - End of Spring Checkpoint v18.5 02/2018Page 1