Classic View: MN State Reporting > MARSS Extracts
Search Terms: MARSS B Extract
The Minnesota Automated Reporting Student System (MARSS) collects student data required by many areas of the Minnesota Department of Education. MARSS B, the Student File, gathers a broad range of student data, particularly details found in student enrollments.
Image 1: MARSS B Editor
Report Logic
The MARSS B Extract reports a record for each enrollment in the selected Calendar(s) within the entered Date Range. If the user selects calendar(s) from the year prior to the selected School Year, the report will include the prior year calendar(s) that fall within the Date Range entered.
Students enrolled in a Grade marked as 'Exclude from State Reporting' are not included in the results.
If a student has a State Aid Category of 46 (STATE AID CATEGORY), the following fields report as indicated:
File Naming Logic
If generating the MARSS B extract in State Format, the output file is named as follows:
"B" + 'district' + "." + 'extractPeriod' + 'yearNum'
Format Options
The following formats are available for generating this extract. State Format should be used for data submission to the state, with CSV, XML and HTML formats can be used to test and review data.
Image 2: MARSS B Extract - State Format (Fixed Width)
Image 3: MARSS B Extract - CSV
Image 4: MARSS B Extract - XML
Image 5: MARSS B Extract - HTML
MARSS B Extract Layout
If Report Legal Identities When Provided is marked, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information.
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) will be included in the extract.
The element name prior to the release of Campus.2008 is shown below the bolded name.
Element Name | Description & Format | Campus Location |
---|---|---|
VALUE B STU_REC_ID | Record ID, reports B Alphabetic, 1 character | MN State Reporting > MARSS Extracts > Extract Type Not dynamically stored |
VALUE F or E SUB_CDE | Extract Period, options are F: Fall and E: End of Year Alphabetic, 1 character | MN State Reporting > MARSS Extracts > Extract Period Not dynamically stored |
SCHOOL YEAR SCH_YER | The end year of the school year selected in the extract editor. 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 |
STUDENT NUMBER STU_NUM | Student's unique identification number. Numeric, 13 digits | Census > People > Demographics > Person Identifiers > State ID Student.number |
FILLER SOC_SEC_NUM | Student's social security number. Currently reports as 000000000. Numeric, 9 digits | Census > People > Demographics > Soc Sec Number Identity.ssn |
DISTRICT NUMBER DST_NUM | The state-assigned district number. Numeric, 4 digits | System Administration > Resources > District Information > State District Number District.number |
DISTRICT TYPE DST_TYE | The state-defined district type. Numeric, 2 digits | System Administration > Resources > District Information > Type District.type |
SCHOOL NUMBER SCH_NUM | The state-assigned identification number for the school. Numeric, 3 digits | System Administration > Resources > School > State School Number School.number |
STUDENT GRADE LEVEL STU_GRD_LVL | The grade level of the student's current enrollment. Alphanumeric, 2 characters | Student Information > General > Enrollments > Grade Enrollment.gradeLevel |
STUDENT RESIDENT DISTRICT NUMBER STU_RES_DST_NUM | The number of the student's resident district. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District Enrollment.residentDistrict |
STUDENT RESIDENT DISTRICT TYPE STU_RES_DST_TYE | The type of the student's resident district. Numeric, 2 digits | System Administration > Resources > District Information > Type District.type |
FILLER STU_RES_SCH_NUM | The number of the student's resident school. Reports as 3 blank spaces. Numeric, 3 digits | Student Information > General > Enrollments > State Reporting Fields > School EnrollmentMN.school |
STATE AID CATEGORY STT_AID_CAT | State aid category of the aid service being provided to the student. See the State Aid Category Options table following. Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > State Aid Category EnrollmentMN.stateAidCategory |
STATUS START DATE STS_BEG_DAT | The start date of the student's enrollment. Will always be on or after the Start Date entered in the extract editor. Date field, 8 digits, YYYYMMDD | Student Information > General > Enrollments > Start Date Enrollment.startDate |
LAST LOCATION OF ATTENDANCE LST_LOC_ATT | The start status of the student's enrollment, the last location of attendance. If the prior year's enrollment Start Date is on or after the Start Date entered in the extract editor, reports the enrollment's Start Status. Otherwise reports as 00. See the Start Status Options table following. Numeric, 2 digits | Student Information > General > Enrollments > Start Status Enrollment.startStatus |
STATUS END STS_END | The end status of the student's enrollment. Reports first from the student's enrollment. If that value is null, reports the End Code Override entered on the Calendar tab, if applicable. If both are null, reports as 40. See the End Status Options table following. Numeric, 2 digits | Student Information > General > Enrollments > End Status; System Administration > Calendar > Calendar > Calendar > End Code Override Enrollment.endStatus Calendar.endCodeOverride |
STATUS END DATE STS_END_DAT | The end date of the student's enrollment. Date field, 8 digits, YYYYMMDD | Student Information > General > Enrollments > End Date Enrollment.endDate |
PERCENT ENROLLED PER_ENR | The percent of time that student is enrolled. Numeric, 3 digits | Student Information > General > Enrollments > State Reporting Fields > Percent Enrolled Enrollment.percentEnrolled |
ATTENDANCE DAYS ATT_DAY | The number of student attendance days. Reports first from the Attendance Override from the Enrollment, if entered. Otherwise, reports the total number of Instructional Days a student was present during the enrollment record start and end date in half or whole days. This value cannot exceed the Maximum Membership Days listed on the Grade Levels tab and will not include any days prior to the Start Date entered in the Extract Editor. This field reports with an implied decimal. For example, 25.5 days reports as 00255. Numeric, 5 digits | Student Information > General > Enrollments > State Reporting Fields > Attendance Override; Calculated Enrollment.adaOverride, Calculated |
MEMBERSHIP DAYS MBR_DAY | The number of days the student was in membership. Reports first from the Membership Override from the Enrollment, if entered. Otherwise, reports the total number of Instructional Days during the enrollment start and end date. This value cannot exceed the Maximum Membership Days listed on the grade levels tab and will not include any days prior to the Start Date entered in the Extract Editor. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Membership Override; Calculated Enrollment.admOverride, Calculated |
POST SECONDARY OPTIONS INDICATOR PST_SEC_OPT | Indicates student participates in Post Secondary Options.
Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > PSEO Enrollment.pseo |
PSEO HIGH SCHOOL PARTICIPATION HOURS PST_SEC_HRS_HS | The number of hours the high school student participates in PSEO. Reports the Post-Secondary HS Hours value entered (zero if necessary). If null, reports as 0000. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Post-Secondary HS Hours EnrollmentMN. pseoHours |
HOMEBOUND SERVICE INDICATOR HOM_BND_SRV | Indicates if student is home bound and receiving services. Options are Y: Yes and N: No. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Homebound Enrollment.homebound |
SPECIAL ED EVALUATION STATUS SPC_ED_STS | The student's special education status. See the Special Ed Status Options table following. Numeric, 1 digit | Student Information > General > Enrollments > Special Ed Fields > Special Ed Status Enrollment.specialEdStatus |
SPECIAL ED INSTRUCTIONAL SETTING SPC_ED_INS_STG | The instructional setting of the student's special ed program. See the Special Ed Disability Setting Options table following. Numeric, 2 digits | Student Information > General > Enrollments > Special Ed Fields > Special Ed Disability Setting Enrollment.specialEdSetting |
ENGLISH LEARNERS LEP_PCP | Indicates if the student is considered to be English Learners (EL). See the following EL Logic section for field logic details. Alphabetic, 1 character | Student Information > Program Participation > English Learners (EL) > Program Status > EL Lep.programStatus |
EL BEGIN DATE LEP_BEG_DAT | The date the student's English proficiency was determined. Reports based on user-defined services with a State Service Type of State Reported. If the Location entered on the student's EL Services program does not match the school the student is enrolled in, reports as 00000000. Date field, 8 digits, YYYYMMDD | Student Information > Program Participation > English Learners (EL) > EL Services > Start Date LepService.startDate |
GIFTED AND TALENTED PARTICIPATION GFT_TAL_PCP | Indicates if the student is considered Gifted/Talented. If there is a Gifted record for the student that is active at any point during the student's enrollment, reports as Y. Otherwise reports as N. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Gifted/Talented Enrollment.giftedTalented |
SEX/GENDER SEX_GEN | The gender of the student. Options are M: Male and F: Female. Alphabetic, 1 character | Census > People > Demographics > Gender Identity.gender |
NORTH AMERICAN INDIAN RAC_ETH | The student's Race/Ethnicity. Reports as 1 if Race/Ethnicity is 01 or 03. Otherwise reports as 0. Numeric, 1 digit | Census > People > Demographics > State Race/Ethnicity Identity.raceEthnicity |
BIRTH DATE BTH_DAT | The student's birth date. Date field, 8 digits, YYYYMMDD | Census > People > Demographics > Birth Date Identity.birthDate |
HOME LANGUAGE HOM_PRM_LNG | The primary or first language of the student, the language spoken in the student's home. Numeric, 3 digits | Census > People > Demographics > Home Primary Language Person.language |
PRIMARY DISABILITY PRM_DIS | The student's primary disability. See the Disability Options table following. Numeric, 2 digits | Student Information > General > Enrollments > Special Ed Fields > Primary Disability Enrollment.disability1 |
TRANSPORTATION CATEGORY TRA_CAT | The student's transportation category. Reports Transportation Category; if that is NULL, reports default from Attribute Dictionary; if that is NULL, reports as 00. See the Transportation Category Options table following. Numeric, 2 digits | Student Information > General > Transportation > Transportation Category Transportation.transportationCode |
ECONOMIC INDICATOR ECO_IND | The student's meal status. Report highest sequence.
When multiple Eligibility records exist for a student in the selected calendar, reports as follows:
If an enrollment record ends prior to the start date of any FRAM records in the same academic year, it still considers the FRAM records using the preceding logic. Prior Year Calendar Logic: Prior Year MARSS B records will look for an application that has an eligibility school year + 1 of the prior year calendar. Numeric, 1 digit | FRAM > Eligibility > Eligibility POSeligibility.eligibility |
MIGRANT INDICATOR MIG_IND | Indicates that the student is a migrant. Options are Y: Yes and N: No. This field only reports when the extract is run for years prior to the 14-15 school year. For all years 14-15 and later, this field reports as blank. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Migrant Enrollment.migrant |
TITLE I STUDENT INDICATOR STU_TTL1 | Indicates that the student is receiving Title 1 services. Reports as follows:
Alphabetic, 1 character | Student Information > Program Participation > Title I > Start & End Date; System Administration > Resources > School > School History > Title 1 Title1.startDate SchoolAttribute.Title1 |
HOMELESS STUDENT HML_STU | Indicates that the student is considered homeless. If the student has a Homeless record that is active at any point during the student's enrollment, reports as Y. Otherwise reports as N. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Homeless Enrollment.homeless |
TRANSPORTING DISTRICT NUMBER TRA_DST_NUM | The number of the district which is responsible for student's transportation. Reports the first 4 characters of the Transporting District if STT_AID_CAT reports as 46. Otherwise, reports State District Number. Numeric, 4 digits | Student Information > General > Transportation > Transporting District OR System Administration > Resources > District Information > State District Number Custom Student |
TRANSPORTING DISTRICT TYPE TRA_DST_TYE | The type of the district which is responsible for student's transportation. Reports the last 2 characters of the Transporting District if STT_AID_CAT reports as 46. Otherwise, reports State District Type . Numeric, 2 digits | Student Information > General > Transportation > Transporting District OR System Administration > Resources > District Information > District Type Custom Student |
SPECIAL PUPILS CARE TREATMENT WRD_STT | An indicator representing a Student who qualifies as a Special Pupil for Care and Treatment at some time during the school year. If "Special Pupils for Care/Treatment" is 'Y: Yes', reports 'Y'. Otherwise reports 'N'. Alphabetic, 1 character, Y or N | Student Information > General > Enrollments > State Reporting Fields > Special Pupils for Care/Treatment EnrollmentMN.specialCare |
INDEPENDENT STUDY FLAG IS_FLG | Indicates that the student is participating in an Independent Study program. If the student has a SAAP record that is active at any point during the student's enrollment with the Independent Study Indicator marked, reports as Y. Otherwise reports as N. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Independent Study EnrollmentMN.independentStudy |
FILLER SES_SRV | Indicates that the student receives Supplemental Educational Services. Current reports as blank. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Supplemental Services EnrollmentMN.supplementalServices |
SPECIAL EDUCATION SERVICE HOURS SPC_SRV_HRS | The number of hours the student received special ed services with a special ed status of 4 or 6. If Service Hours is null, reports the Direct and Indirect minutes per session from the student's IEP. This field includes an implied decimal. Service Hours are calculated as follows:
Numeric, 5 digits | Student Information > General > Enrollments > Special Ed Fields > Service Hours or Student Information > Special Ed > Documents > IEP > Education Plan Custom Enrollment |
MINNESOTA CARE PROGRAM OPT OUT OPT_OUT_MNCR | Indicates that the student has chosen to opt out of SCHIP/MNCare services. FRAM records with a Start Date prior to 7/1 of the academic year being reported are not reported. Alphabetic, 1 character, Y or N | (E line) FRAM > Eligibility > Opt Out SCHIP POSEligibility.optOutSCHIP |
FILLER OPT_OUT_GAMC | Indicates that the student has chosen to opt out of Medicaid/General Assistance services. Current reports as blank. Alphabetic, 1 character, Y or N | (E line) FRAM > Eligibility > Opt Out Medicaid POSEligibility.optOutMedicaid |
RESERVED FOR FUTURE USE FILLER2 | Filler | Filler |
HISPANIC-LATINO HIS_LAT | Indicates that the student is Hispanic/Latino. Options are Y: Yes and N: No. Alphabetic, 1 character | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
AMERICAN INDIAN ALASKA NATIVE AMI_IND_ALK | Indicates that the student is American Indian/Alaska Native. Options are Y: Yes and N: No. Alphabetic, 1 character | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
ASIAN ASI | Indicates that the student is Asian. Options are Y: Yes and N: No. Alphabetic, 1 character | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
BLACK-AFRICAN AMERICAN BLK_AFR | Indicates that the student is Black/African American. Options are Y: Yes and N: No. Alphabetic, 1 character | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
NATIVE HAWAIIAN PACIFIC ISLANDER HAW_PAC | Indicates that the student is Native Hawaiian/Pacific Islander. Options are Y: Yes and N: No. Alphabetic, 1 character | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
WHITE WHT | Indicates that the student is White. Options are Y: Yes and N: No. Alphabetic, 1 character | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
PSEO CONCURRENT ENROLLMENT FLAG PST_CON_OPT | Indicates that the student is concurrently enrolled in CIS and PSEO. Options are Y: Yes and N: No. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > CIS PSEO Concurrent Enr EnrollmentMN.CISPSEOConcurrentEnr |
LOCAL USE DATA LOC_USE_DATA | Reports the PersonID. Alphanumeric, 6 characters | Census > People > Demographics > Person Identifiers > PersonID Identity.personID |
STUDENT LAST NAME LST_NAM | Student's last name. If Report Legal Identities When Provided is marked, reports from Census > People > Identities > Active Identity > Protected Identity Information. Alphabetic, 40 characters | Census > People > Demographics > Last Name Identity.lastName |
STUDENT FIRST NAME FST_NAM | Student's first name. If Report Legal Identities When Provided is marked, reports from Census > People > Identities > Active Identity > Protected Identity Information. Alphabetic, 40 characters | Census > People > Demographics > First Name Identity.firstName |
STUDENT MIDDLE NAME MID_NAM | Student's middle name. If Report Legal Identities When Provided is marked, reports from Census > People > Identities > Active Identity > Protected Identity Information. Alphabetic, 40 characters | Census > People > Demographics > Middle Name Identity.middleName |
NAME SUFFIX SUFFIX | The suffix marking the student's generation. Alphanumeric, 3 characters | Census > People > Demographics > Suffix Identity.suffix |
State Aid Category Options
Code | Description |
---|---|
00 | Regular: enrolled at resident district |
01 | Open Enrollment |
02 | Foreign Exchange Student J-1 Visa |
03 | HSGI Nonresident |
04 | 11/12th Grade choice |
05 | Interdistrict cooperative agreement |
06 | Cooperative Facilities |
08 | Charter school (student/parent choice) |
10 | Joint Powers Agreement |
11 | Missed Open Enr. Deadline |
13 | State Board Exceptions |
14 | Enrolled in another state |
15 | Resident of other state/country |
16 | Shared Time paid to resident district |
17 | Shared Time paid to serving district |
18 | Shared Time paid by parent/guardian |
19 | Tuition agreement w/ resident district |
20 | Tuition agreement w/ parent/guardian |
21 | Ineligible nonresident student |
22 | Open enr, returned to res dist |
24 | Early graduate |
25 | Adult HSGI student |
26 | Private school HSGI |
27 | Temporary care/treatment |
28 | Resident at private school (IEP/care) |
34 | Tribal, meets BIA |
35 | Tribal, does not meet BIA |
41 | Screening by District (general revenue) |
42 | Child & Teen Checkups/EDSDT |
43 | Head Start |
44 | Private Provider |
45 | Conscientious Objector |
46 | ESY Enrollment |
51 | South Dakota residents under reciprocity agreement |
52 | Minnesota residents under reciprocity agreement |
97 | Katrina Evacuee |
98 | Summer graduate/dropout |
Start Status Options
Code | Description |
---|---|
00 | Last year, public school, same district |
01 | Last year, MN nonpublic school |
02 | Last year, another state |
03 | Last year, another country |
04 | Last year, MN public school, other district |
05 | Age 5 or younger as of 9/1, never before in school |
06 | Age 6 or older as of 9/1, never before in school |
07 | Last enrolled before last year |
11 | Midyear transfer from MN nonpublic school |
12 | Midyear transfer from other state |
13 | Midyear transfer from other country |
14 | Midyear transfer from other MN school district |
21 | Midyear transfer from school in this district |
22 | Midyear grade level change |
23 | Midyear change in district of residence |
24 | Midyear re-enrollment after drop |
End Status Options
Code | Description |
---|---|
00 | Used for Fall reporting |
01 | Change in grade level |
02 | Transfer to another school in district |
03 | Transfer to approved nonpublic school |
04 | Moved to other MN school district |
05 | Moved out of MN |
06 | Dropout (16 or older) |
07 | Left after compulsory att age w/ written election |
08 | Graduated from High School |
11 | Died |
12 | Excused: permanent disability |
13 | Jailed |
14 | 15 day drop |
15 | Enrollment ended due to marriage |
16 | Expelled, didn't start elsewhere |
17 | Pregnancy |
18 | Whereabouts unknown/non-approved |
20 | Transfer to other district/not moved |
21 | EC withdrawal: IEP met |
Special Ed Status Options
Code | Description |
---|---|
1 | None |
2 | Evaluated by no service required |
3 | Requires services; not currently participating |
4 | Receiving services |
5 | Requires services, parent refused |
6 | Student with IIIP |
7 | IEP/IFSP terminated during year |
8 | Early Intervention |
9 | Students receiving indirect services only |
EL Field Logic
Reports as Y in the following instances:
- If the student is enrolled in an EL program.
- If the student's most recent EL record has a Program Status of Exited EL and a Program Exit Date on or after the Start Date of the earliest enrollment.
- If the student's most recent EL record has a Program Status of EL and an Identified Date entered.
- If any EL record has a Program Status of EL and an Identified Date on or after the earliest enrollment Start Date and on or before the End Date of the extract.
If a student has enrollment in multiple calendars, this field will report as Y for all MARSS records for that student if it reports as Y for one enrollment.
Reports as N in the following instances:
- If Program Exit Date occurs before the Start Date of the earliest enrollment.
- All other circumstances not described above.
Special Ed Disability Setting Options
Code | Description |
---|---|
00 | No IEP/IFSP/IIIP |
01 | K12: Outside of regular class less than 21% of day |
02 | K12: Resource Room between 21% and 60% of day |
03 | K12: Separate classroom more than 60% of day |
04 | K12: Public separate school facility > than 50% |
05 | K12: Private separate school facility > than 50% |
06 | K12: Public residential facilities > than 50 % |
07 | K12: Private residential facility > than 50% |
08 | K12: Homebound/hospital placement |
11 | Early Int: Developmental Delays/Disabilities |
12 | Early Int: Typically developing |
13 | Early Int: Home |
14 | Early Int: Hospital Inpatient |
15 | Early Int: Residential Facility |
16 | Early Int: Service Provider Location |
17 | Early Int: Other Setting |
30 | EC stu age 3-5 rec srvc in approved voluntary pre-k |
31 | Reg EC at least 10 hrs/week and rec srvc in setting |
32 | Ref EC at least 10 hr/week but rec maj srvc elswhr |
33 | Ref EC up to 10 hours/week and rec srvc in setting |
34 | Ref EC up to 10 hours/week but rec maj srvc elsewhr |
39 | ECSE student enrolled in/receiving sped services in an approved School Readiness Plus (SRP) |
41 | Separate Class |
42 | Separate School |
43 | Residential Facility |
44 | Service Provider Location |
45 | Home |
Disability Options
Code | Description |
---|---|
00 | Not Disabled |
01 | Speech/language impaired |
02 | Developmental Cognitive Disabilities: Mild-Moderate |
03 | Developmental Cognitive Disabilities: Severe-Profnd |
04 | Physically impaired |
05 | Deaf-Hard of Hearing |
06 | Visually impaired |
07 | Specific learning disabilities |
08 | Emotional/behavioral disorders |
09 | Deaf/Blind |
10 | Other health disabilities |
11 | Autism Spectrum Disorder |
12 | Developmental Delay |
14 | Traumatic brain injury |
16 | Severely Multiply Impaired |
54 | 504 Accommodation Plan |
Transportation Category Options
Code | Description |
---|---|
00 | Walkers |
01 | Regular |
02 | Excess |
03 | Disabled |
04 | Desegregation |
05 | Ineligible/Nonresident |
06 | Special Transportation |
07 | Shelter Care Facility |