Lori Burnette DPR Last updated October 10 2017 Data Center Provided SFA Processes ZRPGSFC GSFAPPS ImportExport Process ZRAGSFC GSFAPPS Application Form ZRRPDHR HOPE Paid Hours Calc ID: 675972
Download Presentation The PPT/PDF document "State Financial Aid Program Processing" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
State Financial Aid Program Processing
Lori Burnette, DPR
Last updated: October 10, 2017Slide2
Data Center Provided SFA Processes
ZRPGSFC – GSFAPPS Import/Export Process
ZRAGSFC – GSFAPPS Application Form
ZRRPDHR – HOPE Paid Hours Calc ProcessZRPINVE – GSFC HOPE INVOICING PROCESSHOPE Grant GPA:ZRACTRL – GSFC Control Form ZRPHPRC - HOPE Grant GPA Student ProcessZRRHDSC - HOPE Grant GPA DiscrepanciesZRRHGPA - HOPE Grant GPA ReportZRAGRNT - HOPE Grant GPA FormHOPE Scholarship:ZRPTIER - HOPE SCHOLARSHIP TIER TRACKING PROCESS HOPE Scholarship and Zell Miller Scholarship eligibility determination at 30, 60, 90 hour checkpoints)ZRPTTCP - HOPE SCHOLARSHIP THREE TERM CHECKPOINT PROCESS (Tier 1 HOPE Scholarship and Zell Miller Scholarship eligibility determination at 3 term checkpoint) ZRPHEOS - END OF SPRING TERM CHECKPOINT PROCESS (HOPE Scholarship and Zell Miller Scholarship eligibility determination at end of spring term checkpoint)ZRRHREV - HOPE SCHOLARSHIP Review Report (Identifies students’ with a change in eligibility between HOPE Scholarship and Zell Miller Scholarship)ZRPROLL – HOPE AID YEAR ROLLOVER PROCESS
2Slide3
State Aid Processing Documentation
Documentation for Financial
Aid Processes can be found on the KMS website
at https://kms.tcsg.edu/DPR/AppSupport/RefMaterials.aspx . A password is not required to access the instructional documents on KMS. Simply select from the list of Reference Materials.3Slide4
State Aid Processing Documentation
4Slide5
Data Center Helpdesk
For questions or problem resolution, please
contact the TCSG Data Center by emailing the Help Desk at
datacenter@tcsg.edu .5Slide6
Agenda Items
ZRPGSFC:
GSFAPPS
Import/Export ProcessBanner form: ZRAGSFC – GSFAPPS ApplicationGrant GPAGrant GPA DiscrepanciesBanner form: ZRAGRNT – HOPE Grant GPAScholarship Tier TrackingZRPTIER: HOPE Scholarship Tier TrackingZRPTTCP: HOPE Scholarship Three Term CheckpointZRPHEOS: HOPE Scholarship End of Spring CheckpointZHRHREV: HOPE Scholarship Review ReportZRPROLL: HOPE Aid Year Rollover ProcessZRRPDHR: HOPE Paid Hours Calc ProcessBanner form: ZRAGSFC – GSFAPPS ApplicationZRPINVE: GSFC HOPE Invoicing Process6Slide7
ZRPGSFC:
GSFAPPS IMPORT/EXPORT PROCESS
7Slide8
ZRPGSFC
GSFAPPS Import/Export Process
Banner process that allows colleges to create student files from their Banner system and upload those student files to GSFC. This same process then allows colleges to import the GSFC return files back into their Banner system.
8Slide9
ZRPGSFC
GSFAPPS Import/Export Process
The data received from GSFC includes GSFAPPS application data, GSFC eligibility checks, and Paid Hours information for each student in the file
. 9Slide10
ZRPGSFC - Parameters
10Slide11
ZRPGSFC - Parameters
01
Aid Year Code
Current Aid Year Code – example 151602(I)Import GAD or (E) Export GAUI or EI – Import GSFC Download File (GAD). E – Export/Create GSFC Upload File (GAU)03Export Run ModeRequired if Parameter 02 = E. Valid Values: P, A, RP - Population Selection. A- Admissions, R – Registration. This parameter allows you to select more than one option for your GAU file creation. For more than one option, you must select ‘Record’ ‘Insert’ to insert a new line for Parameter 03. See below instructions.04ApplicationRequired if Parameter 03 = PFor Export Run Mode (Parameter 03) = P (Population Selection), enter the Application for the Population Selection – example FINAID 05Selection IDRequired if Parameter 03 = PFor Export Run Mode (Parameter 03) = P (Population Selection), enter the Selection ID (Name of the Population Selection) 06Creator IDRequired if Parameter 03 = PFor Export Run Mode (Parameter 03) = P (Population Selection), enter the Creator ID of the Population Selection07User IDRequired if Parameter 03 = PFor Export Run Mode (Parameter 03) = P (Population Selection), enter the User ID of the Population Selection 08Term codeRequired if Parameter 03 = A, RFor Export Run Mode (Parameter 03) = A (Admissions) or R (Registered) enter the Term Code (example: 201212) This parameter allows you to select more than one Term Code for your GAU file creation. You must select ‘Record’
‘Insert’ to insert a new line for Parameter 08. See below instructions.
Term code must exist in aid year entered into Parameter 01 (edit added in v.12.1). No output file is generated for aid year/term code mismatch.
09
Email Address
Not Required, but Recommended
Enter User Name for GAU and all output reports 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
jsmith@albanytech.edu
, then Johnnie would enter
jsmith
for Parameter 09.
11Slide12
Parameter 03: Export Run
Mode
GAUnnn.TXT from
your college’s Banner system may be created from any of the following three (3) Export Run Mode options: (P) Population Selection (A) Admission - New Applicants/Re-Admits for a term (R) Registered - Students that are or were registered for the term. You can choose one Export Run option to create your batch file or multiple Export Run options. Parameter 08: Term CodeYou can enter one Term Code for your GAU file creation or you may select multiple Term Codes. For Export Run Options: (A) Admissions and (R) Registered, you may select multiple Term Codes.ZRPGSFC - Parameters12Slide13
ZRPGSFC: Export Mode - Output
Two
files are created
and can be emailed to the valid email address entered.zrpgsfc_xxxxxx.lis –This file provides the user with a total number of records generated in the GAUnnn.TXT file. Emailed to valid email address or retrieved from /u02/jobsub/PROD/gurjobs directory. GAUnnn.TXT file – This is the batch file containing student records. The file is emailed to the user or can be retrieved from the /u01/app/banner/dataload/finaid directory. 13Slide14
SURFER: User Guides
14Slide15
GSFC Provided: GAU File Layout
15Slide16
ZRPGSFC: Export Mode (GAU File)
Uploading file to GSFC (GAUnnn.TXT):
Move the file to your PC.
If file is an email attachment, you will need to save the file to your PC.If retrieving the GAU from the /u01/app/banner/dataload/finaid directory, you must FTP the GAUnnn.TXT file to your PC. (Please consult with your local tech support if you need assistance with the ftp process.) Log into SurferSelect ‘Upload File’Browse to the GAUnnn.TXT file on your PC and select the GAUnnn.TXT fileSelect ‘Upload File’GSFC will process the GAUnnn.TXT file and return the GADnnn.TXT file to your Surfer Inbox for retrieval. 16Slide17
Processing the Download File (GADnnn.TXT
):
Once
GSFC has finished processing the GAU file, they will load the GADnnn_ xxxxxxxxxxxx.TXT file into your SURFER Inbox. You must download this file to your PC and then FTP it to the /u01/app/banner/dataload/finaid directory on the Banner database server. ZRPGSFC: Import Mode (GAD File)17Slide18
SURFER: User Guides
18Slide19
GSFC Provided: GAD File Layout
(108 data fields in GAD File)
19Slide20
ZRPGSFC: Import Mode (GAD File)
20Slide21
Note:
GAU
and GAD files are
deleted from the /u01/app/banner/dataload/finaid directory by the import process. ZRPGSFC: Import Mode (GAD File)21Slide22
The
import process creates
up to seven (7) reports
in the /u02/jobsub/PROD/gurjobs directory. The reports are also emailed to the email address entered in Parameter 09. ZRPGSFC: Import Mode - Output22Slide23
zrpgsfc_xxxxxx.lis
: This report provides a total count of the number of records processed and added from the load process
.
zprgsfc_xxxxxx_cap_hours.lis: This report provides a listing of students that have exceeded the Grant or Scholarship Paid Hours limit or that are approaching the limits. Scholarship – Students with a minimum of 112 Semester Paid Hours or a minimum of 112 Semester Attempted Hours are on report.Grant – Students with a minimum of 48 Semester Paid Hours are on report.zprgsfc_xxxxxx_changes.lis: This report lists any student that was added or modified during the load process that day.zrpgsfc_xxxxxx.log: Primary information is located at the bottom of report. Sample successful load results are displayed at the bottom of the report: Total logical records skipped: 0 Total logical records read: 5626 Total logical records rejected: 0 Total logical records discarded: 0 IMPORTANT: If any records are skipped, rejected, or discarded a zrpgsfc_xxxxxx.BAD file will be generated. If the zrpgsfc_xxxxxx.log report indicates any records were skipped, rejected, or discarded, please notify the Data Center at datacenter@tcsg.edu . The process will not import skipped, rejected, or discarded records. See zrpgsfc_xxxxxx.BAD file details.ZRPGSFC: Import Mode - Output23Slide24
zrpgsfc_xxxxxx.BAD file
: This report lists any student that the process skipped, rejected, or discarded.
This report is only generated if a student is not loaded during the process.
zrpgsfc_xxxxxx_invalid_number.lis: This report provides a list of students that have invalid data in User Defined Fields 23 and/or 73. NOTE: Review this report before proceeding. If this file contains errors, the load process did not complete. You must correct the errors in the file and then try to load the GADnnn.TXT file again. zrpgsfc_xxxxxx_lost.lis: This report provides two lists of students for the aid year. Note: This report identifies students meeting the below criteria for the aid year. Report is not limited to students in the GAD file.Students with a HOPE Scholarship eligible Tier Code and two HOPE Scholarship loss dates for the aid year. Students on report should be reviewed and the Tier Code updated to ‘LH’ (‘HOPE Scholarship Two Losses’).Students with a Zell Miller Scholarship eligible Tier Code and two Zell Miller Scholarship loss dates for the aid year. Students on report should be reviewed and the Tier Code updated to ‘LZ’ (‘Zell Miller Scholarship Two Losses’).ZRPGSFC: Import Mode - Output24Slide25
ZRAGSFC – Banner form
The ZRPGSFC import process updates the ZRAGSFC Banner form.
ZRAGSFC – Contains Application, Eligibility, and Accumulated Hours (Semester) data.
25Slide26
ZRAGSFC: Hours tab
26Slide27
ZRAGSFC: Application Details tab
27Slide28
ZRAGSFC: GSFC Eligibility tab
28Slide29
ZRBGSFC: Banner Table
ZRBGSFC_SEQ_NO
NOT NULL
NUMBER(4)ZRBGSFC_RECORD_TYPENOT NULLVARCHAR2(2 CHAR)ZRBGSFC_SSNVARCHAR2(9 CHAR)ZRBGSFC_STUDENT_IDNOT NULLVARCHAR2(10 CHAR)ZRBGSFC_PIDMNOT NULLNUMBER(10)ZRBGSFC_AIDY_CODENOT NULLVARCHAR2(4 CHAR)ZRBGSFC_CURR_REC_INDVARCHAR2(1 CHAR)ZRBGSFC_SELECTIVE_SERVICEVARCHAR2(1 CHAR)ZRBGSFC_DEFAULT_OWE_REFUNDVARCHAR2(1 CHAR)ZRBGSFC_DOB_MATCHVARCHAR2(1 CHAR)ZRBGSFC_ALIEN_STATUSVARCHAR2(2 CHAR)ZRBGSFC_DRUG_CONVICTIONVARCHAR2(1 CHAR)ZRBGSFC_STATE_OF_RESIDENCEVARCHAR2(2 CHAR)ZRBGSFC_DATE_OF_RESIDENCY
VARCHAR2(8 CHAR)
ZRBGSFC_SSN_DEATH_MATCH
VARCHAR2(1 CHAR)
ZRBGSFC_DEPENDENCY_STATUS
VARCHAR2(1 CHAR)
ZRBGSFC_GA_DRIVERS_LICENSE
VARCHAR2(1 CHAR)
ZRBGSFC_GA_INCOME_TAX
VARCHAR2(1 CHAR)
ZRBGSFC_OFAC_CHECK
VARCHAR2(1 CHAR)
ZRBGSFC_ACTIVE_MILITARY
VARCHAR2(1 CHAR)
ZRBGSFC_MIL_HOME_OF_RECORD
VARCHAR2(1 CHAR)
ZRBGSFC_CREDIT_BUR_SSN_MATCH
VARCHAR2(1 CHAR)
ZRBGSFC_HOPE_APP
VARCHAR2(1 CHAR)
ZRBGSFC_HOPE_APP_STATUS
VARCHAR2(2 CHAR)
ZRBGSFC_HOPE_APP_ERRORS
VARCHAR2(40 CHAR)
ZRBGSFC_GOV_APP
VARCHAR2(1 CHAR)
ZRBGSFC_GOV_APP_STATUS
VARCHAR2(2 CHAR)
ZRBGSFC_GOV_APP_ERRORS
VARCHAR2(40 CHAR)
ZRBGSFC_PUB_SAFE_APP
VARCHAR2(1 CHAR)
ZRBGSFC_PUB_SAFE_APP_STATUS
VARCHAR2(2 CHAR)
ZRBGSFC_PUB_SAFE_APP_ERRORS
VARCHAR2(40 CHAR)
ZRBGSFC_LAW_APP
VARCHAR2(1 CHAR)
ZRBGSFC_LAW_APP_STATUS
VARCHAR2(2 CHAR)
ZRBGSFC_LAW_APP_ERRORS
VARCHAR2(40 CHAR)
ZRBGSFC_GA_HERO_APP
VARCHAR2(1 CHAR)
ZRBGSFC_GA_HERO_APP_STATUS
VARCHAR2(2 CHAR)
ZRBGSFC_GA_HERO_APP_ERRORS
VARCHAR2(40 CHAR)
ZRBGSFC_PRELIM_HOPE_SCHOLAR
VARCHAR2(1 CHAR)
ZRBGSFC_FINAL_HOPE_SCHOLAR
VARCHAR2(1 CHAR)
ZRBGSFC_GRANT_QUARTER_HOURS
NUMBER(6)
ZRBGSFC_SCHOL_QUARTER_HOURS
NUMBER(6)
ZRBGSFC_ACCEL_QUARTER_HOURS
NUMBER(6)
ZRBGSFC_TOTAL_QUARTER_HOURS
NUMBER(6)
ZRBGSFC_ELIGIBLE_GRANT_OVER
VARCHAR2(1 CHAR)
ZRBGSFC_ELIGIBLE_SCHOL_OVER
VARCHAR2(1 CHAR)
ZRBGSFC_DATE_RECEIVED
DATE
ZRBGSFC_LAST_UPDATE
DATE
ZRBGSFC_APPROVAL_DATE
DATE
ZRBGSFC_APP_STATUS_CODE
VARCHAR2(2 CHAR)
ZRBGSFC_ACTIVITY_DATE
DATE
ZRBGSFC_GRANT_ELIGIBLE
VARCHAR2(1 CHAR)
ZRBGSFC_SCHOLARSHIP_ELIGIBLE
VARCHAR2(1 CHAR)
ZRBGSFC_GRANT_SEMESTER_HOURS
NUMBER
ZRBGSFC_SCHOL_SEMESTER_HOURS
NUMBER
ZRBGSFC_ACCEL_SEMESTER_HOURS
NUMBER
ZRBGSFC_TOTAL_SEMESTER_HOURS
NUMBER
ZRBGSFC_HS_DATE_MATCH
VARCHAR2(6 CHAR)
ZRBGSFC_HS_DATEVARCHAR2(6 CHAR)ZRBGSFC_EXPIRATION_DATEVARCHAR2(6 CHAR)ZRBGSFC_BACHELOR_FLAGVARCHAR2(1 CHAR)ZRBGSFC_ZELL_FLAGVARCHAR2(1 CHAR)ZRBGSFC_HOPE_LOST_1VARCHAR2(6 CHAR)ZRBGSFC_HOPE_LOST_2VARCHAR2(6 CHAR)ZRBGSFC_ZELL_LOST_1VARCHAR2(6 CHAR)ZRBGSFC_ZELL_LOST_2VARCHAR2(6 CHAR)ZRBGSFC_ZELL_SMT_HOURSNUMBERZRBGSFC_ZELL_QTR_HOURSNUMBER
29Slide30
Banner: Help/Dynamic Help Query
30Slide31
ZRAGSFC: Application Details tab – Field Lookup
31Slide32
ZRRPHRS: Banner Table
ZRRPHRS_PIDM
NOT NULL
NUMBER(10)ZRRPHRS_AIDY_CODENOT NULLVARCHAR2(4 CHAR)ZRRPHRS_CURR_REC_INDNOT NULLVARCHAR2(1 CHAR)ZRRPHRS_ACTIVITY_DATENOT NULLTIMESTAMP(6)ZRRPHRS_GRANT_TOT_PD_HRSNUMBERZRRPHRS_SCHOL_TOT_PD_HRSNUMBERZRRPHRS_ACCEL_TOT_PD_HRSNUMBERZRRPHRS_ZELL_TOT_PD_HRSNUMBERZRRPHRS_TOT_PD_HRSNUMBER32Slide33
Banner: Help/Dynamic Help Query
33Slide34
ZRAGSFC: Hours tab – Field Lookup
34Slide35
Questions?
35Slide36
Grant GPASlide37
The
HOPE/Zell Miller
Grant Grade Point Average (GPA) calculation is cumulative of all
coursework (excluding Learning Support and Dual Enrollment coursework) beginning with summer term 2003 (Banner term code: 200401). Credit Hours for which a student received HOPE Grant or Zell Miller Grant payment at a prior institution (with the exception of Learning Support and Dual Enrollment) count in determining the student’s 30 and 60 hour Checkpoints and in the GPA calculation.Grant GPA37Slide38
Grant GPA: Dual and Joint Enrollment
Dual Enrollment
Included in Paid HoursInclude hours in Checkpoint Progression?Include in Checkpoint GPA?Summer 2003NoNoNoFall 2003NoNoNoWinter 2004NoNoNoSpring 2004NoNoNoSummer 2004NoNoNoFall 2004 – Spring 2008YesNoNoSummer 2008 - CurrentNo
No
No
Joint Enrollment
Included in Paid Hours
Include hours in Checkpoint Progression?
Include in Checkpoint GPA?
Summer 2003
No
No
No
Fall 2003
No
No
No
Winter 2004
No
No
No
Spring 2004
No
No
No
Summer 2004
No
No
No
Fall 2004 – Spring 2008
Yes
Yes
Yes
Summer 2008 - Current
Yes
Yes
Yes
38Slide39
Grant GPA: Learning Support
Learning Support
Definition includes remedial
coursework and coursework chosen by the student that does not count toward program requirements for the Diploma, Certificate or Degree the student is seeking. (Course registration status code: ‘KO’, ‘OA’, ‘OW’, ‘OF’, ‘OI’, ‘OM’, and ‘OP’) Included in Paid HoursInclude hours in Checkpoint Progression?Include in Checkpoint GPA?Summer 2003YesNoNoFall 2003YesNoNoWinter 2004YesNoNoSpring 2004YesNoNoSummer 2004YesNoNoFall 2004 – Spring 2008YesNoNoSummer 2008 - CurrentYes
No
No
39Slide40
Grant GPA: > Full-Time Enrollment
Greater Than Full-Time Enrollment
Included in Paid HoursInclude hours in Checkpoint Progression?Include in Checkpoint GPA?Summer 2003 (200401) – Fall 2008 (200902)Maximum of 12 hrsMaximum of 12 hrsAll hrs included (excluding LS and DE)Winter 2009 (200903) - CurrentMaximum of 15 hrsMaximum of 15 hrsAll hrs included (excluding LS and DE)40Slide41
Grant GPA – Overall Procedure
Through a combination of data retrieved
from
GSFC and the Banner systems of the TCSG colleges (MIS data), the HOPE Grant GPA is calculated. The data received from GSFC is for all students who received HOPE Grant or Zell Miller Grant at a TCSG College for all terms beginning summer 2003 (200401). The data retrieved from the Banner systems of the TCSG colleges (MIS data) includes the term and course data, course GPA hours, and grades. 41Slide42
Grant GPA – Status Codes
ELIGIBLE STATUS
TIER
DESCRIPTIONDETAILSEligibleGXExempt from 1st Checkpoint (> 30 Hours Prior to Fall 2011) Student has more than 30 hours prior to Fall 2011 and has not reached the 60 hour checkpoint.EligibleG0Eligible - Not reached 1st Checkpoint (0 - 29 hours) Student has not reached 30 Hour Checkpoint.EligibleG1Eligible – 30 Hour Checkpoint (30 - 59 hours)Student is eligible at 30 Hour Checkpoint. EligibleG2Eligible – 60 Hour Checkpoint (60 - 63 hours)Student is eligible at 60 Hour Checkpoint.EligibleG6Eligible – 60 Hour Checkpoint (Regained eligibility)Student regained eligibility at 60th Attempted Hour Checkpoint. EligibleG7Previous N1 (>=2.0 Prior to Fall 2013)Student has at least 2.0 at most recent term prior to Fall 2013. Student lost eligibility at 30 Hour Checkpoint (N1 status) and has not yet reached 60 Hour Checkpoint.Eligible G8Previous N2 (>= 2.0 Prior to Fall 2013)Student has at least 2.0 at most recent term prior to Fall 2013. Student lost eligibility at 60 Hour Checkpoint (N2 status).
Not Eligible
N1
Not Eligible -30 Hour Checkpoint (30 - 59 hours)
Student lost eligibility at 30 Hour Checkpoint. May regain eligibility at 60 Hour Checkpoint.
Not Eligible
N2
Not Eligible – 60 Hour Checkpoint (60 - 63 hours)
Student lost eligibility at 60 Hour Checkpoint. Cannot regain eligibility.
Not Eligible
MX
Maxed – Student reached max Paid Hours
Student in no longer HOPE eligible due to reaching maximum Paid Hours Cap.
42Slide43
ZRACTRL – Banner Form
ZRACTRL
(Banner form) – Stores grade dates and automated email contact information.
43Slide44
ZRACTRL – Banner Form
Grades Processing Date
:
On the date entered for the term, the HOPE Grant GPA process will pick up all courses and grades for HOPE Grant students. This date should be at least one day after grades are rolled to academic history for the term. If a student does not have grades rolled to academic history for all courses for the term, the process will skip the student until he/she has grades for all courses for the term. This date cannot be changed on or after the date.Email information: Contacts will receive automated email notifications associated with Grant GPA processing.44Slide45
Grant GPA – Routine Processing
The Data Center receives an updated file from GSFC on the 1
st
and 3rd weekend each month. The GSFC file contains updated HOPE Grant and Zell Miller Grant Paid Hours data for all students.45Slide46
Grant GPA – Daily Processing
The following students are automatically extracted from each college’s Banner system and processed for the HOPE Grant GPA calculation:
All students with current or future term admissions application.
(Note: Receipt of admissions application only, official admittance is not required for this process.) All students with current or future term registration.All students with HOPE Grant awarded for the current or future aid year. Students are extracted from college Banner systems at 9:00 p.m. daily and processed the next morning. Results are loaded back into college Banner systems at approximately 10:15 a.m. (Later at peak processing times.)46Slide47
ZRPHPRC –
HOPE Grant GPA Student Process
ZRPHPRC is the Banner process that allows colleges to create a request list of students
or an individual student from their Banner system for the HOPE Grant GPA calculation. Note: This process should be used for exception processing only. If you are unable to receive the Grant GPA information on a student then you may use this process to request the information.47Slide48
ZRPHPRC – HOPE Grant GPA Student Process
48Slide49
Grant GPA
The GPA process will perform one of the following actions for each student:
Discrepant or missing information exists
: Any discrepant or missing information errors on a student will prevent the calculation of the HOPE Grant GPA. Detailed information on the discrepant/missing information errors (terms where Grant Paid Hours and academic history do not match) will be loaded into the requesting college’s Banner form ZRAGRNT- HOPE Grant GPA Update tab. Manual entry must be performed to resolve discrepant and/or missing information errors. (Manual updates will be automatically extracted from each college’s Banner system each morning.) No discrepant or missing information exists: The HOPE Grant GPA, eligibility status, and all course details will be loaded into the requesting college’s Banner system. (Banner form ZRAGRNT – HOPE Grant GPA Inquiry tab). 49Slide50
ZRRHDSC:
HOPE
Grant GPA Discrepancies
50Slide51
ZRRHDSC:
HOPE Grant GPA Discrepancies
ZRRHDSC is
the Banner process that creates a report of students (in college name, student name, or student ID order) with:Missing informationReason: ‘No course data found’ Discrepant information Reason: ‘Total Hours do not match’, or ‘Ineligible course status (KO, OA, OW, OF, OI, OM, OP, EX, AU, TR, AC) Students on this report will not have a Grant GPA calculated. 51Slide52
ZRRHDSC:
HOPE Grant GPA Discrepancies
The students listed on the ZRRHDSC report are reflected on Banner form ZRAGRNT, under the ‘HOPE Grant GPA Discrepancies’ tab. Data entry to resolve errors must be performed in the bottom section of this tab.
52Slide53
ZRRHDSC: Parameters
53Slide54
ZRRHDSC:
Parameters
01
Sort OrderRequired.Valid Values: C, N, IC = College name, N = Student Name, I = Student ID02Email User NameNot Required, but RecommendedEnter 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 jsmith@albanytech.edu, then Johnnie would enter jsmith for Parameter 02.03Print ModeRequired. Valid Values: P, A, RP - Population Selection. A- Admissions, R – Registration, NOTE: You may select one Print Mode option only.04Term CodeRequired For Print Mode (Parameter 03) = A (Admissions), or R (Registered) enter the Term Code (example: 201212) for student selection. For Print Mode P – Population Selection, enter the current term code. NOTES: You may select one Term code only. Term code is required, but the process ignores the term code for Print Mode P. 05ApplicationRequired if Parameter 03 = PFor Print Mode (Parameter 03) = P (Population Selection), enter the Application for the Population Selection – example FINAID 06Selection IDRequired if Parameter 03 = PFor Print Mode (Parameter 03) = P (Population Selection), enter the Selection ID (Name of the Population Selection) 07Creator IDRequired if Parameter 03 = PFor Print Mode (Parameter 03) = P (Population Selection), enter the Creator ID of the Population Selection
08
User ID
Required if Parameter 03 = P
For Print Mode (Parameter 03) = P (Population Selection), enter the User ID of the Population Selection
09
Create Excel File?
Required.
Valid Values: Y, N
Y = Yes, Create Excel formatted file. This will create a zrrhdsc_xxxxxx.txt file. (comma delimited file). See next page for Excel file assistance.
N = No, Do not create file. Only a
zrrhdsc_xxxxxx.lis
file will be created.
54Slide55
ZRRHDSC: Output
The following are generated in the
/
u02/jobsub/PROD/gurjobs directory:ZRRHDSC_xxxxxx.lis report ZRRHDSC_xxxxxx.txt fileThe report and file are also emailed to the valid email address entered into Parameter 02. 55Slide56
ZRRHDSC: Output
Sample:
Date: 28-OCT-15 Test Instance Time: 11:10:27 AM
ZRRHDSC - HOPE Grant GPA Discrepancies The following students have HOPE Grant GPA Discrepancies on ZRAGRNT: ID SSN Name Year T Hrs Q/S OPEID School Name Reason --------- --------- -------------- ---- - --- --- ------ -------------------------- ------------ 90009876 123456789 Frank Arthur 2010 4 13 Q 010487 LANIER TECHNICAL COLLEGE Total Hours do not match 90012345 987654321 Meagan Beck 2010 2 13 Q 003956 DALTON STATE COLLEGE No course data found Total Number of Students: ------------------------- 2 The report includes the following information:IDSocial Security NumberNameYear: GSFC award yearT= Term: 1 = Summer, 2 = Fall, 3 = Winter, 4 = SpringHrs: GSFC Grant Paid Hours for the termQ/S: Q= Quarter, S = SemesterOPEID: School code on file at GSFCSchool NameReason: Total Hours do not match, No Course data found56Slide57
Grant GPA Discrepancies:No Course Data Found
This error message will display if the student has Surfer Paid Hours for a term and no corresponding MIS hours (course history for term).
Course
details must be entered into Banner form, ZRAGRNT, (bottom of 2nd tab, HOPE Grant GPA Update section) to update Grant MIS data. 57Slide58
Grant GPA Discrepancies:No Course Data Found
Possible cause 1
: Prior attendance at a USG college and HOPE Grant received from the USG College. (USG College information is not included in MIS collection.)
Resolution: Update Banner form, ZRAGRNT, (bottom of 2nd tab, HOPE Grant GPA Update section) with course(s) paid for by HOPE Grant. 58Slide59
Grant GPA Discrepancies:No Course Data Found
Possible cause 2
: Prior attendance at a TCSG college and HOPE Grant received from the college but no MIS data exists. This can occur if the awarding college had an unresolved MIS error which prevented the student’s enrollment from being collected for the term.
Resolution: Update Banner form, ZRAGRNT, (bottom of 2nd tab, HOPE Grant GPA Update section) with course(s) paid for by HOPE Grant. 59Slide60
Grant GPA Discrepancies:No Course Data Found
Possible cause 3
: Student received HOPE Book payment only for the term. No coursework with a grade exists for the term.
Resolution: Update Banner form, ZRAGRNT, (bottom of 2nd tab, HOPE Grant GPA Update section) with course(s) that the HOPE Grant Book award was based on for the term. You must enter the course(s) into ZRAGRNT using grade ‘NA’. 60Slide61
Grant GPA Discrepancies:No Course Data Found
Possible cause 4
: Student received HOPE Grant for the term, dropped all courses, and coursework does not appear on academic transcript.
Prior to summer quarter 2008 (Banner term 200901) colleges were not required to use standardized course registration status codes. Some scenarios may exist where dropped course(s) paid for by HOPE Grant do not appear on the academic transcript. Resolution: Update Banner form, ZRAGRNT, (bottom of 2nd tab, HOPE Grant GPA Update section) with course(s) paid for by HOPE Grant. You must enter the course(s) into ZRAGRNT using grade ‘NA’. 61Slide62
Grant GPA Discrepancies:No Course Data Found
NOTE:
When
entering/updating Learning Support course data into Banner form ZRAGRNT to resolve discrepancies due to ‘No course data found’, DO NOT check the ‘Exclude’ box. When entering the course details for a Learning Support course, enter one of the following grades: A*, B*, C*, D*, F*, I*, W*, WP*, WF*, S, U, NG*, or NA*. The grade will identify the course as a Learning Support class (grades with an asterisk, Satisfactory, or Unsatisfactory).62Slide63
Grant GPA Discrepancies:No Course Data Found
63Slide64
Grant GPA Discrepancies:No Course Data Found
The top section indicates 3 paid hours for Spring Quarter 2004 in Surfer. Since the discrepancy is for a quarter term, you must resolve the discrepancy using quarter hours. Entering the correct course and the correct number of quarter credit hours will resolve the discrepancy.
64Slide65
Grant GPA Discrepancies:Total Hours do not match
Total Hours do not match
– The academic history data used by this process is the data stored in the MIS database compared to the total Grant Paid Hours in
Surfer. 65Slide66
Grant GPA Discrepancies:Total Hours do not match
MIS hours are greater than Surfer hours for the term.
Possible
cause: Student did not receive HOPE for a course taken outside of major. Course not paid for by HOPE should be excluded from Grant GPA. Resolution: Update Banner form, ZRAGRNT, (bottom of 2nd tab, HOPE Grant GPA Update section). Check ‘Exclude’ next to appropriate course.66Slide67
Grant GPA Discrepancies:Total Hours do not match
Surfer Paid
Hours
are greater than MIS hours for the term.Possible cause 1: Overpayment of funds received by college possibly due to late schedule adjustment for term and no corresponding HOPE Grant adjustment. Resolution: Surfer hours must be adjusted by the awarding college. (Return of funds.) 67Slide68
Grant GPA Discrepancies:Total Hours do not match
Surfer Paid Hours are greater than MIS hours for the
term.
Possible cause 2: Student’s HOPE tuition award, fee award, and book award are correct in Surfer, but the Paid Hours in Surfer are incorrect. This can occur if the ROAENRL FA Billing Hours are incorrect for the term which resulted in the incorrect hours being reported to GSFC for the term via the HOPE Invoicing automated process. Resolution: ‘Data Correction Request Form’ available in Surfer must be submitted to GSFC. No monetary adjustments are needed, only Surfer Paid Hours for the term need to be updated. 68Slide69
Grant GPA Discrepancies:Total Hours do not match
Note:
If
the student is enrolled for more than full-time hours (13 or more through fall 2009 (200902) or 16 or more beginning winter 2009 (200903)) Surfer should reflect the actual hours paid for the term even though only 12 or 15 hours, depending on the term, will count toward the student’s Paid Hours Cap. If the student is enrolled in 20 hours, then Surfer needs to reflect 20 hours for the term.69Slide70
Sample GPA Discrepancy
70Slide71
Sample GPA Discrepancy
Checking the ‘Exclude’ box will remove course from GPA calculation. Top section indicates Surfer has 3 paid hours from Athens Tech for Summer 2014. Excluding the course in bottom section will leave 3 hours which resolves discrepancy
.
71Slide72
Grant GPA Discrepancies:
Ineligible course status
The student’s GSFC Paid Hours agree with the total registered hours for the term. The discrepancy exists because a course for that term has a registration status code of ‘KO’, ‘OA’, ‘OW’, ‘OF’, ‘OI’, ‘OM’, or ‘OP’ or a grade of ‘EX’, ‘AU’, ‘TR’, or ‘AC’ (ineligible HOPE Grant statuses)
AND the discrepancy will continue to exist even if the ineligible course is ‘Excluded’.72Slide73
Grant GPA Discrepancies:Ineligible course status
Example:
Student has
13 Paid Hours for a term. Student’s courses for the term are: ENG 101 A 5 BIO 101 A 5 KO SCT 100 C 3 One of the courses has an ineligible course registration status. (Course Status field under the ‘HOPE Grant GPA Update’ tab of ZRAGRNT will display the one of the following if exists: KO, OA, OW, OF, OI, OM, OP, EX, AU, TR, or AC) Resolution: Contact the college where the student received HOPE Grant for the term. If it is determined that the course was coded incorrectly with one of the statuses above you may update the ‘Course Status’ field to ‘RE’. By updating this field, you are indicating that the course was incorrectly coded with an ineligible status.73Slide74
Sample GPA Discrepancy
74Slide75
Sample GPA Discrepancy
Resolution #1:
Student was overpaid and should have received HOPE Grant payment for CMA 100, 8 hours only.
Data Correction Request form correcting paid hours and refund issued. Send form and refund to GSFC. Surfer will be adjusted and discrepancy will be resolved.75Slide76
Sample GPA Discrepancy
Resolution #2:
Student was correctly paid for 14 hours and KO course registration status is incorrect.
Update ZRAGRNT to resolve discrepancy. Update KO to RE.76Slide77
Sample GPA Discrepancy
Updating KO Course Status to RE will cause the course (HCT 100, 6 hours) to be included in the Grant GPA. DO NOT delete the KO code. To resolve discrepancy the KO code must be updated to RE
.
77Slide78
ZRRHGPA:
HOPE
Grant GPA Report
78Slide79
ZRRHGPA: HOPE Grant GPA Report
Banner
process that allows colleges to create a report of students from their Banner system that will display the HOPE Grant GPA, course detail, and eligibility status. The report created by this process can be emailed to the USER.
79Slide80
ZRRHGPA: Parameters
01
Aid Year Code
RequiredCurrent Aid Year Code – example 1516 02Term codeRequired if Parameter 03 = A, R, C(Note: Term code must exist in aid year in Parameter 01, else the following results: “Number of Students: 0”.)For Run Mode (Parameter 03) = A (Admissions), R (Registered), or C (Checkpoint Term) enter the Term Code (example: 201612). This parameter allows you to select more than one Term Code. You must select ‘Record’ ‘Insert’ to insert a new line for Parameter 02. See page 7 of this document for additional instructions. Note: Term code is required for all run modes, but is used for run modes: A, R, and C only.03Run ModeRequired. Valid Values: P, A, R, F, C, SP - Population Selection. A- Admissions, R – Registration, F – Financial Aid (F – All students with HOPE Grant awarded for aid year), C- Checkpoint (C-All students with eligibility determined at end of term(s)), S – Single ID (S – Single student). This parameter allows you to select more than one option for your student requests. For more than one option, you must select ‘Record’ ‘Insert’ to insert a new line for Parameter 03. See page 7 of this document for additional instructions.04ApplicationRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the Application for the Population Selection – example FINAID 05Selection IDRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the Selection ID (Name of the Population Selection) 06Creator IDRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the Creator ID of the Population Selection07User IDRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the User ID of the Population Selection 08
Email Address
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
jsmith@albanytech.edu
, then Johnnie would enter
jsmith
for Parameter 08.
09
Student ID
Required if Parameter 03 = S
For Run Mode (Parameter 03) = S (Student ID), enter the student’s ID number. (Example: 900012345)
10
Report Type
Required.
Valid Values: S, D
S – Summary Mode (GPA) – provides the last checkpoint and current eligibility status for student(s). D – Detail Mode (GPA and Courses) – provides the last checkpoint, current eligibility status, and course details for student(s).
80Slide81
ZRAGRNT: HOPE Grant GPA
81Slide82
ZRAGRNT:
HOPE Grant GPA Inquiry tab
82Slide83
ZRAGRNT:
HOPE
Grant
GPA Discrepancies tab83Slide84
ZRAGRNT: Grade Changes tab
Any grade change from past five years is identified daily and new grade is incorporated into the Grant GPA automatically.
84Slide85
ZRAGRNT:
University System of GA – N1 Courses
Any diploma or certificate level coursework taken by a student attending a University System of Georgia institution during a term that the student was ineligible for the HOPE Grant due to a below 2.0 Grant GPA at the 30 Hour Checkpoint (N1 status) should be entered into this tab. The coursework entered into this tab is coursework that would have normally been paid for by HOPE Grant (excluding Learning Support and Dual Enrollment) had the student met all HOPE Grant requirements. Coursework will be incorporated into the student’s HOPE Grant GPA and used to determine if student regains eligibility at 60
th Attempted Hour Checkpoint.85Slide86
Grant GPA Banner Tables and ViewSlide87
Grant GPA: Banner Tables
Grant GPA Course Data:
ZRAGRNT - 'HOPE Grant GPA Inquiry' tab NameNull?TypeZRRFIND_PIDMNOT NULLNUMBER(10)ZRRFIND_TERM_CODENOT NULLVARCHAR2(6 CHAR)ZRRFIND_GSFC_OPEID_CODENOT NULLVARCHAR2(8 CHAR)ZRRFIND_GSFC_SCHOOL_NAMENOT NULLVARCHAR2(100 CHAR)ZRRFIND_SUBJ_CODENOT NULLVARCHAR2(5 CHAR)ZRRFIND_CRSE_NUMBNOT NULLVARCHAR2(5 CHAR)ZRRFIND_CRN VARCHAR2(5 CHAR)ZRRFIND_CREDIT_HOURSNOT NULLNUMBER(5,2)ZRRFIND_GRDE_CODENOT NULLVARCHAR2(3 CHAR)ZRRFIND_QUALITY_POINTSNOT NULLNUMBER(6,2)
ZRRFIND_ACTIVITY_DATE
NOT NULL
DATE
ZRRFIND_CURR_REC_IND
NOT NULL
VARCHAR2(1 CHAR)
ZRRFIND_SEQ_NO
NOT NULL
NUMBER(3)
ZRRFIND_FISCAL_YEAR
NOT NULL
VARCHAR2(4 CHAR)
ZRRFIND_LOAD_ID
VARCHAR2(8 CHAR)
ZRRFIND_GPA_IND
NOT NULL
VARCHAR2(1 CHAR)
ZRRFIND_CHCK_IND
NOT NULL
VARCHAR2(1 CHAR)
ZRRFIND_DE_IND
VARCHAR2(1 CHAR)
ZRRFIND_Q_OR_S
NOT NULL
VARCHAR2(1 CHAR)Slide88
Grant GPA: Banner Tables
Grant GPA Discrepancy
Data: (top section of tab)
ZRAGRNT - 'HOPE Grant GPA Discrepancies' tab NameNull?TypeZRRNFND_PIDMNOT NULLNUMBER(10)ZRRNFND_TERM_NUMBERNOT NULLVARCHAR2(1 CHAR)ZRRNFND_FISCAL_YEARNOT NULLVARCHAR2(4 CHAR)ZRRNFND_GSFC_OPEID_CODENOT NULLVARCHAR2(8 CHAR)ZRRNFND_GSFC_SCHOOL_NAMENOT NULLVARCHAR2(100 CHAR)ZRRNFND_NET_HOURSNOT NULLNUMBER(5,2)ZRRNFND_ACTIVITY_DATENOT NULLDATEZRRNFND_Q_OR_SNOT NULLVARCHAR2(1 CHAR)ZRRNFND_REASONNOT NULLVARCHAR2(50 CHAR)ZRRNFND_LOAD_ID
VARCHAR2(8 CHAR)Slide89
Grant GPA: Banner Tables
Grant GPA Discrepancy Resolution :
(User
input) ZRAGRNT - 'HOPE Grant GPA Discrepancies' Tab NameNull?TypeZRRCRSE_PIDMNOT NULLNUMBER(10)ZRRCRSE_TERM_NUMBERNOT NULLVARCHAR2(1 CHAR)ZRRCRSE_GSFC_OPEID_CODENOT NULLVARCHAR2(8 CHAR)ZRRCRSE_SUBJ_CODENOT NULLVARCHAR2(5 CHAR)ZRRCRSE_CRSE_NUMBNOT NULLVARCHAR2(5 CHAR)ZRRCRSE_CRN VARCHAR2(5 CHAR)ZRRCRSE_CREDIT_HOURSNOT NULLNUMBER(5,2)ZRRCRSE_GRDE_CODENOT NULLVARCHAR2(3 CHAR)ZRRCRSE_ACTIVITY_DATENOT NULLDATEZRRCRSE_FISCAL_YEARNOT NULL
VARCHAR2(4 CHAR)
ZRRCRSE_EXCLUDE
VARCHAR2(1 CHAR)
ZRRCRSE_USER_ID
NOT NULL
VARCHAR2(30 CHAR)
ZRRCRSE_Q_OR_S
NOT NULL
VARCHAR2(1 CHAR)
ZRRCRSE_LOAD_ID
VARCHAR2(8 CHAR)
ZRRCRSE_CRSE_STATUS
VARCHAR2(2 CHAR)Slide90
Grant GPA: Banner Tables
ZRAGRNT - 'Grade Changes
'
NameNull?TypeZRRGCHG_PIDMNOT NULLVARCHAR2(9 CHAR)ZRRGCHG_OPEID_CODENOT NULLVARCHAR2(8 CHAR)ZRRGCHG_SCHOOL_NAMENOT NULLVARCHAR2(50 CHAR)ZRRGCHG_TERM_CODENOT NULLVARCHAR2(6 CHAR)ZRRGCHG_CRNNOT NULLVARCHAR2(5 CHAR)ZRRGCHG_SUBJ_CODENOT NULLVARCHAR2(5 CHAR)ZRRGCHG_CRSE_NUMBNOT NULLVARCHAR2(5 CHAR)ZRRGCHG_CREDIT_HOURSNOT NULLNUMBER(4,1)ZRRGCHG_OLD_GRDE_CODENOT NULLVARCHAR2(3 CHAR)ZRRGCHG_NEW_GRDE_CODENOT NULLVARCHAR2(3 CHAR)ZRRGCHG_Q_OR_SNOT NULL
VARCHAR2(1 CHAR)
ZRRGCHG_ACTIVITY_DATE
NOT NULL
DATE
ZRAGRNT -
‘University
of GA - N1 Courses
'
Name
Null?
Type
ZRRN1BR_PIDM
NOT NULL
NUMBER(10)
ZRRN1BR_ACADEMIC_YEAR
NOT NULL
VARCHAR2(4 CHAR)
ZRRN1BR_TERM_NUMBER
NOT NULL
VARCHAR2(1 CHAR)
ZRRN1BR_GSFC_OPEID_CODE
NOT NULL
VARCHAR2(8 CHAR)
ZRRN1BR_SUBJ_CODE
NOT NULL
VARCHAR2(5 CHAR)
ZRRN1BR_CRSE_NUMB
NOT NULL
VARCHAR2(5 CHAR)
ZRRN1BR_CREDIT_HOURS
NOT NULL
NUMBER(5,2)
ZRRN1BR_GRDE_CODE
NOT NULL
VARCHAR2(3 CHAR)
ZRRN1BR_ACTIVITY_DATE
NOT NULL
DATESlide91
Grant GPA: Banner Tables
Grant GPA Term Grades Processing Date:
ZRACTRL - 'HOPE Grant GPA Grade Schedule' NameNull?TypeZRRGPAS_AIDY_CODENOT NULLVARCHAR2(4 CHAR)ZRRGPAS_TERM_CODE_GPANOT NULLVARCHAR2(6 CHAR)ZRRGPAS_GRADES_DATENOT NULLDATEZRRGPAS_ACTIVITY_DATENOT NULLDATEGrant GPA Email Recipients: ZRACTRL - 'HOPE Grant GPA Automated Email Recipients' NameNull?TypeZRRGPAE_NAMENOT NULLVARCHAR2(30 CHAR)ZRRGPAE_EMAIL_CODENOT NULLVARCHAR2(50 CHAR)ZRRGPAE_ACTIVITY_DATE
NOT NULL
DATESlide92
Grant GPA: Banner Tables
Grant GPA
30 and 60 Hour Checkpoint Data. (Snapshot of that term.)
ZRAGRNT – ‘HOPE Grant GPA Inquiry’ tab NameNull?TypeZRRCHCK_PIDMNOT NULLNUMBER(10)ZRRCHCK_TERM_CODE_GPANOT NULLVARCHAR2(6 CHAR)ZRRCHCK_PAID_HOURSNOT NULLNUMBER(6,2)ZRRCHCK_GPA_HOURSNOT NULLNUMBER(6,2)ZRRCHCK_TIER_CODENOT NULLVARCHAR2(2 CHAR)ZRRCHCK_ACTIVITY_DATENOT NULLDATEZRRCHCK_CHECKPOINTNOT NULLNUMBER(1)ZRRCHCK_AIDY_CODE VARCHAR2(4 CHAR)Slide93
Grant GPA: Banner Tables
Table: ZRRHGPA
Grant GPA Term by Term GPA Information for students as long as the student in in a 'G' status.(Eligible Tier Codes: GX, G0, G1, G2) NameNull?TypeZRRHGPA_PIDMNOT NULLNUMBER(10)ZRRHGPA_TERM_CODE_GPANOT NULLVARCHAR2(6 CHAR)ZRRHGPA_CHECKPOINT_HOURSNOT NULLNUMBER(6,2)ZRRHGPA_GPA_HOURSNOT NULLNUMBER(6,2)ZRRHGPA_QUALITY_POINTSNOT NULLNUMBER(7,2)ZRRHGPA_GPANOT NULLNUMBER(4,2)ZRRHGPA_CHECKPOINT_TERM VARCHAR2(6 CHAR)ZRRHGPA_TIER_CODENOT NULLVARCHAR2(2 CHAR)ZRRHGPA_ACTIVITY_DATENOT NULLDATEZRRHGPA_CURR_REC_IND
NOT NULL
VARCHAR2(1 CHAR)
ZRRHGPA_SEQ_NO
NOT NULL
NUMBER(3)
ZRRHGPA_AIDY_CODE
VARCHAR2(4 CHAR)Slide94
Grant GPA: Banner Tables
Table: ZRRN1TK
Tracks the Grant GPA information for students in N1, N2, and G7 status. G7 students may lose eligibility at 60th hour and become N2. NameNull?TypeZRRN1TK_PIDMNOT NULLNUMBER(10)ZRRN1TK_TERM_CODE_GPANOT NULLVARCHAR2(6 CHAR)ZRRN1TK_CHECKPOINT_HOURSNOT NULLNUMBER(6,2)ZRRN1TK_GPA_HOURSNOT NULLNUMBER(6,2)ZRRN1TK_QUALITY_POINTSNOT NULLNUMBER(7,2)ZRRN1TK_GPANOT NULLNUMBER(4,2)ZRRN1TK_TIER_CODENOT NULLVARCHAR2(2 CHAR)ZRRN1TK_ACTIVITY_DATENOT NULLDATEZRRN1TK_AIDY_CODENOT NULLVARCHAR2(4 CHAR)Slide95
Grant GPA: Banner Tables
Table: ZRRHGRS
Stores the paid hours as long as students are in reinstated status. The 'MX' record would get written here as well.(Eligible Tier Codes: G6, G8) GPA is no longer checked. Students updated to MX at 63rd paid hour. NameNull?TypeZRRHGRS_PIDMNOT NULLNUMBER(10)ZRRHGRS_TERM_CODE_GPANOT NULLVARCHAR2(6 CHAR)ZRRHGRS_ATTEMPTED_HOURSNOT NULLNUMBER(7,2)ZRRHGRS_QUALITY_POINTSNOT NULLNUMBER(7,2)ZRRHGRS_GPA_HOURSNOT NULLNUMBER(7,2)ZRRHGRS_GPANOT NULLNUMBER(4,2)ZRRHGRS_ACTIVITY_DATENOT NULLDATEZRRHGRS_ELIGIBILITY_CODENOT NULLVARCHAR2(2 CHAR)ZRRHGRS_AIDY_CODE
NOT NULL
VARCHAR2(4 CHAR)Slide96
Grant GPA: Banner View
ZRVHGPA View
Displays the ZRRHGPA, ZRRN1TK, or ZRRHGRS information for a student based on the ROAINST term code.NameNull?TypeZRVHGPA_PIDM NUMBERZRVHGPA_TIER_CODE VARCHAR2(2 CHAR)ZRVHGPA_AIDY_CODENOT NULLVARCHAR2(4 CHAR)ZRVHGPA_TERM_CODE VARCHAR2(6 CHAR)ZRVHGPA_CHECKPOINT_HOURS NUMBERZRVHGPA_GPA_HOURS NUMBERZRVHGPA_QUALITY_POINTS NUMBERZRVHGPA_GPA NUMBERSlide97
Questions?
97Slide98
Scholarship Tier TrackingSlide99
Scholarship Tier Tracking
HOPE Scholarship
Processing
Sequence:HOPE Scholarship Tier Tracking Process (ZRPTIER)Three Term Checkpoint (ZRPTTCP)End of Spring Checkpoint (ZRPHEOS) Important: Only run after spring termHOPE 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.99Slide100
ZRPTIER:
HOPE Scholar Tracking Process
100Slide101
ZRPTIER: HOPE Scholar Tracking Process
This Banner process is provided to assist colleges with the tracking of tier levels and HOPE GPA calculations for HOPE Scholarship and Zell Miller Scholarship recipients.
Currently
registered degree seeking HOPE or Zell Miller Scholarship recipients will automatically have their term hours and GPA added to user defined fields in Banner. 101Slide102
ZRPTIER: HOPE Scholar Tracking Process
ROAUSDF:
The
OVERALL FIELDS (21 through 28) and the BEGINNING FIELDS (31 through 38) MUST BE manually entered using form ROAUSDF for any student that should be included in the process. If these fields are not manually entered, the student will be omitted from the process. This must be done only once. The appropriate fields will be automatically populated for each term the student is enrolled thereafter. Any student who is not eligible for HOPE Scholarship, but has applied may be set up on ROAUSDF (Fields 21-28 and 31-38) and coded with tier status of ‘NE’. Any student coded as ‘NE’ who crosses a 30/60/90 Hour Checkpoint will be evaluated for eligibility and assigned one of the following tier codes: ‘H2’, ‘H3’, H4’, ‘BG’.102Slide103
ZRPTIER:
HOPE Scholar Tracking Process
FIELD 21
Most Recent TermFIELD 23Overall Attempted HoursFIELD 24Overall GPA HoursFIELD 25Overall Quality PointsFIELD 27Overall GPAFIELD 28Overall EligibilityFIELD 31Beginning TermFIELD 33Beginning Attempted HoursFIELD 34Beginning GPA HoursFIELD 35Beginning Quality PointsFIELD 37Beginning GPAFIELD 38Beginning EligibilityROAUSDF:103FIELD 41Summer Attempted Hours
FIELD 42
Summer GPA Hours
FIELD 43
Summer Quality Points
FIELD 44
Summer GPA
FIELD 45
End of Summer Eligibility
FIELD 46
Fall Attempted Hours
FIELD 47
Fall GPA Hours
FIELD 48
Fall Quality Points
FIELD 49
Fall GPA
FIELD 50
End of Fall Eligibility
FIELD 56
Spring Attempted Hours
FIELD 57
Spring GPA Hours
FIELD 58
Spring Quality Points
FIELD 59
Spring GPA
FIELD 60
End of Spring EligibilitySlide104
ZRPTIER: HOPE Scholar Tracking Process
Registered degree seeking HOPE or Zell Miller Scholarship recipients will automatically have their term hours and GPA added to user defined fields in Banner by the ZRPTIER process.
104Slide105
ZRPTIER:
HOPE Scholar Tracking Process
105Slide106
ZRPTIER: HOPE Scholar Tracking Process
01
Term code
RequiredEnter the Banner Term Code (example: 201612). ‘Invalid Term/Aid Year Combination’ error generated for aid year/term code mismatch.02Aid Year Code Current Aid Year Code – example 151603Run ModeValid Values: R, P, or IR – All Registered for Term, P - Population Selection, I- Student ID (select ‘I’ if running process on single student)04Student IDRequired if Parameter 03 = IFor Run Mode (Parameter 03) = I (Student ID), enter the student’s Banner Student ID05Application CodeRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the Application for the Population Selection – example FINAID 06Selection IDRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the Selection ID (Name of the Population Selection) 07Creator IDRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the Creator ID of the Population Selection08User IDRequired if Parameter 03 = PFor Run Mode (Parameter 03) = P (Population Selection), enter the User ID of the Population Selection
09
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
jsmith@albanytech.edu
, then Johnnie would enter
jsmith
for Parameter 08.
10
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.
106Slide107
ZRPTIER:
HOPE Scholar Tracking Process Eligibility Codes
BG
Below GPA -This code is set when a student crosses a 30/60/90 Hour Checkpoint and the current overall GPA is below 3.00 for HOPE Scholarship or 3.30 for Zell Miller Scholarship.LH HOPE Scholarship Two Losses (Ineligible status.)LZ Zell Miller Scholarship Two Losses (Ineligible status.)MX Exceeded Max Hours (total attempted hours > 127.00) -This code is set whenever the total attempted hours exceeds 127.ND Not Degree – This code is set when it is determined that a student is diploma or certificate seeking for the specified term.NENot Eligible - This code is to be used for tracking ineligible students and is entered manually. Any student who is not eligible for HOPE Scholarship, but has applied may be set up on ROAUSDF (Fields 21-28 and 31-38) and coded with tier status of ‘NE’. Any student coded as ‘NE’ who crosses a 30/60/90 Hour Checkpoint will be evaluated for eligibility and assigned one of the following tier codes: ‘H2’, ‘H3’, H4’, ‘BG’.H1 HOPE Tier 1 (total attempted hours < 30)H2HOPE Tier 2 (total attempted hours >= 30 and < 60)H3HOPE Tier 3 (total attempted hours >= 60 and < 90)H4HOPE Tier 4 (total attempted hours >= 90 and < =127)XPExpired Scholarship – This code may set by the USER for initial evaluations and is set by process whenever the next term’s beginning date is after the scholarship expiration date.Z1Zell Miller Scholarship Tier 1 (total attempted hours < 30)Z2Zell Miller Scholarship Tier 2 (total attempted hours >= 30 and < 60)Z3Zell Miller Scholarship Tier 3 (total attempted hours >= 60 and < 90)Z4Zell Miller Scholarship Tier 4 (total attempted hours >= 90 and < =127)107Slide108
ZRPTIER: Output
The zrptier_xxxxxx.lis file is generated from the ZRPTIER process and can be emailed to the valid email address entered in Parameter 09. This file can also be retrieved from the /
u02/
jobsub/PROD/gurjobs directory.108Slide109
ZRPTIER: Output
109Slide110
ZRPTIER: Output
110Slide111
Scholarship Loss Dates
FIELD 97
HOPE Scholarship Loss Date
FIELD 99Zell Miller Loss DateField 97: HOPE Scholarship Loss Date: The HOPE Scholarship Tier Tracking Process (ZRPTIER), the Three Term Checkpoint Process (ZRPTTCP), and the End of Spring Process (ZRPHEOS) will update Field 97 for any student who loses eligibility for HOPE Scholarship at the end of a term due to a below 3.0 Scholarship GPA at a checkpoint. Field 99: Zell Miller Loss Date: The HOPE Scholarship Tier Tracking Process (ZRPTIER), the Three Term Checkpoint Process (ZRPTTCP), and the End of Spring Process (ZRPHEOS) will update Field 99 for any student who loses eligibility for Zell Miller Scholarship at the end of a term due to a below 3.30 Scholarship GPA at a checkpoint. 111Slide112
ZRPTTCP:
HOPE Scholarship Three Term Checkpoint Process
112Slide113
ZRPTTCP:
HOPE
Scholarship Three Term Checkpoint Process
This Banner process is provided to assist colleges with the tracking of First Tier HOPE Scholarship and Zell Miller Scholarship recipients. A First-Tier (H1 or Z1) recipient enrolled for less than 12 hours for each of his or her first three school terms must have a Postsecondary Cumulative Grade Point Average of at least a 3.00 for HOPE Scholarship and 3.30 for Zell Miller Scholarship at the end of his or her third term (Three-Term Checkpoint), in order to continue eligibility beyond the third term. The HOPE Scholarship Tier Tracking Process (ZRPTIER) must be complete prior to running the Three Term Checkpoint Process.This process only applies to First-Tier (H1 or Z1) students who enrolled for less than 12 credit hours each of their first three (3) terms. Only degree level Tier 1 terms are counted. HOPE Scholarship and Zell Miller Scholarship eligibility can be lost at a 3TC not gained or regained. Eligibility for HOPE Scholarship or Zell Miller Scholarship can only be regained at a future Attempted Hours Checkpoint.113Slide114
ZRPTTCP:
HOPE Scholarship Three Term Checkpoint Process
FIELD 29
3TC StatusFIELD 30GSFC Check TermFIELD 403TC Check TermROAUSDF Fields:114Slide115
ZRPTTCP: Parameters
115Slide116
ZRPTTCP: Parameters
01
Aid Year Code
RequiredCurrent Aid Year Code – example 151602Term codeRequiredEnter the Banner Term Code (example: 201612) If aid year/term code mismatch, the following error is generated in the zrrttcp_invalid_xxxxxx.log file: ‘ Invalid Aid Year/Term Code Combination: YEAR/TERM’.03Run ModeValid Values: A, UA – Audit or U - Update NOTE: It is recommended that you run this process first in audit mode. Audit mode does not update ROAUSDF.04Email User NameNot Required, but RecommendedEnter 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 jsmith@albanytech.edu, then Johnnie would enter jsmith for Parameter 04.116Slide117
ZRPTTCP: Field Updates
If a student was Tier 1 for the TERM, full-time (currently or any time in history as a degree seeking student) and did not require the 3TC, the program will update
ROAUSDF.
Value 29 (3TC Status) will be set to ‘X’ (Not Needed) and Value 40 (3TC Check Term) will be set to the TERM.117Slide118
MANUAL: HOPE Scholarship Three Term Checkpoint Process
ZRPTTCP will
also identify any students that are Tier 1, part time, and have transfer data in Banner. These students could also require the 3TC.
At the end of each term, colleges must request the Part-Time Students report from Surfer. Students listed on this report have been identified by GSFC and need the Three Term Checkpoint (3TC) applied. Once you have evaluated these students, you must manually update the Banner ROAUSDF fields as well as manually update the SURFER Part-Time Eligibility field for each student. To do this, you simply have to “check” the Part-Time Eligibility box on the Student Demographics screen.118Slide119
ZRPTTCP: Output
Two files are generated from the ZRPTTCP process. These files can be emailed to the valid email address entered in Parameter 04 or may be retrieved from the /
u02/
jobsub/PROD/gurjobs directory.119Slide120
ZRPTTCP: Output
120Slide121
ZRPTTCP: Output
121Slide122
ZRPHEOS:
End of Spring Term Checkpoint Process
122Slide123
ZRPHEOS:End of Spring Term Checkpoint Process
HOPE Scholarship or Zell Miller Scholarship recipients
must have a Postsecondary Cumulative Grade Point Average of at least a 3.00 for 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. 123Slide124
ZRPHEOS:End of Spring Term Checkpoint Process
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.
124Slide125
ZRPHEOS:End of Spring Term Checkpoint Process
FIELD 39
EOS Status/Term
ROAUSDF Field:125Slide126
ZRPHEOS: Parameters
126Slide127
ZRPHEOS: Parameters
01
Aid Year Code
RequiredCurrent Aid Year Code – example 151602Term codeRequiredEnter the Banner Spring Term Code (example: 201614). 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.03Run ModeValid Values: A, UA – Audit or U - Update NOTE: It is recommended that you run this process first in audit mode. Audit mode does not update ROAUSDF.04Email User NameNot Required, but RecommendedEnter 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 jsmith@albanytech.edu, then Johnnie would enter jsmith for Parameter 04.127Slide128
ZRPHEOS:End of Spring Term Checkpoint Process
The EOS Checkpoint
will be applied
to the following students: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.Tier 1 and full-time during any term during the Aid Year.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.Tier 1 and ROAUSDF Field 29 (3TC Status = ‘X’). Three Term Checkpoint ‘Not Needed’ because Tier 1 student was full time at least once.128Slide129
ZRPHEOS:End of Spring Term Checkpoint Process
The EOS Process will not be applied to
the following students:
Tier 1 and falls into the 3TC/part-time category. Not enrolled during the Aid Year.Not receiving HOPE Scholarship or Zell Miller Scholarship during the Aid Year.Last Tier Code is ineligible status. 129Slide130
ZRPHEOS: Output
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/gurjobs directory.Reports are located in the user’s home directory.zprheos_xxxxxx.lis: This file contains a list of students that were EOS checked. 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 process did not run. All errors must be resolved before ZRPHEOS will complete.130Slide131
ZRRHREV:
HOPE Scholarship Review Report
131Slide132
ZRRHREV:HOPE Scholarship Review Report
This Banner report is provided to assist colleges with the tracking of HOPE Scholarship and Zell Miller Scholarship student eligibility. This report may be generated as needed, but should be run after the Three Term Checkpoint Process (ZRPTTCP) is complete each summer and fall semester, and after the End of Spring Term Checkpoint Process (ZRPHEOS) is complete each spring semester.
132Slide133
ZRRHREV:HOPE Scholarship Review Report
ZRRHREV identifies the following two groups of students:
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 students’ 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. 133Slide134
ZRRHREV: Parameters
134Slide135
ZRRHREV: Parameters
01
Term code
RequiredEnter the Banner Term Code (example: 201614). Term code must exist in aid year entered into Parameter 02. No report will be generated if aid year/term code mismatch.02Aid Year CodeRequiredCurrent Aid Year Code – example 151603Email User NameNot Required, but RecommendedEnter 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 jsmith@albanytech.edu, then Johnnie would enter jsmith for Parameter 03.135Slide136
ZRRHREV: Output
One file is generated from the ZRRHREV process. The file can be emailed to the valid email address entered in Parameter 03 or may be retrieved from the /
u02/
jobsub/PROD/gurjobs directory.zrrhrev_xxxxxx.lis136Slide137
ZRRHREV: Output
137Slide138
ZRPROLL:
HOPE Aid Year Rollover Process
138Slide139
ZRPROLL:HOPE Aid Year Rollover Process
ZRPROLL is the Banner process that allows colleges to copy current year ROAUSDF Scholarship Tier information from the current aid year to the next aid year.
This
process will update the Overall Values (ROAUSDF Fields 21-28), the Beginning Values (ROAUSDF Fields 31-38), the Three-Term Checkpoint Values (ROAUSDF Fields 29, 30, and 40), and the Loss Dates (ROAUSDF Fields 97 and 99) in the new aid year for students where a ROASTAT record exists in the new aid year and ROAUSDF (Field 28) does not exist for the new aid year. 139Slide140
ZRPROLL:HOPE Aid Year Rollover Process
ZRPROLL may be run as needed but
must be run after all summer semester tier processes are complete.
The process will not change/update any students with ROAUDSF values in the new aid year. Only students with a ROASTAT record and no ROAUDSF record in the new aid year will be updated.140Slide141
ZRPROLL: Parameters
141Slide142
ZRPROLL: Parameters
01
From Aid Year Code
RequiredBanner Aid Year Code (example 1516) to copy ROAUSDF Values from 02To Aid Year CodeRequiredBanner Aid Year Code (example 1617) to copy previous aid year ROAUSDF Values to09Email User NameNot Required, but RecommendedEnter 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 jsmith@albanytech.edu, then Johnnie would enter jsmith for Parameter 08.142Slide143
ZRPROLL: Output
The
zrproll_xxxxxx.lis
file can be emailed to the valid email address entered in Parameter 03. This file can also be retrieved from the /u02/jobsub/PROD/gurjobs directory. 143Slide144
ZRPROLL: Output
144Slide145
Questions?
145Slide146
ZRRPDHR:
HOPE Paid Hours
Calc
ProcessSlide147
ZRRPDHR: HOPE Paid Hours
Calc
Process
ZRRPDHR is the Banner process that allows colleges to identify students receiving HOPE Grant, HOPE Scholarship, Zell Miller Grant, or Zell Miller Scholarship who need adjustments to their award for the term. This process identifies students and updates Banner form RPAAWRD with the adjusted award for the term.ZRRPDHR also calculates term based Cap Hour eligibility indicators that colleges may use in their disbursement rules. Cap Hour Eligibility Indicators are based on:HOPE Grant and Zell Miller Grant: Paid HoursHOPE Scholarship and Zell Miller Scholarship: Paid Hours, Attempted Hours, and Scholarship Expiration Date.147Slide148
ZRRPDHR: HOPE Paid Hours
Calc
Process
ZRRPDHR allows colleges to identify the following four (4) groups of students requiring billing hour and award adjustments: Students who are approaching their Paid Hours Cap and who have registered for more credit hours than HOPE or Zell Miller will pay in their next term of enrollment based on paid hours. HOPE Scholarship or Zell Miller Scholarship recipients who have registered for more credit hours than HOPE/Zell Miller Scholarship will pay in their next term of enrollment based on attempted hours. HOPE Scholarship or Zell Miller Scholarship recipients who are enrolled in Learning Support courses for the term.HOPE Grant, Zell Miller Grant, HOPE Scholarship, or Zell Miller Scholarship recipients who are enrolled in courses outside their program of study. Course registration status codes: ‘KO’, ‘OA’, ‘OW’, ‘OF’, ‘OI’, ‘OM’, and ‘OP’.148Slide149
ZRRPDHR: HOPE Paid Hours
Calc
Process
Using the calculated adjusted billing hours for the four (4) groups of students the program will then calculate the students’ adjusted HOPE Grant, Zell Miller Grant, HOPE Scholarship, or Zell Miller Scholarship for the term. Banner form RPAAWRD will be updated by the ZRRPDHR process with adjusted awards for the term. (Banner form GTVSDAX must be populated with the year specific HOPE and Zell Miller tuition award rates.)149Slide150
ZRRPDHR: HOPE Paid Hours
Calc
Process
The ZRRPDHR process calculates the following hours per term: Learning Support HoursDual Enrollment HoursTotal hours for courses outside the program of study (course registration status codes: KO’, ‘OA’, ‘OW’, ‘OF’, ‘OI’, ‘OM’, and ‘OP’)(Adjusted) HOPE/Zell Billing Hours, Dual Enrollment hours and Learning Support hours are stored and displayed on Banner form ZRAGSFC/ Hours tab.150Slide151
ZRRPDHR: Parameters
151Slide152
ZRRPDHR: Parameters
152Slide153
ZRRPDHR: Parameters
153Slide154
ZRRPDHR: Output
The
zrrpdhr_xxxxxx.lis
and zrrpdhr_xxxxxx.log reports are generated in the /u02/jobsub/PROD/gurjobs directory. The reports are also emailed to the valid email address entered into Parameter 08. The zrrpdhr_xxxxxx.log report (added in version 12.7) displays the parameters used when running the process. 154Slide155
ZRRPRHR: Output
155Slide156
ZRRPDHR: Output
156Slide157
ZRAGSFC: Updates
157Slide158
ZRAGSFC: Updates
The
following fields
will not be updated by the ZRRPDHR process: GSFC Paid Hrs.GSFC Inv CodeSch. TypeThese fields are populated by the invoicing process.If no ‘Paid Hrs – Beginning of Term’ fields are populated for the term ZRRPDHR will automatically update those fields to equal the ‘Overall Semester Paid Hours Detail’ fields even if Parameter 10 = ‘N’. After the fields are populated for the term, Parameter 10 will control if the fields are updated.158Slide159
ZRRTTRK: Banner Table
ZRAGSFC - 'Hours' tab ('Invoicing Detail' and 'Term Cap
Hrs
Eligibility' blocks) NameNull?TypeZRRTTRK_PIDMNOT NULLNUMBER(10)ZRRTTRK_AIDY_CODENOT NULLVARCHAR2(4 CHAR)ZRRTTRK_TERM_CODENOT NULLVARCHAR2(6 CHAR)ZRRTTRK_ACTIVITY_DATENOT NULLDATEZRRTTRK_LS_HRSNOT NULLNUMBER(2)ZRRTTRK_DE_HRSNOT NULLNUMBER(2)ZRRTTRK_BILL_HRSNOT NULLNUMBER(2)ZRRTTRK_GSFC_PD_HRS NUMBER(5,1)ZRRTTRK_GSFC_SCH_TYPE VARCHAR2(2 CHAR)ZRRTTRK_INV_CODE VARCHAR2(2 CHAR)ZRRTTRK_G_ELIG_HRS_IND VARCHAR2(1 CHAR)
ZRRTTRK_S_ELIG_HRS_IND
VARCHAR2(1 CHAR)
ZRRTTRK_Z_ELIG_HRS_IND
VARCHAR2(1 CHAR)
ZRRTTRK_USER_ID
VARCHAR2(30 CHAR)
ZRRTTRK_SYS_IND
NOT NULL
VARCHAR2(1 CHAR)
ZRRTTRK_GRANT_TOT_PD_HRS
NUMBER
ZRRTTRK_SCHOL_TOT_PD_HRS
NUMBER
ZRRTTRK_ZELL_TOT_PD_HRS
NUMBER
ZRRTTRK_TOT_PD_HRS
NUMBERSlide160
Questions?
160Slide161
ZRPINVE:
GSFC HOPE Invoicing ProcessSlide162
ZRPINVE
GSFC HOPE Invoicing Process
Banner process that allows colleges to report
the below state funded financial aid disbursements to the Georgia Student Finance Commission (GSFC). Records can be uploaded to GSFC automatically using this process. ZRPINVE allows colleges to create student files from their Banner system and upload those student files to GSFC. This same process then allows colleges to import the GSFC return file back into their Banner system. Funds Reported to GSFC HOPE GED Dual Enrollment HOPE Grant Zell Miller Grant HOPE Grant – 30 Hours Zell Miller Scholarship HOPE Career Grant REACH Scholarship HOPE ScholarshipSlide163
ZRPINVE GSFC HOPE Invoicing Process
The HOPE Invoicing Process is run for one term at a time and will pull any records for that term coded with the TCSG standardized detail codes.
Degree
students receiving HOPE Scholarship or Zell Miller Scholarship also require Tier levels to be entered into the appropriate ROAUSDF (user defined screen) fields. An Invoice file is created that the user then uploads to GSFC using the GSFC Surfer system. GSFC will process the student data from your file and will generate an invoice return file. This process will then allow you to load the students’ data received from GSFC into your college’s Banner system. Slide164
ZRPINVE GSFC HOPE Invoicing Process
Funds must be in Paid status for the specified term.
Only
funds posted to student accounts from the Banner Financial Aid Module will be included in this process. Source Code (source of the transaction) on Banner Form TSAAREV must equal ‘F’. Any funds posted directly to a student account (Source Code equals ‘T’) will not be included in this process. Degree seeking students receiving HOPE or Zell Miller Scholarship must have Tier levels populated on Banner form ROAUSDF.Banner form GTVSDAX must be populated with the year specific HOPE and Zell Miller tuition award rates.Slide165
ZRPINVE
GSFC HOPE Invoicing
Process
Degree seeking students receiving HOPE or Zell Miller Scholarship must have Tier levels populated on Banner form ROAUSDF.ROAUSDFField DescriptionInvoicing Term TierFIELD 38 Beginning Eligibility Fall Semester HOPE or Zell Miller Scholarship TierFIELD 50 End of Fall Eligibility Spring Semester HOPE or Zell Miller Scholarship TierFIELD 60 End of Spring Eligibility Summer Semester HOPE or Zell Miller Scholarship TierEligible Scholarship Tier ValuesDescriptionH1HOPE Tier 1 H2HOPE Tier 2 H3HOPE Tier 3 H4HOPE Tier 4Z1Zell Miller Tier 1 Z2Zell Miller Tier 2Z3Zell Miller Tier 3Z4Zell Miller Tier 4Slide166
ZRPINVE GSFC HOPE Invoicing Process
Financial Aid Fund Codes must be linked to TCSG standardized Accounts Receivable
Detail
Codes on Banner form RFRBASE. Accounts Receivable Detail Code (TCSG Standardized)Financial Aid Fund DescriptionHO50HOPE Grant TuitionHO54HOPE Scholarship TuitionHO30HOPE Grant – 30 HoursHOPGHOPE GEDMOWTDual Enrollment TuitionMOWFDual Enrollment FeesMOWKDual Enrollment BooksHO5GZell Miller Grant TuitionHO5ZZell Miller Scholarship TuitionSWIGHOPE Career Grant $500 Max. AwardREACREACH ScholarshipSWI2Commercial Truck DrivingHOPE Career Grant $1000 Max AwardSlide167
ZRPINVE - ParametersSlide168
ZRPINVE - Parameters
01
Aid Year Code
RequiredCurrent Aid Year Code – example 151602(I)Import IND or (E) Export INUI or EI – Import GSFC Invoicing Download File (IND). E – Export/Create GSFC Upload File (INU)03Term codeRequired Term Code (example: 201612) – Note: Term Code must be included in Aid Year Code (Parameter 01). Valid term code is any term code after 201212 and must be a semester term code. NOTE: Invalid aid year/term code combination will not generate INU file and will not import IND file. 04Email AddressNot Required, but RecommendedEnter User Name for INU and all output reports 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 jsmith@albanytech.edu, then Johnnie would enter jsmith for Parameter 04.Slide169
ZRPINVE: Export Mode - Output
Five files are created from the ZRPINVE process with Parameter 02: (E) Export INU. All files can be emailed to the valid email address entered in Parameter 04.
zrpinve_xxxxxx.log – Review this file for errors. If errors exist, please notify the Data Center at datacenter@tcsg.edu . The file is emailed to the user or can be retrieved from the /u02/jobsub/PROD/gurjobs directory. zrpinve_xxxxxx.lis – This file provides the user with a summary total of all award amounts included in the INU file. The file is emailed to the user or can be retrieved from the/u02/ jobsub directory. zrpinve_detail_xxxxxx.lis – This file provides the user with a listing of students included in the INUnnn.TXT file. The file is emailed to the user or can be retrieved from the /u02/jobsub/PROD/gurjobs directory. INUnnn.TXT file - This is the batch file containing student invoice records. This file contains all HOPE GED, HOPE Grant, Zell Miller Grant, HOPE Scholarship, Dual Enrollment, and Zell Miller records for the specified term. (Students on the zrpinve_error_xxxxxx.lis report should be reviewed before submitting the INUnnn.TXT file to GSFC.) The file is emailed to the user or can be retrieved from the /u01/app/banner/dataload/finaid directory. zrpinve_error_xxxxxx.lis – This file provides the user with a listing of students who must be reviewed prior to submitting the INUnnn.TXT file to GSFC. The file is emailed to the user or can be retrieved from the /u02/jobsub/PROD/gurjobs directory. Slide170
ZRPINVE: Export Mode Tables
zrpinve_detail_xxxxxx.lis
-
Data is stored in the saisusr.finaid_data table. SQL> desc saisusr.finaid_data Name Type NameTypeRECORD_TYPEVARCHAR2(2 CHAR) BOOKSNUMBER(7,2)SSNVARCHAR2(9 CHAR) SPACES6VARCHAR2(21 CHAR)FNAMEVARCHAR2(20 CHAR) SELECTIVE_SERVICEVARCHAR2(1 CHAR)MIDINTVARCHAR2(1 CHAR) GRADE_LEVELVARCHAR2(1 CHAR)LNAMEVARCHAR2(30 CHAR) SPACES7VARCHAR2(4 CHAR)STREET_ADDRESS1VARCHAR2(40 CHAR)
ACADEMIC_YEAR
VARCHAR2(4 CHAR)
CITY
VARCHAR2(20 CHAR)
SPACES8
VARCHAR2(2 CHAR)
STATE
VARCHAR2(2 CHAR)
TRANSACTION_STATUS
VARCHAR2(1 CHAR)
ZIP_CODE
VARCHAR2(9 CHAR)
SPACES9
VARCHAR2(1 CHAR)
DATE_OF_BIRTH
DATE
MAJOR_CODE
VARCHAR2(4 CHAR)
DEPENDENCY
VARCHAR2(1 CHAR)
PELL_ELIGIBLE
VARCHAR2(1 CHAR)
GENDER
VARCHAR2(1 CHAR)
DUAL
VARCHAR2(1 CHAR)
PIDM
VARCHAR2(8 CHAR)
JOINT
VARCHAR2(1 CHAR)
STUDENT_NUMBER
VARCHAR2(9 CHAR)
KO_HOURS
NUMBER(4,2)
SPACES1
VARCHAR2(13 CHAR)
HS_GRAD
VARCHAR2(6 CHAR)
TERM
VARCHAR2(1 CHAR)
LS_HOURS
NUMBER(4,2)
SPACES2
VARCHAR2(31 CHAR)
PAID_HOURS
NUMBER(4,2)
ATTEMPTED_HOURS
NUMBER(4,2)
DUAL_HOURS
NUMBER(7,2)
SPACES3
VARCHAR2(12 CHAR)
TUITION
NUMBER(7,2)
SPACES4
VARCHAR2(21 CHAR)
FEES
NUMBER(7,2)
SPACES5
VARCHAR2(21 CHAR)
Slide171
ZRPINVE: Export Mode Tables
zrpinve_error_xxxxxx.lis
- Data is stored in the saisusr.finaid_errors table. SQL> desc saisusr.finaid_errors NameTypeRECORD_TYPEVARCHAR2(2 CHAR)TERMVARCHAR2(6 CHAR)IDVARCHAR2(9 CHAR)SSNVARCHAR2(9 CHAR)PIDMVARCHAR2(8 CHAR)HOURSNUMBER(9,2)AMOUNTNUMBER(7,2)MAJOR_CODEVARCHAR2(4 CHAR)DUALVARCHAR2(1 CHAR)JOINTVARCHAR2(1 CHAR)ERROR_TYPEVARCHAR2(10 CHAR)Slide172
ZRPINVE: Error Report
SSN is blank
Missing SSN
Review Banner form SPAPERS for SSN.NOMissing MA mailing addressMissing InformationReview Banner form SPAIDEN for MA address. NOHOPE Scholarship detail code (HO54) or Zell Miller Scholarship detail code (HO5Z) exists for the term on TSAAREV and Tier information is not completeMissing InformationReview Banner form ROAUSDF for Tier information.NODuplicate record: HOPE Scholarship, HOPE Grant, Zell Miller Grant, and/or Zell Miller Scholarship records exist for the term.Student listed in last section of error report.Review student’s eligibility and disbursements for term.NOInvalid or missing major codeMajor/Fund code MismatchReview Banner form SGASTDN major code. Major code is missing or student received HOPE Grant or Zell Miller Grant with a degree major code or received HOPE Scholarship, Zell Miller Scholarship, or HOPE Grant – 30 hour with diploma/certificate major code.NOTransient fund code Invoice must be entered manually into Surfer.NOROAENRL FA Billing Hours are greater than 99 or zero
>= 99 Billing Hours or
Zero Billing Hours
Review ROAENRL Financial Aid Bill Hours. (STANDARD rule code.)
NO
ZRAGSFC HOPE/Zell Billing Hrs.
Missing Billing Hours
ZRAGSFC/ Hours tab. HOPE/Zell Billing Hours is NULL. Run ZRRPDHR process to update student record.
NO
Incorrect award amount. ZRAGSFC HOPE/Zell Billing Hrs. x GTVSDAX entry for aid year does not equal disbursed aid.
Incorrect Award Amount
Review disbursed amount and billing hours on ZRAGSFC for term for HOPE Grant, Zell Miller Grant, HOPE Scholarship, or Zell Miller Scholarship.
Students receiving both
Dual
Enrollment funding
and
HOPE Grant, review the disbursed amount.
Note: HOPE GED and HOPE Career Grant, formerly known as the Strategic Industries Workforce Development Grant, are excluded from this edit.
YES
Students included in INU file.Slide173
ZRPINVE: Error Report
HOPE Grant paid to ineligible student. Student’s Grant GPA is below 2.0 at most recent checkpoint.
N1/N2/ND Record Exists
Review Banner form ZRAGRNT for Grant GPA eligibility status. Reverse HOPE Grant disbursement for term. Student is ineligible.(ND: Eligibility ‘Not Determined’ due to unresolved discrepancy.)NOZell Miller Grant paid to ineligible student (< 3.5) or Zell Miller Grant retroactive first term paid to student based on end of term GPA. Review student’s Grant GPA and eligibility.GPA Less than 3.5Review Banner form ZRAGRNT, ‘Overall Grant GPA’ for most recent Grant GPA. Reverse Zell Miller Grant disbursement for term if ineligible. (If Zell Miller Grant or HOPE Grant discrepancy exists, eligibility is ‘ND’, ‘Not Determined due to unresolved discrepancy’.) YESStudents included in INU file.HOPE Career Grant paid but no HOPE Grant or Zell Miller Grant paid for term.No HOPE/ZM GrtReview HOPE Grant or Zell Miller Grant eligibility and HOPE Career Grant eligibility for term. NOHOPE Career Grant disbursed amount incorrect for number of enrolled hours. Invalid Hours/AmountReview ROAENRL Financial Aid Billing Hours. ZSWIG = $250/term if 8 or less hoursZSWIG = $500/term if 9 or more hoursZSWI2 = $1000 for one term for 9 or more hours Effective Fall 2014 (Banner term: 201512)ZSWIG = $125/term if 1 – 2 hoursZSWIG = $250/term if 3 – 8 hoursZSWIG = $500/term if 9 or more hoursZSWI2 = $1000 for one term for 9 or more hoursYESStudents included in INU file.HOPE Career Grant – Unapproved major code.Invalid Major Code
Review student’s major for term on SGASTDN.
Effective Fall 2014 (Banner term: 201512)
Student’s major code must be listed on Banner form ZTVSWIG.
NO
Student coded as ‘H’ (high school student) received HOPE Career Grant.
HOPE Career Grant Dual/Joint Enroll
Review Banner form SGASTDN student type and Activities tab. Review student’s eligibility for HOPE Career Grant. High School students are not eligible for HOPE Career Grant.
NOSlide174
ZRPINVE: Error Report
Student coded as ‘H’ (high school student) received HOPE Grant and is not coded as ‘JOINT’.
Missing SGRSACT “JOINT”
Review Banner form SGASTDN student type and Activities tab. Review student’s eligibility for HOPE Grant. High School students must be “JOINT” to receive HOPE Grant.NODual Enrollment student fees do not equal $50.00.Fees <> 50.00Review Banner form TSAAREV to ensure detail charge code (‘MOWC’) equals $50.00. NODual Enrollment student books does not equal $25.00 per credit hour. (Maximum allowance based on 15+ hours: $375.00)Books <>25.00*HoursReview Banner form TSAAREV to ensure detail charge code (‘MOWC’) equals $25.00 per hour up to 15 hours.NOREACH Scholarship must be 12+ credit hours for semesterFT enrollment required Review student’s enrolled hours for the term. If student is transient then manual invoicing will be required to accurately report enrolled, billing, and learning support hours.YESStudents included in INU file.Invalid or missing major code ZHG30/HO30Major/Fund code MismatchReview Banner form SGASTDN major code. Major code is missing or student received ZHG30/HO30 for diploma/certificate major code.NOSlide175
ZRPINVE: Error Report
After
correcting an error, ZRPINVE must be run again and the new error report must be reviewed. If an error is resolved and the student meets the criteria for a second error, then the student will be listed on the error report with the new error.
This could result in the sum of the error report plus the .lis report to not equal the totals for each fund on Banner form RFIBUDG. It is recommended that the Banner process, ZFRGSFC, be used to reconcile funds. Slide176
SURFER: User GuidesSlide177
GSFC Provided: INU File Layout
(34 data fields in INU File)Slide178
ZRPINVE: Export Mode (INU File)
Uploading the file to GSFC (INUnnn.TXT):
Move the file to your PC. - If file is an email attachment, you will need to save the file to your PC. - If retrieving the INU from the /u01/app/banner/dataload/finaid directory, you must FTP the INUnnn.TXT file to your PC. (Please consult with your local tech support if you need assistance with the ftp process.)Log into Surfer - Select ‘Upload File’ - Browse to the INUnnn.TXT file on your PC and select the INUnnn.TXT file - Select ‘Upload File’GSFC will process the INUnnn.TXT file and return files to your Surfer Inbox for retrieval.Slide179
ZRPINVE: Import Mode (IND File)
Processing the Download File (INDnnn.TXT):
Once
GSFC has finished processing the INU file, they will load the INDnnn_ xxxxxxxxxxxx.TXT file into your SURFER Inbox.You must download this file to your PC and then FTP it to the /u01/app/banner/dataload/finaid directory on the Banner database server. Slide180
SURFER: User GuidesSlide181
GSFC Provided: IND File Layout
(31 data fields in IND File)Slide182
ZRPINVE: Import Mode (IND File)Slide183
ZRPINVE: Import Mode (IND File)
Note:
INU
and IND files are deleted from the /u01/app/banner/dataload/finaid directory by the import process.Slide184
ZRPINVE: Import Mode - Output
The import process creates up to four (4) reports in the
/
u02/jobsub/PROD/gurjobs directory. The reports are also emailed to the valid email address entered in Parameter 04.Slide185
ZRPINVE: Import Mode - Output
1.
zrpinve_xxxxxx.log
: Primary information is located at the bottom of report. Sample successful load results are displayed at the bottom of the report: Total logical records skipped: 0 Total logical records read: 5626 Total logical records rejected: 0 Total logical records discarded: 0 If any records are skipped, rejected, or discarded a zrpinve_xxxxxx.BAD file will be generated. If the zrpinve_xxxxxx.log report indicates any records were skipped, rejected, or discarded, please notify the Data Center at datacenter@tcsg.edu . The process will not import skipped, rejected, or discarded records. 2.zrpinve_xxxxxx.BAD file: This report lists any student that the process skipped, rejected, or discarded. This report is only generated if a student is not loaded during the process. 3.zrpinve_error_xxxxxx.lis: This report will display an error message if the process does not load (import) the IND records. If an error exists in this file, please notify the Data Center at datacenter@tcsg.edu .4.zrpinve_xxxxxx.lis: This report will display all records imported into Banner. This report is separated into two parts: Accepted Invoices and Rejected Invoices.Slide186
ZRPINVE: Import Mode - zrpinve_xxxxxx.lis
Accepted Invoice Section:
Date:
24-JAN-16 TCSG Technical College Time: 01:08:43 PM ZRPINVE - Invoicing Import Details: 201612 The following students have accepted invoices for the term (GSFC Inv Code = A)Note: Students with updated ZRAGSFC Billing Hours that do not equal theGSFC Paid Hours for the term will have the following comment code:Billing hours <> GSFC Paid hours. Sch Bill Paid InvID SSN Name Major Type Hrs Hrs Code Comment--------- --------- ---------------- ------- ------- ----- ---- ---- - ---- ---- ---- --------------900098765 123456789 Frances Bailey EC13 H2 3 6 A Billing hours <> GSFC Paid hours900432101 012345678 David Bass NS13 H2 3 3 A Slide187
ZRPINVE: Import Mode - zrpinve_xxxxxx.lis
Rejected Invoice Section:
Date:
24-JAN-17 TCSG Technical College Time: 01:08:44 PM ZRPINVE - Invoicing Import Details: 201612The following students have rejected invoices for the term. Students with rejected invoices due to "MAX HOURS REACHED" (GSFC Inv Code = X) will have their Term Cap Hours Eligibility Indicators set to "N" for the term and affected fund code.Please review all students below. The accompanying error report located in your Surfer inbox will provide additional information. GSFC Inv Code - X = Max Hours Reached (Term Cap Hrs Elig. Ind. adjusted)GSFC Inv Code - R = Invoice Rejected for other reason (Term Cap Hrs Elig. Ind. not adjusted) Sch Bill Paid Inv Grant Schol ZellID SSN Name Major Type Hrs Hrs Code Elig Ind Elig Ind Elig Ind900494248 987654321 Joshua Pierce CT61 HD 10 10 R Y Y Y900267456 654321098 Allen Pittman HS21 HD 9 0 X N Y YSlide188
ZRAGSFC – Banner Form
The ZRPINVE import process updates the ZRAGSFC Banner form “Hours” tab.Slide189
ZRAGSFC: Hours tabSlide190
ZRRTTRK: Banner Table
The ZRPINVE import process updates the ZRAGSFC Banner form, Hours tab.
Banner Field NameTable Field NameValues/DescriptionGSFC Paid HoursZRRTTRK_GSFC_PD_HRSGSFC Invoice Paid HoursGSFC Inv CodeZRRTTRK_INV_CODEInvoice Code: A: Accepted InvoiceX: MAX CAP HOURS REACHED. Denial Code 035. Rejected Invoice.R: Rejected Invoice. Invoice rejected due to reason other than ‘Max Cap Hours Reached’.Sch. TypeZRRTTRK_GSFC_SCH_TYPEValid values: HD, HE, H1, H2, H3, H4, Z1, Z2, Z3, Z4, ZGHOPE/ZM Grant –Term Cap Hrs EligibilityZRRTTRK_G_ELIG_HRS_INDUpdated to ‘N’ If:Sch. Type = ‘HD’ or ‘ZG’ and GSFC Inv Code = ‘X’.HOPE Sch. –Term Cap Hrs. EligibilityZRRTTRK_S_ELIG_HRS_INDUpdated to ‘N’ if:Sch. Type = ‘H1’, ‘H2’, ‘H3’, or ‘H4’ and GSFC Inv Code = ‘X’Zell Miller Sch. – Term Cap Hrs. EligibilityZRRTTRK_Z_ELIG_HRS_INDUpdated to ‘N’ if:
Sch. Type = ‘Z1’, ‘Z2’, ‘Z3’, or ‘Z4’ and GSFC
Inv
Code = ‘X’Slide191
ZRPINVE
GSFC HOPE Invoicing Process
Notes:
Zero amount invoice records are submitted to GSFC (included in the INUnnn.TXT file) to back-out any dollar amounts previously submitted.Term Cap Hours Eligibility Indicators are updated to ‘N’ if the invoice for the term is rejected due to ‘Max Hours Reached’.HOPE Regulations definition: “Learning Support means remedial or developmental coursework required by the postsecondary institution or chosen by the student that does not count toward program requirements for the Diploma, Certificate or Degree the student is seeking and for which HOPE payment is sought.” We are required to report the total Learning Support credit hours for HOPE Grant, Zell Miller Grant, HOPE Scholarship, and Zell Miller Scholarship in the invoice records. Learning Support credit hours in the INU file = Remedial/Developmental + Courses coded with registration status code of ‘KO’, ‘OA’, ‘OW’, ‘OF’, ‘OI’, ‘OM’, and ‘OP’. In summary: INU Learning Support Hours = LS + Hours for courses outside of program of study.Paid Hours equal Enrolled Hours for Dual Enrollment students. ZRAGSFC is not updated for Dual Enrollment students. Students with 0 disbursements and ROAENRL FA Billing Hours = 0 (or does not exist) for term will have their ZRAGSFC billing hours updated to 0.Slide192
Questions?