Classic View: MD State Reporting > September 30th Attendance and Enrollment
Search Terms: September 30th Attendance and Enrollment
The September 30th Attendance and Enrollment extract reports information about all primary enrollment records in regular day school, evening high school and part-time programs.
Report Logic
- Reports all students enrolled from the beginning of the school year to the End Date entered on the extract editor (assumed to be the last school day of September).
- All Primary and Special Ed Services enrollment types are reported.
- Students who are state excluded or enrolled in state excluded calendars are not reported.
- When students have multiple enrollments in the same calendar, a separate record reports for each enrollment in the calendar before the report end date.
- June 1 YYYY of the beginning school year is the date used when calculating a 2 year threshold.
Absence Calculation
If the student.... | Then Campus... | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HAS a value in the FTE override field on the enrollment |
| ||||||||||||
has an FTE value of 1 or the FTE field is null | calculates the total number of absences for the reporting period based on the values found in System Administration > Calendar > whole day (absence) and half day (absence). Absences are defined by any attendance code tied to a state code of 1-21. |
Reporting Data for AOP Students
The following enrollment data elements report from the most recent enrollment in the calendar(s) selected in the extract editor.
Data Element Number | Data Element Name |
---|---|
DE 100 | Grade Level |
DE 180 | Migrant |
DE 190 | Foreign Exchange Student |
DE 280 | Entry Status |
DE 290 | Entry Code |
DE 300 | Entry Date |
DE 340 | Exit Status |
DE 350 | Exit Code |
DE 360 | Exit Date |
The following attendance data elements are calculated for each enrollment then summed for a total and reported as a single record.
Data Element Number | Data Element Name |
---|---|
DE 310 | Days Attending |
DE 320 | Days Absent |
Report Editor Fields
Field | Description |
---|---|
Start Date | Enrollment records on and after this date are eligible for reporting. |
End Date | Enrollment records on and before this date are eligible for reporting. |
Run Date | This populates the Submission date field and is used for calculation in the State Eligibility field in the extract (default value is the current date). |
Special Services Date | Used to determine a student’s status in EL, Migrant, FARMS |
EL Exempt Date | This date is used to determine what reports in the EL Exempt field. To report Y in the EL Exempt field, the student's most recent EL Identified date must be after the EL Exempt Date entered here. |
Non-Public End Date | This field is used to help calculate the End Date field. |
Non-Public End Status | This field is used to help calculate the Exit Status and Exit Code fields. |
Ad Hoc Filter | Ad Hoc filters are available for narrowing report results. |
Format |
|
Select Calendars | Select the schools to include in the report. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Report. This process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Report Elements
The following table describes each report element.
Data Element | Description | Location | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LEA Number | The two-digit state designation of the local education agency (LEA). Numeric, 2 digits | System Administration > Resources > District Information > State District Number | ||||||||||||||||||||||||||||||
School Number | Reports the home school number from the student’s enrollment. If the school number is null, the school number on the school tied to the enrollment reports. Numeric, 4 digits | System Administration > Resources > School > State School Number | ||||||||||||||||||||||||||||||
State Assigned Student ID (SASID) | The student's state-assigned ID number. Numeric, 10 digits | Census > People > Demographics > Student State ID | ||||||||||||||||||||||||||||||
Local Student ID Number (LASID) | The student's LEA-assigned ID number. Numeric, 10 digits | Census > People > Demographics > Student Number | ||||||||||||||||||||||||||||||
Last Name | The student's last name.
Alphanumeric, 25 characters | Census > People > Identities > Current Identity > Legal Last Name or Last Name | ||||||||||||||||||||||||||||||
First Name | The student's first name.
Alphanumeric, 15 characters | Census > People > Identities > Current Identity >Legal First Name or First Name | ||||||||||||||||||||||||||||||
Middle Name | The student's middle name.
Alphanumeric, 15 characters | Census > People > Identities > Current Identity > Legal Middle Name or Middle Name | ||||||||||||||||||||||||||||||
Generational Suffix | The suffix tied to the student's name.
Alphanumeric, 3 characters | Census > People > Identities > Current Identity > Legal Suffix or Suffix | ||||||||||||||||||||||||||||||
Preferred Name | An alternative first name preferred by the student. Alphanumeric, 15 characters | Census > People > Identities > Current Identity > Preferred Name | ||||||||||||||||||||||||||||||
Date of Birth | The student's date of birth. Date field, 8 characters YYYYMMDD | Census > People > Identities > Current Identity > Date of Birth | ||||||||||||||||||||||||||||||
Grade | The student's grade level.
Numeric, 2 digits | Student Information> General > Enrollments > Grade | ||||||||||||||||||||||||||||||
Gender | The student's gender. M: Male F: Female X: Non-Binary
Alphanumeric, 1 character | Census > People > Identities > Current Identity > Legal Gender and Gender | ||||||||||||||||||||||||||||||
Hispanic or Latino Ethnicity | An indication that the person traces their origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. If Is the individual Hispanic/Latino = Yes, Y reports. Otherwise, N reports. Alphanumeric, 1 character | Census > People > Demographics > Race Ethnicity > Is the individual Hispanic/Latino | ||||||||||||||||||||||||||||||
American Indian or Alaska Native | Indicates the person has origins with any of the original peoples of North and South America (including Central America) and maintains cultural identification through tribal affiliation or community attachment.
Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native | ||||||||||||||||||||||||||||||
Asian | Indicates the person has origins in any of original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, Philippine Islands, Thailand, and Vietnam.
Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity > Asian | ||||||||||||||||||||||||||||||
Black or African American | Indicates the person has origins in any of the black racial groups of Africa.
Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity > Black or African American | ||||||||||||||||||||||||||||||
Native Hawaiian or Other Pacific Islander | Indicates the person has origins in any of original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.
Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander | ||||||||||||||||||||||||||||||
White | Indicates the person has origins in any of the original peoples of Europe, Middle East, or North Africa.
Numeric, 1 digit | Census > People > Demographics > Race Ethnicity > White | ||||||||||||||||||||||||||||||
Homelessness Status | Indicates whether the student lacks a fixed, regular, and adequate nighttime residence.
Numeric, 1 digit | Student Information > General > Enrollments > State Reporting Fields > Homeless | ||||||||||||||||||||||||||||||
Title 1 Indicator | Indicates if the student participated in a Title 1 program. This field reports Y if:
Otherwise, N reports. Alphanumeric, 1 character | System Administration > Resources > School > Title 1 and Student Information > General > Enrollments > State Reporting Fields > Title 1 System Administration > Resources > School >Title 1 = School wide program Student Information > General > Enrollment > State Reporting > Home School | ||||||||||||||||||||||||||||||
Free/Reduced Price Meals | Indicates if the student receives free/reduced price meals. If the Migrant element reports Y, then this field reports F. Otherwise, the value reports from the FRAM record as of the end date entered on the extract editor. If the eligibility status is N, the value as of the Special Services Date reports.
Alphanumeric, 1 character | FRAM > Eligibility > Eligibility | ||||||||||||||||||||||||||||||
Migrant | Indicates if the student is a migrant as of the End Date on the extract editor. If the Migrant record is N, then the status as of the Special Services Date reports. Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting Fields > Migrant | ||||||||||||||||||||||||||||||
Foreign Exchange Student | Indicates whether the student is a foreign exchange student.
Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting Fields > Foreign Exchange | ||||||||||||||||||||||||||||||
Special Education Services | Indicates the students special education status.
The hierarchy for reporting status is Y, E, 3, 2, N.
Alphanumeric, 1 character | Student Information > General > Enrollment > Special Ed Fields > Special Ed Status Student Information > Special Ed>Documents > IEP > Print Format is MD SPED Date > Detail Editor > Start Date, IEP Closed Date, Exit Code Student Information > General > Flags > Flag (with a state code of 504 and marked as state reported) | ||||||||||||||||||||||||||||||
Special Ed End Date | When the Special Education Services field is E or 3, this field reports the special education Exit Date as of the Effective Date on the extract editor. Date field, 8 characters YYYYMMDD | Student Information > General > Enrollment > Special Ed Fields > Exit Date | ||||||||||||||||||||||||||||||
Special Ed Certificate | Indicates whether the student is on track to receive a MD High School Certificate of Completion. This is required if Special Education Services = Y. Y reports when
Otherwise, N reports. Alphanumeric, 1 character | Student Information > Special Ed > Documents > IEP > (Print Format is MD SPED Date) > Detail Editor > Start Date, IEP Closed Date, Exit Reason, Certificate | ||||||||||||||||||||||||||||||
English Learner (EL) Status | Indicates whether the student has a primary or home language other than English and has been assessed as having limited or no ability to understand, speak or read English.
Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL > Program Status | ||||||||||||||||||||||||||||||
EL Begin Date | The eight-digit date for when EL services started for a student. Date field, 8 characters YYYYMMDD | Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date | ||||||||||||||||||||||||||||||
English Learner Entry into the US Date | The date when the student began EL services or entered the U.S. for the first time. This field is required if EL Indicator = Y or E OR Immigrant = Y.
Date field, 8 characters YYYYMMDD | Census > People > Demographics > Date Entered US School Student Information > Program Participation > English Learners (EL) > EL > Identified Date | ||||||||||||||||||||||||||||||
EL End Date | The eight-digit date of when EL services ended for a student. The EL End Date reports blank when the EL Status is Y. The Program End Date reports when EL Status is E; otherwise this field reports blank. Date field, 8 characters YYYYMMDD | Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date | ||||||||||||||||||||||||||||||
English Learner ELA Assessment Exempt Status | Indicates that the student receiving ESOL services in their first year of enrollment in a U.S. school is exempt from the PARCC English/Language Arts assessment and may substitute the required state assessment with the English Language Proficiency Assessment (ACCESS for ELs 2.0).
Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL > Program Status Census > People > Demographics > Date Entered US School | ||||||||||||||||||||||||||||||
Foster Care Status | Indicates whether the student is in foster care.
Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Services > Foster Care | ||||||||||||||||||||||||||||||
Military Connected Indicator | Indicates the student has a parent or guardian in the military.
Alphanumeric, 1 character | Student Information > Enrollments > Military Connected Status | ||||||||||||||||||||||||||||||
Gifted and Talented Student Indicator | Indicates whether the student is identified as gifted/talented. Alphanumeric, 1 character Y or N | Student Information > Program Participation > Gifted & Talented | ||||||||||||||||||||||||||||||
Filler | N/A | N/A | ||||||||||||||||||||||||||||||
Submission Date | The date the file was submitted to the MSDE. Date field, 8 characters YYYYMMDD | Not dynamically stored | ||||||||||||||||||||||||||||||
Entry Status | The student's entry status.
Alphanumeric, 1 character | Student Information > General > Enrollments > Start Status > Standard Code System Administration > Calendar > Calendar > Days | ||||||||||||||||||||||||||||||
Entry Code | The student's entry code that best describes their last school affiliation prior to entry into the current school.
Alphanumeric, 2 characters | Student Information > General > Enrollments > Start Status > Standard Code System Administration > Calendar > Calendar > Days | ||||||||||||||||||||||||||||||
Entry Date | The enrollment start date.
Date field, 8 characters YYYYMMDD | Student Information > General > Enrollments > Start Date; End Date System Administration > Calendar > Calendar > Days | ||||||||||||||||||||||||||||||
Days Attending | The aggregate number of days the student was in attendance during the current school year, rounded to the nearest half-day.
Example 10 days = 0100
See the Report Logic for more information. Numeric, 4 digits | Calculated | ||||||||||||||||||||||||||||||
Days Absent | The aggregate number of days the student was absent during the current school year, rounded to the nearest half-day.
See the Report Logic for more information.
| Calculated based on System Administration > Calendar > Calendar > Student Whole Day Absence, Student Half Day Absence | ||||||||||||||||||||||||||||||
Filler | N/A | N/A | ||||||||||||||||||||||||||||||
Exit Status | The student's exit status.
If the enrollment is tied to a school with a school type of 99:Non -public, the value reports from the Non-public End Status selected on the extract editor, using the following logic:
Otherwise, 0 reports. Numeric, 1 digit | Student Information > General > Enrollments > End Status > Standard Code | ||||||||||||||||||||||||||||||
Exit Code | The reason the student is exiting. If a student has multiple exits, a record reports for each exit code.
Numeric, 2 digit | Student Information > General > Enrollments > End Status | ||||||||||||||||||||||||||||||
Exit Date | The date the student exited.
Date field, 8 characters YYYYMMDD | Student Information > General > Enrollments > End Date | ||||||||||||||||||||||||||||||
Filler | N/A | N/A | ||||||||||||||||||||||||||||||
Pre-K Full-Time Status | Indicates if the student is in Pre-Kindergarten.
Alphanumeric, 1 character | Student Information > General > Enrollments > Grade | ||||||||||||||||||||||||||||||
Filler | N/A | N/A | ||||||||||||||||||||||||||||||
State Aid Eligibility | Indicates the student's eligibility for State Financial Assistance under the Foundation Program.
Numeric, 2 digits | Student Information > General > Enrollment > State Reporting Fields > State Aid Eligibility | ||||||||||||||||||||||||||||||
Evening High School Student | Indicates whether the student is attending an evening high school program.
Alphanumeric, 1 character | Course > Section > Class Type is E:Evening | ||||||||||||||||||||||||||||||
EH Number of Courses | The number of courses the Evening High school student is enrolled in as of September 30th.
Numeric, 1 digit | Calculated | ||||||||||||||||||||||||||||||
Part-Time Student | Indicates whether the student is considered a part-time student.
Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting > FTE | ||||||||||||||||||||||||||||||
PT Number of Courses | The number of courses the part time student is enrolled in.
Numeric, 1 digit | Course > Level Course > Type > Evening | ||||||||||||||||||||||||||||||
Opt-Out | Indicates the student's legal guardian has chosen to opt-out of the release of directory information. Alphanumeric, 1 character Y or N | Student Information > General > Enrollments > State Reporting Fields > Opt-Out | ||||||||||||||||||||||||||||||
Number of College Courses | The sum of unique courses into which the student is enrolled as of the extract editor End Date when the student is scheduled into a course marked as college (DE is selected in SCED Course Level) in the selected calendars).
Numeric, 1 digit | Scheduling > Courses > Course > SCED Course Level | ||||||||||||||||||||||||||||||
Dual Enrollment | Indicates whether the student is taking both high school and college level courses and receiving credit in both. Alphanumeric, 1 character Y or N | Course > SCED Level > DE | ||||||||||||||||||||||||||||||
Direct Certification | Indicates whether the student’s eligibility for the National School Lunch Program was determined through direct certification.
Alphanumeric, 1 character Y or N | FRAM > Eligibility > Eligibility > Source | ||||||||||||||||||||||||||||||
Pre-K Tier Status | Indicates the Pre-K tier that best identifies the student’s federal poverty level eligibility for State Financial Assistance.
The Early Learning Program record must be active as of the Report End Date. | Student Information > Program Participation > Early Learning > Gross Income AND Number of People in Household | ||||||||||||||||||||||||||||||
Federal Poverty Level | Indicates the percentage of Federal Poverty Level (FPL).
2022 Federal Poverty Guidelines
The Early Learning Program record must be active as of the Report End Date. | Student Information > Program Participation > Early Learning > Gross Income AND Number of People in Household |