NEALP Verification (NV) File

Revised March 8, 2016

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 IS or AC for this academic year
059 No application record on file for this student for this year There is no application record on file for this student If no matching OBRID is found for the current year in the application table
070 Cost of education not numeric Same as programming logic. If cost of education is not numeric
071 Expected financial aid not numeric Same as programming logic. If estimated financial aid is not numeric
072 EFC not numeric Same as programming logic. If expected family contribution is not numeric
073 EFC in record not equal to EFC in application The EFC that was submitted in this file is different than the EFC that was submitted on the student’s application. For this OBRID and academic year, if expected family contribution from this record is not equal to expected family contribution from the student's application record
074 Cost of education minus EFA and EFC not equal to award amount Same as programming logic. If (cost of education minus estimated financial aid minus estimated family contribution) is not equal to annual award amount
148 Award Amount is not numeric  Same as programming logic. If Annual Award Amount is not numeric
149 Award Amount exceeds allowable amount for this program Award amount is greater than the allowable amount. Check the NEALP application table for this student. If student has a planned educational goal =  CPN,DRN,ARN,BRN, or GDN and award amount in this file > 3000.
075 The Defaulted Loan Switch is not Y or N Same as programming logic. If Defaulted loan is not equal to Y or N
013 The Delete Switch is not Y or N Same as programming logic. If Delete Switch is not Y or N
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 verification table entry for the corresponding OBRID, (from Header Record) Institution and Year
AND a field from this file other than the OBRID, Institution, and Year does not match the corresponding field in the NEALP 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 verification table matching on all fields/columns in the record/table
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 verification table matching on Student Identifier, Institution, year
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 verification table matching on Student Identifier, institution and year 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 verification table matching on all fields, but there is also at least one certification record for the same student identifier, institution and term in academic year (from header)
017 Record with this student identifier is already in the file Same as programming logic. If there is already a NEALP verification record for the corresponding Student Identifier on this submission file
081 Invalid institution for this program This institution is not eligible to participate in the NEALP program. If institution code (from header record) is not in the NEALP institution table for this academic year
082 Student not enrolled at this institution.  This student is not enrolled at this institution for the NEALP program. If OBRID is not in the NEALP_appl_inst table for this institution and academic year.
161 Student eligibility code invalid The eligibility code is not valid. If the NEALP eligibility status code is not in the nealp eligibility status verification table
11A Date is not valid Same as programming logic 1) If Start Date is not numeric or; 2) If MM not between 1 and 12 or; 3) If DD not between 1 and 31 or; 4) YYYY < current year. If record in NV file updates the current record in database, use 4) YYYY < (current year - 1)".