Tool Search: MT Data Upload
The Spring Enrollment Count Upload contains data about spring attendance counts. The upload must be in .tsv format. See the Upload Wizard (Montana) article for more information about this tool.
See the Spring Enrollment Count Extract article for information on the matching report for this import.
Import Spring Enrollment Count Records
See the Uploading Files section of the MT Data Upload article for detailed information about importing records via the MT Data Upload tool.
The Retrieve New Student State ID File option is only relevant to Student Demographic uploads. Please ignore this option when uploading Attendance - Spring Count data.
Spring Enrollment Count Logic
The following logic is used when importing data:
- Logic looks for enrollment records within the calendar instead of matching on schedule structure.
- When a student has multiple enrollment records, the most recent primary enrollment record is imported, unless the import has a start date or is importing off the active flag.
- When the student has multiple enrollment records and no primary enrollment record exists, the Partial or Special Ed enrollment record is used, unless the import has an enrollment type, then existing matching logic is used.
- When the student has multiple enrollment records with the same start date and neither is end dated, the enrollment with the highest enrollment ID is used.
File import completion does NOT initiate an Enrollment resync.
Header Layout
| Data Element | Description |
|---|---|
Record Type | The abbreviation for the type of file extract generated. This will always report as HD. Alphanumeric, 2 characters |
Date | The most recent date the file was generated. Date field, 10 characters, MM/DD/YYYY |
Time | The most recent time the file was generated. Time field, 8 characters, HH:MM:SS |
Version | The most current version of the file interface specification and references to the application system. This field will always report as MT9.1. Alphanumeric, 5 characters |
Extract Layout
Data Element | Description | Campus Database and UI Location |
|---|---|---|
Record Type | Always reports a value of "AS" which stands for Attendance Spring Count. Alphanumeric, 2 characters | N/A |
| District Number | Unique identifier assigned to the district by the OPI. String, 4 digits *Number is zero-padded when necessary. | District Information > State District Number District.number |
| School Number | This is a unique number assigned by the Office of Public Instruction that identifies the school into which the students are enrolled. Numeric, 4 digits | School Information > School Number School.number |
| Calendar Number | This is a unique system number that identifies the calendar(s) chosen on the extract editor. Numeric, 1-3 digits | Calendar Information Calendar.number |
| State ID | The reporting student's unique 9-digit statewide student ID number. String, 9 characters *Number is zero-padded when necessary. | Demographics > Student State ID Person.stateID |
| Local ID | Unique student ID number assigned by the school of enrollment. Numeric, 15 digits | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
| Last Name | The reporting student's legal last name. Alphanumeric, 40 characters | Demographics > Last Name Person.lastName |
| First Name | The reporting student's legal first name. Alphanumeric, 35 characters | Demographics > First Name Person.firstName |
| Exclude Spring ANB | Indicates the student will not be included in ANB calculations according to policy for one of the following reasons:
If ‘Exclude Spring ANB’ checkbox is checked, report Y. Else, report N or null. Alphanumeric, 1 character | Enrollments > State Reporting Fields > Exclude Spring ANB Enrollment.ruantSem2 |
| Aggregate Hours of Instruction | The hours of pupil instruction for which a school course or program is offered or for which a pupil is enrolled. The Spring Aggregate Hours of Inst field must equal F, T, H, Q, N or null. String, 1 character | Enrollments > State Reporting Fields > Spring Aggregate Hours of Inst Enrollment.membershipSpringSnapshot |
| Job Corps | Indicates if the student is enrolled in Job Corps during the Spring Enrollment Count. Alphanumeric, 1 character | Enrollments > Job Corps Enrollment.jobCorpsSpring |
| MT Youth ChalleNGe | Indicates if the student is enrolled in the MT Youth ChalleNGe during the Spring Enrollment Count. Alphanumeric, 1 character | Enrollments > MT Youth ChalleNGe Enrollment.mtYouthChallengeSpring |
| Age 19 or 20 Eligible for ANB | Report Y if Age 19 or 20 Eligible for ANB during the Spring Attendance Count is checked. Alphanumeric | Enrollments > Age 19 or 20 Eligible for ANB Enrollment.ageEligibleSpring |
| Early Literacy | Indicates the student participated in an early literacy program in the spring. Alphanumeric, 1 character, Y or N | Enrollments > State Reporting Fields > Spring Early Literacy EnrollmentMT.earlyLiteracySpring |
| Year | The end year of the reporting school year (i.e., 2013 is reported for the 2012-2013 school year. String, 4 characters | Calendar Information > School Years > End Year Calendar.endYear |
