Tool Search: MARSS Extracts
The Minnesota Automated Reporting Student System (MARSS) collects student data required by many areas of the Minnesota Department of Education. MARSS A, the School File, reports school level data.
MARSS A Extract EditorFormat Options
The following formats are available for generating this extract. State Format should be used for data submission to the state, while CSV, XML and HTML formats can be used to test and review data.
MARSS A Extract - State Format (Fixed Width)
MARSS A Extract - CSV
MARSS A Extract - XML
MARSS A Extract - HTMLMARSS A Extract Layout
If the Include Excluded Grade Levels checkbox is marked, students enrolled in Grade Levels marked as State Exclude (System Administration > Calendar > Calendar > Grade Levels > Exclude from state reporting) are included in the extract.
Element Name | Description & Format | Campus Location |
|---|---|---|
SCH_REC_ID | Record ID, reports A Alphabetic, 1 character | MN State Reporting > MARSS Extracts > Extract Type Not dynamically stored |
SUB_CDE | Extract Period, options are F: Fall or E: End of Year Alphabetic, 1 character | MN State Reporting > MARSS Extracts > Extract Period Not dynamically stored |
SCH_YER | The end year of the calendar. For example, the 2009-2010 school year would report as 10. Date field, 2 digits, YY | System Administration > Calendar > School Years > End Year SchoolYear.endYear |
DST_NUM | The state-assigned district number. Numeric, 4 digits | System Administration > Resources > District Information > State District Number District.number |
DST_TYE | The state-defined district type. Numeric, 2 digits | System Administration > Resources > District Information > Type District.type |
SCH_NUM | The state-assigned identification number for the school. Numeric, 3 digits | System Administration > Resources > School > State School Number School.number |
SCH_GRD_LVL | School Grade Level Alphanumeric, 2 digits | System Administration > Calendar > Calendar > Grade Levels GradeLevel.name |
SCH_TTL1 | The school's Title 1 status. Reports based on School History record with an Effective Date during the selected calendar. See School Title 1 Options table following. Reports from the School History record with the most recent Effective Date on or before the extract End Date. Alphabetic, 1 character | System Administration > Resources > School > School History > Title 1 SchoolHistory.title1 |
FILLER | Filler | Filler |
KGN_SCD_IND | The code indicating the Kindergarten schedule. See Kindergarten Code Options table following. Alphabetic , 1 character | System Administration> Calendar > Calendar > Grade Levels > Kindergarten Code GradeLevel.kindergartenCode |
INS_DAY_SES | Instructional days in session. Numeric, 3 digits | Not dynamically stored |
NON_INS_DAY_SES | Noninstructional days in session. Reports as blank as of the 2015-16 school year. Numeric, 3 digits | Not dynamically stored |
LGT_SCH_DAY_MIN | The number of minutes in an instructional day. Reports the Student Day instructional minutes from the Calendar. However, if the value for the Standard Day for the Grade Level is fewer minutes than the Student Day, the Standard Day reports. Numeric, 3 digits | System Administration > Calendar > Calendar > Calendar > Student Day (instructional minutes) OR System Administration > Calendar > Grade Levels > Standard Day Calendar.studentDay |
School Title 1 Options
Code | Title 1 Value (and Served Value, if applicable) |
|---|---|
A | TGELGBNOPROG, SWELIGNOPROG or NOTITLE1ELIG |
B | TGELGBTGPROG or SWELIGTGPROG and Served = Null |
C | SWELIGSWPROG |
D | TGELGBTGPROG or SWELIGTGPROG and Served = Neglected |
E | TGELGBTGPROG or SWELIGTGPROG and Served = Delinquent |
Kindergarten Code Options
Code | Description |
|---|---|
A | Half Day Every Day |
B | Full Day Every Other Day |
C | Full Day 3 Days a Week |
D | Full Day Every Day Spring-Only |
E | Full Day Every Day |
F | Full day Every Day Title 1 |
G | Fee charged KG |
