Edit and Load Specifications

Academic Scholarship (AS) Certification File
December 11, 2001

Edit Rules for each Academic Scholarship (AS) Certification Record

1. Read the record
2. If record is too long
                   write Error 035 on edit report file.
3. If Student Identifier contains any non-alphanumeric character in any character position
                   write Error 002 on edit report file.
4. If Delete Switch is not Y or N
                   write Error 013 on edit report file.
5. If there is already an Academic Scholarship Certification record for the corresponding Student Identifier, and Delete Switch on this submission file
                   write Error 017 on edit report file.
6. Check the academic calendar entry for this institution for the term and academic year specified in the header, and, if the current date is not at least 15 days later than the start date specified in the table row (or if the table row is not present), then
                   write Error 020 on edit report file.
7. If Delete Switch is N and there is already a record in the payment table matching on Student Identifier, , term and academic year but there is no corresponding refund in the payment table

              write Error 012 on edit report file.

8. If Student Rank is not "FR", "SO", "JR" or "SR"
                  write Error 037 on edit report file.
9. If Student GPA is not numeric
                  write Error 058 on edit report file.
10. If Student GPA is greater than 4.00
                   write Error 091 on edit report file.
11. If Student GPA is greater than 0.00 but less than 2.00
                   write Warning B01on edit report file.
12. Check academic calendar table for term_type_code for institution. If term_type_code is "S" and academic term in header is "WI"
                   write Error 030 on edit report file.
13. If Delete Switch is N and there is a row in the Academic Scholarship Certification table for any term in the academic year other than the term in the header matching on Student Identifier, , but not on Institution
                    write Warning B02on edit report file and

generate the following email message to the data reporter

14. Check status for OBRID. If status is not NA or PA
                    write Error 061 on edit report file.
15. If Delete Switch is Y and there is no row in the Academic Scholarship Certification table matching on Student Identifier               

16. If Delete Switch is Y and there is a row in the Academic Scholarship Certification table matching on Student Identifier, and Institution but other fields in the record do not match the columns in the table row and the term and year in the header do not match those columns in the table row
                    write Error 019 on edit report file.
17. If Delete Switch is Y and there is a row in the Academic Scholarship Certification table matching on all fields for the term and academic year, but there is also a payment disbursed for the same Student Identifier, Institution, term and academic year
                    write Error 050 on edit report file.
18. If Delete Switch is N, calculate the total terms of utilization for the OBRID and "shared" scholarship OBRID, if OBRID is in the "shared" scholarship table, by adding the estimated utilization for this record, the estimated utilizations for all scheduled payments which have not been disbursed for all institutions for this ( and shared) OBRID, and the actual utilization for all previous terms minus all refunds for all institutions for this (and shared) OBRID. If calculated total terms is not less than the equivalent of 4 academic years (12 quarters or 8 semesters)

                  write Error 056 on edit report file.

Assess 1 unit for every quarter term transaction and 1.5 units for every semester term transaction. The total number of utilization units must be no more than 12.5.

19. Check application table for OBRID. If no match found. write error 059 on edit report file.

Return to Financial Aid Files