FAS Job Scheduling
SM9xxxJ AGxxxx Other

AG910R
Need 10-11 Auto File Review

The Financial Aid File Review job group runs two jobs to review financial aid applications. The jobs are intended to be run each time a new file of financial aid applications is brought into FAM. It will review all applications each time it is run because the data being edited can change at any time. For example, when the students' electronic application is received, the SMS system may not have any record for the student. As the student applies for admissions and registers for classes, their SMS data is added and changed. The job group will optionally run either of the two jobs. In addition each of the jobs can run standalone.
Special Instructions None
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
O 01 00 SM9154J
10-11 Automatic File Review (Need)
  10-11 Auto File Review - Students Without Awards (SM9154A)
  10-11 Auto File Review - Students With Awards (SM9154B)
  10-11 Auto File Review - Scheduling Errors (SM9154C)
O 02 01 SM9142J
Financial Aid Staff File Review
  Files Ready For Professional Review (SM9142A)
  Files Ready For Staff Review - File Complete (SM9142B)
  Files Ready For Packaging - All Students (SM9142C)


Parameters

AWARD-CD-SEL-LN1
AWARD-CD-SEL-LN2
AWARD-CD-SEL-LN3
AWARD-CD-SEL-LN4
AWARD-CD-SEL-LN5
Enter up to 50 Award Codes to be ignored for students who fail an edit and who have already received awards. Example (ZDZEZF)
EXCLUDE-INACTIVE Y = Exclude students with the inactive code as defined in Table Master WRV-EXCLUDE-CDES
N = Do not exclude students that have the inactive code.
FAF-BEG-DATE Enter range beginning date that the student's FAF must be received by. Leave blank for no beginning
date. If only this date is entered, with no end date, all records from this date and AFTER will be reviewed. Date format: MMDDCCYY Note: The FAF date is the date received on the tracking code defined in SAF/AGENCY Processing Table, under the key value of SAF057-FAF-TRACK.
FAF-END-DATE Enter range ending date that the student's FAF must be received by. Leave blank for no ending
date. The ending date can not be less than the beginning date. If both beginning and ending date are blank - all students with a completion date for FAF will be selected who also meet the other specifications. If only the end date is entered with no beginning date, all records from this date and PRIOR will be reviewed. Date format: MMDDCCYY Note: The FAF date is the date received on the tracking code defined in SAF/AGENCY Processing Table, under the key value SAF057-FAF-TRACK.
FAF-RCVD-DATE The date by which the student's FAF must have been received in Financial Aid. This is determined by the student's tracking record containing the track code established in Processing Table SAF/Agency SAF057-FAF-TRACK and a corresponding received date. FORMAT: MMDDCCYY
FILE-REVIEW-OPT A = Select all students to review
P = Select only students marked for professional review
S = Select all students who are not marked for a professional review
NON-SMS-EXCLUDE Exclude students not in SMS
Y = Student must have a record in SMS to be evaluated in file review.
N = All records meeting other criteria will be evaluated. Records with no SMS data will have a tracking code posted.
POST-NOTIFY-DATE Post the current date to the Notify Date
Y = Change the Notify Date to the current date
N = Change the Due Date to the current date
POST-RECVD-DATE Enter Y or N to post a received date for the File Review code if student has all required items received. Only applies if running in Final Mode
PRELIM-FINAL P = Preliminary--Do not post tracking codes report only
F = Final--Post tracking codes
SEL-DEFAULT-OPT You must enter 1,2 or 3 if you answer "Y" to Z-IN-DEFAULT-ED to perfom the in default edit.
1 = Any in default tracking code will cause the edit to fail regardless of a received date.
2 = Any in default tracking code without a received date will cause the edit to fail.
3 = The will fail if the most recent (by due date) in default tracking code does not have a received date.
SEL-PROB-OPT You must enter 1,2 or 3 if you answer "Y" to Z-PROBATION to perform the on probation edit.
1 = Any probation tracking code will cause the edit to fail regardless of a received date.
2 = Any probation tracking code without a received date will cause the edit to fail.
3 = The edit will fail if the most recent (by due date) probation tracking code does not have a received date.
SEL-REPAY-OPT You must enter 1,2 or 3 if you answer "Y" to Z-OWES-REPYMT to perform the owes repayment edit.
1 = Any owes repayment tracking code will cause the edit to fail regardless of a received date.
2 = Any owes repayment tracking code without a received date will cause the edit to fail.
3 = The edit will fail if the most recent (by due date) owes repayment tracking code does not have a received date.
SEL-TERM-OPT You must enter 1,2 or 3 if you answer "Y" to Z-TERMINATED to perform the terminated from financial aid edit.
1 = Any termination tracking code will cause the edit to fail regardless of a received date.
2 = Any termination tracking code without a received date will cause the edit to fail.
3 = The edit will fail if the most recent (by due date) termination tracking code does not have a received date.
SM9142-RPT-OPT Report Option. Enter 1,2 or 3 for a specific report. If left blank all reports will be printed.
1 = Files Ready for Professional Review Report
2 = Files Ready for Staff Review Report
3 = Files Ready for Packaging Report
SORT-OPTION SORT OPTION
1 = Sort by Student Identification
2 = Sort by Student Name, Student Identification
TRACK-CD-SEL Up to 10 tracking codes that must have received dates in order for the student to be selected for review. Do not separate codes with spaces or commas. If left blank, all students will be selected.
TRK-CD-OPT-DATE Enter the date that the tracking items listed in TRK-CD-OPT-SEL must be received by. Leave blank for no date requirement. Date format: MMDDCCYY
TRK-CD-OPT-SEL Enter the tracking codes that must have a received date in order for a student to be selected for file review. A student is not required to have all of the tracking codes listed, but if a student has a tracking code matching any in the list, the tracking item must have a received date. Use TRK-CD-OPT-DATE to indicate that the tracking items must be received by the specified date.
TRK-CD-RQ-DATE Enter the date that tracking items listed in TRK-CD-RQ-SEL must be received by. Leave blank for no date requirement. Date format: MMDDCCYY
TRK-CD-RQ-SEL Enter the tracking codes that must have a received date in order for a student to be selected for file review. A student must have a received date in all of the tracking codes listed. Use TRK-CD-RQ-DATE to indicate that the tracking item must have a received date by the specified date.
YR-SES-BEG The first session in the session range to review. For example, A891, A901, B011
YR-SES-END The last session in the session range to review. For example, A895, A905, B015
YR-SES-START Enter the first year session for the Academic year (for example, A891, A901, B011).
Z-AGENCY-SPONSOR Award in Sponsorship Module Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-BA-DEG-NEED Bachelors Degree in Need Database Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-BA-DEG-SM Bachelors Degree in Student System Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-ELIGIBILITY-CD Eligibility Code on Student Master Record
Y = Yes, do this edit
N = No, do not do this edit
Z-EST-INC-PAR Estimated Income Parent Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-EST-INC-STU Estimated Income Student Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-HS-GED No High School Diploma or GED Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-IN-DEFAULT-ED In Default Edit.
Y = Yes, do this edit
N = No, do not do this edit You must enter 1,2 or 3 in SEL-DEFAULT-OPT if you choose to do this edit.
Z-INVALID-INTENT Invalid Student Intent Edit
Y = Yes, do this this
N = No, do not do this edit
Z-INVALID-PROG Invalid Program Enrolled Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-NON-CITZ-NEED Ineligible Citizenship Status in Need Database
Y = Yes, do this edit
N = No, do not do this edit
Z-NON-CITZ-SM Ineligible Citizenship Status in Student System
Y = Yes, do this edit
N = No, do not do this edit
Z-NONRES-FEE-PAY Fee Pay Status other than Resident Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-OWES-REPYMT Owes Repayment Edit
Y = Yes, do this edit
N = No, do not do this edit You must enter 1,2 or 3 in SEL-REPAY-OPT if you choose to do this edit.
Z-PR-COL-TRNSFR Prior Colleges Attended in Transfer Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-PRIOR-COL-ADM Prior College Attended Admissions Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-PRIOR-COL-SM Prior Colleges Attended in Student System Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-PROBATION On Financial Aid Probation Edit
Y = Yes, do this edit
N = No, do not do this edit You must enter 1,2 or 3 in SEL-PROB-OPT if you choose to do this edit.
Z-TERMINATED Terminated from Financial Aid Edit
Y = Yes, do this edit
N = No, do not do this edit You must enter 1,2 or 3 in SEL-TERM-OPT if you choose to do this edit.
Z-VET-BENEFITS Has Veterans Benefits in Student System Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-WANTS-STU-LOAN Student Wants Loan Edit
Y = Yes, do this edit
N = No, do not do this edit
Z-WANTS-WORK-STY Wants Work Study Edit
Y = Yes, do this edit
N = No, do not do this edit

Distribution: FAS
Created: MON, FEB 22, 2010, 1:32 PM