FileSpec:200906JuneCycleAplusReimbursement
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2009Jun1.0AplusS' for the 2009 Summer 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 as appears on certificate of birth.
Text 60
065 Legal First Name FirstName Required Legal first name as appears on certificate of birth.
Text 60
070 Legal Middle Name MiddleName Optional Legal middle name as appears on certificate of birth.
Text 60
075 Legal Name Suffix Suffix Optional Legal name suffix as appears on certificate of birth. E.g. Jr, Sr
Text 10
077 Maiden Name MaidenName Optional Maiden Name.
Text 60
080 Date of Birth DateOfBirth Required Date of birth as appears on certificate 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 5 1
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 5 1
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 5 1
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 5 1
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