|
|
OHIO BOARD OF REGENTS |
![]()
Edit Rules for each War Orphans Adjustment (OA) Record
A. |
Read the record |
B. |
If the record is too long |
|
|
Write Error 035 on edit report file |
|
C. |
If Student Identifier contains any non-alphanumeric character in any character position |
|
|
Write Error 002 on edit report file |
D. |
Check the academic calendar entry in the academic calendar table for the term and academic year specified in the header. 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) |
|
|
Write Error 020 on edit report file |
E. |
If no match is found in the WO Certification Table for an entry for the corresponding Student Identifier and institution for the year and term specified in the header |
|
|
Write Error 041 on edit report file |
F. |
If Adjustment Amount is not numeric |
|
|
Write Error 034 on edit report file |
G. |
If Adjustment Type is neither "R" nor "I" |
|
|
Write Error 043 on edit report file |
H. |
If Adjustment Type is “I” check War Orphans Status Table for this student identifier. If status is not “AC” |
|
|
Write Error 061 on edit report file |
I. |
Check Academic Calendar table for term type for institution. If term type is "S" and Adjustment Term is "WI" |
|
|
Write Error 030 on edit report file |
J. |
If Adjustment Type is "I," MIA/POW switch in the War Orphans Application Table is N and the campus type for this institution in the institution/campus history table is IN or PY, check the Academic Calendar table for term type for institution and row from the SGS program maximum table matching on campus type, program code and academic year. If term type from the Academic Calendar table is S, determine award amount by dividing annual max by 2. If term type is Q, determine award amount by dividing the annual max by 3. Check the War Orphans Payment Table for all transaction amounts for the institution and term, as identified in the header and the student identifier. If the sum of all transaction amounts is greater than the calculated award amount from above |
|
|
Write Error 149 on edit report file |
K. |
If adjustment type is “I”, check the War Orphans Payment Table for this student identifier, term and year (from the header record). If a match is found for more than one institution, determine the net amount for each of the institutions for the year and term for this student identifier (total of all transaction amounts for that institution, year and term). If the net amount > $0.00 for more than one institution |
|
|
Write Error 014 on edit report file |
L. |
If Adjustment Type is "R," check the War Orphans Payment Table for all awards and adjustments for the term, student identifier and institution as identified in the submission file. Check this submission file for all OA amounts for this student identifier. If the sum of all award amounts plus all adjustment amounts plus all Adjustment Amounts for all WO records in this file is less than zero |
|
|
Write Error 038 on edit report file |
M. |
If there is already a record in this submission file for this Student Identifier |
|
|
Write Error 017 edit report file |
Report of Errors and Warnings
|
Edit Code |
Edit Text |
Display Field |
|
002 |
Student Identifier contains non-alphanumeric character |
Student Identifier |
|
014 |
Record for this student has already been submitted by another school |
Student Identifier |
|
017 |
Record with this student identifier and delete switch is already in the file |
Student Identifier/Delete Switch |
|
020 |
Current date is not at least 15 days later than term start date |
Start Date (from academic calendar table) |
|
030 |
Third term disbursement not valid for semester school |
Third term amount / Term type |
|
034 |
Term amount is not numeric |
Adjustment amount |
|
035 |
There are non-blank characters beyond the allotted record length for this file |
Record Length |
|
038 |
Refund/nonpayment exceeds certified amount and results in a negative balance for the term. |
Refund Amount, Non-pay Amount |
|
041 |
No certification record found for this student at this institution for this year to apply transaction. |
Student ID, Academic Year, Institution |
|
043 |
Invalid Adjustment Type |
Adjustment Type |
|
061 |
No record with valid status on file for this student |
Student Identifier |
|
149 |
Award amount exceeds allowable amount for this institution |
Award amount/institution |
![]()
http://ww.regents.state.oh.us/hei/datasubdoc/finaid/oaedit.html
Last updated July 31, 2003