|
|
OHIO BOARD OF REGENTS |
|
|
OHIO BOARD OF REGENTS |
|
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 the record is too long |
| 002 | Student Identifier contains non-alphanumeric character | Same as programming logic. | If Student Identifier contains any non-alphanumeric character in any character position |
| 013 | The Delete Switch is not Y or N | Same as programming logic. | If Delete Switch is not Y or N |
| 017 | Record with this student identifier and delete switch is already in the file | There are two or more of this same record in this file | If there is already a War Orphans Scholarship Certification record for the corresponding Student Identifier, inst, term, year, AND delete Switch is N on this submission file. |
| 020 | Current date is not at least 15 days later than term start date | Today’s date is less than 15 days after the start date of this term. | Check the academic calendar entry for this institution for the term and 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 |
| 150 | Record row is already in the certification table | This record already exists in the table, and cannot be reinserted. | If Delete Switch is N and there is already a record in the certification table matching on Student Identifier, term and year, |
| 012 | Record row is already in the table | This record already exists in the table because a refund has never been made. | If Delete Switch is N and there is already a record in the payment table matching on all fields/columns in the record/table but there is no corresponding refund in the payment table |
| 037 | Invalid Student Rank | Same as programming logic. | If Student Rank is not "FR", "SO", "JR" or "SR" |
| 058 | GPA contains non-numeric characters | Same as programming logic. | If Student GPA is not numeric |
| 091 | GPA is greater than 4.00 | Same as programming logic. | If Student GPA is greater than 4.00 |
| B01 | WARNING - GPA is less than 2.00 | Student does not have a documented learning disability, has been enrolled for one year, and their GPA is less than 2.00. | If learning disability switch is "N" AND GPA is equal to or greater than 0.00 but less than 2.00, check War Orphans Payment Table, War Orphans Payment History Table for all matches on student identifier. Check Academic Calendar for all matches on Institution Code, year and term from selected rows. If student has 3 or more rows from quarter schools OR 2 or more rows from semester schools |
| 030 | Third term disbursement not valid for semester school | Winter disbursements are not allowed for semester schools. | Check academic calendar table for term type for institution. If term type is "S" and term in header is "WI" |
| B02 | WARNING - Payment request reflects a transfer from another institution | This student has been previously enrolled at another institution. | If Delete Switch is N and there is a row in the War Orphan 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 |
| 014 | Record for this student has already been submitted by another school | This student has already been submitted by another school for payment for this year and term. | If Delete Switch is N and there is a row in the War Orphan Scholarship Certification table for the same term in the year matching on Student Identifier, but not on Institution, check War Orphans Payment Table for the sum of all transaction amounts for that term, year and previous institution. If sum > zero |
| 061 | No record with valid status on file for this student | This student’s status renders them ineligible for the scholarship. | Check War Orphans Status. If status for this OBRID is not AC or RI |
| 016 | Record for this student is not in the table | This record cannot be deleted because it is not in the table. | If Delete Switch is Y and there is no row in the War Orphans Scholarship Certification table matching on Student Identifier, Institution Code, year and term (from header record) |
| 019 | Delete record does not match table row | This record cannot be deleted because the row in the table contains different field values than this record. | If Delete Switch is Y and there is a row in the War Orphans Scholarship Certification table matching on Student Identifier, Institution, year and term (from header record) but other fields in the record do not match the columns in the table row |
| 050 | Disbursements or adjustments on file. Record cannot be deleted. | This record cannot be deleted because money has been disbursed. | If Delete Switch is Y and there is a row in the War Orphans 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 year |
| 056 | Total of current and all previous disbursements exceeds program lifetime maximum. | The student has reached the lifetime maximum scholarship amount. |
If Delete Switch is N, and learning
disability switch is N, calculate the total terms of utilization for the
OBRID. Check War Orphans Payment Table and War Orphans Payment History
Table for all matches on student identifier where sum of transaction
amounts for term is greater than zero. If calculated total terms is not
less than the equivalent of 5 academic years (15 quarters or 10 semesters) OR If Delete Switch is N, and learning disability switch is Y, calculate the total terms of utilization for the OBRID. Check War Orphans Payment Table and War Orphans Payment History Table for all matches on student identifier where sum of transaction amounts for term is greater than zero. If calculated total terms is not less than the equivalent of 10 academic years (30 quarters or 20 semesters) (Assess 1 unit for every quarter term transaction and 1.5 units for every semester term transaction.) |
| 059 | No application record on file for this student for this year | There is no application record on file for this student | Check application table for OBRID. If no match found |
| B04 | WARNING: Student is eligible for MIA/POW Benefits. Please request room & board, books, general and lab fees as well. | Same as programming logic. | If MIA/POW is Y |
| B05 | WARNING: Amount awarded to student is the equal to or less than students not eligible for MIA/POW benefits | Same as programming logic. | If MIA/POW switch is "Y", check War Orphans Certification Table and War Orphans Application Table. If the award amount from this record is equal to or less than the award amount from any other record in War Orphans Certification Table matching on year, term and institution, where MIA/POW switch is "N" in War Orphans Application Table, then |
| 148 | Award Amount is not numeric | Same as programming logic. | If Award Amount is not numeric |
| 149 | Award Amount exceeds allowable amount for this institution | Award amount for this institution is greater than the allowable amount. | If MIA/POW switch in War Orphans Application Table is N and the campus type code for this institution in the institution/campus history table is IN or PY, check the Academic Calendar for the term type for institution and row from the SGS program maximum table matching on campus type code, program code (WO) and academic year. If term type from Academic Calendar 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. If the award amount in this record is greater than the calculated award amount from above OR If campus type code is UM, UB, SC, CC, or TC and the award amount > $15,000 |
http://ww.regents.state.oh.us/hei/datasubdoc/finaid/woedit.html
Last updated August 10, 2004
