Item_Number | Item_Name | Collection_Rule_ID | Severity | Business_Rule | Short_Title | General_Message | Detailed_Message |
---|---|---|---|---|---|---|---|

005 | Collection Version | ARC00001 | E | CollectionVersion must match '2010Feb1.0AplusW' | CollectionVersion must be '2010Feb1.0AplusW' | The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2010Feb1.0AplusW' | |

005 | Collection Version | ARC00201 | E | Field exceeds its maximum length | Field exceeds its maximum length | Field exceeds its maximum length. | The {0} field exceeds its maximum allowable length of {1} character(s). |

005 | Collection Version | ARC00401 | E | Some fields supply data that is essential for the analysis of student data. The value of that field must be explicit. There are no default values. | One or more required fields are missing | Some fields supply data that is essential for the analysis of data. A value must be provided. There are no default values. | The record is missing the field {0}. |

005 | Collection Version | ARC01600 | E | There must be at least one Aplus Core record | There are no records reported | There must be at least one record reported. | |

010 | Semester Year | ARC00402 | E | SemesterYear must match first 4 characters of CollectionVersion if Correction is null. | SemesterYear is not valid. | The SemesterYear identifies the school year for the data. | |

010 | Semester Year | ARC00458 | E | SemesterYear must be first four digits of the CollectionVersion or first four digits of the CollectionVersion - 1 if Correction is not null. | SemesterYear is not valid. | The SemesterYear identifies the school year for the data. | |

015 | Semester | ARC00459 | E | Must be in code set: (Aplus_Semster_Codes). | Semester must be S, F,or W | Semester must be S (Summer), F (Fall),or W (Winter). | |

020 | Reporting Institution Code | ARC00441 | E | ReportingInstCode must match a valid District Code. District codes are in v_DESE_DISTRICT_PUB_HIGH_STATE view or 300068 (Ranken) | Invalid ReportingInstCode code | ReportingInstCode is not a valid code. | |

020 | Reporting Institution Code | ARC00700 | E | ReportingInstCode must match the SRM user's district code. | The student is not from this institution | The student's ReportingInstCode does not equal that of the trial. | |

025 | Reporting School Code | ARC00460 | E | ReportingSchoolCode must be 0000 or (begin with 11 and match a valid School Code in DESE_Attendance_Center for the SemesterYear or SemesterYear - 1). | ReportingSchoolCode is not valid for ReportingInstCode | ReportingSchoolCode is not a valid school code for the ReportingInstCode. | |

030 | Attending Institution Code | ARC00461 | E | AttendingInstCode must match a valid District Code. District codes are in v_DESE_DISTRICT_PUB_HIGH_STATE view or 300068 (Ranken) | Invalid AttendingInstCode code | AttendingInstCode is not a valid code. | |

035 | Attending School Code | ARC00602 | E | AttendingSchoolCode must be 0000 or (begin with 11 and match a valid School Code in DESE_Attendance_Center for the SemesterYear or SemesterYear - 1). | AttendingSchoolCode is not valid for AttendingInstCode | AttendingSchoolCode is not a valid school code for the AttendingInstCode. | |

050 | MOSIS Student ID | ARC00462 | E | State ID verified against ID system SIDMASTER (State_Student_ID) | StateID not found in MOSIS ID | The State ID was not found in the MOSIS ID system. | |

050 | MOSIS Student ID | ARC01001 | E | The key Semester, SemesterYear, ReportingInstCode, ReportingSchoolCode, AttendingInstCode, AttendingSchoolCode, StateId must be unique across all records in the submission. (No Duplicates allowed) | Multiple records with the same StateID | The StateID must be unique across all records in the submission that have the same Semester, SemesterYear, ReportingInstCode, ReportingSchoolCode, AttendingInstCode, AttendingSchoolCode, StateId. | |

050 | MOSIS Student ID | ARC01010 | E | StateID must exists in DESE_APLUS_STUDENT_ELIGIBILITY and Eligibility_Expired = 0 and DEGREE_OR_CERTIFICATE = 0 and Semester_6 = 0 | Student is not eligible for A+ | Student is not eligible for A+. The MOSIS ID was found to be eligible. Contact A+ if you have questions. | |

080 | Date of Birth | ARC00446 | E | DateofBirth verified against ID system (in conjunction with State ID) SIDMASTER (Date_of_Birth) and SIDMASTER (State_Student_ID) | DateOfBirth does not match MOSIS ID | The date of birth reported does not match the date of birth in the MOSIS ID system. | |

080 | Date of Birth | ARC01020 | E | DateOfBirth must be a valid date. | DateOfBirth is not a valid date | The date is not valid. A date must be in MM/DD/YYYY format and be a valid date. | |

085 | Social Security Number | ARC00445 | E | The Social Security Number can be specified as ###-##-#### or 9 digits. | SSN has an invalid format | The Social Security Number can be specified as ###-##-#### or 9 digits. | |

090 | Program of Study | ARC00609 | E | ProgramOfStudy is required if Correction is not E or D. | ProgramOfStudy is required | ProgramOfStudy is required since Correction is not E or D. | |

095 | Hours Type | ARC00611 | E | Must be in code set: (Aplus_Hour_Type_Codes). | HoursType must be in CR, or CL | HoursType must be CR (Credit Hours), or CL (Clock Hours). | |

095 | Hours Type | ARC00612 | E | Required if Correction is not E or D. | HoursType is required | HoursType is required since Correction is not E or D. | |

100 | Start Hours 1 | ARC00613 | E | StartHours1 are required to be greater than 0 and less than 100 if Correction is not "E" or "D" and HoursType is CR | StartHours is required to be greater than zero | StartHours1 is required to be greater than zero and less than 100 since HoursType is CR (Credit Hours) and the record is not a correction. | |

100 | Start Hours 1 | ARC00615 | E | StartHours1 are required to be greater than 0 and less than 1650 if Correction is not "E" or "D" and HoursType is CL | StartHours is required to be greater than zero | StartHours1 is required to be greater than zero and less than 1650 since HoursType is CL (Clock Hours) and the record is not a correction. | |

100 | Start Hours 1 | ARC00617 | E | If Correction is not "E" or "D" and If srm.dbo.DESE_APLUS_STUDENT_ELIGIBILITY.Semester_5 = 1 and FinAid = N for the StateId or SSN and HoursType is CL then StartHours1 + StartHours2 + StartHours3 cannot be greater than 550. | Student does not have enough A+ Funded Semesters. | Student does not have enough A+ Funded Semesters. Student must be reported with 550 or fewer A+ funded clock hours (StartHours1 + StartHours2 + StartHours3) since the student has already been funded for 5 semesters. | |

100 | Start Hours 1 | ARC00619 | E | If Correction is not "E" or "D" and If srm.dbo.DESE_APLUS_STUDENT_ELIGIBILITY.Semester_4 = 1 and FinAid = N for the StateId or SSN and HoursType is CL then StartHours1 + StartHours2 + StartHours3 cannot be greater than 1100. | Student does not have enough A+ Funded Semesters. | Student does not have enough A+ Funded Semesters. Student must be reported with 1100 or fewer A+ funded clock hours (StartHours1 + StartHours2 + StartHours3) since the student has already been funded for 5 semesters. | |

100 | Start Hours 1 | ARC00621 | E | If Correction is not "E" or "D" and If srm.dbo.DESE_APLUS_STUDENT_ELIGIBILITY.Semester_3 = 1 and FinAid = N for the StateId or SSN and HoursType is CL then StartHours1 + StartHours2 + StartHours3 cannot be greater than 1650. | Student does not have enough A+ Funded Semesters. | Student does not have enough A+ Funded Semesters. Student must be reported with 1650 or fewer A+ funded clock hours (StartHours1 + StartHours2 + StartHours3) since the student has already been funded for 5 semesters. | |

100 | Start Hours 1 | ARC00623 | E | If Correction is not "E" or "D" and If srm.dbo.DESE_APLUS_STUDENT_ELIGIBILITY.Semester_5 = 1 and FinAid = N for the StateId or SSN and StartHours1 is greater than zero then sum of (StartHours1 + StartHours2 + StartHours3) cannot be greater than 23. | Student does not have enough A+ Funded Semesters. | Student does not have enough A+ Funded Semesters. Student must be reported with 23 or fewer A+ funded hours since the student has already been funded for 5 semesters. | |

100 | Start Hours 1 | ARC00625 | E | StartHours1 may have 1 to 4 digits followed by a optional decimal point and 1 digits. | StartHours1 has an invalid format | StartHours1 has an invalid format. It may have 1 to 4 digits followed by a optional decimal point and 1 digits. | |

105 | Tuition Rate 1 | ARC00627 | E | Sum of HoursDropped(n) where HoursDroppedRate(n) matches TuitionRate1 cannot be greater than StartHours1. Declare @TotalDroppedHours intset @TotalDroppedHours = 0If DroppedHoursRate1 = TuitionRate1 Begin@TotalDroppedHours + DroppedHours1ENDIf Dr | HoursDropped are too high | HoursDropped matching TuitionRate1 are too high since they exceed StartHours1. | |

105 | Tuition Rate 1 | ARC00629 | E | If TuitionExempt is null or N and StartHours1 is greater than zero then TuitionRate1 is required. | TuitionRate1 is required | TuitionRate1 is required to be greater than zero sinceTuitionExempt is N (or blank) and StartHours1 is greater than zero. | |

105 | Tuition Rate 1 | ARC00631 | E | If StartHours1 is not greater than zero then TuitionRate1 must be zero or null. | TuitionRate1 not allowed | TuitionRate1 is not allowed since StartHours1 is not greater than zero. | |

105 | Tuition Rate 1 | ARC00633 | E | TuitionRate1 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | TuitionRate1 has an invalid format | TuitionRate1 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

110 | Start Hours 2 | ARC00635 | E | If Correction is not "E" or "D" and HoursType is CR then StartHours2 cannot be greater than 100. | StartHours2 cannot be greater than 100 | StartHours2 cannot be greater than 100 since HoursType is CR (Credit Hours) and the record is not a correction. | |

110 | Start Hours 2 | ARC00637 | E | If Correction is not "E" or "D" and HoursType is CR and StartHours1 is null or zero then StartHours2 cannot be greater than 0. | StartHours2 cannot be greater than 0 | StartHours2 cannot be greater than 0 since StartHours1 is zero or missing. | |

110 | Start Hours 2 | ARC00639 | E | StartHours2 may have 1 to 4 digits followed by a optional decimal point and 1 digits. | StartHours2 has an invalid format | StartHours2 has an invalid format. It may have 1 to 4 digits followed by a optional decimal point and 1 digits. | |

115 | Tuition Rate 2 | ARC00641 | E | Sum of HoursDropped where HoursDroppedRate matches TuitionRate2 cannot be greater than StartHours2. (See TuitionRate1 Rule for example.) | HoursDropped are too high | HoursDropped matching TuitionRate2 are too high since they exceed StartHours2. | |

115 | Tuition Rate 2 | ARC00643 | E | TuitionRate2 cannot match TuitionRate1 | TuitionRate2 must be unique | TuitionRate2 cannot match TuitionRate1. | |

115 | Tuition Rate 2 | ARC00645 | E | If TuitionExempt is null or N and StartHours2 is greater than zero then TuitionRate2 is required. | TuitionRate2 is required | TuitionRate2 is required to be greater than zero sinceTuitionExempt is N (or blank) and StartHours2 is greater than zero. | |

115 | Tuition Rate 2 | ARC00647 | E | If StartHours2 is not greater than zero then TuitionRate2 must be zero or null. | TuitionRate2 not allowed | TuitionRate2 is not allowed since StartHours2 is not greater than zero. | |

115 | Tuition Rate 2 | ARC00649 | E | TuitionRate2 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | TuitionRate2 has an invalid format | TuitionRate2 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

120 | Start Hours 3 | ARC00651 | E | If Correction is not "E" or "D" and HoursType is CR then StartHours3 cannot be greater than 100. | StartHours3 cannot be greater than 100 | StartHours3 is required to be greater than zero since HoursType is CR (Credit Hours) and the record is not a correction. | |

120 | Start Hours 3 | ARC00653 | E | If Correction is not "E" or "D" and HoursType is CR and StartHours2 is null or zero then StartHours3 cannot be greater than 0. | StartHours3 cannot be greater than 0 | StartHours3 cannot be greater than 0 since StartHours2 is zero or missing. | |

120 | Start Hours 3 | ARC00655 | E | StartHours3 may have 1 to 4 digits followed by a optional decimal point and 1 digits. | StartHours3 has an invalid format | StartHours3 has an invalid format. It may have 1 to 4 digits followed by a optional decimal point and 1 digits. | |

125 | Tuition Rate 3 | ARC00657 | E | Sum of HoursDropped where HoursDroppedRate matches TuitionRate3 cannot be greater than StartHours3. (See TuitionRate1 Rule for example.) | HoursDropped are too high | HoursDropped matching TuitionRate3 are too high since they exceed StartHours3. | |

125 | Tuition Rate 3 | ARC00659 | E | TuitionRate3 cannot match TuitionRate1 or TuitionRate2 | TuitionRate3 must be unique | TuitionRate3 cannot match TuitionRate1 or TuitionRate 2. | |

125 | Tuition Rate 3 | ARC00661 | E | If TuitionExempt is null or N and StartHours3 is greater than zero then TuitionRate3 is required. | TuitionRate3 is required | TuitionRate3 is required to be greater than zero sinceTuitionExempt is N (or blank) and StartHours3 is greater than zero. | |

125 | Tuition Rate 3 | ARC00663 | E | If StartHours3 is not greater than zero then TuitionRate3 must be zero or null. | TuitionRate3 not allowed | TuitionRate3 is not allowed since StartHours3 is not greater than zero. | |

125 | Tuition Rate 3 | ARC00665 | E | TuitionRate3 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | TuitionRate3 has an invalid format | TuitionRate3 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

128 | Less than full-time hours | ARC00725 | E | Required if LessThanFull is R or N. | LessThanFullHours are required | LessThanFullHours are required since LessThanFull is R or N. | |

128 | Less than full-time hours | ARC00727 | E | If Correction is not E or D and Semester is not S and LessThanFull is R or N and StartHours1 + StartHours2 + StartHours3 + LessThanFullHours is less than 12 Then LessThanFullHours is too low ELSE IF Correction is not E or D and Semester is S and LessThanF | LessThanFullHours is too low | LessThanFullHours is too low since the sum of StartHours1 + StartHours2 + StartHours 3 + LessThanFullHours is not 12 (6 for Summer Semester) or greater. | |

128 | Less than full-time hours | ARC00729 | E | LessThanFullHours may have 1 to 4 digits followed by a optional decimal point and 1 digits. | LessThanFullHours has an invalid format | LessThanFullHours does not have a valid format. It may have 1 to 4 digits followed by a optional decimal point and 1 digits. | |

129 | Less than full-time reason | ARC00731 | E | Must be in code set: (Aplus_Less_than_Full_Codes) | LessThanFull must be N, R, T, A, or H | LessThanFull must be N (Non-Degree Course), R (Repeat Course), T (Internship), A (ADA), or H (All Available Hours). | |

129 | Less than full-time reason | ARC00733 | E | If Correction is not E or D and Semester is not S and StartHours1 + StartHours2 + StartHours3 are less than 12 and LastSemester is not Y then LessThanFull is required ELSE IF Correction is not E or D and Semester is S and StartHours1 + StartHours2 + Start | LessThanFull is required | LessThanFull is required since StartHours1 + StartHours2 + StartHours3 are less than 12 (6 for Summer Semester) and LastSemester is not Y. | |

130 | Hours Dropped 1 | ARC00667 | E | If Correction is not "E" or "D" and HoursType is CL then HoursDropped1 cannot be greater than 0. | HoursDropped1 cannot be greater than 0 | HoursDropped1 cannot be greater than 0 since HoursType is CL (ClockHours). | |

130 | Hours Dropped 1 | ARC00669 | E | HoursDropped1 may have 1 to 2 digits followed by a optional decimal point and 1 digits. | HoursDropped1 has an invalid format | HoursDropped1 has an invalid format. It may have 1 to 2 digits followed by a optional decimal point and 1 digits. | |

135 | Refund Percent 1 | ARC00671 | E | RefundPercent1 may have 3 digits followed by an optional decimal point and 2 digits. | RefundPercent1 has an invalid format | RefundPercent1 does not have a valid format. It may have 3 digits followed by an optional decimal point and 2 digits. | |

135 | Refund Percent 1 | ARC00673 | W | RefundPercent1 must be null or zero unless HoursDropped1 is greater than 0. | RefundPercent1 must be null or zero | RefundPercen1t must be null or zero since HoursDropped1 is not greater than zero. | |

135 | Refund Percent 1 | ARC00675 | E | RefundPercent1 is required to be between 0 and 100 if HoursDropped1 is greater than 0. | RefundPercent1 must be between 0 and 100.0 | RefundPercent1 must be between 0 and 100.0. | |

140 | Hours Dropped Rate 1 | ARC00677 | E | HoursDroppedRate1 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | HoursDroppedRate1 has an invalid format | HoursDroppedRate1 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

145 | Hours Dropped 2 | ARC00679 | E | If Correction is not "E" or "D" and HoursType is CL then HoursDropped2 cannot be greater than 0. | HoursDropped2 cannot be greater than 0 | HoursDropped2 cannot be greater than 0 since HoursType is CL (ClockHours). | |

145 | Hours Dropped 2 | ARC00681 | E | If Correction is not "E" or "D" and HoursType is CR and HoursDropped1 is null or zero then HoursDropped2 cannot be greater than 0. | HoursDropped2 cannot be greater than 0 | HoursDropped2 cannot be greater than 0 since HoursDropped1 is zero or missing. | |

145 | Hours Dropped 2 | ARC00683 | E | HoursDropped2 may have 1 to 2 digits followed by a optional decimal point and 1 digits. | HoursDropped2 has an invalid format | HoursDropped2 has an invalid format. It may have 1 to 2 digits followed by a optional decimal point and 1 digits. | |

150 | Refund Percent 2 | ARC00685 | E | RefundPercent2 may have 3 digits followed by an optional decimal point and 2 digits. | RefundPercent2 has an invalid format | RefundPercent2 does not have a valid format. It may have 3 digits followed by an optional decimal point and 2 digits. | |

150 | Refund Percent 2 | ARC00687 | W | RefundPercent2 must be null or zero unless HoursDropped2 is greater than 0. | RefundPercent2 must be null or zero | RefundPercent2 must be null or zero since HoursDropped is not greater than zero. | |

150 | Refund Percent 2 | ARC00689 | E | RefundPercent2 is required to be between 0 and 100 if HoursDropped2 is greater than 0. | RefundPercent2 must be between 0 and 100.0 | RefundPercent2 must be between 0 and 100.0. | |

155 | Hours Dropped Rate 2 | ARC00691 | E | HoursDroppedRate2 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | HoursDroppedRate2 has an invalid format | HoursDroppedRate2 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

160 | Hours Dropped 3 | ARC00693 | E | If Correction is not "E" or "D" and HoursType is CL then HoursDropped3 cannot be greater than 0. | HoursDropped3 cannot be greater than 0 | HoursDropped3 cannot be greater than 0 since HoursType is CL (ClockHours). | |

160 | Hours Dropped 3 | ARC00695 | E | If Correction is not "E" or "D" and HoursType is CR and HoursDropped2 is null or zero then HoursDropped3 cannot be greater than 0. | HoursDropped3 cannot be greater than 0 | HoursDropped3 cannot be greater than 0 since HoursDropped1 is zero or missing. | |

160 | Hours Dropped 3 | ARC00697 | E | HoursDropped3 may have 1 to 2 digits followed by a optional decimal point and 1 digits. | HoursDropped3 has an invalid format | HoursDropped3 has an invalid format. It may have 1 to 2 digits followed by a optional decimal point and 1 digits. | |

165 | Refund Percent 3 | ARC00699 | E | RefundPercent3 may have 3 digits followed by an optional decimal point and 2 digits. | RefundPercent3 has an invalid format | RefundPercent3 does not have a valid format. It may have 3 digits followed by an optional decimal point and 2 digits. | |

165 | Refund Percent 3 | ARC00701 | W | RefundPercent3 must be null or zero unless HoursDropped3 is greater than 0. | RefundPercent3 must be null or zero | RefundPercent3 must be null or zero since HoursDropped is not greater than zero. | |

165 | Refund Percent 3 | ARC00703 | E | RefundPercent3 is required to be between 0 and 100 if HoursDropped3 is greater than 0. | RefundPercent3 must be between 0 and 100.0 | RefundPercent3 must be between 0 and 100.0. | |

170 | Hours Dropped Rate 3 | ARC00705 | E | HoursDroppedRate3 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | HoursDroppedRate3 has an invalid format | HoursDroppedRate3 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

175 | Hours Dropped 4 | ARC00707 | E | If Correction is not "E" or "D" and HoursType is CL then HoursDropped4 cannot be greater than 0. | HoursDropped4 cannot be greater than 0 | HoursDropped4 cannot be greater than 0 since HoursType is CL (ClockHours). | |

175 | Hours Dropped 4 | ARC00709 | E | If Correction is not "E" or "D" and HoursType is CR and HoursDropped3 is null or zero then HoursDropped4 cannot be greater than 0. | HoursDropped4 cannot be greater than 0 | HoursDropped4 cannot be greater than 0 since HoursDropped1 is zero or missing. | |

175 | Hours Dropped 4 | ARC00711 | E | HoursDropped4 may have 1 to 2 digits followed by a optional decimal point and 1 digits. | HoursDropped4 has an invalid format | HoursDropped4 has an invalid format. It may have 1 to 2 digits followed by a optional decimal point and 1 digits. | |

180 | Refund Percent 4 | ARC00713 | E | RefundPercent4 may have 3 digits followed by an optional decimal point and 2 digits. | RefundPercent4 has an invalid format | RefundPercent4 does not have a valid format. It may have 3 digits followed by an optional decimal point and 2 digits. | |

180 | Refund Percent 4 | ARC00715 | W | RefundPercent4 must be null or zero unless HoursDropped4 is greater than 0. | RefundPercent4 must be null or zero | RefundPercent4 must be null or zero since HoursDropped is not greater than zero. | |

180 | Refund Percent 4 | ARC00717 | E | RefundPercent4 is required to be between 0 and 100 if HoursDropped4 is greater than 0. | RefundPercent4 must be between 0 and 100.0 | RefundPercent4 must be between 0 and 100.0. | |

185 | Hours Dropped Rate 4 | ARC00719 | E | HoursDroppedRate4 may have 1 to 5 digits followed by a optional decimal point and 2 digits. | HoursDroppedRate4 has an invalid format | HoursDroppedRate4 has an invalid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

205 | Tuition Exemption | ARC00735 | E | Must be in code set: (Yes/No Code Set) | TuitionExempt must be Y or N | TuitionExempt must be Y or N. | |

210 | Last Semester | ARC00737 | E | If Correction is not E or D and Semester is not S and StartHours1 + StartHours2 + StartHours3 is less than 12 then LastSemester is required ELSE IF If Correction is not E or D and Semester is S and StartHours1 + StartHours2 + StartHours3 is less than 6 | LastSemester is required | LastSemester is required since the sum of all StartHours for this student are less than 12 (6 for Summer Semester). | |

214 | Tuition | ARC00721 | E | Tuition must equal (StartHours1 * TuitionRate1 + StartHours2 * TuitionRate2 + StartHours3 * TuitionRate3) minus (HoursDropped1 * RefundPercent1 * HoursDroppedRate1 + HoursDropped2 * RefundPercent2 * HoursDroppedRate2 + HoursDropped3 * RefundPercent3 * Hou | Tuition value is not valid | Tuition value is not valid. Tuition must equal (StartHours1 * TuitionRate1 + StartHours2 * TuitionRate2 + StartHours3 * TuitionRate3) minus (HoursDropped1 * RefundPercent1 * HoursDroppedRate1 + HoursDropped2 * RefundPercent2 * HoursDroppedRate2 + HoursDro | |

214 | Tuition | ARC00723 | E | Tuition may have 1 to 5 digits followed by a optional decimal point and 2 digits. | Tuition has an invalid format | Tuition does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

215 | Fees | ARC00739 | E | Fees may have 1 to 5 digits followed by a optional decimal point and 2 digits. | Fees has an invalid format | Fees does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

220 | Financial Aid | ARC00741 | E | Must be in code set: (Aplus_Fin_Aid_Codes). | FinAid must be F, P, or N | FinAid must be F (Full Funded), P (Funding Pending), or N (Not Funded). | |

220 | Financial Aid | ARC00743 | E | If FinAid is "P". | FinAid must be N or F to Certify | FinAid must be N or F to Certify this trial. If this student remains pending at the collection deadline the student should be removed and added next semester as a correction addition. | |

220 | Financial Aid | ARC00745 | E | if Correction is not "E" or "D" and FinAid is F (fully funded) then at least one of the following must be greater than zero. (PELL, ACG, Scholarship) | FinAid requires a funding source be provided | Since FinAid is F (Fully Funded) at least one of the following funding sources must have a value greater than zero. (PELL, ACG, Scholarship). | |

220 | Financial Aid | ARC00746 | E | if Correction is not "E" or "D" and Finaid = F then A+ Balance cannot be greater than zero for any record with that state id. | FinAid cannot be 'F' | FinAid cannot be 'F' since student has a record with AplusBalance greater than zero. | |

220 | Financial Aid | ARC00747 | E | FInAid is required if StartHours1 is greater than zero. | FinAid is required to be N, F, or P | FinAid is required to be N, F, or P since StartHours1 is greater than zero. | |

225 | PELL/SEOG | ARC00749 | E | PELL may have 1 to 5 digits followed by a optional decimal point and 2 digits. | PELL has an invalid format | PELL does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

230 | Academic Competiveness Grant | ARC00751 | E | ACG may have 1 to 5 digits followed by a optional decimal point and 2 digits. | ACG has an invalid format | ACG does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

235 | Scholarship | ARC00753 | E | Scholarship may have 1 to 5 digits followed by a optional decimal point and 2 digits. | Scholarship has an invalid format | Scholarship does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

240 | Aplus Balance | ARC00755 | E | Sum of AplusBalance for the StateID must be greater than 0 if FinAid is N. | AplusBalance must be greater than zero | AplusBalance must be greater than zero since FinAid is not (F)unded. | |

240 | Aplus Balance | ARC00757 | E | if Correction is not "E" or "D" then AplusBalance must equal Tuition + Fees - PELL - ACG - Scholarship | AplusBalance is greater or less than expected | AplusBalance should equal the sum of tuition + Fees - PELL - ACG - Scholarship. | |

240 | Aplus Balance | ARC00759 | E | AplusBalance cannot be negative. | AplusBalance cannot be negative | AplusBalance must be a positive amount. | |

240 | Aplus Balance | ARC00761 | E | AplusBalance may have 1 to 5 digits followed by a optional decimal point and 2 digits. | AplusBalance has an invalid format | AplusBalance does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

250 | Correction | ARC00763 | E | Must be in code set: (Aplus_Correction_Codes). | Correction must be D, E, or A | Correction must be D (Deficient Funds Received), E (Excess Funds Received), or A (Added Student). | |

250 | Correction | ARC00765 | E | Required if Semester does not match the last character of the CollectionVersion. | Correction is required | Correction is required since the Semester does not match the current semester being reported. | |

250 | Correction | ARC00767 | E | Correction must be null if Semester does match the last character of the CollectionVersion. | Correction must be null | Correction cannot be made for the current semester. | |

250 | Correction | ARC00769 | E | Correction cannot be "E" if CollectionVersion ends with "S". | Correction cannot be made to prior fiscal year | Correction of Excess Funding cannot be made to prior fiscal year. | |

255 | Correction Amount | ARC00771 | E | Required if Correction is "E" or "D". | CorrectionAmnt is required | CorrectionAmnt is required since Correction is E or D. | |

255 | Correction Amount | ARC00773 | E | CorrectionAmnt Must be null if Correction is null or 'A'. | CorrectionAmnt must be null | CorrectionAmnt must be null since Correction is A. | |

255 | Correction Amount | ARC00774 | E | CorrectionAmnt may have 1 to 5 digits followed by a optional decimal point and 2 digits. | CorrectionAmnt has an invalid format | CorrectionAmnt does not have a valid format. It may have 1 to 5 digits followed by a optional decimal point and 2 digits. | |

260 | Correction Comment | ARC00775 | E | Required if Correction is not null. | CorrectionCmnt is required | CorrectionCmnt is required since Correction is E, D, or A. | |

260 | Correction Comment | ARC00777 | W | CorrectionCmnt must be null if Correction is null. | CorrectionCmnt must be null | CorrectionCmnt must be null since Correction is null. |