AG994R
Need 18-19 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.

Parameters

Enter up to 50 Award Codes to be ignored for
students who fail an edit and who have already
received awards.

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

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.

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

Up to 10 tracking codes that must have a received
date in order for a student to be selected for
file review. Do not separate codes with spaces
or commas. If a student has a tracking code
matching ANY in this list (they need not have all
of them), the tracking item must have a received
date. Use TRK-CD-OPT-DATE to indicate that the
tracking item must be received by the specified
date. If left blank, all students are selected.

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, B781 or B891

YR-SES-END

The last session in the session range to review.
For example, B785 or B895

YR-SES-START

Enter the first year session for the Academic
year (for example, B781 or B891).

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-WORK-STY

Wants Work Study Edit
Y = Yes, do this edit
N = No, do not do this edit