Item | Item Name | Column Name | Required | Definition | Code Set | Data Type | Length | Precision |
---|---|---|---|---|---|---|---|---|

005 | Collection Version | CollectionVersion | Required | Collection version should contain this value '2011Feb1.0AplusW' for the 2011 Fall Aplus Reimbursement Collection. | Text | 50 | ||

010 | Semester Year | SemesterYear | Required | The 4 digit year in which the semester was held. | Integer | 4 | ||

015 | Semester | Semester | Required | Semester being reported. (S)ummer, (F)all, (W)inter. | Aplus_Semester_Codes | Text | 1 | |

020 | Reporting Institution Code | ReportingInstCode | Required | Institution that is requesting reimbursement. DESE assigned 6 digit college code. | Text | 6 | ||

025 | Reporting School Code | ReportingSchoolCode | Required | School code of institution requesting reimbursement. DESE assigned 4 digit school code. | Text | 4 | ||

030 | Attending Institution Code | AttendingInstCode | Required | Institution student is attending. DESE assigned 6 digit district code. | Text | 6 | ||

035 | Attending School Code | AttendingSchoolCode | Required | Required if CareerDistrictCode is not null. DESE 4 digit school code. | Text | 4 | ||

050 | MOSIS Student ID | StateID | Required | State assigned student identifier. See http://dese.mo.gov/MOSIS for more information. | Text | 10 | ||

055 | Local Student ID | LocalStudentID | Optional | Local student id. Allows for data to be associated to local systems from DESE source systems. | Text | 20 | ||

060 | Legal Last Name | LastName | Required | Legal last name. | Text | 60 | ||

065 | Legal First Name | FirstName | Required | Legal first name. | Text | 60 | ||

070 | Legal Middle Name | MiddleName | Optional | Legal middle name. | Text | 60 | ||

075 | Legal Name Suffix | Suffix | Optional | Legal name suffix. E.g. Jr, Sr | Text | 10 | ||

077 | Maiden Name | MaidenName | Optional | Maiden Name. | Text | 60 | ||

080 | Date of Birth | DateOfBirth | Required | Date of birth. | Text | 10 | ||

085 | Social Security Number | SSN | Required | Social Security Number. Formats allowed (999999999) or (999-99-9999) | Text | 11 | ||

090 | Program of Study | ProgramOfStudy | Conditional | Student's primary program of study. | Text | 50 | ||

095 | Hours Type | HoursType | Conditional | Required if Correction is not E or D. Designate the type of Hours for the record. Either Credit Hours (CR) or Clock Hours (CL). | Aplus_Hour_Type_Codes | Text | 2 | |

100 | Start Hours 1 | StartHours1 | Conditional | Required for all records unless correction is (E)xcess or (D)efficient. Number of credit hours or clock hours the student beings the semester with. | Decimal | 6 | 1 | |

105 | Tuition Rate 1 | TuitionRate1 | Conditional | Required if HoursType is CR and StartHours is greater than zero. Designate the student's tuition rate. | Decimal | 8 | 2 | |

110 | Start Hours 2 | StartHours2 | Conditional | Required for all records unless correction is (E)xcess or (D)efficient. Number of credit hours or clock hours the student beings the semester with. | Decimal | 6 | 1 | |

115 | Tuition Rate 2 | TuitionRate2 | Conditional | Required if HoursType is CR and StartHours is greater than zero. Designate the student's tuition rate. | Decimal | 8 | 2 | |

120 | Start Hours 3 | StartHours3 | Conditional | Required for all records unless correction is (E)xcess or (D)efficient. Number of credit hours or clock hours the student beings the semester with. | Decimal | 6 | 1 | |

125 | Tuition Rate 3 | TuitionRate3 | Conditional | Required if HoursType is CR and StartHours is greater than zero. Designate the student's tuition rate. | Decimal | 8 | 2 | |

128 | Less than full-time hours | LessThanFullHours | Conditional | Required if Less than full hours is Repeat Course or Non-Degree Course. The number of hours attributed to the "less than full hours" reason. | Decimal | 6 | 1 | |

129 | Less than full-time reason | LessThanFull | Conditional | Required if Hours are below 12. (Internship, ADA, All available hours, Repeat Courses, Non-Degree Class) | Aplus_LessThanFull_Codes | Text | 1 | |

130 | Hours Dropped 1 | HoursDropped1 | Optional | Number of credit hours the student drops during the semester. | Decimal | 4 | 1 | |

135 | Refund Percent 1 | RefundPercent1 | Conditional | Required if DroppedHours is greater than zero. Percent of tuition refunded for hours dropped. | Decimal | 6 | 2 | |

140 | Hours Dropped Rate 1 | HoursDroppedRate1 | Conditional | Required if DroppedHours is greater than zero. Designate the tuition rate of the dropped hours. | Decimal | 8 | 2 | |

145 | Hours Dropped 2 | HoursDropped2 | Optional | Number of credit hours the student drops during the semester. | Decimal | 4 | 1 | |

150 | Refund Percent 2 | RefundPercent2 | Conditional | Required if DroppedHours is greater than zero. Percent of tuition refunded for hours dropped. | Decimal | 6 | 2 | |

155 | Hours Dropped Rate 2 | HoursDroppedRate2 | Conditional | Required if DroppedHours is greater than zero. Designate the tuition rate of the dropped hours. | Decimal | 8 | 2 | |

160 | Hours Dropped 3 | HoursDropped3 | Optional | Number of credit hours the student drops during the semester. | Decimal | 4 | 1 | |

165 | Refund Percent 3 | RefundPercent3 | Conditional | Required if DroppedHours is greater than zero. Percent of tuition refunded for hours dropped. | Decimal | 6 | 2 | |

170 | Hours Dropped Rate 3 | HoursDroppedRate3 | Conditional | Required if DroppedHours is greater than zero. Designate the tuition rate of the dropped hours. | Decimal | 8 | 2 | |

175 | Hours Dropped 4 | HoursDropped4 | Optional | Number of credit hours the student drops during the semester. | Decimal | 4 | 1 | |

180 | Refund Percent 4 | RefundPercent4 | Conditional | Required if DroppedHours is greater than zero. Percent of tuition refunded for hours dropped. | Decimal | 6 | 2 | |

185 | Hours Dropped Rate 4 | HoursDroppedRate4 | Conditional | Required if DroppedHours is greater than zero. Designate the tuition rate of the dropped hours. | Decimal | 8 | 2 | |

205 | Tuition Exemption | TuitionExempt | Conditional | Designate the student's tuition rate is different. | Yes_No | Text | 1 | |

210 | Last Semester | LastSemester | Conditional | Required if Hours are below 12. Designate if this is the student's final semester. | Yes_No | Text | 1 | |

214 | Tuition | Tuition | Conditional | Required for all records unless correction is (E)xcess or (D)eficient. Student's tuition amount. | Decimal | 8 | 2 | |

215 | Fees | Fees | Optional | Student's fees. | Decimal | 8 | 2 | |

220 | Financial Aid | FinAid | Conditional | Required for all records unless correction is (E)xcess or (D)eficient. Designate if a student's tuition is fully funded, pending or no financial aid. | Aplus_Financial_Aid_Codes | Text | 1 | |

225 | PELL/SEOG | PELL | Conditional | Required if student is fully funded and correction is not (E)xcess or (D)eficient. Student's fees. | Decimal | 8 | 2 | |

230 | Academic Competiveness Grant | ACG | Conditional | Required if student is fully funded and correction is not (E)xcess or (D)eficient. Student's fees. | Decimal | 8 | 2 | |

235 | Scholarship | Scholarship | Conditional | Required if student is fully funded and correction is not (E)xcess or (D)eficient. Student's fees. | Decimal | 8 | 2 | |

240 | Aplus Balance | AplusBalance | Conditional | Required for all records unless correction is (E)xcess or (D)eficient. Student's Aplus Balance. | Decimal | 8 | 2 | |

245 | Comments | Comments | Conditional | Explanation of any irregularities. | Text | 200 | ||

250 | Correction | Correction | Optional | Designate if this record is a correction. Either (D)eficient Funds Received, (E)xcess Funds Received, or (A)dded student. | Aplus_Correction_Codes | Text | 1 | |

255 | Correction Amount | CorrectionAmnt | Conditional | Required if Correction is (D)eficient or (E)xcess. Amount overpaid or deficient. | Decimal | 8 | 2 | |

260 | Correction Comment | CorrectionCmnt | Conditional | Required if Correction is filled in. Comment detailing the correction specified. | Text | 200 |