NEALP Certification (NT) File Revised May 31, 2006

 

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
061 No record with valid status on file for this student This student’s status renders them ineligible for the scholarship. Check NEALP Application Status table. If status for this OBRID is not AC for this academic year
037 Invalid Student Rank Same as programming logic. If Student Rank is not in the Nursing Grade Level table
076 Invalid Enrollment Status Same as programming logic. If Current Enrollment Status is not "F", "H" or "L"
077 Satisfactory Progress not Y or N Same as programming logic. If Satisfactory Progress is not "Y" or "N"
148 Award amount is not numeric Same as programming logic. If Award Amount is not numeric
152 Award amount cannot be $0.00. Same as programming logic. If Award Amount is = 0.00 (Edit message area = S)
078 Projected Graduation Date is blank, non-numeric, or contains invalid values Same as programming logic. If Projected Graduation Date is blank, not numeric, has invalid values (Invalid values include: first 2 characters are <01 or >12, third and fourth character positions are <01 and >31, fifth and sixth are <> 19 or 20; year of submission is greater than projected graduation date)
013 The Delete Switch is not Y or N Same as programming logic. If Delete Switch is not Y or N
079 This student is ineligible for NEALP because they defaulted on a student loan. Same as programming logic. For this OBRID and academic year, if defaulted loan = Y (from verification table)
012 Record row is already in the table Same as programming logic. If Delete Switch is N and there is a row in the NEALP certification tables matching on all fields
014 Record for this student has already been submitted by another school Same as programming logic. If Delete Switch is N, check NEALP payment table matching on Student Identifier, term and year (as determined by header record), but not on Institution. If a match is found for more than one institution, determine the total (net) amount for each of the other institutions for the term and year for that student (total of all transaction amounts for that institution, term and year). If the net amount is > $0.00 for other institutions
016 Record for this student is not in the table Same as programming logic. If Delete Switch is Y and there is no row in the NEALP certification table matching on Student Identifier, Institution, year and term
019 Delete record does not match table row Same as programming logic. If Delete Switch is Y and there is a row in the NEALP certification tables matching on Student Identifier, institution, year and term 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. Same as programming logic. If Delete Switch is Y and there is a row in the NEALP certification tables matching on all fields, but there is also at least one payment disbursed for the same student identifier, institution and term or there is at least one row in the adjustment table that matches OBRID, institution and term
017 Record with this student identifier and delete switch is already in the file Same as programming logic. If there is already a NEALP record for the corresponding Student Identifier on this submission file
020 Current date is not at least 15 days later than term start date Same as programming logic. Check the academic calendar entry for this institution for the term 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 (EXCEPTION: If term code for this institution is “S” and term in header is “WI”)
030 Third term disbursement not valid for semester school Same as programming logic. Check academic calendar table for term code for institution. If term code is "S" and term in header record 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
B02 WARNING - Payment request reflects a transfer from another institution Same as programming logic. If Delete Switch is N and there is a row in the NEALP Certification table for any term in the same academic year as the term in the header matching on Student Identifier, but not on Institution
031 Term amount exceeds program maximum Same as programming logic. If Delete Switch is N, check the NEALP verification table for the annual award amount for this student, institution and academic year and check the academic calendar table for term code for institution. If term code is "S" and the award amount in the record is more than one-half the annual award amount
OR
If term code is "Q" and the award amount in the record is more than one-third the annual award amount
033 Number of disbursements exceeds program maximum Same as programming logic. If Delete Switch is N, use calculation for amount of utilization as found in the load requirements for the utilization table. If, with the addition of this record, sum of units > 3,
056 Student has no remaining utilization. Same as programming logic. If Delete Switch is N, calculate the total terms of utilization for the OBRID from the NEALP utilization table. If sum of grant unit num of all rows is greater than or equal to 4 academic years (12 quarters or 8 semesters)
U02 UPDATE: Fields for this record did not match all fields submitted in previous version of this file. These fields will be updated. Same as programming logic. If Delete Switch is N and there is already a NEALP certification table entry for the corresponding OBRID, (from Header Record) Institution, Year, Term and Award Amount
AND
a field from this file other than the OBRID, Institution, Year, Term and Award Amount does not match the corresponding field in the NEALP certification table
B06 Student is making unsatisfactory progress and will not be paid for this term. Same as programming logic. If Satisfactory Progress is N
B07 Student is enrolled less than half time and will not be paid for this term. Same as programming logic. If Current Enrollment status is L
083 Student was awarded for expense period 2 and is not eligible for AU term disbursement. Same as programming logic. Check the NEALP application table for this student and academic year. If expense period code = 2 and the term (from the header record) is = “AU”
084 Row already exists for this student with a different award amount. Same as programming logic. If delete switch is N, and record exists in NEALP certification table that matches on SSN, year, term, inst code, but not award amount