New OBR logo

OHIO BOARD OF REGENTS 

 

horizontal red line

 

Edit and Load Specifications

 

War Orphans Adjustment (OA) File
September 10, 2003

 

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

 

horizontal red line

 

Return to Financial Aid Files

http://ww.regents.state.oh.us/hei/datasubdoc/finaid/oaedit.html
Last updated July 31, 2003