OHIO BOARD OF REGENTS 

 

horizontal red line

Edit Specifications

 

Student Choice Adjustment File

Revised January 18, 2005

 

Error Code Edit Message Text
(Text that appears in the primary edit results)
Business Logic
(The rules that triggered the error.)
Programming Logic
(Detailed and technical explanation of the conditions that triggered the error)

035

There are non-blank characters beyond the allotted record length for this file

Same as programming logic.

If record is too long

017

Record with this student identifier and delete switch is already in the file

Same as programming logic.

If there is already a Student Choice Adjustment record for the corresponding Student Identifier and Adjustment Term in this submission file

041

No certification record found for this student at this institution for this year to apply transaction.

Same as programming logic.

Check the Student Choice certification table for an entry for the corresponding Student Identifier and institution for the year and term specified in the header, and, if no match is found, then

034

Term amount is not numeric

Same as programming logic.

If Adjustment Amount is not numeric

030

Third term disbursement not valid for semester school

Same as programming logic.

Check Academic Calendar table for term type for institution. If term type is "S" and Adjustment Term is "WI"

825

The year and term of this record is not available on this system.

Same as programming logic.

Use calculation for 030 above. If above is not true, and there is not an entry in the academic calendar table for this institution, year and term

031

Term amount exceeds program maximum

Same as programming logic.

If Adjustment Type is "I," check the SGS Program Maximum Table for the maximum annual amount for OSCG for the academic year. Check the Student Choice payment table for all award amounts and adjustments for the academic year, the term as identified in the header, and student identifier as identified in the submission file. If term type code is "S" and the sum of the all award amounts plus all adjustment amounts plus the Adjustment Amount in this SA record is more than one-half the maximum annual amount for OSCG for the academic year
OR
If term type code is "Q" and the sum of all award amounts plus all adjustment amounts plus the Adjustment Amount in this SA record is more than one-third the maximum annual amount for OSCG for the academic year

(Exception: If institution is in SGS program institution exceptions table, allow file to be submitted, and use the same annual maximum amount for SH)

032

Total of term amounts exceeds annual program maximum

Same as programming logic.

If Adjustment Type is "I," check the SGS Program Maximum Table for the maximum annual amount for OSCG for the academic year. Check the Student Choice payment table for all award amounts and adjustments for the academic year and the student identifier as identified in the submission file. Check this submission file for all SA amounts for this student identifier. If the sum of all award amounts plus all adjustment amounts plus all the Adjustment Amounts for all SA records in this file for this student identifier is more than the maximum annual amount for OSCG for the academic year

(Exception: If institution is in SGS program institution exceptions table, allow file to be submitted, and use the same annual maximum amount for SH)

014

Record for this student has already been submitted by another school

Same as programming logic.

If adjustment type is “I”, check the Student Choice 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

043

Invalid Adjustment Type

Same as programming logic.

If Adjustment Type is neither "R" nor "I"

038

Refund/nonpayment exceeds certified amount and results in a negative balance for the term.

Same as programming logic.

If Adjustment Type is "R," check the Student Choice payment table for all awards and adjustments for the term and student identifier as identified in the submission file. Check this submission file for all SA amounts for this student identifier. If the sum of all award amounts plus all adjustment amounts plus all Adjustment Amount for all SA records in this file is less than zero

032

Total of term amounts exceeds annual program maximum

Same as programming logic.

If Adjustment Type is I, check for non-zero term totals in Student Choice payment table for this student for this academic year. Check academic calendar for the institutions in each record. If term type code = “Q”, assign 1 unit of utilization. If term type code = “S”, assign 1.5 units of utilization. If sum of units > 2 but < 3, check adjustment amount in this record. If adjustment amount in this record > 1/6 of annual maximum amount for program code OSCG for the current academic year in SGS Program Maximum,

(Exception: If institution is in SGS program institution exceptions table, allow file to be submitted, and use the same annual maximum amount for SH)

033

Number of disbursements exceeds program maximum

Same as programming logic.

If Adjustment Type is I, check the utilization table for all rows for all terms for this student for this academic year. If, with the addition of this record, sum of units > 3,

056

Total of current and all previous disbursements exceeds program lifetime maximum.

Same as programming logic.

If adjustment type is "I," calculate the total terms of utilization for the OBRID by adding the estimated utilization for all scheduled payments which have not been disbursed for previous terms and the year and term in this SA record for this student, and the actual utilization for all previous years.  If calculated total terms exceeds the equivalent of 5 academic years (15 quarters or 10 semesters),

 Return to Financial Aid Files

http://ww.regents.state.oh.us/hei/datasubdoc/finaid/saedit.html
Last updated January 18, 2005